From: Shachar Shemesh (linux-il_at_nonexisting.hamakor.org.il)
Date: Mon 21 Jun 2004 - 10:58:08 IDT
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 linux-il-request_at_linux.org.il with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Mon 21 Jun 2004 - 11:13:51 IDT