Re: [Postfixadmin-devel] Setup error

[Geoff S. <ge...@Qu...>]

Hi,

Thanks for the reply.

On Thu, 5 May 2011, Christian Boltz wrote:

>> then ran "lynx http://localhost/postfixadmin/setup.php".
>>
>>     updating to version 730 (PgSQL)...
>>
>>     DEBUG INFORMATION:
>>     Invalid query: ERROR: language "plpgsql" does not exist HINT: Use
>>     CREATE LANGUAGE to load the language into the database.
>
> The interesting thing is that the function to update to version 730
> first runs a 'CREATE LANGUAGE plpgsql' query. Looks like this fails on
> your system for some reason.
>
> Please run setup.php?debug=1 to get a more useful error message.

    Updating database:

    - old version: 729; target version: 740

    updating to version 730 (PgSQL)...

    CREATE LANGUAGE plpgsql

    DEBUG INFORMATION:
    Invalid query: ERROR: must be owner of database postfixadmin

    CREATE OR REPLACE FUNCTION merge_quota() RETURNS TRIGGER AS
    $merge_quota$ BEGIN UPDATE quota SET current = NEW.current + current
    WHERE username = NEW.username AND path = NEW.path; IF found THEN RETURN
    NULL; ELSE RETURN NEW; END IF; END; $merge_quota$ LANGUAGE plpgsql;

    DEBUG INFORMATION:
    Invalid query: ERROR: language "plpgsql" does not exist HINT: Use
    CREATE LANGUAGE to load the language into the database.

> Or login to PostgreSQL directly and run the following query:
>    CREATE LANGUAGE plpgsql

Not sure exactly what I need to do that.  I've only just installed this on 
a clean VPS and don't know what account I should use to ogin.  I'll need 
to go look at Debian docs I guess.

Thanks,
Geoff.