| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Christopher St John <ckstjohn(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org, Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
| Subject: | Re: serial types, pg_depend, permissions |
| Date: | 2005-10-08 17:10:16 |
| Message-ID: | 4347FD78.9070900@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Saringolis | 2005-10-10 02:30:58 | Backup / Restore not working |
| Previous Message | Andreas Pflug | 2005-10-07 15:22:38 | Re: serial types, pg_depend, permissions |