Re: Roll Back dont roll back counters - Mailing list pgsql-general

From Colin 't Hart
Subject Re: Roll Back dont roll back counters
Date
Msg-id 9lgpfj$2167$1@news.tht.net
Whole thread Raw
In response to Roll Back dont roll back counters  ("Ben-Nes Michael" <miki@canaan.co.il>)
List 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



pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: Re: why sequential scan
Next
From: "Ben-Nes Michael"
Date:
Subject: Re: Roll Back dont roll back counters