Re: merging 2 dumps / dumping only 1 schema

Am Sam, 2003-08-02 um 18.43 schrieb Nabil Sayegh:

> There is no errormsg. and the data gets inserted into the table with the
> 'wrong' value.
>
> Is that because of the old-style RI ?

Apart from that:
Is it possible to pg_dump a specific table from a specific schema ?
The db has n schemas. Each schema belongs to a different user.
When I do
pg_dump -U user_of_specific_schema -a -t table_to_dump
I get pg_dump: Attempt to lock table "table_to_dump" failed.  ERROR:
other_user: permission denied

Shouldn't it use the search_path ?

Apparently it tries to dump all tables from all schema.

It also doesnt accept the table as schema.table.
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de