e one).
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Merlin Moncure [mailto:[EMAIL PROTECTED]
Sent: Monday, September 11, 2006 1:08 PM
To: Brandon Aiken
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database migration and redesign
On 9/11/06, Brandon Aiken &
On 9/11/06, Brandon Aiken <[EMAIL PROTECTED]> wrote:
My question relates to primary keys. The vast majority of tables have a
primary key on a single char or varchar field. Is it considered better
practice to create a serial type id key to use as the primary key for the
table, and then create a
Since you're in the process of modifying a database, you could find this useful:
Agile Databases Techniques, by Scott Ambler.
Regards
Marco
On 9/11/06, Brandon Aiken <[EMAIL PROTECTED]> wrote:
I've been tasked with the unenviable job or migrating a MySQL 4.0 database
to something more us
I’ve been tasked with the unenviable job or migrating
a MySQL 4.0 database to something more usable (namely, PostgreSQL 8). MySQL
4.0 doesn’t even support basic things like subqueries, and in order to
emulate the effects that RULEs, TRIGGERs and VIEWs bring, they had been using
PHP scripts
