PGAccess/pgplsql Blues - Mailing list pgsql-sql

From Josh Berkus
Subject PGAccess/pgplsql Blues
Date
Msg-id web-65768@davinci.ethosmedia.com
Whole thread Raw
Responses Re: PGAccess/pgplsql Blues
Re: PGAccess/pgplsql Blues
List pgsql-sql
Folks,
I've been having an annoying problem that I'm hoping someone else has
had and solved:
When I edit some of my more complex plpgsql functions using PGAccess,
the functions break and cannot be made to work again except by reloading
them from PLSQL/text.  All attempts to use the function after PGAccess
editing are met with: 'Parse error at or near ""'
Once the *identical* function text is reloaded via PSQL command-line,
however, the function works.
I'm using Postgres 7.1 RC2 and PGAccess 0.98.5.
                    -Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: question about PL/pgSQL function
Next
From: george young
Date:
Subject: select distinct too slow