Drawbacks of using BYTEA for PK? - Mailing list pgsql-general

From David Garamond
Subject Drawbacks of using BYTEA for PK?
Date
Msg-id 40017220.5030607@zara.6.isreserved.com
Whole thread Raw
Responses Re: Drawbacks of using BYTEA for PK?
List pgsql-general
Are there any drawbacks of using BYTEA for PK compared to using a
primitive/atomic data types like INT/SERIAL? (like significant
performance hit, peculiar FK behaviour, etc).

I plan to use BYTEA for GUID (of course, temporarily I hope, until
PostgreSQL officially supports GUID data type), since it seems to be the
most convenient+compact compared to other data types currently
available. I use GUIDs for most PK columns.

--
dave

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: CHAR(N) storage requirement
Next
From: Peter Eisentraut
Date:
Subject: Re: CHAR(N) storage requirement