On Feb 8, 2008 3:35 AM, PostgreSql <hampi1(at)gumtreegully(dot)com(dot)au> wrote:
> 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?
First of all query your pg_class catalog table and see if you can see those
tables in there like this:
*select relname from pg_class where relname = 'tablename';*
If its there then check you search_path and see if you have your schema name
Other then that I am not sure what do you mean by copying the files from
Windows server to Linux as I think you can not use the data files created by
initdb on Windows for a Linux server.
Fujitsu Australia Software Technology
In response to
pgsql-admin by date
|Next:||From: Achilleas Mantzios||Date: 2008-02-08 13:48:53|
|Subject: Re: Queriy results erratic on Linux|
|Previous:||From: Chris Hoover||Date: 2008-02-08 13:01:44|
|Subject: Re: Where to find information on the new HOT tables?|