Re: [7.4beta3] pg_dump -t xxx won't output sequences

Tomas Szepe <szepe(at)pinerecords(dot)com> 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