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

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