pg_dump bug - Mailing list pgsql-hackers

From Sferacarta Software
Subject pg_dump bug
Date
Msg-id 12639.981019@bo.nettuno.it
Whole thread Raw
List pgsql-hackers
Hi all,

I created a table and a view on my database:

CREATE TABLE prova (bp bpchar);
CREATE VIEW wprova AS SELECT * FROM prova;


If I unload it using pg_dump I have this:

CREATE TABLE "prova" ("bp" char(-5));
CREATE TABLE "wprova" ("bp" char(-5));
COPY "prova" FROM stdin;
\.
getIndices(): SELECT failed


NB: There are two errors:   1. My view "wprova" becomes a table.   2. The length of "bp" is wrong.

I'm using v6.4beta2 on Linux.

Jose'




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] HAVING bug
Next
From: Sferacarta Software
Date:
Subject: Re[2]: [HACKERS] using indexes