[HACKERS] PostGreSQL and zlib

to implement as a C function that would call zlib Is there already an implementation of such things? Thanks! Hubert FONGARNAND ___ Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait

Re: [HACKERS] PostGreSQL and zlib

... Another question : does this TOAST code works for all type of data, like TEXT (in our case) Le jeudi 25 octobre 2007 à 11:03 +0100, Gregory Stark a écrit : Hubert FONGARNAND [EMAIL PROTECTED] writes: I'm sure it's very easy to implement as a C function that would call zlib

[HACKERS] PostGreSQL and recursive queries...

drop. What is the best solution Please help me!!! Hubert FONGARNAND Fiducial ---End Message--- ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] PostGreSQL and recursive queries...

drop. What is the best solution Please help me!!! Hubert FONGARNAND Fiducial ---End Message--- ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] PostGreSQL and recursive queries...

Le mardi 27 novembre 2007 à 10:00 -0500, Andrew Dunstan a écrit : Hubert FONGARNAND wrote: We are using the CONNECT BY patch made by Evgen Potemkin on PostGreSQL 8.2... It works like a charm with very high performances. But now, we are looking for the 8.3 release... Evgen Potemkin

Re: [HACKERS] pg_dump and BINARY mode COPY

I use often pgdump... and we have many bytea on our database... Without binary COPY, backup is very slow and takes 4x more space on the network wire... It would be great to have an option (--binary) with eventually a WARNING message (that your backup could be not portable across architecture...)

[HACKERS] BUG: type of xxxx does not match that when preparing the plan

: type of rec.label does not match that when preparing the plan CONTEXT: PL/pgSQL function test line 15 at assignment It seems that if the type of label changes from varchar to text it crashes... Thanks for fixing this! Hubert FONGARNAND _ Ce

Re: [HACKERS] BUG: type of xxxx does not match that when preparing the plan

I'm sorry, you're right it fails too with older version of postgresql Le jeudi 31 janvier 2008 à 10:35 -0500, Tom Lane a écrit : Hubert FONGARNAND [EMAIL PROTECTED] writes: We are testing PostGreSQL 8.3 RC2 on our beta plateform and we are facing some problems with plpgsql function

Re: [HACKERS] WITH support

://gppl.moonbone.ru/, it works well on 8.1... But we are ready to drop it if WITH RECURSIVE is integrated!!! It would be great to open a page on the developper wiki on this subject? Sincerely Hubert FONGARNAND

Re: [HACKERS] WITH support

week. As always, I too wouldn't have a problem if someone else is going to see it through for 8.3. Why not looking at http://gppl.moonbone.ru/ evgen potemkin. has ever made a patch for WITH and CONNECT BY? I'm ready to test these features... (RECURSIVE) when they'll land in CVS... Hubert

[HACKERS] Temparary disable constraint

Hi, Is there a way to temporary disable a constraint (without drop and recreating it) in postgresql? Thanks ___ Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné,

Re: [HACKERS] Temparary disable constraint

22:02 -0500, Bruce Momjian a écrit : Hubert FONGARNAND wrote: Hi, Is there a way to temporary disable a constraint (without drop and recreating it) in postgresql? Sure, try ALTER TABLE ... DISABLE TRIGGER for the constraint trigger name

Re: [HACKERS] Recursive Queries

The only code that is usable (and performant) is the CONNECT BY patch made by Evgen Potemkin, It works on production servers on the 8.1.5 I hope that a WITH RECURSIVE will be in the 8.3... but I don't see anybody working on this... (what a shame...) Le mercredi 24 janvier 2007 à 17:27 +,

Re: [HACKERS] Recursive Queries

The CONNECT BY patch from evgen potemkin has been ported to pg 8.2... and it's now in BSD License... I will test it on our test environement Le jeudi 25 janvier 2007 à 11:08 +, Gregory Stark a écrit : Hm, having skimmed through the Evgen Potemkin's recursive queries patch I find it quite

[HACKERS] Function cache regeneration

database, and we don't want nor recreating all of them nor restarting the database... Is there a way to do this in SQL? Thanks Hubert FONGARNAND