Re: PostgreSQL Gotchas

Chris Travers <chris@verkiel.metatrontech.com> writes:
> I make the following assumptions:

> 1)  All backend references to identifiers are treated as quoted by the
> backend as mentioned in a previous thread.
> 2)  Same with official clients like psql.
> 3)  We don't guarantee complete backward compatibility in the system
> catalogs anyway (note that this is a trivial problem to solve if 1 above
> is solved-- schemas, views, and rules can accomplish some cool tricks
> :-) ).

None of these assumptions are acceptable, particularly not #2.  In
reality #2 is a proxy for "I'm willing to break all existing clients
that look at the system catalogs".  Which we're not.

            regards, tom lane