On 14/07/2011 4:53 AM, Aleksey Tsalolikhin wrote:
The following bug has been logged online:
Bug reference: 6117
Logged by: Aleksey Tsalolikhin
Email address: atsaloli.t...@gmail.com
PostgreSQL version: 8.4.8
Operating system: CentOS 5.5 (64-bit)
Description: psql -c does not work as expected. a documentation bug?
a program bug?
Details:
The psql man page says, in the section for the -c option:
If the command string contains multiple SQL
commands, they are processed in a single
transaction
However when I run a command string with multiple
SQL commands, apparently only the last one is
processed.
What's happening is that all of them are processed, but only the output
for the last one is emitted. I agree that the documentation isn't clear
about that, and I'm not sure whether or not that was the intended result.
psql -c "CREATE TABLE test(x integer); INSERT INTO test(x) VALUES
(1),(2),(3); SELECT version(); SELECT * FROM test;"
x
---
1
2
3
(3 rows)
Comments anybody? Just fix the docs, or is this a behaviour issue?
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
