Обсуждение: 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-----