Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 662CB632F35 for ; Fri, 20 Nov 2009 12:23:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 94651-08 for ; Fri, 20 Nov 2009 16:23:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from QMTA02.emeryville.ca.mail.comcast.net (qmta02.emeryville.ca.mail.comcast.net [76.96.30.24]) by mail.postgresql.org (Postfix) with ESMTP id 2C541632AD2 for ; Fri, 20 Nov 2009 12:23:15 -0400 (AST) Received: from OMTA02.emeryville.ca.mail.comcast.net ([76.96.30.19]) by QMTA02.emeryville.ca.mail.comcast.net with comcast id 7Tx51d0060QkzPwA2UPGRl; Fri, 20 Nov 2009 16:23:16 +0000 Received: from tucker.local ([24.17.164.54]) by OMTA02.emeryville.ca.mail.comcast.net with comcast id 7UPE1d0031Ak4z48NUPEaE; Fri, 20 Nov 2009 16:23:15 +0000 From: Adrian Klaver To: pgsql-sql@postgresql.org Subject: Re: Sqldf - error message Date: Fri, 20 Nov 2009 08:23:13 -0800 User-Agent: KMail/1.9.10 Cc: Pavel Stehule , Tom Lane , "Marvelde, Luc te" References: <1276C0564833F043AB4C85ED8DA9CFE502AF054F@ctemail1.nioo.int> <21320.1258727961@sss.pgh.pa.us> <162867790911200643t6eb9d186n7889b53b3e2d0c4d@mail.gmail.com> In-Reply-To: <162867790911200643t6eb9d186n7889b53b3e2d0c4d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200911200823.13435.aklaver@comcast.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.45 tagged_above=-10 required=5 tests=AWL=0.149, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/69 X-Sequence-Number: 33420 On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote: > 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" It is more complicated than that see: http://code.google.com/p/sqldf/ It is a framework sqldf over a framework rsqlite over sqlite. The data fram= es=20 the OP is talking about are variables that are coerced to being 'tables'. I= can=20 see no mailing list for sqldf itself. The closet I could come is=20 https://stat.ethz.ch/mailman/listinfo/r-help which seems to have quite a few discussions on sqldf and would probably be = the=20 better place to ask this question. > > 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 =2D-=20 Adrian Klaver aklaver@comcast.net