Re: BUG #5403: Missing left parenthesis. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5403: Missing left parenthesis.
Date
Msg-id 10745.1270218797@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5403: Missing left parenthesis.  ("Andrey.S.Alexeenko" <rastamanchik@mail.ru>)
List pgsql-bugs
"Andrey.S.Alexeenko" <rastamanchik@mail.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

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #5403: Missing left parenthesis.
Next
From: "Hiroshi Saito"
Date:
Subject: Re: UTF-8 encoding failure