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

Re: Additional Help Desired in Application Port to PostgreSQL

From: David Wheeler <david(at)kineticode(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: Additional Help Desired in Application Port to PostgreSQL
Date: 2006-07-21 19:42:19
Message-ID: F9A1476E-98D0-49CC-9DDC-4B6E37E7E36A@kineticode.com (view raw or flat)
Thread:
Lists: pdxpug
On Jul 21, 2006, at 12:11, Rich Shepard wrote:

> install/xrms-schema.xml:293:    <field  
> name="account_status_record_status" type="C" size="1">
> install/.#xrms-schema.xml.1.18:293:    <field  
> name="account_status_record_status" type="C" size="1">
>
>   Notice that it's defined (last two lines) with quotes, but used  
> either
> without quotes or (in delete.php) with single quotes.

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.

>   If I'm correct that this is a problem, I guess that I'll start  
> working my
> way through all table and field names and make sure they're not quoted

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!

Best,

David

In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2006-07-21 19:56:57
Subject: Re: Additional Help Desired in Application Port to PostgreSQL
Previous:From: Rich ShepardDate: 2006-07-21 19:31:14
Subject: Re: Additional Help Desired in Application Port to PostgreSQL

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