Re: Additional Help Desired in Application Port to PostgreSQL

On Fri, 21 Jul 2006, David Wheeler wrote:

> Well, unless they have a dumb XML parser, those quotation marks won't be
> in the SQL schema. Does \d account_status_record_status show the quotation
> marks? But yeah, the use of single quotes for identifiers is valid in
> MySQL but not in PostgreSQL, as you note.

No, \d+ shows no identifiers with quotation marks.

I'll hold off on the sigle quotes for now.

> Sounds about right. But I'd try to copy a query into psql to make sure
> that it really doesn't work, first, just to be positive before you spend
> all that time!

OK. I'll start with the file that threw the error and work back to find a
query.

Thanks,

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863