On Wed, Jun 22, 2005 at 11:49:59PM +0000, Prasad dev wrote:
>
> Basically i am dealing with triggers which addresses referential integrity,
Are you familiar with foreign key constraints? PostgreSQL can
automatically do referential integrity checks for you.
http://www.postgresql.org/docs/7.3/static/tutorial-fk.htmlhttp://www.postgresql.org/docs/7.3/static/ddl-constraints.html#DDL-CONSTRAINTS-FKhttp://www.postgresql.org/docs/7.3/static/sql-createtable.html
(Links are to the 7.3 documentation because you said you were running
that version.)
> SO in the end what i look for is a proper message instead of "DELETE 0".
You could do this in application code, or you could wrap the delete
in a function that checks how many rows were deleted and raises a
notice if the count was zero.
http://www.postgresql.org/docs/7.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
If you were using 7.4 or later, you could use a statement-level
AFTER trigger to raise a notice if no rows were deleted. But it's
still not clear what value such a notice would add.
> by the way what do you mean by dont post in HTML ?
Your previous messages were HTML-formatted. Some people use
text-based mail readers, so they have to take extra steps to convert
the HTML to something legible; also, some people's spam filters
might automatically delete HTML messages. Plain text is more likely
to be acceptable to some people.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/