PostgreSQL Discussion - Re: PRIMARY KEY on a *group* of columns imply that each

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: PRIMARY KEY on a *group* of columns imply that each

Scott Marlowe

2005-04-27, 9:23 am

On Wed, 2005-04-27 at 09:06, Stephane Bortzmeyer wrote:
> On Wed, Apr 27, 2005 at 05:19:32AM +0000,
> Patrick TJ McPhee <ptjm@interlog.com> wrote
> a message of 37 lines which said:
>
>
> May be I should but I didn't.
>
>
> OK, I will try to write a custom trigger, then.

Often the best bet here, btw, is to declare it not null then use
something other than null to represent null, like the text characters NA
or something.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Sponsored Links