Re: [PATCHES] plpgsql, return can contains any expression
Pavel Stehule [EMAIL PROTECTED] writes: This patch allows using any row expression in return statement and does transformation from untyped row to composite types if it's necessary. This patch doesn't seem to cope with cases where the supplied tuple has the wrong number of columns, and it doesn't look like it's being careful about dropped columns either. Also, that's a mighty bizarre-looking choice of cache memory context in coerce_to_tuple ... but then again, why are you bothering with a cache at all for temporary arrays? I am sorry, Tom. But I don't understand. I can check number of columns, ofcourse and I'll do it. What cache for temporary arrays do you mean? Best regards Pavel Stehule _ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[PATCHES] Dynamic linking on AIX
This patch fixes linking on AIX. Relevant threads on psql-hackers: http://archives.postgresql.org/pgsql-hackers/2006-09/msg01020.php http://archives.postgresql.org/pgsql-hackers/2006-09/msg01084.php http://archives.postgresql.org/pgsql-hackers/2006-09/msg01109.php Up to now, the default on AIX was to link statically. This was not intended; it's just that AIX has different ideas about shared libraries than Linux and nobody cared. --enable-rpath was matched to the AIX equivalent. I tested the patch on AIX 5.3 with gcc; it should also work with IBM's cc. The patch is backward compatible until AIX 4.3 at least, and I added a kludge to Makefile.shlib so that it should also build something operational on AIX 3.2.5. The change to src/interfaces/ecpg/test/Makefile.regress is not actually part of the patch, but without it building fails if you configure --with-ldap --disable-shared I tested building with --disable-shared and --enable-shared (with --enable-rpath and --disable-rpath). Yours, Laurenz Albe aixlink.patch Description: aixlink.patch ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[PATCHES] Tiny plpython fix
Seems __vc_errcode was used during Visual C++ beta at some point, and is now declared deprecated in the system headers. This patch renames our use of it to __msvc_errcode, so we don't conflict anymore. //Magnus plpython_vcerr.patch Description: plpython_vcerr.patch ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[PATCHES] Update to msvc build sys
Here's a patch that updates the msvc build system. It contains the changes in Hiroshi-sans patch from about a week ago, so please apply this patch instead to avoid conflicts. Changes summary: * Change all references to vcbuild directory, since system was moved to src\tools\msvc on commit. * Supports building both Debug and Release binaries now (previously only debug. debug still default). Difference is mainly in that release binaries are optimized. Unfortunatly, full program optimization had to be turned off - more on that later. * Generate ecpg_config.h which is now generated by configure, and thus needs to be generated for vc as well. * Add LDAP library to libpq if used (required for connection-info-in-ldap) * Change build.bat to use unix line endings. To committer: please make sure that the file ends up with all lines with unix line endings, in case the patch gets mangled in some way. //Magnus vcbuild.diff Description: vcbuild.diff ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[PATCHES] LDAP function signature for MSVC
This patch changes the function definition for ldap_start_tls_sA() on win32 by removing the WINLDAPAPI. This is because in some cases WINLDAPAPI gets defined to __declspec(dllimport), which is not permitted at this location. in all other location it apears to be defined to nothing, so removing it really should have no effect. //Magnus libpq_auth_ldap_msvc.diff Description: libpq_auth_ldap_msvc.diff ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[PATCHES] pg_strcasecmp in fe-connect.c
This patch fixes a couple of cases where we use strcasecmp() instead of pg_strcasecmp() in fe_connect.c, coming from the LDAP client pathc. //Magnu libpq_strcmp.diff s libpq_strcmp.diff Description: libpq_strcmp.diff ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [PATCHES] Doc patch on Warm Standby for High Availability
Patch applied. Thanks. I saw the standby script in there now. Thanks. --- Simon Riggs wrote: Docs pretty much as posted on hackers recently. SGML compiles cleanly... Comments/changes welcome. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com [ Attachment, skipping... ] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [PATCHES] currentItemData refactoring
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Heikki Linnakangas wrote: Here's a patch to remove currentItemData currentMarkpos from IndexScanDesc, and add equivalent fields in access method specific opaque structs for those access methods that need them. That makes the index am API cleaner. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] LDAP function signature for MSVC
Magnus Hagander [EMAIL PROTECTED] writes: This patch changes the function definition for ldap_start_tls_sA() on win32 by removing the WINLDAPAPI. Applied. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PATCHES] pg_strcasecmp in fe-connect.c
Magnus Hagander [EMAIL PROTECTED] writes: This patch fixes a couple of cases where we use strcasecmp() instead of pg_strcasecmp() in fe_connect.c, coming from the LDAP client pathc. Applied. I found another instance in contrib/hstore, too. There are also some occurrences in pgbench.c, but I'm unsure that we need be paranoid about changing those. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PATCHES] Update to msvc build sys
Magnus Hagander [EMAIL PROTECTED] writes: Here's a patch that updates the msvc build system. It contains the changes in Hiroshi-sans patch from about a week ago, so please apply this patch instead to avoid conflicts. Changes summary: Applied, thanks. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly