#436 postgresql schema bugs and fixes

[Marius Andreiana]

phpwiki 1.3.11

There's no need to use httpd_user in postgresql schema.
Create the user and database as any other postgresql db:
su - postgres
createuser wiki

Then with current shell user:
createdb -U wiki wiki
psql -U wiki -f schemas/psql-initialize.sql

To fix:
cat psql-initialize.sql |grep -v "httpd_user" > psql.sql

Next, some errors (these are in original .sql file too) :

psql:psql.sql:152: ERROR: syntax error at or near "("
at character 47
psql:psql.sql:153: ERROR: syntax error at or near ":"
at character 21

FIXES: Add this line to definitions
\set rating_id :prefix 'rating_id'

Remove NUMBER and UNSIGNED which come from mysql
adaptation.

I attached the fixed schema.

[Marius Andreiana]

fixed pgsql schema

[Reini Urban]

Logged In: YES
user_id=13755

Fixed in current CVS.

http://sourceforge.net/cvs/?group_id=6121
or http://phpwiki.sf.net/nightly/phpwiki.nightly.tar.gz