Re: BUG #5403: Missing left parenthesis.

Lists: pgsql-bugs
From: "Andrey(dot)S(dot)Alexeenko" <rastamanchik(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5403: Missing left parenthesis.
Date: 2010-04-02 11:34:45
Message-ID: 201004021134.o32BYjsZ086967@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

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

[root(at)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(at)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=#

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
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 12:12:25
Message-ID: 4BB5DF29.6010107@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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(at)mail(dot)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

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
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