Re: Primary key constraint violation without error? - Mailing list pgsql-sql

Mario Splivalo wrote:
> Actually it's not violation, but I get no error message on violating
> it...
> 

> CREATE OR REPLACE FUNCTION punimessages()
>   RETURNS bool AS
> $BODY$
> 
> declare
>     userId users%ROWTYPE;
> 
> begin
> 
>     truncate table mes_del;^^^^^^^^^^^^^^^^^^^^^^^

This at the start of your inserts is why you're not seeing an error :-)

--   Richard Huxton  Archonet Ltd