Thread: namespace?
-----BEGIN PGP SIGNED MESSAGE----- Sorry, new at this. I did try to search the docs, but didn't turn up anything useful. I've created a db using just "create database phpws;" and it worked. now, trying to create tables, I just get: phpws=# CREATE TABLE branch_sites ( branchName varchar(20)); ERROR: No namespace has been selected to create in Any clues? ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpRdZVPEkLgodAWVAQEQHgQAiJuguEHaAlplB7ywtq8diyh496BwwiNX O0tryZmDyGi0eBlG+cPNYcbgqOkbt8nyAQlHO3mlYq2lyx7MegJr0HJJDpG7ltk9 31FfTCDfBnTVdkJ9yxYAZF3Bh0UOxO+c7mbIGFjx2fJ4EG2i4FQDqX13+oZpiz8W av3o9D/3/c8= =J9/a -----END PGP SIGNATURE-----
Andy Harrison <ah59@httpsite.com> writes: > I've created a db using just "create database phpws;" and it worked. now, > trying to create tables, I just get: > phpws=# CREATE TABLE branch_sites ( branchName varchar(20)); > ERROR: No namespace has been selected to create in What have you done to your search_path setting? regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- > > $ createdb test > CREATE DATABASE > $ > Looks like this was the issue. When I did it from the cli and then went in and created a table, no more namespace error. ~~ Andy Harrison ah##@httpsite.com ICQ: 123472 AIM/Y!: AHinMaine [full headers for details] -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQCVAwUBPpRotVPEkLgodAWVAQEqywP8DK+h45CjU6Xfhb7f4og54PPefDLIc3CL BBsiqoixzSmfayfZlnOaTAhsNK9je1AbZnTEn2xp66j11W52TkfRX2loi1po4De6 5kd5ZvHKvQ4KEz7PmeQMss2FAJs2iNHEcZO5K6DlM9jrosFNXDn2ZokPLm4XvMQo P3GIqP+4pUM= =RIy3 -----END PGP SIGNATURE-----