Re: Sequence Cleanup - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Sequence Cleanup
Date
Msg-id 1039468390.1954.2.camel@rh72.home.ee
Whole thread Raw
In response to Sequence Cleanup  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Rod Taylor kirjutas T, 10.12.2002 kell 01:49:
> Below is a short list of TODOs on sequences I wish to tackle over the
> next week.
...
> Ok, this is where it gets confusing.  Right now setval() is implemented
> in such a manner that it cannot be rolled back (see SETVAL NOTE below),
> but I'd like ALTER SEQUENCE to be transaction safe.

All *val('seqname') functions are transaction-unsafe, i.e. live outside
transactions. 

Why would you want alter transaction to be transaction safe ? 


-- 
Hannu Krosing <hannu@tm.ee>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: DB Tuning Notes for comment...
Next
From: Tom Lane
Date:
Subject: Re: Sequence Cleanup