[luxor] luxor totally broken on postgresql ... :(

[Marc G. Fournier]

Almost, one KEY define left that doesn't work under PostgreSQL:

*** luxor.sql.orig      Tue Oct 26 15:36:29 2004
--- luxor.sql   Tue Oct 26 15:36:49 2004
***************
*** 5,11 ****
       langid SMALLINT NOT NULL DEFAULT 0,
       declaration char(255) NOT NULL DEFAULT '',
       PRIMARY KEY (declid),
-     KEY declid (declid)
   );

   CREATE TABLE luxor_files (
--- 5,10 ----

the rest looks good though ... thanks ...



On Tue, 26 Oct 2004, Chuck Hagenbuch wrote:

> Quoting "Marc G. Fournier" <scrappy at hub.org>:
>
>> Attached is an SQL file translation from the MySQL ... but, even with
>> that, the mysql and pgsql both define a luxor_files, but when I go to the
>> page, it seems to be trying to find a luxor_file table ...
>
> There was a typo that's now fixed. I also did a quick pass over luxor.sql and
> the SQL driver to use DB emulated sequences instead of auto increment fields,
> etc; take a look at that.
>
> -chuck
>
> -- 
> "But she goes not abroad in search of monsters to destroy." - John Quincy 
> Adams
> -- 
> luxor mailing list - Join the hunt: http://horde.org/bounties/#luxor
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: luxor-unsubscribe at lists.horde.org
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664