From: Ben-Nes Michael (miki_at_nonexisting.hamakor.org.il)
Date: Mon 21 Jun 2004 - 10:22:52 IDT
----- Original Message -----
From: "Shachar Shemesh" <linux-il_at_shemesh.biz>
To: "Ben-Nes Michael" <admin_at_canaan.co.il>
Cc: <linux-il_at_linux.org.il>
Sent: Sunday, June 20, 2004 7:01 PM
Subject: Re: quick MySQL howto, anyone?
> Ben-Nes Michael wrote:
>
> >Maybe you right but this is what I think of MySQL after working on daily
> >basis with Postgres.
> >
> >Though their still importent thing to implent, like:
> >defferable updates. <- this is a real bummer :(
> >
> >
> I'll admit to ignorance. What's that?
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.
>
> >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.
>
> >and more
> >
> >
>
>
> --
> Shachar Shemesh
> Lingnu Open Source Consulting ltd.
> http://www.lingnu.com/
>
>
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
=================================================================
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 - 10:36:25 IDT