Re: [GENERAL] rule question

2008-02-29 Thread Tim Rupp
matically. Thanks DEVI.G - Original Message - From: "Tim Rupp" <[EMAIL PROTECTED]> To: Sent: Friday, February 29, 2008 8:47 AM Subject: [GENERAL] rule question Hey list, Does CREATE RULE require an exclusive lock on the table it's making a rule for? For instance, if

[GENERAL] rule question

2008-02-28 Thread Tim Rupp
Hey list, Does CREATE RULE require an exclusive lock on the table it's making a rule for? For instance, if an insert is being done on the table, and you do 'create rule', it will wait for said insert to finish? Thanks, -Tim ---(end of broadcast)---

Re: [GENERAL] check constraint question

2008-01-24 Thread Tim Rupp
On Jan 24, 2008 9:47 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Tim Rupp" <[EMAIL PROTECTED]> writes: > > ... a bunch of inherited tables that have the following constraint > > > CHECK (start_time >= '2008-01-01'::date AND end_time < '

[GENERAL] check constraint question

2008-01-24 Thread Tim Rupp
Hi list, I was looking for a bit of clarification on a check constraint that I have on some tables. I was following the example in the partitioning documentation http://www.postgresql.org/docs/8.2/interactive/ddl-partitioning.html And got it to work, but when I tried to apply the same idea to my