The submit button on the form located at
http://www.postgresql.org/bugs/bugs.php?1 results in a report of a
parsing error, so I'm sending this here as the alternative.
Is the following a bug in the referential integrity system? This is
for PG 7.0.0. I realize that declaring the "ref" column in
Test case:
create table test (data text unique);
Outside of psql, run this command (This is for bash):
while true ; do echo "begin work; insert into test (data) values ('This
is a test string.'); commit work;" ; done | psql
Watch the resident set size of the postmaster that the psql is connect
On Wed, Oct 01, 2003 at 07:57:18PM -0700, Theodore Petrosky wrote:
> here is the actual query:
>
> agencysacks=# SELECT jobnumseq, (SELECT cname FROM
> clientinfo ci WHERE ci.acode = j.clientid) as client,
> shrtdesc, to_char(proofduedate, 'Dy FMMon DD,
> HH12 am') FROM jobs j WHERE proof
