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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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?
************************************

Browse pgsql-general by date

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