Re: PGAccess/pgplsql Blues

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: PGAccess/pgplsql Blues
Date: 2001-06-04 18:02:32
Message-ID: web-66746@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Roberto,

> IIRC, pgaccess does quote-escaping for you, so if you try to write
> "standard" PL/pgSQL (escaping single quotes), it'll barf this error.
>
> Just something to check.

Thanks. This doesn't seem to be the case; it seems to be a translation
problem:

1. Test fn_save_order: it's working.
2. Open fn_save_order in PGAccess.
3. Add '--test comment' on its own line.
4. Save fn_save_order.
5. test it: "Parse Error at or near "" "

Unfortunately, I can't afford to pay Constatin for debugging, so that's
where things stand ...

-Josh

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Manuel Sugawara 2001-06-04 18:03:11 Re: SQL Date Challenge
Previous Message Josh Berkus 2001-06-04 17:31:52 SQL Date Challenge