Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-20 Thread CG
, 2009 7:05:47 PM Subject: Re: [GENERAL] best practice transitioning from one datatype to another CG writes: > While transitioning from 8.1 to 8.4, I need to transition to the internal > UUID type in place of the contrib/uniqueidentifier module. I've built the > database aroun

Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-16 Thread CG
___ From: Arndt Lehmann To: pgsql-general@postgresql.org Sent: Thursday, July 16, 2009 5:22:26 AM Subject: Re: [GENERAL] best practice transitioning from one datatype to another On Jul 16, 5:46 pm, a.w...@netzmeister-st-pauli.de (Andreas Wenk) wrote: > Arndt Lehmann schrieb: >

Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-16 Thread Arndt Lehmann
On Jul 16, 5:46 pm, a.w...@netzmeister-st-pauli.de (Andreas Wenk) wrote: > Arndt Lehmann schrieb: > > > On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote: > >> CG writes: > >>> While transitioning from 8.1 to 8.4, I need to transition to the internal > >>> UUID type in place of the contrib/

Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-16 Thread Andreas Wenk
Arndt Lehmann schrieb: On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote: CG writes: While transitioning from 8.1 to 8.4, I need to transition to the internal UUID type in place of the contrib/uniqueidentifier module. I've built the database around uniqueidentifier, so nearly every tab

Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-15 Thread Arndt Lehmann
On Jul 16, 8:05 am, t...@sss.pgh.pa.us (Tom Lane) wrote: > CG writes: > > While transitioning from 8.1 to 8.4, I need to transition to the internal > > UUID type in place of the contrib/uniqueidentifier module. I've built the > > database around uniqueidentifier, so nearly every table has one co

Re: [GENERAL] best practice transitioning from one datatype to another

2009-07-15 Thread Tom Lane
CG writes: > While transitioning from 8.1 to 8.4, I need to transition to the internal > UUID type in place of the contrib/uniqueidentifier module. I've built the > database around uniqueidentifier, so nearly every table has one column of > that data type. It's going to be tedious to > ALTER

[GENERAL] best practice transitioning from one datatype to another

2009-07-15 Thread CG
Another UUID question... I was hoping to put this off for a while, but it looks like it's going to need to happen sooner than later. Rats! I keep telling myself transitioning to core datatypes is good for the soul. While transitioning from 8.1 to 8.4, I need to transition to the internal UUID t