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

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

-- test (1 ligne) and now : postgres=# SELECT test(2); NOTICE: SELECT 'test'::text AS label ERROR: 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&qu

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...) b

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 lookin

[HACKERS] PostGreSQL and recursive queries...

ager that if we move to the next version of postgresql there will be a performance 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

[HACKERS] PostGreSQL and recursive queries...

we move to the next version of postgresql there will be a performance drop. What is the best solution Please help me!!! Hubert FONGARNAND Fiducial --- End Message --- ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] PostGreSQL and zlib

ompression level... 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 t

[HACKERS] PostGreSQL and zlib

I'm sure it's very easy 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 co

[HACKERS] Function cache regeneration

r intranet 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 Hu

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 quit

Re: [HACKERS] Recursive Queries

Le jeudi 25 janvier 2007 à 12:12 -0500, Gregory Stark a écrit : > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > > > That's basically how the existing patch approached the problem. It > > > invents a > > > new type of join and a new type of tuplestore that behaves this way. This > > > has >

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 +, Gr

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

[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é, nou

Re: [HACKERS] WITH support

ever made a patch for WITH and CONNECT BY? I'm ready to test these features... (RECURSIVE) when they'll land in CVS... Hubert FONGARNAND ___ Ce message et les �ventuels documents joints peuvent contenir des informations confidentielles. Au

Re: [HACKERS] WITH support

emkin http://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