Message-ID: <40DBF70A.6060605@sharp.fm>
Date: Fri, 25 Jun 2004 11:57:30 +0200
From: Graham Leggett <minfrin@sharp.fm>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040623
MIME-Version: 1.0
To: Richard Huxton <dev@archonet.com>
Cc: Frank Bax <fbax@sympatico.ca>, pgsql-sql@postgresql.org
Subject: Re: Normalising an existing table - how?
References: <5.2.1.1.0.20040624170431.04384a70@pop6.sympatico.ca>
	<40DB4B64.5080101@sharp.fm> <40DBE463.7060308@archonet.com>
In-Reply-To: <40DBE463.7060308@archonet.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Richard Huxton wrote:

>> How would I put the primary key of each row in newtable back into 
>> oldtable? Also, newtable already exists and contains data - I need to 
>> add normalised data to an already partially normalised database.

> How can newtable contain data if you don't have any keys for it?
> 
> Perhaps a fuller example, with the schemas of the tables in question 
> would help.

I have a system that keeps track of money. Part of the system's money 
handling is already normalised, in that there is a money table, 
containing information about the amount concerned, the amount of tax 
appropriate, the currency involved, etc. Part of the system is not 
normalised, in that a simple column in table contains the amount of 
money, but not the tax appropriate, nor the currency involved. My task 
is to fix this situation to make it consistent throughout.

Because the database is partially normalised, the money table already 
contains rows corresponding to the properly normalised part of the 
database. New rows need to be added on top of the existing rows, 
replacing the rest of the columns that need to be normalised. As a 
result, creating a new money table is not possible, as this table 
already exists.

Regards,
Graham
--