Re: auto-increment integer field for each row

Lonni J Friedman <netllama@gmail.com> writes:
> I tried to use the trigger example here, but it silently fails to work:
> http://archives.postgresql.org/pgsql-sql/2000-02/msg00147.php

That example seems to be lacking a CREATE TRIGGER command, so
there's nothing telling the system to call the function.
It never worked as given --- read the whole thread.

The only really out-of-date part of it is that nowadays
"returns trigger" is preferred to "returns opaque".
But you need CREATE TRIGGER.

            regards, tom lane