Re: [HACKERS] bug? rules fail to cascade after NOT IN

2003-03-03 Thread Brandon Craig Rhodes
nteering. :-) -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech[EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] bug? rules fail to cascade after NOT IN

2003-03-03 Thread Brandon Craig Rhodes
Tom Lane <[EMAIL PROTECTED]> writes: > Brandon Craig Rhodes <[EMAIL PROTECTED]> writes: > > The `working' test case omits the > > AND (account, policy) NOT IN > > (SELECT account, policy FROM policy_accounts_active) > > condition from the end o

[HACKERS] bug? rules fail to cascade after NOT IN

2003-03-03 Thread Brandon Craig Rhodes
ction of our techniques will be appreciated! test-broken.sql Description: Binary data test-working.sql Description: Binary data -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech[EMAIL PROTECTED] -

Re: [HACKERS] problem importing languages in CVS tip

2003-03-03 Thread Brandon Craig Rhodes
Tom Lane <[EMAIL PROTECTED]> writes: > [I do not see that error] here. Try a full recompile. (Unless you > configure with --enable-depend, a "make distclean" is a smart move > during *any* update from CVS.) An initdb followed by rebuilding my tables fixed the problem.

[HACKERS] problem importing languages in CVS tip

2003-03-03 Thread Brandon Craig Rhodes
-l' which makes me wonder if I have done something horribly wrong. Does anyone else see this? -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech[EMAIL PROTECTED] ---(end of broa

[HACKERS] possibly spurious `EXCEPT ... may not refer to other relation...'

2003-02-20 Thread Brandon Craig Rhodes
current_delete AS ON DELETE TO current DO INSERT INTO former (number) SELECT number FROM current WHERE number = OLD.number EXCEPT SELECT number FROM trash; -- Brandon Craig Rhodes http://www.rhodesmill.org/brandon Georgia Tech