Skip site navigation (1) Skip section navigation (2)

Re: function does not exist error...

From: Dan Jewett <danjewett(at)mac(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: function does not exist error...
Date: 2002-11-22 18:05:11
Message-ID: p05200f06ba04218fd466@[] (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
>>  The big picture of what I'm trying to do is that I have large flat
>>  file of records created with info about individual recordings
>>  (songs).  I want to split those out into appropriately referenced
>>  tables.
>>  I thought I could create a combination of rules and triggers to step
>>  through the table (or a text file exported from it) and send the data
>>  where it needs to go.  Part of the process would be to check for
>>  existing entries to prevent redundency. I also want be able to add
>>  entries to join tables on the fly.
>Why do you want to use Triggers and Rules?   Do you need to import this data
>from source daily?  Even so, batch processing will be faster than executing a
>trigger for each row inserted.
>-Josh Berkus

You are right of course.  Thanks for rearranging my thinking on this. 
So, on to figuring out the query for the batch.


In response to

pgsql-novice by date

Next:From: Dan JewettDate: 2002-11-22 18:33:37
Previous:From: Tom LaneDate: 2002-11-22 16:41:38
Subject: Re: How does "SELECT ... FOR UPDATE" work?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group