Re: [BUGS] BUG #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Tom Lane
Craig Ringer writes: > On 23/10/2010 1:11 AM, Tom Lane wrote: >> Why do you expect that? The parameter only controls the *server*'s >> output, it is not suggested anywhere that it should have an effect >> on clients. > I'm not at all sure what the right answer is here. I just wanted to > raise

Re: [BUGS] BUG #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Craig Ringer
On 23/10/2010 1:11 AM, Tom Lane wrote: "Eiichi Nakamura" writes: For PostgreSQL 9.0.1, after changing server "bytea_output" parameter as "escape" in postgresql.conf file, it is expected that PQescapeByteaConn (libpq) returns "escape" format. Why do you expect that? The parameter only control

Re: [BUGS] BUG

2010-10-22 Thread Alexia Lau
Hi Dharmendra, I am encountering the same exact problem with the 9.0 one-click installer for Linux from EnterpriseDB on SUSE 11 and RedHat 5.5 with the latest release this week. In your email dated 9/28/10, you indicated it's fixed. Will you fix it for SUSE 11 and RedHat 5.5? Sincerely, Alex

[BUGS] BUG #5721: EnterpriseDB linux one-click installer missing libuuid.so.16

2010-10-22 Thread Alexia Lau
The following bug has been logged online: Bug reference: 5721 Logged by: Alexia Lau Email address: a...@esri.com PostgreSQL version: 9.0.1 Operating system: SUSE 11/RHEL 5.5 32-bit & 64-bit Description:EnterpriseDB linux one-click installer missing libuuid.so.16 Detai

Re: [BUGS] BUG #5719: Constraint Problem

2010-10-22 Thread Alex Hunsaker
On Thu, Oct 21, 2010 at 12:03, Alex Hunsaker wrote: > Or if you just want the not null constraints: > create table kittu1 (like kota1 including constraints); Correction, the above should read: "Or, if you want check constraints". Not null constraints are always copied, and including constraints

Re: [BUGS] BUG #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Tom Lane
"Eiichi Nakamura" writes: > For PostgreSQL 9.0.1, after changing server "bytea_output" parameter as > "escape" in postgresql.conf file, it is expected that PQescapeByteaConn > (libpq) returns "escape" format. Why do you expect that? The parameter only controls the *server*'s output, it is not su

[BUGS] BUG #5720: Bug for PQescapeByteaConn (libpq)

2010-10-22 Thread Eiichi Nakamura
The following bug has been logged online: Bug reference: 5720 Logged by: Eiichi Nakamura Email address: nakam...@nepsys.ddo.jp PostgreSQL version: 9.0.1 Operating system: Linux kernel 2.6.27 Description:Bug for PQescapeByteaConn (libpq) Details: For PostgreSQL 9.0.1