[BUGS] BUG #4866: ECPG and BYTEA

2009-06-19 Thread Rick Levine
The following bug has been logged online: Bug reference: 4866 Logged by: Rick Levine Email address: richard_d_lev...@raytheon.com PostgreSQL version: 8.3.7 Operating system: Windows Vista Description:ECPG and BYTEA Details: ECPG does not handle BYTEA columns properl

Re: [BUGS] BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1

2009-06-19 Thread Tom Lane
Brendan Jurd writes: > I hope that answers your question. to_date() is by nature a weird > beast with many strange corners in its behaviour, and it's hard to > strike a balance between backwards compatibility and Least > Astonishment. My personal preference would be for a 100% strict > interpret

Re: [BUGS] BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1

2009-06-19 Thread Brendan Jurd
2009/6/19 Tom Lane : > regression=# select to_date(' 2009 07', ' MM'); >  to_date > >  2009-07-01 > (1 row) > > However, that just begs the question --- it seems that leading space is > allowed in MM, just not in .  Brendan, is that intentional or is it > a bug? > The reason t

Re: [BUGS] BUG #4865: replace function returns null

2009-06-19 Thread Tom Lane
"Jamolkhon Khakimov" writes: > replace( 'abcdefabcdef', 'XX', null) > // returns null, while it should return 'abcdefabcdef' No, it should return null. Like most Postgres functions, replace is strict, meaning it returns null if any input is null. This is sensible in the abstract because an unkn

Re: [BUGS] BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1

2009-06-19 Thread Tom Lane
"Jeremy Ford" writes: > select > to_char(2009,'') as year, > to_char(3,'09') as month, > to_date(to_char(2009,'')||to_char(3,'99') ,'MM') as method1, > to_date(to_char(2009,'')||'-'||to_char(3,'09') || '-01','-MM-DD') > as method2 Or, eliminating the extraneous st

[BUGS] BUG #4865: replace function returns null

2009-06-19 Thread Jamolkhon Khakimov
The following bug has been logged online: Bug reference: 4865 Logged by: Jamolkhon Khakimov Email address: jkhaki...@gmail.com PostgreSQL version: 8.2.7 Operating system: Linux Description:replace function returns null Details: I dont know if it's a bug or not. It j

[BUGS] BUG #4864: rc1 not installs on Windows

2009-06-19 Thread pasman
The following bug has been logged online: Bug reference: 4864 Logged by: pasman Email address: pasma...@gmail.com PostgreSQL version: 8.4rc1 Operating system: WinXP sp2 Description:rc1 not installs on Windows Details: I run postgresql-8.4.0-rc1-1-windows.exe from ht

[BUGS] BUG #4863: postgresql.conf typo in log_line_prefix

2009-06-19 Thread Jan-Peter Seifert
The following bug has been logged online: Bug reference: 4863 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@gmx.de PostgreSQL version: 8.4 RC1 Operating system: Windows Description:postgresql.conf typo in log_line_prefix Details: log_line_prefix is s

Re: [BUGS] BUG #4861: Incorrect log_line_prefix default value in postgresql.conf

2009-06-19 Thread Dave Page
On Thu, Jun 18, 2009 at 11:44 PM, Milen A. Radev wrote: > Tom Lane написа: >> >> "Dmitry Ryabov" writes: >>> >>> Description:        Incorrect log_line_prefix default value in >>> postgresql.conf >> >>> log_line_prefix = '%%t ' >>> (must be log_line_prefix = '%t ') >> >> Uh, the default setting is

[BUGS] BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1

2009-06-19 Thread Jeremy Ford
The following bug has been logged online: Bug reference: 4862 Logged by: Jeremy Ford Email address: jeremf...@gmail.com PostgreSQL version: 8.4 RC1 Operating system: Fedora 10 i386 Description:different results in to_date() between 8.3.7 & 8.4.RC1 Details: Running t