Andy Colson <andy@xxxxxxxxxxxxxxx> writes: > Having a little problem with my large objects. In 8.4 the db owner was > 'andy', but my web connected as payuser (which had appropriate permissions). > The backup/restore to pg9 made all the large objects owned by 'andy', > and I'm guessing payuser does not have select rights. If you just want it to work like it did before, I believe there's a server parameter you can change to disable permissions checks on large objects. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
