Re: [GENERAL] Converting uuid primary key column to serial int

2011-06-08 Thread Adrian Klaver
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

Re: [GENERAL] Converting uuid primary key column to serial int

2011-06-08 Thread Mike Christensen
>> 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

Re: [GENERAL] Converting uuid primary key column to serial int

2011-06-08 Thread David Johnston
> -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

Re: [GENERAL] Converting uuid primary key column to serial int

2011-06-08 Thread Mike Christensen
On Wed, Jun 8, 2011 at 1:06 PM, David Johnston wrote: >> -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: [G

Re: [GENERAL] Converting uuid primary key column to serial int

2011-06-08 Thread David Johnston
> -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 column to serial int > f