pg_dump bug

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump bug
Date: 1998-10-19 13:21:35
Message-ID: 12639.981019@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1998-10-19 13:47:53 Re: [HACKERS] unique indexes and pqlib
Previous Message Paul Friberg CEO - ISTI 1998-10-19 13:03:39 PostgreSQL COPY command