Re: sequence / last_value problem

From: terry(at)greatgulfhomes(dot)com
To: "'Tina Messmann'" <tina(dot)messmann(at)xinux(dot)de>, "'Joel Burton'" <joel(at)joelburton(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: sequence / last_value problem
Date: 2002-05-23 14:17:36
Message-ID: 001001c20264$97504300$2766f30a@development.greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)greatgulfhomes(dot)com

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tina Messmann
> Sent: Thursday, May 23, 2002 9:38 AM
> To: Joel Burton; pgsql-general(at)postgresql(dot)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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
> >Knowledge Management & Technology Consultant
> >
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2002-05-23 14:24:12 Re: problems with pg_dump... with postmaster really
Previous Message Tom Lane 2002-05-23 14:14:31 Re: problems with pg_dump... with postmaster really