Tom Lane wrote:
> Markus Schiltknecht <markus@bluegap.ch> writes:
> > Tom Lane wrote:
> >> Hm, that's an interesting point. psql's -c just shoves its whole
> >> argument string at the backend in one PQexec(), instead of dividing
> >> at semicolons as psql does with normal input.
>
> > Is there a good reason to not let psql -c behave exactly like psql from
> > STDIN?
>
> Backwards compatibility, mostly --- there seems to be a considerable
> risk of subtly breaking people's scripts if we change the transactional
> boundaries for psql -c commands.
True, but if we keep hitting people who don't expect this behavior, I
wonder if we should just fix it and mention it in the release notes.
-- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +