Re: Current enums patch - Mailing list pgsql-patches

From Tom Dunstan
Subject Re: Current enums patch
Date
Msg-id 46115A52.7010702@tomd.cc
Whole thread Raw
In response to Re: Current enums patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Current enums patch  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-patches
Tom Lane wrote:
> But probably making them act like identifiers is not a good idea,
> because I doubt we want automatic downcasing in enum_in.  People
> wouldn't be happy if they had to write WHERE color = '"Red"' or
 > something like that to get at a mixed-case enum label.

Ah, that's what you had in mind. Yeah, that's a bit verbose.

 > Let's
> just throw the error instead.  (I agree that enum_in can just fail
> with "no such label", but CREATE TYPE ought to give a specific
> error about it.)

Agreed.

Andrew, you said you had a mostly-working patch already?

Cheers

Tom


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Blocked post
Next
From: Bruce Momjian
Date:
Subject: Re: Blocked post