Re: [SQL] upsert doesn't seem to work..

2013-02-17 Thread Ben Morrow
Quoth bier...@gmail.com (Bert): > > We continuously load data from flat files in our database. > We first insert the data into unlogged tables (in the loadoltp schema), and > then we use the 'upsert' statement to transfer the data from the load table > into the tables we are going to use. > > The

Re: [SQL] upsert doesn't seem to work..

2013-02-13 Thread Sergey Konoplev
On Tue, Feb 12, 2013 at 1:38 AM, Bert wrote: > At first everything seems to run ok, however it seems that new fields aren't > always inserted as desired. Could you please explain how are you expecting the new fields to be inserted and what exactly made you think they were inserted wrong? > > > T