Re: Separating data sets in a table - Mailing list pgsql-sql

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.