Bill <pg(at)dbginc(dot)com> writes:
> PostgreSQL 8.3 on Windows. I have the table below which has a before
> insert trigger. The CREATE TRIGGER statement and the trigger function
> are also shown below.
The script you show attempts to create the trigger before creating the
function, which of course isn't going to work. Did you check whether
the trigger actually got created?
regards, tom lane