rule, but all the insert rule examples I
can find in the docs have simple sql do instead clauses, whereas my
trigger called a rather involved plsql function.
Advice most appreciated.
Take care,
--
Camm Maguire[EMAIL PROTECTED
Greetings, and thanks for your reply!
Tom Lane <[EMAIL PROTECTED]> writes:
> Camm Maguire <[EMAIL PROTECTED]> writes:
> > Greetings! We have a script updating our database with thousands of
> > entries on a daily basis. To speed up processing, we drop a
> >
, and the trigger drop is the
first statement:
drop trigger rprices_insupdel on rprices;
DROP
ERROR: RelationClearRelation: relation 160298 modified while in use
Any pointers most appreciated!
--
Camm Maguire[EMAIL PROTECTED
state yourself". I can
provide the schema if needed.
Thanks for your help!
Tom Lane <[EMAIL PROTECTED]> writes:
> Camm Maguire <[EMAIL PROTECTED]> writes:
> > Greetings! 'copy from stdin' on 7.0.2 appears to simply hang if more
> > than ~ 1000 records fo
Greetings, and thanks so much for your reply!
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On 5 Dec 2000, Camm Maguire wrote:
>
> > Greetings! I've noticed in the documentation that the sql standard
> > requires foreign keys to reference primary key/(or maybe
The current postgresql behavior seems useful in cases where
one wants to update a foreign key to a value already in the original
table.
Take care,
--
Camm Maguire[EMAIL PROTECTED]
==
Greetings! 'copy from stdin' on 7.0.2 appears to simply hang if more
than ~ 1000 records follow in one shot. I couldn't see this behavior
documented anywhere. Is this a bug?
Take care,
--
Camm Maguire[
