Tomas Szepe <[EMAIL PROTECTED]> writes: > Not sure if this is a bug, but still. :)
> pgsql7.3.4$ pg_dump -a -t seq_wtmp db1 > [ works ] > pgsql7.4beta3$ pg_dump -a -t seq_wtmp db1 > pg_dump: specified table "seq_wtmp" does not exist Looking at the CVS history, I see that Neil added code to deliberately reject this case, but I don't understand why. /* * If the user is attempting to dump a specific table, check to ensure * that the specified table actually exists (and is a table or a view, * not a sequence). */ if (selectTableName) { for (i = 0; i < ntups; i++) if (strcmp(tblinfo[i].relname, selectTableName) == 0 && tblinfo[i].relkind != 'S') break; Neil, what's the reason not to allow dumping just a sequence? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly