[GENERAL] help debugging hung process

I'm having problems with hanging apache processes that seem to be stuck in pqSocketPoll. I'm running postgresql 7.4.11 on CentOS 3 (upgraded from 7.4.5 that was also having this problem; haven't upgraded to 7.4.12 because I haven't found RPMs yet). Using Apache 1.3.35 with mod_perl. I haven't be

[GENERAL] {Virus?} *DETECTED* Online User Violation

Warning: This message has had one or more attachments removed Warning: (email-info.zip). Warning: Please read the "CONGAS-Attachment-Warning.txt" attachment(s) for more information. We regret to inform you that your account has been suspended due to the violation of our site policy, more info is

[GENERAL] {Virus?} Rbgbqsvkmzwndu

Warning: This message has had one or more attachments removed Warning: (document.zip). Warning: Please read the "CONGAS-Attachment-Warning.txt" attachment(s) for more information. We regret to inform you that your account has been suspended due to the violation of our site policy, more info is a

Re: Query inside transaction [GENERAL]

But if someone else runs the same transaction in the same time what value does "currval('sequence')" return? That one of the first transaction or that one of the other transaction? Moreover, field id is a unique primary key, it does not accept duplicates. On 25/06/2004 11.58, Michal Táborský <[

Re: [GENERAL] Different runtime on the same query

20.58, Tom Lane <[EMAIL PROTECTED]> wrote: >NMB Webmaster <[EMAIL PROTECTED]> writes: >> I have two database quite similar, one has more tables than the >other. > >Are both of them vacuumed/analyzed recently? The slow plan seems >to be >estimating many more row

Re: [GENERAL] Separating application from data

Sorry for CC to mailing list, I forgot!! On 01/06/2004 11.35, Richard Huxton <[EMAIL PROTECTED]> wrote: >Please CC: the mailing list too, other people might have something > >useful to say. > >NMB Webmaster wrote: >> It is for backup purpose. I thought that in this

Re: [GENERAL] dump 7.3 into 7.2?

Tom, Do you know if it is possible to upgrade postgresql on a RAQ4? Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Saturday, December 27, 2003 1:09 PM To: Russ Schneider Cc: pgsql-general Subject: Re: [GENERAL] dump 7.3 into 7.2?

Re: [GENERAL] DBD::Pg problem

Tried that ...it is definetely the to_email field, not any others that is causing the problem. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alex Satrapa Sent: Wednesday, December 03, 2003 6:31 PM To: Ausrack Webmaster Cc: [EMAIL PROTECTED

Re: [GENERAL] DBD::Pg problem

| text| modify | timestamp without time zone | status | smallint| parent | integer | Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martijn van Oosterhout Sent: Wedne

[GENERAL] DBD::Pg problem

Hi I am trying to insert a simple email address into a text field, and I get the below error: DBD::Pg::st execute failed: ERROR: pg_atoi: error in "<[EMAIL PROTECTED]>": can't parse "<[EMAIL PROTECTED]>" I figure it is because of the < and @ in the value, but why does it take these as operat

[GENERAL] BIG PROBLEM !!!

Hi all ! I'm from Brazil, so sorry for my bad english!! My Problem: I installed PostgreSQL 7.0.2, but, always than I try acess the server of Postgre with ODBC driver (for Win95) it give me the error: General SQL error Could not connect to the server; Could not connect to remote sockets What I do