[BUGS] BUG #4845: cash_in is broken for lc_monetary = 'ja'

2009-06-10 Thread Itagaki Takahiro
The following bug has been logged online: Bug reference: 4845 Logged by: Itagaki Takahiro Email address: itagaki.takah...@oss.ntt.co.jp PostgreSQL version: 8.4dev, 8.3.7 Operating system: Windows XP Description:cash_in is broken for lc_monetary = 'ja' Details: The t

Re: [BUGS] BUG #4838: Database corruption after btree_gin index creation

2009-06-10 Thread Daniele Bortoluzzi
2009/6/10 Tom Lane : [...] > I cannot replicate this problem based on the little information > provided.  The GIN bug we found a couple of days ago would explain > the "tuple offset out of range" errors, and if you had had Asserts > enabled it would explain Assert failures; but I don't see that it

[BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Anders Gunnarsson
The following bug has been logged online: Bug reference: 4846 Logged by: Anders Gunnarsson Email address: fsog...@passagen.se PostgreSQL version: newest Operating system: Windows XP Description:Error reading file: config Details: Problem running post-install step. I

Re: [BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Dave Page
On Wed, Jun 10, 2009 at 9:40 AM, Anders Gunnarsson wrote: > > The following bug has been logged online: > > Bug reference:      4846 > Logged by:          Anders Gunnarsson > Email address:      fsog...@passagen.se > PostgreSQL version: newest > Operating system:   Windows XP > Description:        

Re: [BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Dave Page
On Wed, Jun 10, 2009 at 9:58 AM, Anders Gunnarsson wrote: > Very fast support! > > I managed to install it but when I tried to start the program (Holdem > Manager) which uses PostgreSQL it says: "new encoding (SQL_ASCII) is > incompatible with the encoding of the template database (UTF8) > > I trie

[BUGS] BUG #4847: Encoding is incompatible with template database

2009-06-10 Thread Anders Gunnarsson
The following bug has been logged online: Bug reference: 4847 Logged by: Anders Gunnarsson Email address: fsog...@passagen.se PostgreSQL version: 8.4 Operating system: Windows XP Description:Encoding is incompatible with template database Details: Hey, I had problem

[BUGS] BUG #4848: Encoding is incompatible with template database

2009-06-10 Thread Anders Gunnarsson
The following bug has been logged online: Bug reference: 4848 Logged by: Anders Gunnarsson Email address: fsog...@passagen.se PostgreSQL version: 8.4 Operating system: Windows XP Description:Encoding is incompatible with template database Details: So, now I am a mem

[BUGS] patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Simon Bertrang
Hi, the following patch does two things on OpenBSD: 1) Add missing libs to the krb5/com_err check that are required. We have this in our ports tree since 7.4.3 but i can't find any report about it, so here it finally is. 2) Prevent the use of -Wl,--as-needed in the readline case but use

Re: [BUGS] BUG #4848: Encoding is incompatible with template database

2009-06-10 Thread Simon Bertrang
On Wed, Jun 10, 2009 at 09:16:40AM +, Anders Gunnarsson wrote: > > The following bug has been logged online: > > Bug reference: 4848 > Logged by: Anders Gunnarsson > Email address: fsog...@passagen.se > PostgreSQL version: 8.4 > Operating system: Windows XP > Description:

Re: [BUGS] BUG #4846: Error reading file: config

2009-06-10 Thread Dave Page
On Wed, Jun 10, 2009 at 10:46 AM, Anders Gunnarsson wrote: > Is It possible to change to template0 on the existing DB? > Created a new one in pgAdmin with template0, both the old postgres-db and > this new one got red X on themself in "pgadmin", and the program saw this > new DB as unknown and whou

[BUGS] Postgres

2009-06-10 Thread Andreas Mutota
Hallow, I am wondering if your server is up and running. I have been trying to register myself with user list-forum. I could not getting through. I have quick query concerning about postgres installation in Linux machine. I have managed installing Postgres in my machine(Linux). I could

Re: [BUGS] Postgres

2009-06-10 Thread hubert depesz lubaczewski
On Wed, Jun 10, 2009 at 12:38:14PM +0200, Andreas Mutota wrote: > I could create database and tables but I cannot populate data into any of > the tables. what do you mean by "cannot populate"? what commands are you using? what are the error messages? Best regards, depesz -- Linkedin: http://w

[BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Greg Stark
On Wed, Jun 10, 2009 at 10:25 AM, Simon Bertrang wrote: > > the following patch does two things on OpenBSD: Thank you. >  1) Add missing libs to the krb5/com_err check that are required. >    We have this in our ports tree since 7.4.3 but i can't find any >    report about it, so here it finally

Re: [BUGS] BUG #4838: Database corruption after btree_gin index creation

2009-06-10 Thread Tom Lane
Daniele Bortoluzzi writes: > If I cannot reproduce the error, what is the best way to catch the > stack trace? Do I have to recompile with --enable-debug? Yes, that would be the best thing. If you are using gcc there is no harm in using --enable-debug all the time; it just makes the executable f

Re: [BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Tom Lane
Greg Stark writes: > This seems really weird. Firstly, doesn't OpenBSD use ELF? Shouldn't > the library pull in the indirectly needed libraries automatically? But > more to the point, why on *earth* would com_err depend on -lssl and > -lcrypto? com_err is just a standard error handling library. W

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread Dhaval Jaiswal
Hi All, postgres=# select to_timestamp('20096010','MMDD'); to_timestamp --- 2013-12-18 00:00:00+05:30 (1 row) The month is 60 in my case and it is giving some random value, whereas I am expecting some error message like date is not valid. Is it an ex

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread Greg Stark
On Wed, Jun 10, 2009 at 3:23 PM, Dhaval Jaiswal wrote: > > postgres=# select to_timestamp('20096010','MMDD'); > >    to_timestamp > --- >  2013-12-18 00:00:00+05:30 > > (1 row) > > The month is 60 in my case and it is giving some random value, whereas I am > expectin

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread Tom Lane
Greg Stark writes: > On Wed, Jun 10, 2009 at 3:23 PM, Dhaval > Jaiswal wrote: >> postgres=# select to_timestamp('20096010','MMDD'); >> --- >>  2013-12-18 00:00:00+05:30 > I suspect you'll find that the 60th month after the start of 2009 is > in fact december 2013. Yea

[BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Simon Bertrang
On Wed, Jun 10, 2009 at 02:19:30PM +0100, Greg Stark wrote: > On Wed, Jun 10, 2009 at 10:25 AM, Simon Bertrang wrote: > > > > the following patch does two things on OpenBSD: > > Thank you. > > > >  1) Add missing libs to the krb5/com_err check that are required. > >    We have this in our ports

[BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Greg Stark
On Wed, Jun 10, 2009 at 4:07 PM, Simon Bertrang wrote: > > Anyway, the reason why our com_err depends on libssl and libcrypto is > because it is linked into libkrb5; libcom_err is just a link to libkrb5: > > $ ls -il /usr/lib/libkrb5.so.16.0 /usr/lib/libcom_err.so.16.0 > 1117313 -r--r--r--  4 root

Re: [BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Simon Bertrang
On Wed, Jun 10, 2009 at 10:05:36AM -0400, Tom Lane wrote: > Greg Stark writes: > > This seems really weird. Firstly, doesn't OpenBSD use ELF? Shouldn't > > the library pull in the indirectly needed libraries automatically? But > > more to the point, why on *earth* would com_err depend on -lssl and

Re: [BUGS] BUG #4845: cash_in is broken for lc_monetary = 'ja'

2009-06-10 Thread Tom Lane
"Itagaki Takahiro" writes: > The type input function for money is broken > if lc_monetary is set to zero-precision locale. > Since Japanese "yen" has no decimal fractions, > lconv.frac_digits is 0 when lc_monetary = 'ja'. Looks like a good fix, will apply. regards, tom la

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread Dhaval Jaiswal
Yes, there isn't a use case for a month value outside 1-12, i found this due a typo. On Wed, Jun 10, 2009 at 8:12 PM, Tom Lane wrote: > Greg Stark writes: > > On Wed, Jun 10, 2009 at 3:23 PM, Dhaval > > Jaiswal wrote: > >> postgres=# select to_timestamp('20096010','MMDD'); > >> ---

Re: [BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Simon Bertrang
On Wed, Jun 10, 2009 at 05:20:00PM +0200, Simon Bertrang wrote: > On Wed, Jun 10, 2009 at 10:05:36AM -0400, Tom Lane wrote: > > Greg Stark writes: > > > This seems really weird. Firstly, doesn't OpenBSD use ELF? Shouldn't > > > the library pull in the indirectly needed libraries automatically? But

[BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
The following bug has been logged online: Bug reference: 4849 Logged by: David Leppik Email address: dlep...@vocalabs.com PostgreSQL version: 8.3.5 Operating system: Linux (CentOS 5.2) Description:intermittent future timestamps Details: We are intermittently getting

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread Tom Lane
"David Leppik" writes: > We are intermittently getting results from now() which are around 10 minutes > in the future. Most calls return a reasonable value. Because the erroneous > timestamps are in the future, they cannot be explained by transaction > delays. Postgres is just reporting what it

Re: [HACKERS] [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-10 Thread Tom Lane
Given that RC freeze is nearly upon us for 8.4, and that we need a reasonably non-invasive fix for 8.3 anyway, I propose that for now we just deal with the syncscan issue by tweaking heap_rescan so that rs_startblock doesn't get changed. It looks like that's about a three-line patch. The question

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
Never mind. Turns out the bug was in our own code (read: me, personally, being stupid) to convert a java.sql.Timestamp to java.sql.Date. Why it works at all in MySQL... I don't even want to know. Why is it we can spend weeks looking at a bug, and we can't find it until we decide to bla

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread Kevin Grittner
David Leppik wrote: > Never mind. Turns out the bug was in our own code (read: me, > personally, being stupid) to convert a java.sql.Timestamp to > java.sql.Date. Why it works at all in MySQL... I don't even want > to know. java.sql.Date or java.util.Date? (You don't show your imports,

Re: [BUGS] BUG #4849: intermittent future timestamps

2009-06-10 Thread David Leppik
My typo. Converting java.sql.Timestamp to java.util.Date was buggy on my end. David On Jun 10, 2009, at 1:00 PM, Kevin Grittner wrote: David Leppik wrote: Never mind. Turns out the bug was in our own code (read: me, personally, being stupid) to convert a java.sql.Timestamp to java.sql.D

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread Peter Eisentraut
On Wednesday 10 June 2009 18:02:45 Dhaval Jaiswal wrote: > Yes, there isn't a use case for a month value outside 1-12, i found this > due a typo. What Would Oracle Do? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.o

Re: [BUGS] Re: patch to fix configure(.in) on openbsd wrt/ krb5/com_err and readline linking

2009-06-10 Thread Tom Lane
Simon Bertrang writes: > Found it: spillboon has --with-gssapi in configure flags which pulls the > missing pieces in. We don't build with GSSAPI enabled though, hence the > patch. Applied to HEAD only. We might consider a back-patch if there are no reports of trouble.

Re: [HACKERS] [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-10 Thread Mark Kirkwood
Tom Lane wrote: Given that RC freeze is nearly upon us for 8.4, and that we need a reasonably non-invasive fix for 8.3 anyway, I propose that for now we just deal with the syncscan issue by tweaking heap_rescan so that rs_startblock doesn't get changed. It looks like that's about a three-line pa

[BUGS] BUG #4850: install of PostGIS password error

2009-06-10 Thread ALEC TEBBUTT
The following bug has been logged online: Bug reference: 4850 Logged by: ALEC TEBBUTT Email address: suns...@dccnet.com PostgreSQL version: 8.3.7.1 Operating system: Win XP Pro SP3 Description:install of PostGIS password error Details: When installing PostGIS 1.3.6

Re: [BUGS] to_timestamp error handling.

2009-06-10 Thread tushar
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Eisentraut wrote: > On Wednesday 10 June 2009 18:02:45 Dhaval Jaiswal wrote: >> Yes, there isn't a use case for a month value outside 1-12, i found this >> due a typo. > > What Would Oracle Do? Oracle is throwing an error.