There is a TODO item:
* Views with spaces in view name fail when referenced
>
> I have a similar problem, i think it worked with previous postrgesql versions (6.4.x)
> when i typed:
>
> ------------------------
>
> [marn@mi marn]$ createdb pr
> [marn@mi marn]$ psql pr
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: pr
> pr=> create table "J�zyk obcy"(a text);
> CREATE
> pr=> select * from "J�zyk obcy";
> a
> -
> (0 rows)
>
> pr=> create view "J�zyk obcy1" as select * from "J�zyk obcy";
> CREATE
> pr=> select * from "J�zyk obcy1";
> ERROR: nodeRead: Bad type 0
> pr=> vacuum;
> ERROR: nodeRead: Bad type 0
> pr=> drop view "J�zyk obcy1";
> ERROR: nodeRead: Bad type 0
>
> -------------------------------
>
> note that the name of the view contains a space and a national character
>
> there is no problem with:
>
> -------------------------------
> [marn@mi marn]$ destroydb pr;
> [marn@mi marn]$ createdb pr
> [marn@mi marn]$ psql pr
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> [PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: pr
>
> pr=> create table "J�zyk_obcy"(a text);
> CREATE
> pr=> select * from "J�zyk_obcy";
> a
> -
> (0 rows)
>
> pr=> create view "J�zyk_obcy1" as select * from "J�zyk_obcy";
> CREATE
> pr=> select * from "J�zyk_obcy1";
> a
> -
> (0 rows)
>
>
> just a killing space??????????????
> --
>
> Marcin Inkielman
>
> ************************************
> sibi omino similis?
> ************************************
>
>
> ************
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026