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

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

From
Marcin Inkielman
Date:
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?
************************************


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

From
Bruce Momjian
Date:
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