Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] ERROR: nodeRead: Bad type 0

From: Marcin Inkielman <marn(at)oceanic(dot)wsisiz(dot)edu(dot)pl>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0
Date: 1999-09-27 20:46:27
Message-ID: 199909272046.WAA26301@oceanic.wsisiz.edu.pl (view raw or flat)
Thread:
Lists: pgsql-general
I have a similar problem, i think it worked with previous postrgesql versions (6.4.x)
when i typed:

 ------------------------

[marn(at)mi marn]$ createdb pr
[marn(at)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 "Jzyk obcy"(a text);
CREATE
pr=> select * from "Jzyk obcy";
a
-
(0 rows)
 
pr=> create view "Jzyk obcy1" as select * from "Jzyk obcy";
CREATE
pr=> select * from "Jzyk obcy1";
ERROR:  nodeRead: Bad type 0
pr=> vacuum;
ERROR:  nodeRead: Bad type 0
pr=> drop view "Jzyk 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(at)mi marn]$ destroydb pr;
[marn(at)mi marn]$ createdb pr
[marn(at)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 "Jzyk_obcy"(a text);
CREATE
pr=> select * from "Jzyk_obcy";
a
-
(0 rows)
 
pr=> create view "Jzyk_obcy1" as select * from "Jzyk_obcy";
CREATE
pr=> select * from "Jzyk_obcy1";
a
-
(0 rows)


just a killing space??????????????
-- 

Marcin Inkielman

************************************
	sibi omino similis?
************************************

pgsql-general by date

Next:From: Jason FarnsworthDate: 1999-09-27 20:54:24
Subject: Finding info on database users
Previous:From: Keith G. MurphyDate: 1999-09-27 19:44:27
Subject: Re: [GENERAL] libpq on win32 & postgresql on linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group