The following bug has been logged online:
Bug reference: 3730
Logged by: Penty Wenngren
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3 BETA 2
Operating system: FreeBSD 7 BETA 2
Description:Creating a swedish dictionary fails
Details:
I'm trying to create a
Andrius,
see the explanation about that at
http://www.postgresql.org/docs/8.3/static/functions-comparison.html for
more details.
Cheers
Julo
Heikki Linnakangas wrote:
Andrius Glozeckas wrote:
I have a parent_type_id linking to group_type_id on the same table
(group_type). I am trying to
The following bug has been logged online:
Bug reference: 3729
Logged by: Andrius Glozeckas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux Fedora 7
Description:Query doesn't return the right answer
Details:
I have a parent_type_id
Andrius Glozeckas wrote:
I have a parent_type_id linking to group_type_id on the same table
(group_type). I am trying to get the groups with certain parent_type_id (be
it null or 17) and the number of their children in the same query:
SELECT g1.*, COUNT(g2.*)
FROM group_type g1 LEFT JOIN group_
On Wed, Nov 07, 2007 at 02:41:51PM -0500, Steve Langasek wrote:
> On Wed, Nov 07, 2007 at 01:49:53PM -0500, Tom Lane wrote:
> > All the other diffs that Martin showed are divide-by-zero failures,
> > and I do not see any of them on Gentoo's machine. I think that this
> > must be a compiler bug. T
heasley napsal(a):
The following bug has been logged online:
Bug reference: 3728
Logged by: heasley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.10
Operating system: sparc-sun-solaris2.9 gcc-4.1.1
Description:pthread autoconf hangs
Details:
If the auto
Andrius Glozeckas wrote:
> I have a parent_type_id linking to group_type_id on the same table
> (group_type). I am trying to get the groups with certain parent_type_id (be
> it null or 17) and the number of their children in the same query:
>
> SELECT g1.*, COUNT(g2.*)
> FROM group_type g1 LEFT J
Tom Lane wrote:
> "Andreas Pflug" <[EMAIL PROTECTED]> writes:
>
>> If replace is used with UTF8 client_encoding, searching for a malformed
>> string, the backend will crash.
>>
>
>
>> SELECT replace('Ärger', chr(195), 'Ae')
>>
>
> I see no crash here. Maybe it's been fixed since 8
On Thu, Nov 08, 2007 at 11:23:39AM +, Andrius Glozeckas wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3729
> Logged by: Andrius Glozeckas
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.2.5
> Operating system: Linux Fedora 7
> Descript
"Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes:
> A few moments ago I got the following message, but didn't found any
> reference on the internet (including lists).
> Nov 8 13:50:56 SERVER postgres[18874]: [5-1] user=XXX,db=XXXPANIC: hash
> table "PROCLOCK hash" corrupted
> The error showed
"Penty Wenngren" <[EMAIL PROTECTED]> writes:
> I'm trying to create a swedish dictionary for tsearch as specified in the
> 8.3 manual, but it breaks:
Can you point us to copies of the swedish files you used?
regards, tom lane
---(end of broadcast)-
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Is there a reason you rounded off most of the costs? It looks like the
> estimated costs of the two join types are nearly equal, and so it's pure
> chance which one gets chosen.
No real reason, it's just a post-processing script used to make
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> I tried the patch you sent, with no change. However, I then changed the
> default_statistics_target to 100, reanalyzed, and it came back with the
> "good" plan. Trying this on the original larger query (which pulls from
> tables with millions o
The following bug has been logged online:
Bug reference: 3731
Logged by: Daniel Cristian Cruz
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Red Hat ES 4
Description:ash table "PROCLOCK hash" corrupted
Details:
A few moments ago I got t
"Sam Mason" <[EMAIL PROTECTED]> writes:
> I've just discovered that an index that doesn't refer to any of its table's
> columns isn't automatically dropped when its table is.
I've applied a patch for this:
http://archives.postgresql.org/pgsql-committers/2007-11/msg00137.php
On Thu, Nov 08, 2007 at 11:42:55AM -0500, Tom Lane wrote:
> "Penty Wenngren" <[EMAIL PROTECTED]> writes:
> > I'm trying to create a swedish dictionary for tsearch as specified in the
> > 8.3 manual, but it breaks:
>
> Can you point us to copies of the swedish files you used?
>
I just realized I
Daniel Cristian Cruz wrote:
> A few moments ago I got the following message, but didn't found any
> reference on the internet (including lists).
>
> Nov 8 13:50:56 SERVER postgres[18874]: [5-1] user=XXX,db=XXXPANIC: hash
> table "PROCLOCK hash" corrupted
>
> The error showed after some query t
Thu, Nov 08, 2007 at 11:04:01AM +0100, Zdenek Kotala:
> heasley napsal(a):
> >The following bug has been logged online:
> >
> >Bug reference: 3728
> >Logged by: heasley
> >Email address: [EMAIL PROTECTED]
> >PostgreSQL version: 8.1.10
> >Operating system: sparc-sun-solaris2.9 g
Penty Wenngren <[EMAIL PROTECTED]> writes:
> On Thu, Nov 08, 2007 at 05:21:17PM -0500, Tom Lane wrote:
>> I suspect you are working in a locale that doesn't think à is a
>> letter --- check lc_ctype.
> It doesn't seem to make any difference. The first try was done from a
> terminal that didn't ca
Penty Wenngren <[EMAIL PROTECTED]> writes:
> I used iconv to convert svenska.aff and svenska.datalist (from
> iswedish-1.2.1) to UTF-8. The converted files can be found at:
> http://www.lederhosen.org/swedish.affix
> http://www.lederhosen.org/swedish.dict
I think the reason it's failing right ther
20 matches
Mail list logo
