Re: Unique Constraint with foreign Key - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: Unique Constraint with foreign Key
Date
Msg-id 20040517185113.B592@hermes.hilbert.loc
Whole thread Raw
In response to Re: Unique Constraint with foreign Key  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
> > or Can i have varchar types  of size 50 as primary keys in Postgres.
> Yes. But unless the 50 character limit comes from a business rule, you
> might want to use the type 'text'.
And if that limit does come from a business rule you might want
to think twice whether using columns constrained by business
rules are good candidates for primary keys.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-sql by date:

Previous
From: PS PS
Date:
Subject: Max Columns in a SQL Select
Next
From: Andrew Hammond
Date:
Subject: Re: view running query