PgSql

[HACKERS] disabling log_min_duration_statement from pg_dump?
Hi, Every often, i analyze logs to find most slow queries... and every time i found myself trying to ignore pg_dump's generated COPY commands which could be very expensive... can we add a parameter in pg_dump and pg_dumpall to disable log_min_duration_statement? -- Atentamente, Jaime Casanova Soporte y ca... 8 Mar 2010 16:25

[HACKERS] arithmetic about inet
I got some point from others.I already red and debug network.c . Now I now the basic logic behind that. But still I'm confused by arithmetic. I find some comments on that , I need some one's help. /* * int * bitncmp(l, r, n) * compare bit masks l and r, for n bits. * return: * -1, 1, or 0 in the libc tra... 7 Mar 2010 21:47

[HACKERS] ecpg compiler warning about char* comparison
There is a complier warning in ecpg/ecpglib/error.c on HEAD: error.c: In function 'eecpg_raise_backend': error.c:309: warning: comparison with string literal results in unspecified behavior It comes from the following coparison: --- #define ECPG_SQLSTATE_ECPG_INTERNAL_ERROR "YE000" char *sqlstate; if (sql... 7 Mar 2010 21:47

incorrect exit code from psql with single transaction + violation of deferred FK constraint
Bruce Momjian <bruce(a)momjian.us> writes: The attached patch checks for the proper return from BEGIN/COMMIT, and properly frees the libpq structures. In testing, this does return 3 as you expected. Really? It looks to me like you'd get exit(1). Maybe that's the right thing, but MainLoop itself seems to r... 8 Mar 2010 20:56

Core dump running PL/Perl installcheck with bleadperl [PATCH]
Tim Bunce <Tim.Bunce(a)pobox.com> writes: I encountered a core dump running PL/Perl installcheck with a very recent git HEAD of PostgreSQL and a not quite so recent git HEAD of perl. The cause is a subtle difference between SvTYPE(sv) == SVt_RV and SvROK(sv). The former is checking a low-level implementatio... 9 Mar 2010 18:06

C++ project using postgresql source
On lör, 2010-03-06 at 18:26 +0700, Kiswono Prayogo wrote: Hi, good day everyone ^^ i got these errors: primnodes.h:1155: error: expected unqualified-id before 'using' when i tried to compile plv8 project using g++, could postgresql use/chage variable name considering also C++ keywords? This was al... 6 Mar 2010 08:33

[HACKERS] C++ project using postgresql source
Hi, good day everyone ^^ i got these errors: primnodes.h:1155: error: expected unqualified-id before ‘using’ when i tried to compile plv8 project using g++, could postgresql use/chage variable name considering also C++ keywords? that is: # using # typeid # typename # namespace # delete detailed error... 6 Mar 2010 07:28

[HACKERS] Core dump running PL/Perl installcheck with bleadperl [PATCH]
I encountered a core dump running PL/Perl installcheck with a very recent git HEAD of PostgreSQL and a not quite so recent git HEAD of perl. The cause is a subtle difference between SvTYPE(sv) == SVt_RV and SvROK(sv). The former is checking a low-level implementation detail while the later is directly checking "d... 5 Mar 2010 10:32

SQL compatibility reminder: MySQL vs PostgreSQL
2010/3/5 François Pérou <francois.perou(a)free.fr>: Dear friends, As a reminder, I took part in the development of pgAdmin and I am not looking for a flame war. What did you work on François? I can't find your name in my email archives or on archives.postgresql.org. -- Dave Page EnterpriseDB UK: h... 8 Mar 2010 16:25

Visual Studio 2005, C-language function - avoiding hacks?
On Fri, Mar 5, 2010 at 4:02 AM, Craig Ringer <craig(a)postnewspapers.com.au> wrote: Kevin Flanagan wrote: the compiler complained about various missing include files, starting with ‘libintl.h’. Having read the post at http://archives.postgresql.org/pgsql-general/2009-03/msg00332.php I created a... 9 Mar 2010 03:28