[GENERAL] Referential cascade technique

2001-07-23 Thread Mike Finn
ow we did it in oracle). Anyone have a better approach? Assuming this is the right way to do this can someone advise me where/how to extract the required data from the pg_xxx tables? thanks, Mike. === Mike Finn Tactical Executive Systems [EMAIL P

[GENERAL] Unexpected *ABORT STATE*

2001-07-30 Thread Mike Finn
is a sample gbtest=> begin; BEGIN gbtest=> select * fro pg_trigger; ERROR: parser: parse error at or near "fro" gbtest=> select * from pg_trigger; NOTICE: current transaction is aborted, queries ignored until end of transaction block *ABORT STATE* gbtest=> rollback; Mike. ==

[GENERAL] Comparing fixed precision to floating

2001-08-21 Thread Mike Finn
uld someone explain what I am missing. Else could we put a =(numeric, float8) operator on the todo list? Thanks, in advance for any help. Mike. === Mike Finn Tactical Executive Systems [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] last comma inside "CREATE TABLE ()" statements

2001-04-26 Thread Mike Finn
ble' . Yes we could just make sure that we avoid sloppy syntax but it is great to have the parser say 'hey that was wrong, fix it and I won't complain again'. I'm more than happy to fix it now and know that I can use it later without hassle. Just my 2 (okay maybe 3) cen