FAQ

Search Discussions

35 discussions - 146 posts

  • Our WAL backup documentation says in some parts of it: ..."%p is replaced by the absolute path of the file to archive..." [1] I think this is (at least for 8.1 and upcoming 8.2 releases) wrong, since ...
    Bernd HelmleBernd Helmle
    Nov 3, 2006 at 11:19 am
    Nov 10, 2006 at 10:32 pm
  • Avg performance for these two datatypes can be improved by *not* calculating the sum of squares in the shared accumulator (do_numeric_accum). However there is a little subtlety as this function is ...
    Mark KirkwoodMark Kirkwood
    Nov 23, 2006 at 10:08 pm
    Feb 17, 2007 at 12:56 am
  • [jks@jks-work-desktop /tmp/tmp/postgresql-8.2rc1]$ src/tools/make_diff/difforig ./doc/src/sgml/ref/rollback_to.sgml *** ./doc/src/sgml/ref/rollback_to.sgml.orig 2006-11-27 16:57:41.000000000 -0500 ...
    Joseph ShraibmanJoseph Shraibman
    Nov 27, 2006 at 10:08 pm
    Nov 28, 2006 at 2:08 am
  • Attached is a first revision of a patch that adds a column to pg_stat_activity containing the time at which the backend's current transaction began, or NULL if the backend is not inside a ...
    Neil ConwayNeil Conway
    Nov 19, 2006 at 2:45 am
    Nov 20, 2006 at 4:46 pm
  • I have applied your test_fsync patch for 8.2. Thanks. --------------------------------------------------------------------------- Greg Smith wrote: -- Bruce Momjian bruce@momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    Nov 23, 2006 at 4:41 pm
    Nov 24, 2006 at 11:43 pm
  • My company is currently using version 7.2 and would like to convert to the latest version. Unfortunately, version 7.3 implicitly casts a null text to an int4. For example: Create table employee_table ...
    Dwight EmmonsDwight Emmons
    Nov 16, 2006 at 9:53 pm
    Nov 17, 2006 at 8:50 am
  • Attached is a patch that fixes a minor error in CheckLDAPAuth() in 8.2: when an LDAP handle is obtained via ldap_init(), it needs to be released via ldap_unbind(). The code did this, but only if an ...
    Neil ConwayNeil Conway
    Nov 5, 2006 at 12:43 am
    Nov 6, 2006 at 1:51 am
  • As discussed briefly on pgsql-hackers, the current psql \d command does not make any distinction between enabled and disabled triggers. The attached patch modifies psql's describeOneTableDetails() ...
    Brendan JurdBrendan Jurd
    Nov 7, 2006 at 4:55 am
    Nov 18, 2006 at 2:26 am
  • Hi, as promised on -docs, here comes my proposal on how to improve the replication documentation. The patches are split as follows and have to be applied in order: replication_doku_1.diff: Smallest ...
    Markus SchiltknechtMarkus Schiltknecht
    Nov 15, 2006 at 10:43 am
    Nov 16, 2006 at 10:02 pm
  • Hello, this patch correct bug in to_char function with incorrect uppercased month's or day's name. Regards Pavel Stehule Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
    Pavel StehulePavel Stehule
    Nov 29, 2006 at 11:06 pm
    Feb 4, 2007 at 2:54 am
  • Hello, This patch allow use TM prefix in to_char functions for czech environment. Regards Pavel Stehule Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/
    Pavel StehulePavel Stehule
    Nov 29, 2006 at 9:26 am
    Nov 29, 2006 at 3:56 pm
  • I noticed a gripe about plpgsql exceptions leaking memory: http://archives.postgresql.org/pgsql-performance/2006-11/msg00032.php (woulda been nice if he'd reported it more formally, but whatever.) ...
    Tom LaneTom Lane
    Nov 3, 2006 at 5:41 am
    Nov 22, 2006 at 1:17 am
  • Typo in the changes to plperl - uses wrong dir, and had a missing slash. Also fixes error checking for xsubpp - it was broken in a way that hid the problem above when run more than once (which is the ...
    Magnus HaganderMagnus Hagander
    Nov 21, 2006 at 5:45 pm
    Nov 21, 2006 at 6:01 pm
  • Hi. I think this problem to be complex.... http://archives.postgresql.org/pgsql-hackers/2006-11/msg00042.php FormatMessage of windows cannot consider the encoding of the database. However, I should ...
    Hiroshi SaitoHiroshi Saito
    Nov 7, 2006 at 3:04 pm
    Dec 4, 2006 at 10:24 pm
  • This patch fixes a gratuituous string difference. Barring objections I'll apply shortly. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 ...
    Alvaro HerreraAlvaro Herrera
    Nov 29, 2006 at 7:10 pm
    Nov 29, 2006 at 7:45 pm
  • I noticed that the section on pl langs points to appendix H to find out about additional pl's, but there is no info there to speak of. The attached patch ads a list of external pl's and cleans up ...
    Robert TreatRobert Treat
    Nov 17, 2006 at 11:25 pm
    Nov 21, 2006 at 12:05 am
  • Attached is a draft patch for the WAL-and-freezing issues we've been discussing. This incorporates Heikki and Simon's work on providing WAL-logging for tuple freezing actions and pg_clog truncation ...
    Tom LaneTom Lane
    Nov 4, 2006 at 11:06 pm
    Nov 5, 2006 at 4:35 pm
  • Hi. The module link is insufficient.:-( ---- Sorry, japanese message change to xxx --- link.exe @C:\DOCUME~1\hi-saito\LOCALS~1\Temp\nmk03360. common.obj : error LNK2001: xxxxxx "_pg_qsort" xxxxxx ...
    Hiroshi SaitoHiroshi Saito
    Nov 30, 2006 at 1:29 am
    Dec 4, 2006 at 10:26 pm
  • * Add support for building postgres.bki. * Add a genbki.pl script to do this. This could possibly be used in place of the shellscript for the unix build as well, sometime in the future, but not for ...
    Magnus HaganderMagnus Hagander
    Nov 29, 2006 at 6:22 pm
    Nov 29, 2006 at 7:50 pm
  • I think this patch fixes it. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
    Alvaro HerreraAlvaro Herrera
    Nov 29, 2006 at 12:33 pm
    Nov 29, 2006 at 7:43 pm
  • Please find enclosed a patch which adds this :) Cheers, D -- David Fetter <david@fetter.org http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
    David FetterDavid Fetter
    Nov 28, 2006 at 10:51 pm
    Nov 28, 2006 at 10:55 pm
  • I was looking the other day for a variable that turned out to be PGSSLMODE, but the psql docs didn't reveal it to me. I propose to add the following para to the psql docs to point to additional info ...
    Andrew DunstanAndrew Dunstan
    Nov 21, 2006 at 2:54 pm
    Nov 21, 2006 at 5:04 pm
  • I noticed that the Partitioning section of the docs has *two* sections of caveats in different places, but close together. One called caveats, one not. That looks like it just led to somebody not ...
    Simon RiggsSimon Riggs
    Nov 16, 2006 at 6:04 pm
    Nov 21, 2006 at 4:17 am
  • Our MingW FAQ appears to be seriously out of date. Couple of fixes: we want to direct MSI downloads to main download site, NT4 not supported anymore, msvc build env in progress, pgsql-hackers-win32 ...
    Magnus HaganderMagnus Hagander
    Nov 12, 2006 at 8:42 pm
    Nov 20, 2006 at 10:17 pm
  • The attached patch fixes the problem discussed here http://archives.postgresql.org/pgsql-hackers/2006-11/msg00357.php as well as a related problem that I discovered while working on it: the sequence ...
    Tom LaneTom Lane
    Nov 17, 2006 at 1:23 am
    Nov 18, 2006 at 12:59 pm
  • If people want to know the output, run a program and look at the postmaster logs. If we document it, we have to keep it current, even if we improve it later. I will say I had trouble testing this ...
    Bruce MomjianBruce Momjian
    Nov 16, 2006 at 11:19 pm
    Nov 17, 2006 at 9:40 am
  • While there's not anything wrong with this proposed patch in itself, I have to admit that I don't see the point. There are probably thousands of places in the backend where we increment an integer ...
    Tom LaneTom Lane
    Nov 12, 2006 at 4:29 am
    Nov 13, 2006 at 4:58 am
  • Hi Attached is a patch to make ECPGconnect call ECPGclear_auto_mem, as ECPGdo already does. Peter Harris Concept Systems Ltd This email and any files transmitted with it are confidential and are ...
    Peter HarrisPeter Harris
    Nov 7, 2006 at 2:57 pm
    Nov 8, 2006 at 10:49 am
  • I have made some progress with what I think is needed to have two interpreters for plperl. This is a lot harder than the pltcl case for two reasons: 1. there are no restrictions on having 2 tcl ...
    Andrew DunstanAndrew Dunstan
    Nov 5, 2006 at 9:14 pm
    Nov 5, 2006 at 10:26 pm
  • Sergey E. KoposovSergey E. Koposov
    Nov 4, 2006 at 1:41 pm
    Nov 4, 2006 at 7:04 pm
  • It is not obvious that a function should be declared "RETURNS VOID" if it is not supposed to return a value. There's also a user-comment on the 8.1 doc-page. Joachim
    Joachim WielandJoachim Wieland
    Nov 3, 2006 at 3:57 am
    Nov 3, 2006 at 7:18 am
  • I propose to authenticate client via verification of its SSL certificate. IDEA. Recent versions of PostgreSQL database server can verify client's SSL certificate (via server's root.crt now). Server ...
    Gleb KouzmenkoGleb Kouzmenko
    Nov 17, 2006 at 9:24 am
    Nov 17, 2006 at 9:24 am
  • A patch which implements HOT is attached with this email. This patch applies cleanly to PostgresQL 8.2 BETA3 and passes all the regression tests with two exceptions which are explained later. This ...
    Pavan DeolaseePavan Deolasee
    Nov 14, 2006 at 7:01 pm
    Nov 14, 2006 at 7:01 pm
  • subscribe
    Dave PageDave Page
    Nov 13, 2006 at 11:23 am
    Nov 13, 2006 at 11:23 am
  • Since the discussion in September on Block B-Tree concept, I've worked on that and it has evolved to what I call "Grouped Index Tuples". That means that one index tuple in a B-tree can represent many ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 10, 2006 at 12:19 pm
    Nov 10, 2006 at 12:19 pm
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouppgsql-patches @
categoriespostgresql
discussions35
posts146
users37
websitepostgresql.org
irc#postgresql

37 users for November 2006

Tom Lane: 36 posts Bruce Momjian: 20 posts Simon Riggs: 16 posts Neil Conway: 10 posts Andrew Dunstan: 6 posts Brendan Jurd: 6 posts Magnus Hagander: 5 posts Mark Kirkwood: 5 posts Pavel Stehule: 4 posts Alvaro Herrera: 3 posts Joseph Shraibman: 3 posts Markus Schiltknecht: 3 posts Heikki Linnakangas: 2 posts Hiroshi Saito: 2 posts Joshua D. Drake: 2 posts Martijn van Oosterhout: 2 posts Bernd Helmle: 1 post Bruno Wolff III: 1 post Dave Page: 1 post David Fetter: 1 post
show more
Archives