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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]