From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | Mark Stosberg <mark(at)summersault(dot)com> |
Cc: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Separating data sets in a table |
Date: | 2002-08-25 20:11:15 |
Message-ID: | Pine.LNX.4.44.0208252202540.18595-100000@wr-linux02.rki.ivbb.bund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Stosberg | 2002-08-25 21:35:08 | Re: Separating data sets in a table |
Previous Message | Tom Lane | 2002-08-25 15:20:42 | Re: weird situation, BUG or I'm not doing it right |