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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])