Re: Separating data sets in a table

On Sat, 24 Aug 2002, Mark Stosberg wrote:

> On Thu, 22 Aug 2002, Andreas Tille wrote:
> > Hello,
> >
> > I want to solve the following problem:
> >
> > CREATE TABLE Ref ( Id int ) ;
> > CREATE TABLE Import ( Id int,
> > Other varchar(42),
> > Flag int,
> > Ts timestamp ) ;
> > CREATE TABLE Data ( Id int,
> > Other varchar(42) ) ;
> larger problem. I get the sense that you have data you importing on a
> regular basis from outside Postgres, and you want to check it before
> it get moves into production, but I'm not exactly sure what's happening.

You are completely right. I just do an import from an external database.
The person I obtain the data from does an output of the table in a form
to do a "COPY FROM". The problem is that it might happen that there are
some data rows which infringe referential integrity and I have to ask
back the data provider for additional data which describe additional data
which are referenced by the Id mentioned above. So I have to sort out those
data sets who have no known Id in my production data.

Kind regards

Andreas.