Re: [Phpwebsite-developers] postgres

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

Yes it is _supposed_ to work.  But a fair amount of the SQL syntax used is 
still mysql-centric.  I've been focusing on the datatypes that I thought 
would break compliance.  I guess the best way to find things is to 
actually use it.

Don.

On Fri, 28 Mar 2003, Andy Harrison wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> 
> Is the postgres support supposed to work?
> 
> Tried getting it set up, got all my ducks in a row, but after I go through the
> config file creation using pgsql for the db, it prompts me to continue with the
> installation, I click and get:
> 
> - ------
> phpWebSite Core Installation: Version 0.9.0
> 
> SQL: show tables from phpws
> syntax error
> - ------
> 
> Show tables from phpws? That's not valid postgres.... Besides, there are no
> tables in the database at this point.
> 
> postgres error log shows:
> 
> ERROR: parser: parse error at or near "from" at character 13
> 
> 
> I'm Running, FreeBSD 5.0-RELEASE, apache-1.3.27, mod_php4-4.3.1,
> postgresql-7.3.1 (tcpip enabled, limited to localhost)
> 
> phpinfo is at http://www.nocarbos.com/output.php (sorry, just registered it
> recently so you'll probably have to put the ip in your hosts file,
> 208.3.251.162)
> 
> ~~ 
> Andy Harrison
> Great Works Internet
> System Operations
> ajh...@gw...
> RSA 1024 pgp key: http://www.nachoz.com/andy.pub
> 
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
> 
> iQCVAwUBPoRnQ1PEkLgodAWVAQE9QwQAknBeZjKEAr0QCCG7TCSZlxFRhIBQXZHg
> 3u53C3bGVaiSqawvJidAg1Sd486INRhIPRIf9bNW+eRQDDfbgpgGxfR52vjppm0M
> AR5Pdp/l9+DYSSKmTUiLDIjYqadXw+9oYiSaenEaQo8YRnS5aUlyarFsdXB8VV5A
> orAMzZ7Asug=
> =3cAQ
> -----END PGP SIGNATURE-----
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by:
> The Definitive IT and Networking Event. Be There!
> NetWorld+Interop Las Vegas 2003 -- Register today!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?keyn0001en
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
>