Re: [BUGS] postgresql8.1 crushes on some inserts/updates in KOI8 encoding

2005-11-20 Thread Tom Lane
Alexey Beschiokov <[EMAIL PROTECTED]> writes: > postgresql server crushes on some inserts / upates statements. BTW, the patch I sent you before was incomplete; one thing I found that it didn't cover was COPY. There is a better solution committed here: http://archives.postgresql.org/pgsql-committ

Re: [BUGS] BUG #2056: to_char no long takes time as input?

2005-11-20 Thread Tom Lane
"Nick Addington" <[EMAIL PROTECTED]> writes: > The following code works in 8.0.4 but fails in 8.1.0: > select to_char('1:00 pm'::time,'HH:MM AM'); I'm inclined to think that disallowing AM/PM for intervals was a mistake --- if we allow both HH and HH24 (which we do) then the various flavors of AM/

Re: [BUGS] password issues

2005-11-20 Thread Magnus Hagander
> In an attempt to download the PostgreSQL, I inadvertantly > choose to have a random password set. Since the random one > was a mile long, I hit the back key thinking this would allow > me to rechoose a password. Well, I was wrong, I have not > completed the download, and I can not access it s

[BUGS] Fwd: Bug#338645: postgresql-contrib-8.1: dbf2pg silently ignores the -F and -T options

2005-11-20 Thread Martin Pitt
Hi PostgreSQL developers! I recently received the Debian bug report below about missing iconv support for the dbf2pg contrib module. The submitter created a patch which replaces the silent ignoring of -F (when iconv support is disabled) with a meaningful warning. Do you consider applying this up

[BUGS] password issues

2005-11-20 Thread kerry
In an attempt to download the PostgreSQL, I inadvertantly choose to have a random password set. Since the random one was a mile long, I hit the back key thinking this would allow me to rechoose a password. Well, I was wrong, I have not completed the download, and I can not access it since I do

[BUGS] BUG #2057: unable to install a server on the admin

2005-11-20 Thread Yusuf Belgore
The following bug has been logged online: Bug reference: 2057 Logged by: Yusuf Belgore Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows xp Description:unable to install a server on the admin Details: says cannot resolve ip address.

Re: [BUGS] BUG #2042: Installation failed

2005-11-20 Thread Magnus Hagander
[back on list] Weird - that error indicates that the account that was either created or verified, suddenly was not available again! So. Repeating the question, what was the name of the account? And adding the question - was this an account the installer created, or was it a pre-existing account?

Re: [BUGS] BUG #2056: to_char no long takes time as input?

2005-11-20 Thread Michael Fuhr
On Sun, Nov 20, 2005 at 07:53:50AM +, Nick Addington wrote: > The following code works in 8.0.4 but fails in 8.1.0: > > select to_char('1:00 pm'::time,'HH:MM AM'); > > 8.1.0 gives this is the error message: > ERROR: invalid format specification for an interval value > HINT: Intervals are no