On Thu, Apr 8, 2010 at 1:52 PM, dipti shah <shahdipti1...@gmail.com> 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: misiekb...@gmail.com FB: http://tinyurl.com/fbmbst MS: http://myspace.com/mpawlikowski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general