Not sure this is the right answer: in older version you could enable
it via the postgresql.conf file, modifing the variable log_statement
and setting that to true. Also, you should check the syslog level
variable in the same file.
Regards
Marco
On 6/17/06, Mark Constable <markc@xxxxxxxxx> wrote:
On Sunday 18 June 2006 02:33, Tom Lane wrote:
> > uid is an email address stored in the passwd table as user@xxxxxxxxxx
> > and this construct allows an incoming username such as "user.domain.com"
> > to be compared to the stored "user@xxxxxxxxxx".
> But, if you're not wedded to that particular way, why not use replace()?
I only decided to ditch MySQL tonight so I'm within the first
1/2 dozen hours of using pgsql for almost the first time. I've
lost a fair amount of hair with the basics of db and user setup
and close to burnout.
> SELECT wpath FROM passwd WHERE uid="\L" OR replace(uid, '@', '.')="\L"
Excellent. Just the double quotes needed to be changed to single
quotes to avoid this error and replace() indeed works for my needs.
ERROR: column "user.domain.com" does not exist
Another anti-burnout question, how would I turn on the ability
to view any SQL requests in the logfile ?
No doubt there is an answer in the list archives somewhere but
my first few searches brought up nothing useful.
--markc
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Marco Bizzarri
http://notenotturne.blogspot.com/
