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?
************************************