Re: Roll Back dont roll back counters

From: "Colin 't Hart" <cthart(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Roll Back dont roll back counters
Date: 2001-08-16 15:36:21
Message-ID: 9lgpfj$2167$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> If I design a table with SERIAL type and then try to insert few rows, but
> some of the rows are rolled back the roll back process does not roll back
> the counter status.
>
> Is there a way to do a roll back to the counter ?

And I suppose if I deleted some rows you'd want
all rows with higher values for the SERIAL data-typed
column to renumber automatically...

:-)

Cheers,

Colin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message newsreader 2001-08-16 15:43:59 Re: why sequential scan
Previous Message roypgsqlgen 2001-08-16 15:26:11 confused on maximum characters