Re: PG_ERROR 42501 permissions error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: byrnejb(at)harte-lyne(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG_ERROR 42501 permissions error
Date: 2010-12-01 22:01:28
Message-ID: 22310.1291240888@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"James B. Byrne" <byrnejb(at)harte-lyne(dot)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 read-write parameter. Sounds like you're using some client-side
software that's not designed to work against such an old server,
and expects that it can set the value however it likes.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2010-12-01 22:28:47 Re: Proper Permissions for /usr/local/pgsql/data
Previous Message Tom Lane 2010-12-01 21:54:21 Re: PG84 and SELinux