Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group