[ADMIN] suddenly changed behaviour

2004-01-25 Thread Coby Beck
ened? I am using 7.2 (yes I know, but upgrading is a bit of a difficulty at the moment) Thanks in advance for assistance! Coby Beck ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] suddenly changed behaviour

2004-01-26 Thread Coby Beck
I am using 7.2 (yes I know, but upgrading is a bit of a difficulty at the moment) Thanks in advance for assistance! Coby Beck ---(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

[ADMIN] parameter to control cycle detection

2004-04-08 Thread Coby Beck
he rule code is generated programmatically so for now at least I would like to avoid having to find a general solution for the sake of an optimization I may not need and it is not an option to hand tweak this one problem rule. Can I set this 10 parameter higher somewhere? TIA. Coby Beck --- Outgoing ma

Re: [ADMIN] parameter to control cycle detection

2004-04-08 Thread Coby Beck
> > "Coby Beck" <[EMAIL PROTECTED]> writes: > > I get the following error trying to update a view: > > "ERROR: query rewritten 10 times, may contain cycles" > > Update to something newer. The default limit is 100 in 7.3, and the > whole t