Andreas Haumer <[EMAIL PROTECTED]> writes:
> Tom Lane schrieb:
>> Exactly what problems did you have using "-O -U user" ?
> So, the main problem is the call to
> CREATE PROCEDURAL LANGUAGE plpgsql;
> on the "mwdb" schema which contains all the tables, functions etc.
Right. As of 8.3, the default
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Tom!
Thanks for your reply!
Tom Lane schrieb:
> Andreas Haumer <[EMAIL PROTECTED]> writes:
>> I now solved it by temporarily adding the "superuser" privilege
>> to the roles in question.
>
> That should not be necessary, unless the dump contained
Andreas Haumer <[EMAIL PROTECTED]> writes:
> I now solved it by temporarily adding the "superuser" privilege
> to the roles in question.
That should not be necessary, unless the dump contained objects that
require superuser permission to create (such as C-language functions)
--- in which case givi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Just a short followup...
Andreas Haumer schrieb:
> Hi!
>
> I must be blind or something but it seems I just can't
> figure out a working procedure to restore a PG dump in
> custom format (created with "pg_dump -Fc") into several
> different PG d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I must be blind or something but it seems I just can't
figure out a working procedure to restore a PG dump in
custom format (created with "pg_dump -Fc") into several
different PG databases with different owners (i.e. for
testing purposes)
I want
