Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A3A6E2E3224 for ; Fri, 8 Feb 2008 09:49:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43751-03 for ; Fri, 8 Feb 2008 09:48:53 -0400 (AST) Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by postgresql.org (Postfix) with ESMTP id 0052A2E2F1C for ; Fri, 8 Feb 2008 09:48:58 -0400 (AST) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id m18DmtdC083920 for ; Fri, 8 Feb 2008 15:48:55 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id m18DmsWa083919 for pgsql-admin@postgresql.org; Fri, 8 Feb 2008 15:48:54 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Queriy results erratic on Linux Date: Fri, 8 Feb 2008 15:48:53 +0200 User-Agent: KMail/1.9.7 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200802081548.54204.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/94 X-Sequence-Number: 28168 =D3=F4=E9=F2 Friday 08 February 2008 00:35:52 =EF/=E7 PostgreSql =DD=E3=F1= =E1=F8=E5: > Hi > My application runs fine on Windows. > However when I copy the files to the Linux server some queries return no= =20 > results or errors even though the records and tables exist! > It is always the same records or tables that are not found! > In case of a table the error is: function.pg-query: Query failed: ERROR:= =20 > relation "sites" does not exist in .... >=20 > Any idea what might cause the problem? That you were using windows before, so the spirit of UNIX/open source is punishing you! Maybe your table/column names are sensitive to lower/upper case? >=20 > The server configuration: > PHP Version 5.0.4 > PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.= 2=20 > 20030222 (Red Hat Linux 3.2.2-5) >=20 > Thanks=20 >=20 >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? >=20 > http://archives.postgresql.org >=20 =2D-=20 Achilleas Mantzios