Tom Lane wrote: > Markus Schiltknecht <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
