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/
