Re: [GENERAL] Can't restart statistics collection and autovacuum

2014-03-14 Thread Ignacio Colmenero
g the server reboot, our server is hosted by Rackspace and, for some reason it ran out of memory, and they rebooted it; that's something I also need to check out, but that's for another post. Thanks. On 14/03/2014 1:13 PM, Tom Lane wrote: Ignacio Colmenero writes: Yesterday, the data

[GENERAL] Can't restart statistics collection and autovacuum

2014-03-14 Thread Ignacio Colmenero
3 OS: Ubuntu 11.10 (GNU/Linux 3.0.0-12-virtual x86_64) -- /Ignacio Colmenero/ Database Analyst Abra Controls Inc. P# (403) 775-2237 ignacio.colmen...@abracontrols.com <mailto:ignacio.colmen...@abracontrols.com>

Re: [GENERAL] Problems with vacuumdb

2005-09-19 Thread Ignacio Colmenero
No. The statement_timeout parameter is set to 0. Thanks. --- Ignacio Colmenero Software Development Micotan Software Company Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: September 19

Re: [GENERAL] Problems with vacuumdb

2005-09-19 Thread Ignacio Colmenero
No. The statement_timeout parameter is set to 0. Thanks. --- Ignacio Colmenero Software Development Micotan Software Company Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: September 19

[GENERAL] Problems with vacuumdb

2005-09-19 Thread Ignacio Colmenero
acuum process to get through? Any parameters I should fix?   Thanks in advance, ------- Ignacio Colmenero Software Development Micotan Software Company Ltd.  

Re: [GENERAL] ERROR: control reached end of function without RETURN

2005-02-11 Thread Ignacio Colmenero
Thanks Tom. I didn't know I needed a RETURN statement at the end. I assumed that the "return next" statement would be enough. It works fine now. ------- Ignacio Colmenero Software Development Micotan Software Company Ltd. -Original Me

[GENERAL] ERROR: control reached end of function without RETURN

2005-02-11 Thread Ignacio Colmenero
select * from search_geo() ; I get the error: ERROR:  control reached end of function without RETURN   What can be wrong?   TIA Ignacio.   --- Ignacio Colmenero Software Development Micotan Software Company Ltd.  

Re: [GENERAL] Questions about functionality

2005-02-07 Thread Ignacio Colmenero
nacio. --- Ignacio Colmenero Software Development Micotan Software Company Ltd. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Questions about functionality

2005-02-04 Thread Ignacio Colmenero
Sorry if my questions are kind of newbie.   Ignacio.   --- Ignacio Colmenero Software Development Micotan Software Company Ltd.