Re: Per-column collation

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Per-column collation
Date: 2010-12-04 16:01:24
Message-ID: 1291478484.3568.2.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On tor, 2010-11-18 at 21:37 +0200, Heikki Linnakangas wrote:
> On 15.11.2010 21:42, Peter Eisentraut wrote:
> > On mån, 2010-11-15 at 11:34 +0100, Pavel Stehule wrote:
> >> I am checking a patch. I found a problem with initdb
> >
> > Ah, late night brain farts, it appears. Here is a corrected version.
>
> Some random comments:
>
> In syntax.sgml:
>
> > + The <literal>COLLATE</literal> clause overrides the collation of
> > + an expression. It is appended to the expression at applies to:
>
> That last sentence doesn't parse.

Fixed in the patch I'm about to send out.

> Would it be possible to eliminate the ExecEvalCollateClause function
> somehow? It just calls through the argument. How about directly
> returning the argument ExprState in ExecInitExpr?

This currently mirrors the handling of RelabelType. Perhaps both could
be improved, but that is an independent issue.

> get_collation_name() returns the plain name without schema, so it's not
> good enough for use in ruleutils.c. pg_dump is also ignoring collation's
> schema.

Fixed schema handling in ruleutils and pg_dump in new patch.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2010-12-04 16:02:52 Re: Per-column collation
Previous Message Kevin Grittner 2010-12-04 15:46:24 Re: Requirement for the Buffer manager to load multiple pages at once