Received: from alef.gac.peachnet.edu (ALEF.GAC.PEACHNET.EDU [168.16.201.160]) by hub.org (8.9.2/8.9.1) with SMTP id KAA14145 for ; Mon, 1 Mar 1999 10:03:57 -0500 (EST) (envelope-from bgunter@alef.gcsu.edu) Received: from lambda by alef.gac.peachnet.edu (SMI-8.6/SMI-SVR4) id KAA00916; Mon, 1 Mar 1999 10:03:29 -0500 X-BlackMail: lambda.gcsu.edu, lambda, , 168.16.215.41 X-Authenticated-Timestamp: 10:03:29(EST) on March 01, 1999 Message-ID: <004201be63f4$7a9815b0$29d710a8@lambda.gcsu.edu> From: "Ben Gunter" To: "Constantin Teodorescu" , Subject: Re: [INTERFACES] Tables acting funny with pgaccess Date: Mon, 1 Mar 1999 10:02:09 -0500 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_003F_01BE63CA.91A69670" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_003F_01BE63CA.91A69670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Oops...here's the attachment. -----Original Message----- From: Ben Gunter To: Constantin Teodorescu ; pgsql-interfaces@postgreSQL.org Date: Monday, March 01, 1999 10:00 AM Subject: Re: [INTERFACES] Tables acting funny with pgaccess >I have attached the pg_dump output, but you probably won't need it. > >When I got your message this morning, I started looking into the problem a >little further. I found two things that I should have noticed before: > >1) The problem only occurs when I use capital letters in the field names >(e.g., "FirstName", "LastName"). Field names consisting of all lower case >letters don't cause a problem. > >2) If I enclose the field name in quotes when running the query (e.g., >SELECT t0."LastName" FROM "Present" t0;), then everything works just fine. > >That _almost_ solves my problems. It would be nice if I could use the >visual query designer to run queries on tables with field names containing >upper case letters. (But then again, I could just make all my field names >lower case and all would be well.) > >I think Tom Lane is right. It seems like field names are being quoted when >the table is created, but not when a query is executed. > >Thanks for looking into it. > >-Ben > >-----Original Message----- >From: Constantin Teodorescu >To: pgsql-interfaces@postgreSQL.org >Date: Monday, March 01, 1999 2:17 AM >Subject: Re: [INTERFACES] Tables acting funny with pgaccess > > >>Ben Gunter wrote: >>> >>> > declare mycursor cursor for select t0.lastname from "Present" t0 >> >>Send me a small pg_dump of that table with a few records. >>I will try it here. >> >>-- >>Constantin Teodorescu >>FLEX Consulting Braila, ROMANIA >> >> > ------=_NextPart_000_003F_01BE63CA.91A69670 Content-Type: application/octet-stream; name="Present.out" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Present.out" Q1JFQVRFIFRBQkxFICJQcmVzZW50IiAoCgkiTGFzdE5hbWUiIGNoYXJhY3RlcigzMCkgTk9UIE5V TEwsCgkiRmlyc3ROYW1lIiBjaGFyYWN0ZXIoMzApIE5PVCBOVUxMKTsKQ09QWSAiUHJlc2VudCIg RlJPTSBzdGRpbjsKU21pdGggICAgICAgICAgICAgICAgICAgICAgICAgCUpvaG4gICAgICAgICAg ICAgICAgICAgICAgICAgIApKb2huc29uICAgICAgICAgICAgICAgICAgICAgICAJUm9iZXJ0ICAg ICAgICAgICAgICAgICAgICAgICAgCkphY2tzb24gICAgICAgICAgICAgICAgICAgICAgIAlUaXRv ICAgICAgICAgICAgICAgICAgICAgICAgICAKQW5kcmV3cyAgICAgICAgICAgICAgICAgICAgICAg CUdhcnkgICAgICAgICAgICAgICAgICAgICAgICAgIApBbmRlcnNvbiAgICAgICAgICAgICAgICAg ICAgICAJUGFtZWxhICAgICAgICAgICAgICAgICAgICAgICAgClwuCg== ------=_NextPart_000_003F_01BE63CA.91A69670--