SET SCHEMA? 
Author Message
 SET SCHEMA?

Can someone explain where we are on this?  Is it a TODO item?

---------------------------------------------------------------------------

Quote:

> > 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

> message can get through to the mailing list cleanly

--
  Bruce Momjian                        |   http://www.***.com/

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Sun, 13 Feb 2005 03:25:53 GMT
 SET SCHEMA?

Quote:

> 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.

--

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



Sun, 13 Feb 2005 04:52:11 GMT
 SET SCHEMA?

Added:

Quote:
>       o Add SET SCHEMA

---------------------------------------------------------------------------

Quote:


> > 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.

> --

> 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

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 13 Feb 2005 05:17:07 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. set schema in visual explain...

2. Set schema="yourdb"

3. SET SCHEMA?

4. Cannot set SCHEMA in db2cli.ini

5. Set Schema problems

6. Setting Schema

7. Setting schema

8. db2 7.1/win2k - SET SCHEMA failure with JDBC

9. Set schema="yourdb"

10. how can I set system-wide default schema?

11. set current schema

12. SET CONSTRAINTS not schema-aware


 
Powered by phpBB® Forum Software