Re: serial types, pg_depend, permissions - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: serial types, pg_depend, permissions
Date
Msg-id 4347FD78.9070900@pse-consulting.de
Whole thread Raw
In response to serial types, pg_depend, permissions  (Christopher St John <ckstjohn@gmail.com>)
List pgadmin-support
Christopher St John wrote:
> i'm using pgadmin3 v1.2.2 on os x against a postgres 8.0.3 server to
> add a bigserial column to a table. i'm getting the error:
> 
>   ERROR: permission denied for relation pg_depend

Ok, you're missing write privileges on pg_depend; we didn't check that.
I added code to svn to support this, thanks for reporting.

Apparently, after the initial implementation of pgAdmin's add column 
code (for 7.3), adding serial and bigserial to existing tables has been 
implemented; formerly, this didn't work.
Dave, I only have 8.0+ servers running, can you check when ALTER TABLE 
xxx ADD COLUMN xxx serial was introduced, for 7.4 or 8.0?

In the meanwhile, dlgColumn.cpp:285 assumes pgsql>= 8.0.

Regards,
Andreas


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: serial types, pg_depend, permissions
Next
From: "Chris Saringolis"
Date:
Subject: Backup / Restore not working