Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 08812632655 for ; Fri, 20 Nov 2009 10:44:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51008-01 for ; Fri, 20 Nov 2009 14:43:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f181.google.com (mail-yx0-f181.google.com [209.85.210.181]) by mail.postgresql.org (Postfix) with ESMTP id AF788632432 for ; Fri, 20 Nov 2009 10:43:55 -0400 (AST) Received: by yxe11 with SMTP id 11so2842134yxe.15 for ; Fri, 20 Nov 2009 06:43:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=b7sDIwDFTkdrnw+mzEEqT3uM4gqqSBHrkLBhfPZDNQo=; b=cJQ/KmCqeEju62tm4COz4zVuyVnOHvuYffnw5WvHZDVHC3HHPHBIc30bRjkIdLVfqB cyyRq3T05Axd7Nn4ZNfxtL4tM0iT6RQgEZBb4KbZY+6BsV6EgYINyHY7MEfOVXIfiIvf 5cvyW6NBPkrkEzHI4ycp3hrtVA+hABZ+a25Ck= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=M73WnFy6bb/NUbDac2vIko62AJAlq3DniMO3B8BtAUxoQOvjl8C2L3vED9Vl1Or8aK yyPd0qmFZVV2Xh1houjV48t5uqTZa0c5aRMrLKEfRrOYckoEdL0XH76ZgeNjWXUldwOx d89dSWiX/Kl1dMKwmc9HFuLE/tFy0qD3Et7fY= MIME-Version: 1.0 Received: by 10.151.16.13 with SMTP id t13mr2763269ybi.214.1258728233533; Fri, 20 Nov 2009 06:43:53 -0800 (PST) In-Reply-To: <21320.1258727961@sss.pgh.pa.us> References: <1276C0564833F043AB4C85ED8DA9CFE502AF054F@ctemail1.nioo.int> <21320.1258727961@sss.pgh.pa.us> Date: Fri, 20 Nov 2009 15:43:53 +0100 Message-ID: <162867790911200643t6eb9d186n7889b53b3e2d0c4d@mail.gmail.com> Subject: Re: Sqldf - error message From: Pavel Stehule To: Tom Lane Cc: "Marvelde, Luc te" , pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/64 X-Sequence-Number: 33415 2009/11/20 Tom Lane : > "Marvelde, Luc te" writes: >> If I run this SQL query: > >>> sqldf("SELECT >> + dbo_tbl_Terrein.RingCentraleNaam, >> + dbo_tbl_Broedsels.BroedselID >> + FROM ((dbo_tbl_BroedselLocatie >> + INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID =3D >> dbo_tbl_Broedsels.BroedselID) >> + INNER JOIN dbo_tbl_Nestkasten ON dbo_tbl_BroedselLocatie.NestkastID = =3D >> dbo_tbl_Nestkasten.NestkastID) >> + INNER JOIN dbo_tbl_Terrein ON dbo_tbl_Nestkasten.TerreinNummer =3D >> dbo_tbl_Terrein.TerreinNummer >> + WHERE (((dbo_tbl_Terrein.RingCentraleNaam)=3D'Oosterhout a/d Waal'));"= ) > >> I get the following message: > >> Error in sqliteExecStatement(con, statement, bind.data) : >> =C2=A0 RS-DBI driver: (error in statement: no such column: >> dbo_tbl_Broedsels.BroedselID) > > It looks to me like sqldf is unaware of the rules about identifier > case-folding in Postgres. =C2=A0That column would come back named > "broedselid", but it's probably looking for "BroedselID". > Or possibly it's expecting the qualifier "dbo_tbl_Broedsels." > to be included in the returned column name. =C2=A0Either way, you > need to bug sqldf's authors to fix it. > is it Postgres? I see "Error in sqliteExecStatement" regards Pavel Stehule > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0regards, tom lane > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >