The trouble with search_path ...

[Chris Gamache <cgg007(at)yahoo(dot)com>]

Please try to reproduce this bug:

Select properties on a database element. 
Click to the Variables tab
Select "search_path" from the drop-down
Set the Variable value textfield to "public, pgcatalog, my_schema"
Click OK.

in the description pane you'll find:

-- Database: data

-- DROP DATABASE data;

CREATE DATABASE data
  WITH ENCODING = 'SQL_ASCII';
ALTER DATABASE data SET "search_path=public,;
ALTER DATABASE data SET pg_catalog,;
ALTER DATABASE data SET my_schema";

Somehow I don't think that's the right syntax... Since I've done this, how can
I undo it?

ALTER DATABASE RESET "search_path=public,;
ALTER DATABASE data SET pg_catalog,;
ALTER DATABASE data SET my_schema";

?

CG


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