Creating a new database at runtime.

This is a multi-part message in MIME format.

------=_NextPart_000_01FE_01C3ECC0.0EDDF8D0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hello
I am trying to do the following:
1. startup my php app
2. check for its database under pgsql
3. If its not there it create it.
4. This may happen for several different apps. I add new apps all the
time.

Attempts:
1.I have tried to connect to the database and check the error for
absence(pg_database) and then try to create it. This fails because the
DATABASE missing is fatal.
2. I have tried to connect to template1 and check pg_database for my
database and if it is not there create it.
a. This works but I get the following warning, myindex is a
serial field for my database. Do test this I go into phpPgAdmin and drop
the addressbook database. Then I open my app to this error. When I
refresh the screen everything works?!


Warning: pg_query(): Query failed: ERROR: relation "info_myindex_seq"
already exists . in /usr/local/apache2/htdocs/AddressBook/index.php on
line 128
Could not create info tableERROR: relation "info_myindex_seq" already
exists


3. If I repeat this sequence with a different app. It is the same
performance but the new app has its tables and the tables from the first
database?!
4. I have tried turning on the sql_inheritence to false without any
help.
5. I cannot connect to template0.



I do not understand the template0 concept, I am coming from the MYSQL
world. Is there a way to do this?????????


Marcel

------=_NextPart_000_01FE_01C3ECC0.0EDDF8D0
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">