Re: [SQL] Is there anything special about pg_dump's compression?

2007-11-15 Thread Tom Lane
Jean-David Beyer <[EMAIL PROTECTED]> writes: > I turned the software compression off. It took: > 524487428 bytes (524 MB) copied, 125.394 seconds, 4.2 MB/s > When I let the software compression run, it uses only 30 MBytes. So whatever > compression it uses is very good on this kind of data. > 2981

Re: [SQL] Is there anything special about pg_dump's compression?

2007-11-15 Thread Jean-David Beyer
Andrew Sullivan wrote: > On Thu, Nov 15, 2007 at 11:05:44AM -0500, Jean-David Beyer wrote: >> Does pg_dump's compression do anything really special that it is not >> likely the tape drive already does? The drive claims 2:1 compression >> for average data (e.g., not already compressed stuff like .jp

Re: [SQL] trap for any exception

2007-11-15 Thread Sabin Coanda
> > I read 37.7.5. Trapping Errors, but the syntax requires to write > explicitly the exception condition, and not a generic one. > > Is it possible to build a generic trap or do you know a workaround for > that ? > Sorry, I found the OTHERS condition that trap any error. But the question still

[SQL] Erlang & PostgreSQL native driver

2007-11-15 Thread Daniel Caune
Hi, We are using Erlang, PostgreSQL 8.2.5, and the Erlang library pgsql developed by Christian Sunesson (http://jungerl.cvs.sourceforge.net/jungerl/jungerl/lib/pgsql/). The Erlang library pgsql is easy to use and does the job so far, at least for our prototyping phase. However, this library has

Re: [SQL] trap for any exception

2007-11-15 Thread Stephan Szabo
On Thu, 15 Nov 2007, Sabin Coanda wrote: > Hi there, > > I'd like to build a PL/pgSQL function which is able to generic trap any > error, and interpret it. > > I read 37.7.5. Trapping Errors, but the syntax requires to write explicitly > the exception condition, and not a generic one. > > Is it po

Re: [SQL] trap for any exception

2007-11-15 Thread Stephan Szabo
On Thu, 15 Nov 2007, Sabin Coanda wrote: > > > > I read 37.7.5. Trapping Errors, but the syntax requires to write > > explicitly the exception condition, and not a generic one. > > > > Is it possible to build a generic trap or do you know a workaround for > > that ? > > > Sorry, I found the OTHERS

[SQL] trap for any exception

2007-11-15 Thread Sabin Coanda
Hi there, I'd like to build a PL/pgSQL function which is able to generic trap any error, and interpret it. I read 37.7.5. Trapping Errors, but the syntax requires to write explicitly the exception condition, and not a generic one. Is it possible to build a generic trap or do you know a workaro

Re: [SQL] Is there anything special about pg_dump's compression?

2007-11-15 Thread Andrew Sullivan
On Thu, Nov 15, 2007 at 11:05:44AM -0500, Jean-David Beyer wrote: > Does pg_dump's compression do anything really special that it is not likely > the tape drive already does? The drive claims 2:1 compression for average > data (e.g., not already compressed stuff like .jpeg files). It's zlib, if I

[SQL] Is there anything special about pg_dump's compression?

2007-11-15 Thread Jean-David Beyer
When I run pg_dump, the computer spends a great amount of time in "system" state. Like 100% of one cpu and part of another. The small part seems to be the postgreSQL server, and the big part the client (pg_dump) compressing the data. Now my tape drive has built-in compression anyway (although I co

Re: [SQL] trap for any exception

2007-11-15 Thread Sabin Coanda
That's ok, I found SQLSTATE and SQLERRM. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate