Skip site navigation (1) Skip section navigation (2)

Re: Additional Help Desired in Application Port to PostgreSQL

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Additional Help Desired in Application Port to PostgreSQL
Date: 2006-07-21 20:01:14
Message-ID: Pine.LNX.4.64.0607211257490.19612@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
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

In response to

pdxpug by date

Next:From: Selena DeckelmannDate: 2006-07-29 14:52:27
Subject: postgresql & PAM auth on Mac OS X
Previous:From: Rich ShepardDate: 2006-07-21 19:56:57
Subject: Re: Additional Help Desired in Application Port to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group