Skip site navigation (1) Skip section navigation (2)

BUG #1725: psql --command and PQexec do not work and fail silently

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 (view raw or flat)
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.

Responses

pgsql-bugs by date

Next:From: Prasad DuggineniDate: 2005-06-22 22:32:58
Subject: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Previous:From: diego ayala torresDate: 2005-06-21 20:46:50
Subject: error del pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group