From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
---|---|
To: | A E <cooljoint(at)yahoo(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Scripting a new db server setup |
Date: | 2004-01-04 17:31:51 |
Message-ID: | BC1D9C17.3DEB7%scott_ribe@killerbytes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Thanks Doug! I got some weird errors though when trying to run a command to
> create db, create user, create elements from the pgAdmin sql editor. I was
> trying to test and in a nutshell it not allow me to create the db in the same
> script as everything else, because I seperated the parts and it worked fine.
I think it's likely that at some point you wound up connected to wrong db
and need a connect command somewhere in your script. For instance, you
connect to template1 to start because your db doesn't exist yet, now
creating your db doesn't connect you to it. But when you split the script,
you explicitly connect to your db for the second script.
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Nolan | 2004-01-04 18:47:20 | Re: GetLastInsertID ? |
Previous Message | Dave Cramer | 2004-01-04 16:55:31 | Re: website doc search is extremely SLOW |