postgres "invalid objectname"

LabKey Support Forum (Inactive)
postgres "invalid objectname" Ben Bimber  2011-05-02 06:35
Status: Closed
 
A lab at NEPRC has installed labkey using the windows installer. a while back they installed labkey 10.3 + pg 8.3 installed using the installer, but didnt use it. they upgraded to 11.1 using the installer a week or so ago; however, it looks like they're still running pg 8.3.

They checked out and installed the entire customMOdules folder from the 11.1 branch of svn. All the SQL upgrade scripts associated with these modules ran normally. If you go into pg_admin, the 'laboratory' and 'SSP_Assay' schemas exist, and they have the proper tables. these schemas are exposed through file-based modules. the labkey interface seems to be behaving normally in most respects.

when they try to view the hard tables in either of these schemas, they get the error "postgres: invalid objectname 'inventory' " or "postgres: invalid objectname 'SSP_Assay' ", where the second piece is either a table or schema name.

does anyone have suggestions on troubleshooting? could pg 8.3 plausibly be the problem?

thanks in advance.
 
 
Ben Bimber responded:  2011-05-04 05:45
for some odd reason it does no good to create tables in postgres if their site is running off sqlserver. creating those tables in the proper DB should fix their problem.