Re: [GENERAL] pg_autovacuum exceptions question

2009-08-17 Thread Chris Bowlby
pport that, would it be via a: CREATE DATABASE blip WITH AUTOVACUUM = OFF; command or something similar? Alvaro Herrera wrote: > Chris Bowlby wrote: > >> Hi Guys, >> >> In relation to pg_autovacuum, I have a quick question, that I can't seem >> to find

[GENERAL] pg_autovacuum exceptions question

2009-08-17 Thread Chris Bowlby
Hi Guys, In relation to pg_autovacuum, I have a quick question, that I can't seem to find an answer to anywhere. I use a temporary database that only exists when certain scripts are running, and is dropped when the scripts are complete. In that process, I have seen pg_autovacuum periodically exami

Re: [GENERAL] issue with an assembled date field

2008-02-29 Thread Chris Bowlby
ho Tom, Thanks that gave me the brain burp I needed to click into what was causing the root issue. On Fri, 2008-02-29 at 13:47 -0500, Tom Lane wrote: > Chris Bowlby <[EMAIL PROTECTED]> writes: > > I am converting an encoded field (lot_id) into a date field, the 5 > > char

Re: [GENERAL] issue with an assembled date field

2008-02-29 Thread Chris Bowlby
#x27;); INSERT INTO my_lot_test(lot_id) VALUES('02027'); Note that the formatting here is unique to my test, but the issue arises with this any valid combination of string that I have tried, short and longer. On Fri, 2008-02-29 at 13:12 -0500, Colin Wetherbee wrote: > Chris Bowlby wrote

[GENERAL] issue with an assembled date field

2008-02-29 Thread Chris Bowlby
Hi All, I am currently running into an issue with a query and would like to get some assistance if possible. The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux Enterprise Server 9 SP3 I am converting an encoded field (lot_id) into a date field, the 5 character of every lo

[GENERAL] Issues with PL/PGSQL function..

2007-07-16 Thread Chris Bowlby
Hi All, Running into a small issue with a PL/PGSQL function under PostgreSQL 8.0.11... epassembly=# select version(); version - PostgreSQL 8.0.11 on x86_64-unk

[GENERAL] SPI based table locks.

2006-07-13 Thread Chris Bowlby
Hi All, I've been working on a small module that I will be pluging into my local PostreSQL 8.x database and am in need of doing some table locking. At this time, I've used various other examples to no avail and was wondering what the proper method for aquiring a table lock within the module w

Re: [GENERAL] www.postgresql.org

2001-09-19 Thread Chris Bowlby
> > > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > Chris Bowlby,

[HACKERS] Client can not connect to socket...

2001-03-20 Thread Chris Bowlby
? Chris Bowlby, - Web Developer @ Hub.org. [EMAIL PROTECTED] www.hub.org 1-902-542-3657 - ---(end of broadcast)--- TIP 6: Have you searched