Re: [BUGS] BUG #3737: lower/upper fails to match extended chars in LATIN1

2007-11-12 Thread Heikki Linnakangas
(please keep the list cc'd) Jonas Forsman wrote: if I cannot change charset within a postgres installation and then benefit from all the features in postgres isn't that to be seen as a bug or at least it should be a workaround easier than dumping everything which I think is a too large risk to

[BUGS] BUG #3744: libpq.a missed from /lib directory

2007-11-12 Thread Lorenzo Fiorini
The following bug has been logged online: Bug reference: 3744 Logged by: Lorenzo Fiorini Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 beta2 Operating system: Windows 2000 Description:libpq.a missed from /lib directory Details: In the 8.2.5 there is a lib

Re: [BUGS] BUG #3744: libpq.a missed from /lib directory

2007-11-12 Thread Magnus Hagander
On Mon, Nov 12, 2007 at 08:14:16AM +, Lorenzo Fiorini wrote: > > The following bug has been logged online: > > Bug reference: 3744 > Logged by: Lorenzo Fiorini > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 beta2 > Operating system: Windows 2000 > Descriptio

Re: [BUGS] BUG #3744: libpq.a missed from /lib directory

2007-11-12 Thread Dave Page
Lorenzo Fiorini wrote: > The following bug has been logged online: > > Bug reference: 3744 > Logged by: Lorenzo Fiorini > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 beta2 > Operating system: Windows 2000 > Description:libpq.a missed from /lib directory

Re: [BUGS] BUG #3737: lower/upper fails to match extended chars in LATIN1

2007-11-12 Thread Heikki Linnakangas
Jonas Forsman wrote: Recreating indicies is maybe not great but can be done quit easily compared to reinitializing a db or recoding an entire database. Sometimes a bit of a solution is all what it is needed. Would it be possible to change the locale on the fly and only recreate indicies afterwa

Re: [BUGS] BUG #3737: lower/upper fails to match extended chars in LATIN1

2007-11-12 Thread Jonas Forsman
From my point of view (administrators view, not developers) it is such a drawback in postgres implementation that it seriously challenges the position as a competitor to the big dragons. (IF they suffer from the same missing feature) Recreating indicies is maybe not great but can be done quit e

Re: [BUGS] BUG #3734: Invalid XML schema output.

2007-11-12 Thread Euler Taveira de Oliveira
Peter Eisentraut wrote: > Having a space before /> appears to be common practice, including in the > examples in the SQL/XML spec. > Agreed. Feel free to add whitespace before every /> of simple xml elements. -- Euler Taveira de Oliveira http://www.timbira.com/ ---

Re: [BUGS] BUG #3713: problem with thread safety???

2007-11-12 Thread Zdenek Kotala
Tom Lane napsal(a): So somehow src/test/thread/thread_test.c is missing from your source tree. The only reason I've seen for that happening is when people thought that they could download just the "base" tarball and not the whole source distribution. I found this problem as well when I verif

Re: [BUGS] BUG #3724: Duplicate values added to table despite unique index

2007-11-12 Thread Mason Hale
> >> 2. Can you check that there are still 1 (rather than 0) copies of the > >> rows in the 8.2.5 DB? > > > Yes, we have 1 of each row (I kept the most recently updated version of > > each): > > Ah, I forgot that the rows were obviously not identical because of the > differing updated_at values. >

Re: [BUGS] Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists

2007-11-12 Thread Pedro Gimeno Fortea
Tom Lane wrote: The hole in your argument is that this is not so. The purpose of a backup is to get the *user's* objects into the same state they were in. If we applied that reasoning to *system* objects then presumably loading a dump from an 8.2 database into 8.3 would magically destroy all th

[BUGS] BUG #3745: I am unable to load the data in postgresql DB

2007-11-12 Thread Jawad Hussain
The following bug has been logged online: Bug reference: 3745 Logged by: Jawad Hussain Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: Linux Description:I am unable to load the data in postgresql DB Details: Below is the error log I am g

[BUGS] Insert taking too long

2007-11-12 Thread Blanco, Jose
Recently, we ran an 'vacummdb --full' on our database, and I'm finding that a scrip that use to take just a couple of ours to run, is now taking 12 hours to run. It's a perl script that does a lot of inserting into a few tables. I've tried dropping indices to speed up the inserts, but this does n

Re: [BUGS] Insert taking too long

2007-11-12 Thread Tom Lane
"Blanco, Jose" <[EMAIL PROTECTED]> writes: > Recently, we ran an 'vacummdb --full' on our database, and I'm finding > that a scrip that use to take just a couple of ours to run, is now > taking 12 hours to run. It's a perl script that does a lot of inserting > into a few tables. I've tried droppi

Re: [BUGS] BUG #3745: I am unable to load the data in postgresql DB

2007-11-12 Thread Tom Lane
"Jawad Hussain" <[EMAIL PROTECTED]> writes: > WARNING: could not create listen socket for "localhost" > FATAL: could not create any TCP/IP sockets Sounds like your machine's DNS setup is broken, to the point where it can't resolve the name "localhost". regards, tom lane

Re: [BUGS] BUG #3730: Creating a swedish dictionary fails

2007-11-12 Thread Penty Wenngren
On Fri, Nov 09, 2007 at 05:39:58PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> After looking at the callers I'm inclined to think that the only > >> safe way to implement this routine is to change its API to provide > >> both counts. Comments? > >

Re: [BUGS] Postgresql Domain Names

2007-11-12 Thread Robin H
I am an unrelated company that received a similar email: > Dear Manager, We are China Net Technology Limited, which is the domain name register center in China.I have something need to confirm with you.    we have received an application formally,one company named "Lealui Holdings Limited" a

Re: [BUGS] Postgresql Domain Names

2007-11-12 Thread Andrew Sullivan
On Mon, Nov 12, 2007 at 10:53:39AM -0800, Robin H wrote: > It seems their whole business might be just going company by company to pump > registrations using the fear factor !! This is not at all unlikely -- many companies do this. For all that, they may also be owned by LEALUI Holdings Limited.