Re: Escaping quotes and double-quotes problem - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Escaping quotes and double-quotes problem
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB10475F2@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Escaping quotes and double-quotes problem  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 24 February 2002 21:00
> To: Dave Page
> Cc: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] Escaping quotes and
> double-quotes problem
>
>
> Le Dimanche 24 Février 2002 21:05, Dave Page a écrit :
> > Having said that, the function update code doesn't do that
> (Add does)
> > so I've comitted a fix for that.
> Thanks. I checked-out from CVS to get your fix.
>
> *** Please remove your fix ***, it's not in
> > the right place and will probably cause excessive quoting in some
> > cases.
> Do you mean I should also remove my fix in Functions.cls?

Yes please. The Source property should return the code that the user typed
in in the first place (i.e. with the doubled quotes). By keeping the Source
correct, then the SQL property will work with no modification, as will
frmFunction in pgAdmin which displays/updates the Source property, not the
SQL. If the fix is in the SQL property, then the quotes will be lost when
the user edits or displays the function.

Regards, Dave.

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: pgAdmin2 UTF-8 support
Next
From: Dave Page
Date:
Subject: Re: Working oin pgAdmin2