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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: bug in on_error_rollback !?



On Fri, 2006-10-27 at 03:50 -0500, Andrew Dunstan wrote:
> psql variables and commands are not SQL, and are case sensitive. For
> example, \ds and \dS are not at all the same.
> 
> This is documented clearly on the psql man page, so it is simply not a
> bug

It may be documented, but \set still has a terrible user interface.
There is no feedback about whether a variable has been successfully
changed. Updates to non-existent variables are silently accepted, and
references to non-existent variables do not result in an error. I've
complained about this before[1], but there wasn't a consensus on how to
improve this behavior (given the need for backward compatibility).

-Neil

[1] http://mail-archive.com/pgsql-hackers(at)postgresql(dot)org/msg41273.html





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group