Re: Having a problem with my stored procedure - Mailing list pgsql-general

Here is a question that I am stumped on:

Does postgres even recognize last_inserted() as mysql does? I notice
that the function fails on that line.

Thanks,
 Laura

Tom Lane wrote:
> Laura McCord <mccordl@southwestern.edu> writes:
>
>> I tried doing two different triggers as you suggested but I kept getting
>> an error stating:
>>
>
>
>> psql:archive_news_articles.sql:75: ERROR:  trigger "archive_articles"
>> for relation "news_content" already exists
>> psql:archive_news_articles.sql:80: ERROR:  trigger "update_archives" for
>> relation "news_content" already exists
>>
>
>
>> So, I thought perhaps it couldn't be done.
>>
>
> You need to pick different names for the triggers ... or if you're
> trying to replace an existing trigger definition, you need to DROP it first.
>
>             regards, tom lane
>