Re: \ escapes in check constraint strings?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: \ escapes in check constraint strings?
Date: 2004-07-16 22:02:24
Message-ID: 200407170002.24055.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Nishad Prakash 2004-07-16 23:22:21 Cannot recreate DB scheme using pg_dump
Previous Message Bruno Wolff III 2004-07-16 22:01:40 Re: \ escapes in check constraint strings?