Re: [GENERAL] ERROR: nodeRead: Bad type 0 - Mailing list pgsql-general

From Marcin Inkielman
Subject Re: [GENERAL] ERROR: nodeRead: Bad type 0
Date
Msg-id 199909272046.WAA26301@oceanic.wsisiz.edu.pl
Whole thread Raw
List pgsql-general
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?
************************************

pgsql-general by date:

Previous
From: "Keith G. Murphy"
Date:
Subject: Re: [GENERAL] libpq on win32 & postgresql on linux
Next
From: Jason Farnsworth
Date:
Subject: Finding info on database users