Project

General

Profile

« Previous | Next » 

Revision 3502

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: taxondetermination: taxondetermination_taxonoccurrence_id_fkey(): Fixed bug where string containing a \-escape needed an "E" prefix

View differences:

schemas/vegbien.sql
308 308 
        FROM taxonoccurrence
309 309 
        WHERE taxonoccurrence_id = new.taxonoccurrence_id
310 310 
    ) THEN
311 
        RAISE EXCEPTION 'insert or update on table "taxondetermination" '
311 
        RAISE EXCEPTION E'insert or update on table "taxondetermination" '
312 312 
'violates foreign key constraint "taxondetermination_taxonoccurrence_id_fkey"\n'
313 313 
'DETAIL: Key (taxondetermination_taxonoccurrence_id_fkey)=(%) is not present in'
314 314 
' table "taxonoccurrence".', new.taxonoccurrence_id

Also available in: Unified diff