Thread: Beta 4 problem(s)
I've been using the 7.1 beta version for quite a while now and just upgraded to beta 4, I've noticed my application is reporting that the backend shuts down prematurely... (I'm using PHP).. I'm having a time trying to debug this.. I know it's not my code as this works fine on a 7.0.3 install.. I've upped my debug level to the max and don't see anything indicating that the backend crashed, so I'm at a loss.. In the PHP code, I just go to execute a query (after checking to make sure the value returned by pg_connect isn't 0) and I get a PHP warning "Warning: 1 is not a valid PostgreSQL link resource in ...". I'd like to figure this out, any pointers on what I might be able to do in the backend? It seems to be somewhat PHP related because I can take the individual queries and run them in psql just fine.. Are there any known issues in beta4 that might cause this kind of thing to happen? Are there any changes that anyone can think of that might need to happen to the PHP PostgreSQL support for 7.1? I'd be happy to look into doing making the changes if so.. Thanks!! -Mitch
Did you recompile PHP with postgre support after you upgraded? > -----Original Message----- > From: Mitch Vincent [SMTP:mitch@venux.net] > Sent: Thursday, February 01, 2001 9:13 AM > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] Beta 4 problem(s) > > I've been using the 7.1 beta version for quite a while now and just > upgraded > to beta 4, I've noticed my application is reporting that the backend shuts > down prematurely... (I'm using PHP).. I'm having a time trying to debug > this.. I know it's not my code as this works fine on a 7.0.3 install.. > I've > upped my debug level to the max and don't see anything indicating that the > backend crashed, so I'm at a loss.. > > In the PHP code, I just go to execute a query (after checking to make sure > the value returned by pg_connect isn't 0) and I get a PHP warning > "Warning: > 1 is not a valid PostgreSQL link resource in ...". > > I'd like to figure this out, any pointers on what I might be able to do in > the backend? > > It seems to be somewhat PHP related because I can take the individual > queries and run them in psql just fine.. Are there any known issues in > beta4 > that might cause this kind of thing to happen? Are there any changes that > anyone can think of that might need to happen to the PHP PostgreSQL > support > for 7.1? I'd be happy to look into doing making the changes if so.. > > Thanks!! > > -Mitch >
Yes, I did.. -Mitch ----- Original Message ----- From: "Matthew" <matt@ctlno.com> To: "'Mitch Vincent'" <mitch@venux.net>; <pgsql-hackers@postgresql.org> Sent: Thursday, February 01, 2001 10:33 AM Subject: RE: [HACKERS] Beta 4 problem(s) > Did you recompile PHP with postgre support after you upgraded? > > > -----Original Message----- > > From: Mitch Vincent [SMTP:mitch@venux.net] > > Sent: Thursday, February 01, 2001 9:13 AM > > To: pgsql-hackers@postgresql.org > > Subject: [HACKERS] Beta 4 problem(s) > > > > I've been using the 7.1 beta version for quite a while now and just > > upgraded > > to beta 4, I've noticed my application is reporting that the backend shuts > > down prematurely... (I'm using PHP).. I'm having a time trying to debug > > this.. I know it's not my code as this works fine on a 7.0.3 install.. > > I've > > upped my debug level to the max and don't see anything indicating that the > > backend crashed, so I'm at a loss.. > > > > In the PHP code, I just go to execute a query (after checking to make sure > > the value returned by pg_connect isn't 0) and I get a PHP warning > > "Warning: > > 1 is not a valid PostgreSQL link resource in ...". > > > > I'd like to figure this out, any pointers on what I might be able to do in > > the backend? > > > > It seems to be somewhat PHP related because I can take the individual > > queries and run them in psql just fine.. Are there any known issues in > > beta4 > > that might cause this kind of thing to happen? Are there any changes that > > anyone can think of that might need to happen to the PHP PostgreSQL > > support > > for 7.1? I'd be happy to look into doing making the changes if so.. > > > > Thanks!! > > > > -Mitch > > >