Re: BUG #5403: Missing left parenthesis.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrey(dot)S(dot)Alexeenko" <rastamanchik(at)mail(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5403: Missing left parenthesis.
Date: 2010-04-02 14:33:17
Message-ID: 10745.1270218797@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Andrey.S.Alexeenko" <rastamanchik(at)mail(dot)ru> writes:
> library=> SELECT '978-5-699-00691-5'::isbn::text;
> ERROR: malformed record literal: "978-5-699-00691-5"
> LINE 1: SELECT '978-5-699-00691-5'::isbn::text;
> ^
> DETAIL: Missing left parenthesis.

I can replicate the above if I create a table (not a datatype) named
isbn.

I see no bug here, just a difference in what's visible in the search
path for the two users.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hiroshi Saito 2010-04-02 15:33:44 Re: UTF-8 encoding failure
Previous Message Craig Ringer 2010-04-02 12:12:25 Re: BUG #5403: Missing left parenthesis.