Re: Sequence Cleanup

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Sequence Cleanup
Date: 2002-12-09 21:13:11
Message-ID: 1039468390.1954.2.camel@rh72.home.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tm(dot)ee>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-12-09 21:19:54 Re: Sequence Cleanup
Previous Message Tom Lane 2002-12-09 21:10:27 Re: DB Tuning Notes for comment...