Sorry... Long time not using pg_locks...
My function (on pid 20125) was running, pid 25743 requested an exclusive
lock and is waiting, and all others were waiting for this one.
2009/4/8 Daniel Cristian Cruz
> Hi all,
>
> I had a big function (the same one mentioned before) which is locking a
>
Daniel Cristian Cruz writes:
> sgn=# SELECT * FROM pg_locks WHERE relation = 1706665;
> locktype | database | relation | page | tuple | transactionid | classid |
> objid | objsubid | transaction | pid |mode | granted
> --+--+--+--+---+
Hi all,
I had a big function (the same one mentioned before) which is locking a
table, where it doesn't use the table for updates, just selects. (PostgreSQL
8.2)
My pg_locks had:
sgn=# SELECT * FROM pg_locks WHERE relation = 1706665;
locktype | database | relation | page | tuple | transactionid
Daniel Cristian Cruz writes:
> Is it normal?
Yes.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi all,
Sometimes I use RAISE DEBUG on my functions, and it showed this message on
PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian
4.3.3-5) 4.3.3.
Is it normal? Could it be something wrong with my code?
Regards,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
Tom:
Thanks for the info. I will look into upgrading.
I used lastval mainly because I found that documented on the inet
somewhere and it seemed to work for me. If curval is better I'll switch
to that.
Thanks
Aaron Parks
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
S
Dimitri,thank you.it works well.
yours,tony
2009/4/6 Dimitri Fontaine
> Hi,
>
> On Friday 03 April 2009 05:03:37 Tony Liao wrote:
> > now I want to insert default value [] to prefix column,because if
> the
> > prefix colu
