On Thu, Jul 14, 2011 at 10:10:28AM +0800, Craig Ringer wrote:
> 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(dot)tech(at)gmail(dot)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?
> >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
> 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;"
> (3 rows)
> Comments anybody? Just fix the docs, or is this a behaviour issue?
I have added documentation for this behavior. Patch attached, and
backpatched to 9.2 and 9.1.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ It's impossible for everything to be true. +
Description: text/x-diff (981 bytes)
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2012-08-03 22:51:45|
|Subject: Re: BUG #6126: CC parameter in to_char() behaves incorrectly|
|Previous:||From: Craig Ringer||Date: 2012-08-03 14:01:06|
|Subject: Re: BUG #7479: SERVICE NOT START|