[GENERAL] PG_ERROR 42501 permissions error

2010-12-01 Thread James B. Byrne
It never rains but it pours they say. I am trying to extract (ad hoc) some data from my production database on the 8.1 service that I tried to upgrade to 8.4. I am using the same username and password as is used by a process hosted on the same server as the posgresql instance. That process works

Re: [GENERAL] PG_ERROR 42501 permissions error

2010-12-01 Thread Tom Lane
James B. Byrne byrn...@harte-lyne.ca writes: I am particularly nonplussed over the 'ERROR: 55P02: parameter standard_conforming_strings cannot be changed' message. Can anyone here clue me in as to what I am doing wrong? 8.1 did have a read-only parameter named that; in 8.2 and later it's a