On Thu, May 13, 2010 at 8:14 PM, David Fetter wrote:
>> Well, the inability to change the list of values is certainly an
>> unpleasant limitation, but is it so fatal that we should hide the
>> feature from people who could possibly use it? I think not.
>
> It's enough of a foot-gun that I would n
Excerpts from Tom Lane's message of vie may 14 00:32:12 -0400 2010:
> Josh Kupershmidt writes:
> > On Thu, May 13, 2010 at 8:08 PM, Tom Lane wrote:
> >> Well, the inability to change the list of values is certainly an
> >> unpleasant limitation, but is it so fatal that we should hide the
> >> fea
Josh Kupershmidt writes:
> On Thu, May 13, 2010 at 8:08 PM, Tom Lane wrote:
>> Well, the inability to change the list of values is certainly an
>> unpleasant limitation, but is it so fatal that we should hide the
>> feature from people who could possibly use it? I think not.
> I happened upon t
On Thu, May 13, 2010 at 8:08 PM, Tom Lane wrote:
> Well, the inability to change the list of values is certainly an
> unpleasant limitation, but is it so fatal that we should hide the
> feature from people who could possibly use it? I think not.
I happened upon this article relevant to the subje
On Thu, May 13, 2010 at 08:08:31PM -0400, Tom Lane wrote:
> David Fetter writes:
> > On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
> >> I'm surprised no one has yet suggested an ENUM type.
>
> > I didn't suggest it because I didn't know about it, but because
> > I've found ENUM to be
David Fetter writes:
> On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
>> I'm surprised no one has yet suggested an ENUM type.
> I didn't suggest it because I didn't know about it, but because I've
> found ENUM to be a trap for the unwary.
> Very seldom are people absolutely certain th
On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
> Josh Kupershmidt writes:
> > On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
> >> If you've measured a performance issue for a table that tiny, it's a
> >> bug that needs fixing in PostgreSQL. �What measurements have you done
> >>
ut of
pg_constraints.
Thanks Tom for that idea!
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, May 13, 2010 12:33 AM
To: Josh Kupershmidt
Cc: David Fetter; Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pulling data from a constraint def
Josh Kupershmidt writes:
> On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
>> If you've measured a performance issue for a table that tiny, it's a
>> bug that needs fixing in PostgreSQL. What measurements have you done
>> so far?
> Just for fun, I tried it out myself. Here are the times I
On Wed, May 12, 2010 at 12:58 AM, David Fetter wrote:
> If you've measured a performance issue for a table that tiny, it's a
> bug that needs fixing in PostgreSQL. What measurements have you done
> so far?
Just for fun, I tried it out myself. Here are the times I got on my
modest laptop:
CHECK
In response to Gauthier, Dave :
> I have a constraint defined on a table
>
> constraint design_style_is_invalid check (design_style in
> ('rls','sdp','rf','ssa','rom','rpt','analog','sdprpt','clkdist','global')),
>
> Is there a way to get the valid values in the list from the metadata somehow
On Tue, May 11, 2010 at 06:38:59PM -0700, Gauthier, Dave wrote:
> Hi:
>
> I have a constraint defined on a table
>
> constraint design_style_is_invalid check (design_style in
> ('rls','sdp','rf','ssa','rom','rpt','analog','sdprpt','clkdist','global')),
>
> Is there a way to get the valid val
On Tue, May 11, 2010 at 9:38 PM, Gauthier, Dave wrote:
> I have a constraint defined on a table
>
>
>
> constraint design_style_is_invalid check (design_style in
> ('rls','sdp','rf','ssa','rom','rpt','analog','sdprpt','clkdist','global')),
>
>
>
> Is there a way to get the valid values in the
Hi:
I have a constraint defined on a table
constraint design_style_is_invalid check (design_style in
('rls','sdp','rf','ssa','rom','rpt','analog','sdprpt','clkdist','global')),
Is there a way to get the valid values in the list from the metadata somehow?
Specifically, when someone hits th
14 matches
Mail list logo