Ben-Nes Michael wrote:
Its becoming a real Off topic so ill make it short :)
lets say one of the rows in the table is an unique index and it has the
following values ( each row ): 1, 2, 3, 4, 5
Deferable Update enable you to update the table like this: update table_name
set unique_row = unique_row + 1;
Currently postgres will abort when row 1 will get the forbidden value of 2
( 1 + 1 ) which is also the value of row 2.
Actually, that's usually referred to as "defferable constraints", not
updates. Postgres has those only for foreign keys at the moment.
transaction within transaction
Nested transactions are due to be in for 7.5. Feature freeze is begining
of July.
Good to know, their work is a quite revolution. its amazing.
Forgot to mention, 2 phase commit is also coming in at the same version.
Shachar
--
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
