[GENERAL] list triggers - how?

2003-07-27 Thread Holger Marzen
How can I list defined triggers on PostgreSQL 7.1.3? -- PGP/GPG Key-ID: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] list triggers - how?

2003-07-27 Thread Thomas Kellerer
Holger Marzen schrieb: How can I list defined triggers on PostgreSQL 7.1.3? I'm using the following statement: select trg.tgname, tbl.relname, case trg.tgtype & cast(2 as int2) when 0 then 'AFTER' else 'BEFORE' end as trigger_type, case trg.tgtype & cast(28

RE : [GENERAL] Reminder => Poll @ Codewalkers

2003-07-27 Thread Bruno BAGUETTE
Hello everybody, > 28% for postgresql now. Second after MySQL. PostgreSQL rating is currently decreasing : 22% Don't forget to vote for your favorite RDBMS on http://codewalkers.com/ ! :-) --- Bruno BAGUETTE - [EMAIL PROTECTED] ---(

Re: [GENERAL] [ANNOUNCE] v7.3.4 Bug Fix Release

2003-07-27 Thread Tom Lane
The Hermit Hacker <[EMAIL PROTECTED]> writes: > In order to address a potentially serious (although rare) server startup > failure that was recently reported, we have just bundled up and put onto > the ftp sites v7.3.4 of PostgreSQL ... BTW, it should be mentioned that the startup failure was intr