#1284 install.sql breaks in PostgreSQL 7.3

closed-postponed
nobody
None
5
2006-03-16
2004-06-03
reubendb
No

Php Version: 4.3.3
Web Server: Apache 1.3.26
Operating System: Linux 2.4.20-20.7
SQL Server: PostGreSQL 7.3
Browser: Firefox-0.8
PhpWebSite Version: 0.9.3.3

All the table creation stuff is broken. Even copy paste
the SQL statement to the psql console results in error,
so the SQL statement is not compatible with postgresql.

The SQL file that used for creating the database:
setup/install.sql does not work in postgresql-7.3. I
fix that in my copy, but then, it breaks again in
:
DB Error: syntax error
CREATE TABLE mod_lang_EN ( phrase_id int unsigned NOT
NULL, module varchar(30) NOT NULL default '', phrase
text NOT NULL, translation text NOT NULL, PRIMARY KEY
(phrase_id), KEY module (module) ); [nativecode=ERROR:
parser: parse error at or near "unsigned"]

Discussion

  • Shaun Murray
    Shaun Murray
    2006-03-16

    Logged In: YES
    user_id=722742

    phpWebSite prior to v1.0 does not support Postgres or indeed any other database than
    MySQL. We hope to fully support Postgres in v1.0. Until that time we are postponing
    any bug, RFE or patch. We do not intend to add Postgres support into v0.10.x

    Please revisit your issue in v1.0 and if the problem still exists then please add to this
    report.

     
  • Shaun Murray
    Shaun Murray
    2006-03-16

    • status: open --> closed-postponed