Re: [GENERAL] Copression

2005-03-21 Thread Jay Guerette
FWIW: If you use an stunnel or ssh connection of some sort, merely for compression and not security, the ARCFOUR encryption algorithm appears to have the lowest overhead & fastest throughput. Benchmarked it once for exactly this purpose. > > > It's a possible to compress traffic between server and

Re: [GENERAL] row numbering

2005-02-28 Thread Jay Guerette
OT: You have other database issues: http://www.gnumed.org/ error insert into WebLog values(586,31,"2005-02-28","") Duplicate entry '2005-02-28' for key 2 On Sun, 27 Feb 2005 18:08:02 +0100, Karsten Hilbert <[EMAIL PROTECTED]> wrote: > > > is there a way return a column with the row number autom

[GENERAL] Disabling triggers in a transaction

2005-02-28 Thread Jay Guerette
If I disable INSERT and UPDATE triggers inside a transaction; by setting and resetting reltriggers in pg_class; am I correct in thinking that this will disable triggers globally for that table for the duration of that transaction? So an INSERT or UPDATE to this table, outside of the transaction and