[GENERAL] Reliably finding temporary table

2005-06-07 Thread Ian Burrell
We have some functions which need to dynamically create a temporary table if it does not already exist. We use the following function: CREATE OR REPLACE FUNCTION test_date_time_exists() RETURNS BOOLEAN AS ' BEGIN RETURN EXISTS ( SELECT * FROM pg_class WHERE re

Re: [GENERAL] [Slony1-general] Mem usage/leak - advice needed

2005-12-22 Thread Ian Burrell
On 12/22/05, John Sidney-Woollett <[EMAIL PROTECTED]> wrote: > In trying to investigate a possible memory issue that affects only one > of our servers, I have been logging the process list for postgres > related items 4 times a day for the past few days. > > This server uses postgres 7.4.6 + slon 1