Problems with RAISE EXCEPTION

From: Tulio Oliveira <mestredosmagos(at)marilia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems with RAISE EXCEPTION
Date: 2001-02-27 11:40:27
Message-ID: 3A9B922B.6040508@marilia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

My triggers performs a lot of verifications over the data before insert
or update.

So I need make all checks, and at the end, RAISE EXCEPTION msgsErrors;

and the variable msgsErrors containing all Error Messages reported by
hole trigger.

But the RAISE EXCEPTION don't accept variables, only a CONTANT STRING.

Nor strigs concatenation are supported ........

I'm make any mistake ?
Exist any way to do that ?

Regards,

Tulio Oliveira

Responses

Browse pgsql-general by date

  From Date Subject
Next Message martin.chantler 2001-02-27 11:47:23 Re: Migrate from MS SQL 6.5 to postgres??
Previous Message Matthias Teege 2001-02-27 10:57:47 Last x records