----- Original Message ----- From: "Shachar Shemesh" <[EMAIL PROTECTED]> To: "Ben-Nes Michael" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
