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

From Bruce Momjian
Subject Re: [GENERAL] ERROR: nodeRead: Bad type 0
Date
Msg-id 199909280132.VAA20754@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] ERROR: nodeRead: Bad type 0  (Marcin Inkielman <marn@oceanic.wsisiz.edu.pl>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rodney McDuff
Date:
Subject: Re: [GENERAL] \d command
Next
From: myers
Date:
Subject: Solaris 7 x86 error