Re: [Phpwebsite-developers] postgres

[Don S. <do...@se...>]

Did you specify which database to create it in.  When you ran psql, what 
command did you specify?

Don.

On Wed, 9 Apr 2003, Andy Harrison wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> 
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> On 01-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers]
> postgres"
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> Is the postgres support supposed to work?
> > 
> > Absolutely. 'Supposed to' being the key phrase. Don told me about the
> > error in setup and that has been fixed. If you would like to lend a hand,
> > point out any incompatibilities and I will be happy to repair them.
> 
> 
> 
> 
> Ok, finally got around to trying it again.  I downloaded the cvs tarball last
> night and installed it.  I got further this time, it created the config file,
> and prompted me to create the admin user.  At the module install screen, I
> select all and click install button.  The next screen gives me: 
> 
> 
> 
> phpWebSite Core Installation: Version 0.9.1 RC1
> 
> SQL: CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '',
> configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL
> default '', modsInstalled text, branchDir text NOT NULL, branchHttp
> varchar(255) NOT NULL default '')
> unknown error
> 
> - From psql, I chopped that into a single line and tried it manually. 
> 
> phpws=# CREATE TABLE branch_sites ( branchName varchar(20) NOT NULL default '',
> configFile varchar(255) NOT NULL default '', IDhash varchar(32) NOT NULL
> default '', modsInstalled text, branchDir text NOT NULL, branchHttp 
> varchar(255) NOT NULL default '');
> ERROR:  No namespace has been selected to create in
> 
> 
> I'm not pgsql expert, so I have no idea what it is.  If you don't either, I
> don't mind doing the leg work and trying to figure it out if you need.  Let me
> know.
> 
> 
> 
> ~~ 
> Andy Harrison
> ah##@httpsite.com
> ICQ: 123472  AIM/Y!: AHinMaine
> [full headers for details]
> 
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
> 
> iQCVAwUBPpQf6lPEkLgodAWVAQE/SgP/UPGS4X8vXk8A7WzaAkasy70qrsYbi4ts
> P90KNq04qBjmO5uxBRLMDSbxeJi1OzV2NH7hzE2r+xas12hsp7lTUA3775cfNlPJ
> 0umbRN25kae+By4Xx4ndYwhz+8Z2g+U8HJCKuyz9+FJBaVOrxC3TS7iZEPv71pcQ
> WvD8hYEdJHE=
> =pocE
> -----END PGP SIGNATURE-----
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
> for complex code. Debugging C/C++ programs can leave you feeling lost and 
> disoriented. TotalView can help you find your way. Available on major UNIX 
> and Linux platforms. Try it free. www.etnus.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
>