Hello.
I'd like to use ORDER BY in any specified order and LIMIT, OFFSET for paging
query results.
The query is FULL OUTER JOIN of two tables by field id. I think the results of
Merge Full Join
to be ordered by some "combined id". And there is no need in extra Sort if I
specify ORDER BY
that "c
Hello.
I've encountered deadlock with first transaction updating information
field in the primary table, and second trasaction reloading secondary
table using TRUNCATE and INSERT. Here is simple example:
create table t1 ( id integer primary key, name text );
create table t2 ( id integer reference
ating system.
Tom Lane wrote:
> Alexey Nalbat <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Your example doesn't deadlock for me ...
>
> > With default value "deadlock_timeout=1000" error raises in first
> > transaction:
>
> Then th
Tom Lane wrote:
>
> Your example doesn't deadlock for me ...
Scott Marlowe wrote:
>
> That's not a deadlock, transaction 3 is simply waiting for transaction 1
> to commit or rollback.
>
> If you run a commit or rollback on transaction 1 then transaction 3 will
> then be ready to commit or rollb
Hello.
I've encountered deadlock on postgresql 8.1. Here is the simple example.
create table t1 (
id1 integer primary key,
val1 integer
);
create table t2 (
id2 integer primary key,
id1 integer references t1 on delete cascade,
val1 integer,
val2 integer,
val3 integer
);
insert into t1 sele
