View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 08:09 PM
Andreas Pflug
 
Posts: n/a
Default Re: serial types, pg_depend, permissions

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, your diagnose is quite right, missing permissions; we should check
that before trying to add the dependency.
In addition, this is code from early days, apparently adding a serial is
now supported in 8.0, I missed that. Still, since pgAdmin supports
adding arbitrary sequences too, we can't drop the pg_dependency stuff
completely.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote