Re: Queriy results erratic on Linux

Στις 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