DROP DATABASE usa;
CREATE DATABASE usa WITH TEMPLATE = template0 OWNER = usadmin ENCODING = 'LATIN1';
ALTER DATABASE usa SET search_path TO 'public, contrib';
Notice the single quotes around the TO bit? That's completely broken. Those '' must not be there.
Is a fix for this required for only search_path, or is it a more general problem?
Chris
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
