[BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Lee Packham
The following bug has been logged online: Bug reference: 3699 Logged by: Lee Packham Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: OSX Leopard Description:Fails to compile DTrace Support Details: I have built a patch to enable a workin

[BUGS] BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250"

2007-10-26 Thread Marek Romanowski
The following bug has been logged online: Bug reference: 3700 Logged by: Marek Romanowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3-beta1 Operating system: Windows XP Professional Description:initdb could not find suitable encoding for locale "Polish_Po

Re: [BUGS] BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250"

2007-10-26 Thread Magnus Hagander
On Fri, Oct 26, 2007 at 08:39:21AM +, Marek Romanowski wrote: > > The following bug has been logged online: > > Bug reference: 3700 > Logged by: Marek Romanowski > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3-beta1 > Operating system: Windows XP Professional

Re: [BUGS] BUG #3700: initdb could not find suitable encoding for locale "Polish_Poland.1250"

2007-10-26 Thread Dave Page
Marek Romanowski wrote: > The following bug has been logged online: > > Bug reference: 3700 > Logged by: Marek Romanowski > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3-beta1 > Operating system: Windows XP Professional > Description:initdb could not find

[BUGS] connection problem

2007-10-26 Thread annaiah h
Help me ,please. I have installed pgsql-8.2.5 on redhat-Linux server and pdAdmin3 on windows-xp, When i try to connect to installed PGSQL on win-xp with Linux-server i get the message : Connection refused (0x274D/10061) All changes in pg_hba.conf and in postgresql.conf have done.Maybe i mus

Re: [BUGS] connection problem

2007-10-26 Thread Tom Lane
"annaiah h" <[EMAIL PROTECTED]> writes: > When i try to connect to installed PGSQL on win-xp with Linux-server i get > the message : > Connection refused (0x274D/10061) Either you didn't start the postmaster, or there's a firewall filter blocking your access to port 5432 ...

Re: [BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Tom Lane
"Lee Packham" <[EMAIL PROTECTED]> writes: > I have built a patch to enable a working DTrace on OSX with Postgres 8.2.5. You can't seriously expect us to accept a patch that rips out Solaris dtrace support to put in OSX dtrace support :-(. Can't you fix it so that it still uses the PG_TRACEn macro

Re: [BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Robert Lor
From: Lee Packham <[EMAIL PROTECTED]> > I have built a patch to enable a working DTrace on OSX with Postgres 8.2.5. > Basically the problem is that the dtrace command on OSX doesn't have > the -G > parameter - so you have to use the newer -h method to produce a header > file. > It bothers me t

Re: [BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Lee Packham
The only thing I couldn't do was sort out the makefile to auto generate the header file. So the patch has a pre-built header file. I don't know Make well, enough. Sorry. But yeah - I was pretty annoyed they broke the -G parameter (i.e. didn't include it at all. Cheers, Lee. On 10/26/07, Robert

Re: [BUGS] Yet another problem with ILIKE and UTF-8

2007-10-26 Thread Gergely Bor
Hello Gregory, hello all, I've tested the DB created with hu_HU.UTF8 lc_* settings and it works like a charm! We'll re-create the database and move the contents. It's a nice improvement of 8.3 to detect and disallow such misconfiguration. -- Summing up the issue & fix (for googling): - Ve

Re: [BUGS] Possible planner bug/regression introduced in 8.2.5

2007-10-26 Thread Jakub Ouhrabka
Hi Tom, Hmm. I think there are two different bugs involved here. One is fixed by the attached patch, and it masks the performance problem on your test case, but I wonder whether it will be enough for your real application. Can you try this and see if it fixes 8.2.5 for you? many thanks for t

[BUGS] The PostgreSQL Data directory Must be on an NTFS formatted Volume

2007-10-26 Thread larm
Hello I have a problem with the installation: Data directory error: The PostgreSQL Data directory Must be on an NTFS formatted Volume Regards Toke ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] Possible planner bug/regression introduced in 8.2.5

2007-10-26 Thread Tom Lane
Jakub Ouhrabka <[EMAIL PROTECTED]> writes: > We did some test today with patched 8.2.5. For some cases it is ok but > for large ones it is still taking quite a big time (e.g. for 23 joins is > the planning time 107s). Maybe there's no regression from 8.2.4 - we'll > do the tests against 8.2.4 on

Re: [BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Tom Lane
"Lee Packham" <[EMAIL PROTECTED]> writes: > Dtrace is in Leopard. Just so you know :) Hmph ... that might be enough of a reason to upgrade right there ... regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is

Re: [BUGS] The PostgreSQL Data directory Must be on an NTFS formatted Volume

2007-10-26 Thread David Fetter
On Fri, Oct 26, 2007 at 03:49:09PM +0200, [EMAIL PROTECTED] wrote: > Hello > > I have a problem with the installation: Data directory error: > > The PostgreSQL Data directory Must be on an NTFS formatted Volume That's not a bug. It's a pretty obvious instruction on what you need to do. Cheers,

Re: [BUGS] BUG #3699: Fails to compile DTrace Support

2007-10-26 Thread Robert Lor
Tom Lane-2 wrote: > > "Lee Packham" <[EMAIL PROTECTED]> writes: >> Dtrace is in Leopard. Just so you know :) > > Hmph ... that might be enough of a reason to upgrade right there ... > > I believe ZFS is also in Leopard. Even more reason to upgrade! -Robert -- View this message in context:

Re: [BUGS] Possible planner bug/regression introduced in 8.2.5

2007-10-26 Thread Tom Lane
I wrote: > ...probably have some cases like that in your real application. But I'd > expect 8.2.4 to be equally slow because it also contains the code that > is slow in that scenario. I'm hoping to get some time today to think > about how that could be fixed. Please try the attached patch (in ad

[BUGS] BUG #3701: Don't work intarray GIN indexes

2007-10-26 Thread girla
The following bug has been logged online: Bug reference: 3701 Logged by: girla Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta1 Operating system: Windows XP Proffesional SP2 Description:Don't work intarray GIN indexes Details: 8.3beta1 never used intarr

Re: [BUGS] The PostgreSQL Data directory Must be on an NTFS formatted Volume

2007-10-26 Thread Chris Browne
[EMAIL PROTECTED] writes: > I have a problem with the installation: Data directory error: > > The PostgreSQL Data directory Must be on an NTFS formatted Volume In which way does this appear to be a bug? Is the volume you are trying to put the database on an NTFS-formatted one, and the system is n

Re: [BUGS] BUG #3701: Don't work intarray GIN indexes

2007-10-26 Thread Tom Lane
"girla" <[EMAIL PROTECTED]> writes: > 8.3beta1 never used intarray GIN indexes. Works for me: contrib_regression=# \d test__int Table "public.test__int" Column | Type| Modifiers +---+--- a | integer[] | Indexes: "text_idx" gin (a gin__int_ops) contr