postgres 7.0.2 - Mailing list pgsql-hackers

From nataraj@cdxc.com
Subject postgres 7.0.2
Date
Msg-id 39A2910D.F59DD51A@cdxc.com
Whole thread Raw
In response to postmaster locking issues  ("suchet singh khalsa" <suchet_singh@hotmail.com>)
Responses Re: postgres 7.0.2
List pgsql-hackers
<blockquote type="CITE">  <br /><a href="http://www.hotmail.com">Hi all,</a></blockquote> I am using postgres 7.0.2 and
havingsome problems after adding new tables to an existing database. I initially created a database for a web
applicationusing Perl, CGI and Apache webserver on Redhat Linux 6.2.  After createing the database I added few tables
using"Create table" command. Using the psql commands I can querry the newly created tables and I can insert into and
deleterecords from the new tables. But For some reason, If I use the same querries in web application, it does not
returnany data. In otherwords, the web application sees only the tables created initially when the database was created
andit does not see the tables added after the creation of the tables. Are there any commands to update the database
serverabout the newly  created tables. I restarted the postgres database server, restarted the Apache webserver. It
stilldoes not recognise the new tables in my web application. I made sure that all the querries are alright, because I
copiedand pasted the querries from my web application onto the psql command line, they all worked. I don't know if this
ispostgres related problem or not. <p>Thanks, I really appreciate your help, <br />Nataraj 

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: LIKE gripes (and charset docs)
Next
From: Hannu Krosing
Date:
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan