[ADMIN] Group By Time Stamp

2002-03-24 Thread Ariunbold Gerelt-Od
Hi, I have a table Answers with fields answer_id integer,time_stamp timestamp. How can I create a query that gives a sum of answer_id=ID ,but in every 2 hours. For example: answer_sum time_stamp 10 2002-03-24 20-22 12 2002-03-24 22-24 20 2002-03-25 00-02 4

[ADMIN] Find a broken table

2001-08-13 Thread Ariunbold Gerelt-Od
Hi guys, Suddenly, the processes for postmaster are overqueued and becoming more and more for every access. By investigating,it seems me that maybe several tables or indexes of database are broken and i was wondering is there any way to find out the exact broken table or index? thanx in advance.

[ADMIN] Script hangs on

2001-06-05 Thread Ariunbold Gerelt-Od
By Php scripts I am connecting to database SERVER: It works good enough. But problem is if somebody suddenly switch off the server(210.111.1.10), the script hangs on. How would my script check that host is open before connecting? ---(end of broadcast)--

Re: [ADMIN] Script Hangs on

2001-06-05 Thread Ariunbold Gerelt-Od
Frist ,How in script could I Ping? Second,from command line Ping also hangs. Csaba Bobak wrote: > > > $port=9939; > > $host=\"210.111.1.10\"; > > pg=pg_connect($port,$host); > > ?> > > > But problem is if somebody suddenly switch off > > the server(210.111.1.10), the script hangs on. > > How w

[ADMIN] Script Hangs on

2001-06-05 Thread Ariunbold Gerelt-Od
By Php scripts I am connecting to database SERVER: But problem is if somebody suddenly switch off the server(210.111.1.10), the script hangs on. How would my script check that host is open before connecting? ---(end of broadcast)--- TIP 6: Have