I was reviving an old test program which hasn't been used since 9.1 and found 
that "SET search_path = xyzzy" no longer fails if the schema "xyzzy" doesn't 
exist.

Is there an approved or recommended way to tell if a schema exists?  I can 
think of lots of ways, but none as easy as the 9.1 search_path.  I suppose I 
shouldn't rely on undocumented features ...

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / fe...@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to