Re: [8.0.3] Not dumping all sequences ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [8.0.3] Not dumping all sequences ...
Date
Msg-id 24691.1123018254@sss.pgh.pa.us
Whole thread Raw
In response to [8.0.3] Not dumping all sequences ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: [8.0.3] Not dumping all sequences ...
List pgsql-hackers
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> Have databse that \ds shows several sequences, but one in partiicular, I 
> can't seem to 'dump' with pg_dump:

>   public | xa_url_id_seq                   | sequence | pareto_su

Given the name, this could be a SERIAL column's sequence --- which is
not dumped as a separate object by pg_dump, since recreating the SERIAL
column ought to create it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: dbt3 data with 10GB scale factor
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [8.0.3] Not dumping all sequences ...