Re: [Phpwebsite-developers] postgres

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 09-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers]
postgres"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 


Ok, next problem figured out.

After I select all modules and click install, the next page shows this:

CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id varchar(32)
NOT NULL default '', data text NOT NULL, ttl int NOT NULL default '0', KEY
mod_title (mod_title, id) )
syntax error


I looked up the syntax and key creation is a little different:

CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id varchar(32)
NOT NULL default '', data text NOT NULL, ttl int NOT NULL default '0',
CONSTRAINT mod_title_id PRIMARY KEY (mod_title, id) );

The mod_title_id is a name for the constraint, the docs don't indicate that
it's terribly important what you name it, so I just followed the example and
named the constraint after the two key fields.



~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPpVmClPEkLgodAWVAQE5SQQAmqsLikRngDQOb8ZlIa2h+4EORcCbcT8/
OwWQd+VfIuH0KPoysKrLzLyTmZCPi5EyOzOmTU6t0AzfFaht0qV1sB8x1tg7Fek/
XhDhip6HrLokeqVdh2nFCUjPP0/fu40F7nxwnH+5zSA1zPwIJLhmCofgShq/UdVp
JW5kiGeKXxc=
=5CCy
-----END PGP SIGNATURE-----