From: | "Charlie Monkton" <charlie(at)hwhc(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1725: psql --command and PQexec do not work and fail silently |
Date: | 2005-06-22 14:01:15 |
Message-ID: | 20050622140115.84A00F0AC8@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1725
Logged by: Charlie Monkton
Email address: charlie(at)hwhc(dot)net
PostgreSQL version: 7.4.6
Operating system: Solaris 9
Description: psql --command and PQexec do not work and fail silently
Details:
Create the following tables:
create table test
(
i int primary key not null
);
create table test_ref
(
i int references test(i) on delete cascade
);
Executing the following SQL via the psql -c option (or PQexec does not
work:
psql -c "delete from test;insert into test values ( 1 );insert into
test_ref values ( 1 );"
INSERT 30816 1
#select * from test_ref;
i
---
(0 rows)
echo "delete from test;insert into test values ( 1 );insert into test_ref
values ( 1 );" | /usr/local/pgsql/bin/psql
DELETE 1
INSERT 30813 1
INSERT 30814 1
# select * from test_ref;
i
---
1
(1 row)
This is very bad as multiple statement executed by PQexec fail and do not
return an error message.
From | Date | Subject | |
---|---|---|---|
Next Message | Prasad Duggineni | 2005-06-22 22:32:58 | BUG #1726: Whenever i reboot my tables indexes is getting corrupted. |
Previous Message | diego ayala torres | 2005-06-21 20:46:50 | error del pg_dump |