Re: sequence / last_value problem - Mailing list pgsql-general

From terry@greatgulfhomes.com
Subject Re: sequence / last_value problem
Date
Msg-id 001001c20264$97504300$2766f30a@development.greatgulfhomes.com
Whole thread Raw
In response to Re: sequence / last_value problem  (Tina Messmann <tina.messmann@xinux.de>)
List pgsql-general
If she had never called nextval, then the sequence would still be on its
first value, would that be why the dump did not include the setval
statement???

Just an idea...

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tina Messmann
> Sent: Thursday, May 23, 2002 9:38 AM
> To: Joel Burton; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] sequence / last_value problem
>
>
> Joel Burton wrote:
> [snip..]
>
> >pg_dump output should contain a setval() at the end to fix
> this -- did you
> >take this out?
> >
> Thank you for the clarification.
> No, i didn't take anything out from my dump and there is no setval at
> the end of my dump file....
>
> Regards
> Tina
>
> >
> >
> >HTH.
> >
> >Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
> >Knowledge Management & Technology Consultant
> >
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problems with pg_dump... with postmaster really
Next
From: Martín Marqués
Date:
Subject: Re: problems with pg_dump... with postmaster really