[ postfixadmin-Bugs-2339963 ] pgsql DB creation broken w/ schemas

[SourceForge.net <no...@so...>]

Bugs item #2339963, was opened at 2008-11-24 20:28
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: v 2.2
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: pgsql DB creation broken w/ schemas

Initial Comment:
The database creation and upgrade routines for postgreSQL do not fully function when using the schema feature of pgsql.

Here's what worked for me:

Left is my version, right is 2.2.1.1 from Gentoo ebuild.

# diff upgrade.php /usr/share/webapps/postfixadmin/2.2.1.1/htdocs/upgrade.php
79c79
< $sql = "SELECT * FROM " . table_by_key ('config') . " WHERE name = 'version'";
---
> $sql = "SELECT * FROM config WHERE name = 'version'";
132c132
<         $sql = "UPDATE " . table_by_key ('config') . " SET value = $i WHERE name = 'version'";
---
>         $sql = "UPDATE config SET value = $i WHERE name = 'version'";
376c376
<              domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ',
---
>              domain character varying(255) NOT NULL REFERENCES domain,
391c391
<              domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ',
---
>              domain character varying(255) NOT NULL REFERENCES domain,
414c414
<             CREATE TABLE ' . table_by_key('mailbox') . ' (
---
>             CREATE TABLE mailbox (
420c420
<                  domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ',
---
>                  domain character varying(255) NOT NULL REFERENCES domain,
438c438
<                 domain character varying(255) NOT NULL REFERENCES ' . table_by_key ('domain') . ',
---
>                 "domain" character varying(255) NOT NULL REFERENCES "domain",
448c448
<                 on_vacation character varying(255) NOT NULL REFERENCES ' . table_by_key ('vacation') . '(email) ON DELETE CASCADE,
---
>                 on_vacation character varying(255) NOT NULL REFERENCES vacation(email) ON DELETE CASCADE,


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2339963&group_id=191583