Thread: BUG #5403: Missing left parenthesis.

The following bug has been logged online:

Bug reference:      5403
Logged by:          Andrey.S.Alexeenko
Email address:      rastamanchik@mail.ru
PostgreSQL version: 8.4.2
Operating system:   FreeBSD 7.2
Description:        Missing left parenthesis.
Details:

[root@genesis /home/ss25]# psql -U library library
Password for user library:
psql (8.4.2)
Type "help" for help.

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.
library=>
[3]+  Stopped                 psql -U library library
[root@genesis /home/ss25]# psql -U pgsql library
Password for user pgsql:
psql (8.4.2)
Type "help" for help.

library=# SELECT '978-5-699-00691-5'::isbn::text;
     text
---------------
 5-699-00691-5
(1 row)

library=#

On 2/04/2010 7:34 PM, Andrey.S.Alexeenko wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5403
> Logged by:          Andrey.S.Alexeenko
> Email address:      rastamanchik@mail.ru
> PostgreSQL version: 8.4.2
> Operating system:   FreeBSD 7.2
> Description:        Missing left parenthesis.
> Details:

Your issue is the different behaviour between the `library' and `pgsql'
users?

Do they have a different search_path setting?

--
Craig Ringer

"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