Re: [Gnumed-devel] Consumable substances

[Karsten Hilbert]

On Mon, Sep 05, 2011 at 01:41:05PM -0700, Jim Busser wrote:

> 2) when I run
> 
>       MacBook-2:bin djb$ ./pg_dump -U gm-dbo --data-only 
> --table=pg_temp_4.tallman -f install-data-pack.sql gnumed_v16
>       Password: 
> 
> I get
> 
>       pg_dump: SQL command failed
>       pg_dump: Error message from server: ERROR:  permission denied for 
> schema pg_temp_4

That means user gm-dbo does not have access rights for table
"tallman" (the schema pg_temp_4 is auto-assigned).

Which (database) user did you create that table as ?  I
would hazard a guess it wasn't gm-dbo ;-)

Actually, however, this is still different: since you are
doing the filling of the tallman table within one session
there is no tallman table anymore when you try to dump it
from another session -- since you declared it temporary. The
schema will still be around (because it is lazily garbage
collected) but you don't have permission to access it
(explanation above). *Having* permission would not help
because the (temp) table is gone anyway.

I'd suggest not using a temp table and rather explicitely
dropping it afterwards.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346