Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8C26C2E3E5A for ; Thu, 7 Feb 2008 19:07:21 -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 35425-01-8 for ; Thu, 7 Feb 2008 19:07:14 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 7CE482E2D40 for ; Thu, 7 Feb 2008 19:07:01 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m17N6uGL077063 for ; Thu, 7 Feb 2008 19:06:56 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m17MjEVh040464 for pgsql-admin@postgresql.org; Thu, 7 Feb 2008 18:45:14 -0400 (AST) (envelope-from news) From: "PostgreSql" X-Newsgroups: pgsql.admin Subject: Queriy results erratic on Linux Date: Fri, 8 Feb 2008 08:35:52 +1000 Organization: Hub.Org Networking Services Lines: 18 Message-ID: X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/92 X-Sequence-Number: 28166 Hi My application runs fine on Windows. However when I copy the files to the Linux server some queries return no 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: relation "sites" does not exist in .... Any idea what might cause the problem? 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 20030222 (Red Hat Linux 3.2.2-5) Thanks