Re: massive quotes? - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: massive quotes?
Date
Msg-id 3F5F8B06.50809@pse-consulting.de
Whole thread Raw
In response to Re: massive quotes?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: massive quotes?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: massive quotes?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan wrote:

> Alvaro Herrera wrote:
>
>> On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
>>  
>>
>>> Bruce Momjian wrote:
>>>
>>>   
>>>
>>>> I assume we never came to a final conclusion on how to do CREATE
>>>> FUNCTION without double-quoting.
>>>>     
>>>
>>
>>  
>>
>>> Many discussions, but no final conclusion in sight, it seems. That 
>>> \beginliteral stuff is psql centric, where a sql syntax solution is 
>>> needed.
>>>   
>>
>>
>> Oh, is it?  Didn't people agree that other frontends (pgAdmin,
>> phpPgAdmin, etc) have solutions for the problem already?
>>
>>  
>>
> I think there is agreement that these do. It would still look ugly in 
> a programmatic interface like JDBC. Not that I use JDBC to set up 
> functions, but I can imagine someone wanting to. But personally I 
> could live with a nice enough psql-only fix.

I never agreed that a client solution would be satisfying. While 
frontends might try to hide some uglyness of the syntax to the user for 
single functions, editing large scripts with many functions is still 
suffering from "massive quotes".

Regards,
Andreas




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FK type mismatches?
Next
From: Oliver Elphick
Date:
Subject: Re: wish: limit number of connections per database