SET SCHEMA?
Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)
I guess that SET SCHEMA should change the front of the search path, so
that it would change the schema reported by current_schema(). It would
be a simplified form of SET SEARCH_PATH.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Praying always with all prayer and supplication in the
Spirit, and watching thereunto with all perseverance
and supplication for all saints." Ephesians 6:18
Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)I guess that SET SCHEMA should change the front of the search path, so
that it would change the schema reported by current_schema(). It would
be a simplified form of SET SEARCH_PATH.
Hrm - it would be sort of silly to launch an all-new standards-compliant
schema support without it?
Chris
Can someone explain where we are on this? Is it a TODO item?
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)I guess that SET SCHEMA should change the front of the search path, so
that it would change the schema reported by current_schema(). It would
be a simplified form of SET SEARCH_PATH.Hrm - it would be sort of silly to launch an all-new standards-compliant
schema support without it?Chris
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073On Tue, 2002-08-27 at 20:25, Bruce Momjian wrote:
Can someone explain where we are on this? Is it a TODO item?
Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)
I think it should be.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But the end of all things is at hand; be ye therefore
sober, and watch unto prayer. And above all things
have fervent love among yourselves; for love shall
cover the multitude of sins." I Peter 4:7,8
Added:
o Add SET SCHEMA
---------------------------------------------------------------------------
Oliver Elphick wrote:
On Tue, 2002-08-27 at 20:25, Bruce Momjian wrote:
Can someone explain where we are on this? Is it a TODO item?
Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)I think it should be.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But the end of all things is at hand; be ye therefore
sober, and watch unto prayer. And above all things
have fervent love among yourselves; for love shall
cover the multitude of sins." I Peter 4:7,8---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073