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


16 Aug 2002 06:38:00 +0100
Oliver Elphick <olly@lfix.co.uk>
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.

Hrm - it would be sort of silly to launch an all-new standards-compliant
schema support without it?

Chris


Fri, 16 Aug 2002 13:42:41 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: SET SCHEMA?

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 19073

Tue, 27 Aug 2002 15:25:23 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: SET SCHEMA?
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


27 Aug 2002 21:52:07 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: SET SCHEMA?

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, Pennsylvania 19073

Tue, 27 Aug 2002 17:16:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: SET SCHEMA?