[PERFORM] Upgrading from from 7.4.2 to 8.0

2005-01-26 Thread James Gunzelman
Title: Message Will I have to dump and reload all my databases when migrating from 7.4.2 to 8.0?     Jim Gunzelman Senior Software Engineer   phone: 402.361.3078   fax: 402.361.3178 e-mail:  JamesGunzelman[EMAIL PROTECTED]   Solutionary, Inc. www.Solutio

[PERFORM] Efficient way to remove OID data

2004-11-16 Thread James Gunzelman
Title: Message I have a table that has 2 columns of an OID type.  I would like to issue a truncate table command but my understanding is that the data pointed to by the OIDs is not removed and orphaned.  What would be the most efficient way to truncate the table and not have orphaned data?