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
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
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
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
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
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
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
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
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
___