Re: [Postfixadmin-devel] Setup error

[David G. <da...@co...>]

See below.

>> 
>> 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;
> 


sudo -s (or otherwise become root)

su - postgres

psql postfix    (assuming db name is postfix; "psql -l" will list all databases)

Copy and paste the above in.... if that fails, try the 'create language plpgsql' then paste the above in.

I'm wondering if it's a case of some default setting changing....

thanks
David.