Thread: 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 watchingthereunto 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, Pennsylvania19073
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 untoprayer. 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? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- 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, Pennsylvania19073