Re: \ escapes in check constraint strings? - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: \ escapes in check constraint strings?
Date
Msg-id 200407170002.24055.peter_e@gmx.net
Whole thread Raw
In response to \ escapes in check constraint strings?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-bugs
Bruno Wolff III wrote:
> I see the following behaivor on 7.4.3 and 7.4 stable from about a
> week ago: bruno=> create table test ();
> CREATE TABLE
> bruno=> alter table test add constraint test2 check('\\' = '');
> ALTER TABLE
> bruno=> \d test
>     Table "public.test"
>  Column | Type | Modifiers
> --------+------+-----------
> Check constraints:
>     "test2" CHECK ('\\'::text = ''::text)

It prints the SQL source code for the check constraint.  There is no
bug, AFAICS.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: \ escapes in check constraint strings?
Next
From: Nishad Prakash
Date:
Subject: Cannot recreate DB scheme using pg_dump