statement timeout test case - Mailing list pgsql-general

From Medi Montaseri
Subject statement timeout test case
Date
Msg-id 3DF936E7.6080309@intransa.com
Whole thread Raw
Responses Re: statement timeout test case  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
I'm trying to develop a test case to see how the statement_timeout in
7.3 works...

Can I just say...

make the change in $PGDATA/postgresql.conf, pg_ctl reload

In psql(1) session one say 'lock table test in EXCLUSIVE mode'
In psql(1) session two say 'select * from test'

What I'm expecting is that sessoion two should block and then timeout....

Thanks

PS: I don't see any unlock commands....does it automagically unlock the
table
when psql(1) session is closed.


pgsql-general by date:

Previous
From: "Charles H. Woloszynski"
Date:
Subject: Re: [PERFORM] CLUSTER command
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: What port to connect on?