[GENERAL] Documentation on standard conforming strings?

2009-10-05 Thread Preston de Guise
Hi, I don't yet properly understand the conforming strings implementation that came in 8.3 The manual (to me at least) has been a little imprecise in describing the implications for correctly inserting data with this enabled without getting back a plethora of warnings, or having the inser

Re: [GENERAL] Programming interfaces when using MD5 authentication

2009-10-05 Thread Preston de Guise
On 02/10/2009, at 23:47 , Tom Lane wrote: Preston de Guise writes: Using Perl to program interfaces to PostgreSQL, and had previously misunderstood how md5 password authentication worked, so I'm now re- doing it, but struggling to find out how DBD::Pg might be used to actually authent

[GENERAL] Programming interfaces when using MD5 authentication

2009-10-01 Thread Preston de Guise
scern) I actually need to submit: md5 md5($pass salt) Can DBD::Pg be used for these connections? If anyone has experience in this I'd much appreciate your thoughts or suggestions. (I realise the "connect" function is from DBI, but it seems to me that the