On Wednesday, June 08, 2011 1:40:35 pm David Johnston wrote:
> > -Original Message-
> > From: Mike Christensen [mailto:m...@kitchenpc.com]
> > Sent: Wednesday, June 08, 2011 4:26 PM
> > To: David Johnston; pgsql-general@postgresql.org
> > Subject: Re: [GENERA
>> I'm assuming I can still have a "Serial" column that is NOT a primary key,
> and
>> it'll incremement just the same as I add rows? If that's the case, I
> think that's
>> a superior approach..
>>
>> BTW, this table is too small to worry about disk space of UUIDs and/or
>> perhaps any sort of pe
> -Original Message-
> From: Mike Christensen [mailto:m...@kitchenpc.com]
> Sent: Wednesday, June 08, 2011 4:26 PM
> To: David Johnston; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Converting uuid primary key column to serial int
> I'm assuming I c
eral@postgresql.org
>> Subject: [GENERAL] Converting uuid primary key column to serial int
>
>> for each ingredient are kinda a hassle to manage though, and I'm thinking
> in
>> this case I might just want to use a 32bit integer for the primary key..
>
>> 2)
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Mike Christensen
> Sent: Wednesday, June 08, 2011 2:57 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Converting uuid primary key co
Hi all -
For most of my database I use UUIDs as primary keys because, well, I
just like it better and like being able to generate a key in the
middle tier when I create new data. However, I have one table that
has a very fixed and immutable set of data with a few thousand
ingredients in it. This