escape_string_warning doesn't work

From: "Tjibbe Rijpma" <tjibbe(at)hotmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: escape_string_warning doesn't work
Date: 2006-03-10 17:24:59
Message-ID: BAY115-DAV161813034F985462B3B9B4DDED0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello

I tried the option escape_string_warning, but why it doesn't get a warning
with the following code:

SET escape_string_warning TO on;
CREATE DOMAIN email AS character varying(50) CHECK (((VALUE)::text ~
'^[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([.-][a-z0-9]+)*)+\\.[a-z]{2,}$'::t
ext));

regards,

Tjibbe

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-03-10 18:07:27 Re: escape_string_warning doesn't work
Previous Message george young 2006-03-10 17:04:00 Re: Relations as arguments to a stored procedure?