guids / bytea and index use ? - Mailing list pgsql-general

From rahul143
Subject guids / bytea and index use ?
Date
Msg-id 1354511574672-5734650.post@n5.nabble.com
Whole thread Raw
Responses Re: guids / bytea and index use ?  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Hi,

We are currently using a 32byte varchar for our primary keys. We tried to
reduce this down to 16 bytes but varchar didn’t seem to store this
correctly. I’d like to use bytea instead so we could use 16bytes, but are
indexes used properly ? Does anyone have any other suggestions on how to
store guids ? We don’t have any experience in recompiling the postgres
source code etc.



-----




--
View this message in context: http://postgresql.1045698.n5.nabble.com/GENERAL-guids-bytea-and-index-use-tp5734650.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: rahul143
Date:
Subject: Re: MS-Access and Stored procedures
Next
From: rahul143
Date:
Subject: Postgres PHP error