unsubscribe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
On Friday 16 September 2005 20:37, Josh Berkus wrote:
> People:
>
> The Eclipse project is interested in having PostgreSQL people contribute to
> their Data Services plug in. Do we have any java hackers in the
> community using Eclipse? Anyone interested?
Well I use Eclipse and PostgreSQL, but
hi
i have a table with more or less this structure:
id (serial)
category (ltree)
region (ltree[])
price (integer)
title (text)
entered (timestamptz)
now.
i would like to be able to search by region and category, but order using price, title or entered.
previous design was quite simple:
id (ser
I'm using PostgreSQL 7.3.6 and run into a permissions problem when a
particular constraint trigger is attempting to restore using
pg_restore.
Is there a good way to analyze what permissions are required for a
particular constraint trigger? I have a problem where it looks like a
contraint trigger
Greg Stark <[EMAIL PROTECTED]> writes:
> John Seberg <[EMAIL PROTECTED]> writes:
>> This tells me that Postgresql is not using the same
>> method for determining duplicates when GROUPING and
>> INDEXing.
> You might try running the GROUP BY query after doing:
> set enable_hashagg = false;
> With
Tom Lane <[EMAIL PROTECTED]> writes:
> If that does change the results, it indicates you've got strings which
> are bytewise different but compare equal according to strcoll(). We've
> seen this and other misbehaviors from some locale definitions when faced
> with data that is invalid per the en
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > If that does change the results, it indicates you've got strings which
> > are bytewise different but compare equal according to strcoll(). We've
> > seen this and other misbehaviors from some locale definitions
On Sat, Sep 17, 2005 at 11:50:44AM -0400, Greg Stark wrote:
> Hm. Some experimentation shows that at least on glibc's locale definitions the
> strings that I thought compared equal don't actually compare equal.
> Capitalization, punctuation, white space, while they're basically ignored in
> general
> I don't know if it's guarenteed by spec, but it certainly seems silly
> for strings to compare equal when they're not. Just because a locale
> sorts ignoring case doesn't mean that "sun" and "Sun" are the same. The
> only real sensible rule is that strcoll should return 0 only if strcmp
> would a
On Sat, Sep 17, 2005 at 12:45:17PM -0500, Mike Nolan wrote:
> > I don't know if it's guarenteed by spec, but it certainly seems silly
> > for strings to compare equal when they're not. Just because a locale
> > sorts ignoring case doesn't mean that "sun" and "Sun" are the same. The
> > only real se
Martijn van Oosterhout writes:
> On Sat, Sep 17, 2005 at 12:45:17PM -0500, Mike Nolan wrote:
> > > I don't know if it's guarenteed by spec, but it certainly seems silly
> > > for strings to compare equal when they're not. Just because a locale
> > > sorts ignoring case doesn't mean that "sun" and
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> If that does change the results, it indicates you've got strings which
>> are bytewise different but compare equal according to strcoll(). We've
>> seen this and other misbehaviors from some locale definitions when fa
On Sat, Sep 17, 2005 at 03:49:24PM -0400, Greg Stark wrote:
> Well, consider the case of a two different Unicode encoded strings that
> actually represent the same series of characters. They may be byte-wise
> different but there's really no difference at all in the text they contain.
Strictly spe
On Sun, Sep 11, 2005 at 11:00:02PM -0800, Poul Jensen wrote:
> Tom Lane wrote:
>
> >No, tableoid is sort of a virtual column ... it doesn't exist on disk.
> >When you query it you get a value fetched from the internal data
> >structure representing the table.
> >
> >
> So virtual columns are poss
Is there a pdf version of the documentation ? I find HTML version much
harder to read than a printed copy.
Thanks,
Warren Bell
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Sat, Sep 17, 2005 at 06:45:35PM -0700, Warren Bell wrote:
> Is there a pdf version of the documentation ? I find HTML version much
> harder to read than a printed copy.
Look under Documentation -> Manuals on the PostgreSQL web site.
http://www.postgresql.org/
--
Michael Fuhr
---
On Fri, Sep 16, 2005 at 12:12:04PM -0700, [EMAIL PROTECTED] wrote:
> I'm using PostgreSQL 7.3.6 and run into a permissions problem when a
> particular constraint trigger is attempting to restore using
> pg_restore.
Could you be more specific? What are you doing and what's the error
message?
--
17 matches
Mail list logo
