[GENERAL] DELETE Weirdness

2010-01-14 Thread Ravi Chemudugunta
There are two ways of deleting things, DELETE FROM WHERE PK IN ( ...SET... ); DELETE FROM USING WHERE AND ; I am deleting from a table where the rows are inter-related (it is a tree); using the first version with IN, it does not delete all rows; there is a trigger that rearranges the rows wh

[GENERAL] query evaluation

2008-11-26 Thread Ravi Chemudugunta
Hi all, I have the following query. select part_id, consume_part(part_id) from part where in_use = false; does it: a/ iterate over all parts, calling consume on them and then show the records where in_use is false (i.e. all parts have been consumed by the SP consume_part) or b/ filter

[GENERAL] Code Organisation

2008-11-18 Thread Ravi Chemudugunta
Hi, I realise this may be a subjective topic ; however: what does everyone think about grouping a set of functions together, by related it maybe that they call on each other but more so live in the same file on disk (before they get submitted) ... we are trying to use the output of pg_dump for ve

Re: [GENERAL] using plpgsql debuggers

2008-10-29 Thread Ravi Chemudugunta
f... -ravi On Wed, Oct 29, 2008 at 9:54 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Wed, Oct 29, 2008 at 6:48 AM, Ravi Chemudugunta > <[EMAIL PROTECTED]> wrote: > > hi all, > > > > has anyone here heard of / used: > > > > http://pgfoundry.org/proj

[GENERAL] using plpgsql debuggers

2008-10-28 Thread Ravi Chemudugunta
hi all, has anyone here heard of / used: http://pgfoundry.org/projects/edb-debugger/ This allows one to debug code, using breakpoints, single stepping etc. which seems really great but I haven't figured out how to use it yet? I can't figure out how to invocate the server (target) side in order