Thread: SQL Query and SET commands

PgAdmin III v1.1.0 devel March 31 2004 : 

How do SET commands work within the SQL Query windows? Are they set for the
entire connection duration, or just the window-life, or just the query?

I'm doing some work with schema that requires me to alter the search path. I'm
experiencing SET varialbe carryover. I can set the search path, and run an
"EXPLAIN" on a different query that behaves the way that it should when the
search path is set properly. But! I want to be certain of the behavior so that
I don't do something harmful like dropping a table from one schema that exists
with the same name in another becuase the SET search_path had reverted...

CG

    
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 

Chris Gamache wrote:

>PgAdmin III v1.1.0 devel March 31 2004 : 
>
>How do SET commands work within the SQL Query windows? Are they set for the
>entire connection duration, or just the window-life, or just the query?
>  
>

Every SQL query window has its own connection to the database, so set 
commands will usually be private to that window.


Regards,
Andreas