From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Queriy results erratic on Linux |
Date: | 2008-02-08 13:48:53 |
Message-ID: | 200802081548.54204.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Στις Friday 08 February 2008 00:35:52 ο/η PostgreSql έγραψε:
> 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?
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?
>
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Julio Leyva | 2008-02-08 14:31:30 | Re: Queriy results erratic on Linux |
Previous Message | Shoaib Mir | 2008-02-08 13:47:02 | Re: Queriy results erratic on Linux |