Skip site navigation (1) Skip section navigation (2)

Re: Unique Constraint with foreign Key

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Unique Constraint with foreign Key
Date: 2004-05-17 16:51:13
Message-ID: 20040517185113.B592@hermes.hilbert.loc (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-sql by date

Next:From: Richard HuxtonDate: 2004-05-17 18:06:42
Subject: Re: Max Columns in a SQL Select
Previous:From: PS PSDate: 2004-05-17 16:37:36
Subject: Max Columns in a SQL Select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group