Hi Michael,
Thanks for answering.
On Sun, 2006-09-17 at 08:36 -0600, Michael Fuhr wrote:
> On Sun, Sep 17, 2006 at 02:32:10PM +0200, Joost Kraaijeveld wrote:
> Where does prototype.customers fit in? Are you sure it has a row
> that matches the WHERE clause? Where would that row have come from?
On Sun, Sep 17, 2006 at 02:32:10PM +0200, Joost Kraaijeveld wrote:
> For the contactaddress I also have a trigger(function) that should
> update the record in the third table with the additional info of the
> contactaddress:
>
>
> SELECT INTO customer_record objectid FROM prototype.customers
Hi,
I create two records in a transaction in two different tables: customer
and contactaddress. customer has a foreign key to contactaddress.
I also have third table, customeraddress, which is a materialized view
of the join of customer and contactaddress
For the table customer I have a trigger(
