On Thu, Apr 8, 2010 at 1:52 PM, dipti shah <[email protected]> wrote: > techdb=> select * from techtable; > ERROR: permission denied for relation techtable > techdb=> > > ...and it gives permission denied..!
This should work: SELECT description from techtable; UPDATE techtable SET description = 'xyz' This should not work: select * from techtable; UPDATE techtable SET other_column = 'xyz' -- Pozdrawiam / Best Regards / Mit freundlichen Grüßen Michal Pawlikowski XMPP: [email protected] FB: http://tinyurl.com/fbmbst MS: http://myspace.com/mpawlikowski -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
