On Tue, February 28, 2012 12:17, Adrian Klaver wrote: > > I guess the options are either do as I did above or > create a new template database as the owner you want > and use that as the template for your CREATE > DATABASE. Why does this not work? => \c test You are now connected to database "test" as user "devl". ALTER EXTENSION plpgsql OWNER TO devl; ERROR: syntax error at or near "OWNER" LINE 1: ALTER EXTENSION plpgsql OWNER TO devl; => \c - postgres You are now connected to database "test" as user "postgres". ALTER EXTENSION plpgsql OWNER TO devl; ERROR: syntax error at or near "OWNER" LINE 1: ALTER EXTENSION plpgsql OWNER TO devl; -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@xxxxxxxxxxxxx Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
