Bug #953: pg_dump dies on tables with no columns

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #953: pg_dump dies on tables with no columns
Date: 2003-04-23 00:14:15
Message-ID: 20030423001415.753624758F1@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ziga Kranjec (ziga(at)ljudmila(dot)org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dump dies on tables with no columns

Long Description
version 7.3.2

pg_dump stated dying while dumping some of my databases.
The error message is:

pg_dump: SQL command to dump the contents of table "fields" failed
pg_dump: Error message from server: ERROR: parser: parse error at or near ")" at character 19
pg_dump: The command was: COPY wdbi.fields () TO stdout;

Further investigation shows that there is a problem with
COPY SQL command:

db=# copy wdbi.fields to stdout;
ERROR: MemoryContextAlloc: invalid request size 0
lost synchronization with server, resetting connection

Table wdbi.fields looks like this:

CREATE TABLE fields (
);

that is, no columns, which otherwise seems fine,
as far as Postgres is concerned.

This table was created using a database modelling tool;
so far just a class was created. Columns haven't been
added yet (but they eventually will).

This is a major annoyance, because it stops backups from
working :-(
Actually, pg_dump will dump everything up to the offending
table, so "COPY table FROM stdin" is the last thing it prints...

Sample Code
create table foo ();
copy foo to stdout;

No file was uploaded with this report

Browse pgsql-bugs by date

  From Date Subject
Next Message CN 2003-04-23 05:51:50 UNION Types Mismatch
Previous Message Erik Walthinsen 2003-04-22 19:41:59 BUG: Infinite syslog() loop