Re: [GENERAL] update error with serializable

2017-01-20 Thread Kevin Grittner
On Fri, Jan 20, 2017 at 11:27 AM, Rob Sargent wrote: > On 01/20/2017 10:05 AM, Kevin Grittner wrote: >> https://www.postgresql.org/message-id/flat/d8joa0eh9yw@dalvik.ping.uio.no#d8joa0eh9yw@dalvik.ping.uio.no > Configurable or dynamic? Wouldn't something related to tuples per page (and

Re: [GENERAL] update error with serializable

2017-01-20 Thread Rob Sargent
On 01/20/2017 10:05 AM, Kevin Grittner wrote: On Fri, Jan 20, 2017 at 4:44 AM, Tom DalPozzo wrote: I've two threads countinuously updataing rows in the same table. Each one does: BEGIN, UPDATE,UPDATECOMMIT There can't be two active transactions updating the same row (my bug apart but I d

Re: [GENERAL] update error with serializable

2017-01-20 Thread Kevin Grittner
On Fri, Jan 20, 2017 at 4:44 AM, Tom DalPozzo wrote: > I've two threads countinuously updataing rows in the same table. > Each one does: BEGIN, UPDATE,UPDATECOMMIT > There can't be two active transactions updating the same row (my > bug apart but I don't think so). > I'm using default_transac

[GENERAL] update error with serializable

2017-01-20 Thread Tom DalPozzo
Hi, I've two threads countinuously updataing rows in the same table. Each one does: BEGIN, UPDATE,UPDATECOMMIT There can't be two active transactions updating the same row (my bug apart but I don't think so). I'm using default_transaction_isolation = 'serializable' I get "could not serialize ac

Re: [GENERAL] update error

2009-04-24 Thread Tom Lane
josep porres writes: > So, what's the point of the alias in the documentation? You might want the alias elsewhere in the command, in places where it's actually possible to refer to more than one table. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-gene

Re: [GENERAL] update error

2009-04-24 Thread josep porres
So, what's the point of the alias in the documentation? -> http://www.postgresql.org/docs/current/static/sql-update.html 2009/4/24 Filip Rembiałkowski > > > 2009/4/24 josep porres > >> Hello, >> >> I am migrating a database to pg and modifying the app. >> In that process I found an error and i

Re: [GENERAL] update error

2009-04-24 Thread josep porres
ok, it's working without the alias inside the SET thanks 2009/4/24 Filip Rembiałkowski > > > 2009/4/24 josep porres > >> Hello, >> >> I am migrating a database to pg and modifying the app. >> In that process I found an error and i don't see the reason. >> >> It's happening when executing the n

Re: [GENERAL] update error

2009-04-24 Thread Filip Rembiałkowski
2009/4/24 josep porres > Hello, > > I am migrating a database to pg and modifying the app. > In that process I found an error and i don't see the reason. > > It's happening when executing the next update sentence > Do you see what's wrong? table name / alias is not allowed in SET section. http

[GENERAL] update error

2009-04-24 Thread josep porres
Hello, I am migrating a database to pg and modifying the app. In that process I found an error and i don't see the reason. It's happening when executing the next update sentence Do you see what's wrong? The server is pg8.3.7 for w32 ___