FAQ

PostgreSQL > pgsql-hackers > December 2010

Search Discussions

185 discussions - 2,584 posts

  • I've mulled over the design for sync rep for awhile now, and have come up with a feature set that includes the final detailed feedback from Fujii Masao, Aidan Van Dyk, Josh Berkus and others. The ...
    Simon RiggsSimon Riggs
    Dec 30, 2010 at 5:26 pm
    Jan 5, 2011 at 2:00 am
  • Hi, Please find attached revision 16 of the extension patch, with the following additions over the previous one: - added documentation as proposed by David Wheeler, you can browse it online if ...
    Dimitri FontaineDimitri Fontaine
    Dec 9, 2010 at 8:34 pm
    Jan 5, 2011 at 7:36 pm
  • It would be cool to be able to transparently use hstores as Python dictionaries and vice versa. It would be easy enough with hstore as a core type, but with hstore as an addon it's not that easy. ...
    Jan UrbańskiJan Urbański
    Dec 13, 2010 at 7:57 am
    Dec 15, 2010 at 9:48 pm
  • Here's a patch that changes walsender to require a special privilege for replication instead of relying on superuser permissions. We discussed this back before 9.0 was finalized, but IIRC we ran out ...
    Magnus HaganderMagnus Hagander
    Dec 23, 2010 at 9:53 am
    Jan 6, 2011 at 4:59 am
  • The attached patch is the modular version of SE-PostgreSQL. Since I reduced the caching mechanism for access control decision, its code scale became about 2.6KL. [kaigai@saba sepgsql]$ wc -l *.[ch] ...
    KaiGai KoheiKaiGai Kohei
    Dec 24, 2010 at 2:54 am
    Mar 3, 2011 at 3:51 pm
  • There are various applications where we want to completely replace the contents of a table with new/re-calculated data. It seems fairly obvious to be able to do this like... 1. Prepare new data into ...
    Simon RiggsSimon Riggs
    Dec 14, 2010 at 6:27 pm
    Jul 8, 2011 at 6:23 am
  • Hi everyone, one of the ssesion I've attended on PgDay last week was Heikki's session about statistics in PostgreSQL. One of the issues he mentioned (and one I regularly run into) is the absence of ...
    Tomas VondraTomas Vondra
    Dec 12, 2010 at 2:58 am
    Dec 27, 2010 at 3:12 pm
  • Hi everyone, about two weeks ago I've started a thread about cross-column stats. One of the proposed solutions is based on number of distinct values, and the truth is the current distinct estimator ...
    Tomas VondraTomas Vondra
    Dec 27, 2010 at 4:13 pm
    Jan 20, 2011 at 9:58 pm
  • Dear fellow hackers, Problem: A normal diff of two slightly different schema dump files (pg_dump -s), will not produce a user-friendly diff, as you get all changes in the same file. Solution: I ...
    Joel JacobsonJoel Jacobson
    Dec 28, 2010 at 4:00 pm
    Nov 28, 2012 at 6:46 pm
  • The snapshot synchronization discussion from the parallel pg_dump patch somehow ended without a clear way to go forward. Let me sum up what has been brought up and propose a short- and longterm ...
    Joachim WielandJoachim Wieland
    Dec 30, 2010 at 12:31 pm
    Mar 3, 2011 at 11:53 pm
  • Hi, Well $subject says about it all really. The bitrot of course comes from the fact that the last in-commitfest-dependency has been commited in, and I kept a version of pg_execute_sql_file() in the ...
    Dimitri FontaineDimitri Fontaine
    Dec 16, 2010 at 1:14 pm
    Dec 20, 2010 at 11:32 pm
  • Dear Greg, I have updated the MERGE patch for two main problems. 1. Support of system attributes in MERGE action expressions. In old version of MERGE, I use the top join as the only RTE in var name ...
    Boxuan ZhaiBoxuan Zhai
    Dec 4, 2010 at 1:28 pm
    Jan 18, 2011 at 6:22 pm
  • The new SQL Standard (SQL:2011) contains this: "Table constraints are either enforced or not enforced. Domain constraints and assertions are always enforced.", 4.17.2 The SQL Standard allows you to ...
    Simon RiggsSimon Riggs
    Dec 12, 2010 at 10:51 pm
    Jun 3, 2011 at 5:03 pm
  • In reviewing the work Shigeru Hanada has done on SQL/MED, it's come to my attention that we have a lot of error messages that use the error code ERRCODE_WRONG_OBJECT_TYPE and have text like this: ...
    Robert HaasRobert Haas
    Dec 27, 2010 at 3:13 am
    Jan 3, 2011 at 3:31 pm
  • I've been playing around with postgresql hint bits in order to teach myself more about the internals of the MVCC system. I noticed that the hint bit system has been around forever (Vadim era) and ...
    Merlin MoncureMerlin Moncure
    Dec 21, 2010 at 10:42 pm
    Dec 22, 2010 at 11:13 pm
  • Hi, I found a bug which always prevents SignalSomeChildren with BACKEND_TYPE_WALSND from sending a signal to walsender. Though currently SignalSomeChildren with BACKEND_TYPE_WALSND has not been ...
    Fujii MasaoFujii Masao
    Dec 15, 2010 at 3:54 am
    Jan 21, 2011 at 4:43 am
  • texteq, textne, byteaeq and byteane detoast their arguments, then check for equality of length. Unequal lengths imply the answer trivially; given equal lengths, the functions proceed to compare the ...
    Noah MischNoah Misch
    Dec 20, 2010 at 6:20 pm
    Jan 19, 2011 at 8:23 am
  • Hi, I often find myself wanting advisory locks that are automatically released when the transaction ends, so here's a small patch trying to do just that. I don't know much about the lock system so ...
    Marko TiikkajaMarko Tiikkaja
    Dec 13, 2010 at 10:52 pm
    Feb 18, 2011 at 8:39 am
  • Hackers, Some of you might already be aware that this combination produces a fatal startup crash in PostgreSQL: 1. Create an Ext3 or Ext4 partition and mount it with data=journal on a server with ...
    Josh BerkusJosh Berkus
    Dec 1, 2010 at 2:56 am
    Mar 11, 2011 at 1:26 am
  • Here's a patch implementing traceback support for PL/Python mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php. It's an incremental patch on top of the plpython-refactor ...
    Jan UrbańskiJan Urbański
    Dec 23, 2010 at 1:55 pm
    Mar 8, 2011 at 10:09 am
  • As a side note, I think the term "writable CTE" is a misnomer. The CTE is not writable. The CTE is the result of a write operation. A writable CTE would look like this: WITH foo AS (SELECT ...) ...
    Peter EisentrautPeter Eisentraut
    Dec 22, 2010 at 6:28 pm
    Jan 21, 2011 at 1:13 pm
  • Hello I am resending a redesigned proposal about special plpgsql statement that support iteration over an array. The most conflict issue of last proposal was a syntax. It enhanced relative complex ...
    Pavel StehulePavel Stehule
    Dec 16, 2010 at 7:20 pm
    Dec 17, 2010 at 8:08 pm
  • Drat. OK, will work on it tomorrow. I didn't realize those places needed to be updated. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
    Robert HaasRobert Haas
    Dec 26, 2010 at 4:55 am
    Feb 4, 2011 at 3:37 am
  • Hi there, below is the problem, which I don't have when running in shell. The database is in UTF-8 encoding. CREATE OR REPLACE FUNCTION url_decode(Vkw varchar) RETURNS varchar AS $$ use strict; use ...
    Oleg BartunovOleg Bartunov
    Dec 8, 2010 at 3:13 pm
    Jan 17, 2011 at 4:04 am
  • I'm reviving the discussion on the subject topic because I just had an epiphany which makes it seem simple to implement. The concept of this is that if you start a SERIALIZABLE READ ONLY transaction ...
    Kevin GrittnerKevin Grittner
    Dec 5, 2010 at 3:11 pm
    Dec 10, 2010 at 3:22 pm
  • We're now just a day or two from the end of this CommitFest and there are still a LOT of open patches - to be specific, 23.Here's a brief synopsis of where we are with the others, all IMO of course. ...
    Robert HaasRobert Haas
    Dec 13, 2010 at 5:38 pm
    Jan 20, 2011 at 5:43 pm
  • Hello list, FK's cannot refer to rows in inheritance childs. With some changes in LockRows, together with removing the ONLY keyword in ri_trigger.c, it was possible to refer to the rows in child ...
    Yeb HavingaYeb Havinga
    Dec 1, 2010 at 2:02 pm
    Dec 7, 2010 at 11:07 am
  • Hi I've just ran into a problem while upgrading from 8.4 to 9.0. pg_upgrade aborted during the step "Adding support functions to new cluster" with "ERROR: permission denied for language c" error. ...
    Florian PflugFlorian Pflug
    Dec 12, 2010 at 9:55 am
    Mar 9, 2011 at 7:25 pm
  • Hi everyone, I just wrote my first patch, and I need to know whether I missed something or not. I haven't used C for a really long time, so sickbags on standby, and if you notice something really ...
    TvTv
    Dec 11, 2010 at 6:59 pm
    Feb 10, 2011 at 2:22 pm
  • After reviewing the two ongoing threads about fixing the wal_sync_method fiasco, I think there is general agreement on these two points: 1. open_datasync shouldn't be the default choice 2. O_DIRECT ...
    Tom LaneTom Lane
    Dec 7, 2010 at 4:24 pm
    Jan 16, 2011 at 12:15 am
  • Hello attached patch contains a implementation of iteration over a array: Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Dec 23, 2010 at 8:31 pm
    Jan 29, 2011 at 7:08 pm
  • Hi all, Most of you already know I am new to this list and newer to any OSS development. However, while browsing the source code (of 9.0.1) I find that there is only one way to store relations on ...
    Vaibhav KaushalVaibhav Kaushal
    Dec 10, 2010 at 6:39 am
    Jan 1, 2011 at 8:59 pm
  • Hi, The other infrastructure patch that has been mark ready for commit then commented further upon by Tom is $subject, even if the function provided as been renamed to pg_execute_sql_file(). Please ...
    Dimitri FontaineDimitri Fontaine
    Dec 11, 2010 at 9:09 pm
    Dec 16, 2010 at 9:12 am
  • Folks, Is there any good reason that this works: postgres=# select ('1e+01'::numeric)::integer postgres-# ; int4 ------ 10 But this doesn't? postgres=# select '1e+01'::Integer postgres-# ; ERROR: ...
    Josh BerkusJosh Berkus
    Dec 17, 2010 at 7:06 pm
    Dec 18, 2010 at 2:03 am
  • Part of this may be my C skills not being good enough - if so, please enlighten me :-) My pg_streamrecv no longer works with 9.1, because it returns PGRES_COPY_BOTH instead of PGRES_COPY_OUT when ...
    Magnus HaganderMagnus Hagander
    Dec 28, 2010 at 12:13 pm
    Mar 31, 2011 at 4:16 pm
  • Here's the base refactoring patch mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php Git branch for this patch: https://github.com/wulczer/postgres/tree/refactor It does ...
    Jan UrbańskiJan Urbański
    Dec 23, 2010 at 1:40 pm
    Jan 26, 2011 at 11:42 pm
  • Hello, [Tried the general forum, didn't hear from anyone so far, trying this forum now, please review, thanks] We are looking to distribute postgres databases to our customers along with our ...
    Srini RaghavanSrini Raghavan
    Dec 23, 2010 at 12:35 am
    Mar 11, 2011 at 10:35 am
  • Attached patch implements a function called pg_primary_conninfo() that returns, well, the primary_conninfo used on the standby when in streaming replication mode (otherwise NULL). Objections? -- ...
    Magnus HaganderMagnus Hagander
    Dec 28, 2010 at 1:32 pm
    Jan 13, 2011 at 11:06 am
  • pg_ctl.c::test_postmaster_connection() has some fragile code that tries to detect the server port number by looking in the pg_ctl -o string, postgresql.conf, the PGPORT environment variable, and ...
    Bruce MomjianBruce Momjian
    Dec 18, 2010 at 6:22 pm
    Dec 27, 2010 at 8:20 pm
  • I'm still not convinced there's any hazard of this type, but there is, apparently, a problem with failing to emit XLOG records for GIST indexes, because they apparently use LSNs to detect concurrent ...
    Robert HaasRobert Haas
    Dec 14, 2010 at 9:06 pm
    Dec 18, 2010 at 1:51 am
  • Initdb fails for me when host machine has no access to the Postgres build location. LOG: could not open directory .../install/share/timezone": No such file or directory LOG: could not open directory ...
    BRUSSER MichaelBRUSSER Michael
    Dec 9, 2010 at 5:37 pm
    Dec 13, 2010 at 6:02 pm
  • Extensions Patch v15 Review =========================== Submission review ----------------- * Is the patch in context diff format? Yes. * Does it apply cleanly to the current git master? Yes. * Does ...
    David E. WheelerDavid E. Wheeler
    Dec 4, 2010 at 1:09 am
    Dec 9, 2010 at 4:20 am
  • I'm betting 8.4, because there is a field named "using" on that line in 8.4 ... We did clean up C++ keyword uses in the header files in 9.0, but your report shows it's already gotten broken again. ...
    Tom LaneTom Lane
    Dec 26, 2010 at 5:31 pm
    Jan 13, 2011 at 5:34 pm
  • I am suggesting adding a function to libpq: PGresult *PQvexec(PGconn *conn, const char *fmt, ...); It behaves similar to PQexec, but it allows for printf style varargs and does connection ...
    Marc BalmerMarc Balmer
    Dec 5, 2010 at 9:52 am
    Dec 28, 2010 at 3:06 am
  • ALTER TABLE ALTER TYPE always rewrites the table heap and its indexes. In some cases, we can determine that doing so is unhelpful, and that the conversion shall always succeed: CREATE DOMAIN loosedom ...
    Noah MischNoah Misch
    Dec 29, 2010 at 12:56 pm
    Jan 6, 2011 at 5:47 am
  • I am having a hard time understanding this patch. I decided to start with the README, and I'm still lost. :-( My understanding of the problem is as follows. Acquiring a lock on a tuple prevents the ...
    Robert HaasRobert Haas
    Dec 19, 2010 at 4:24 am
    Dec 21, 2010 at 1:48 am
  • This broke the buildfarm on Windows, and I'm not sure of the best way to fix it. We currently define read and write permissions in port/win32.h specifically for windows. A quick-fix to just add these ...
    Magnus HaganderMagnus Hagander
    Dec 11, 2010 at 1:18 pm
    Dec 13, 2010 at 4:38 pm
  • Here's a patch implementing custom Python exceptions for SPI errors mentioned in http://archives.postgresql.org/pgsql-hackers/2010-12/msg01991.php. It's an incremental patch on top of the ...
    Jan UrbańskiJan Urbański
    Dec 23, 2010 at 2:39 pm
    Mar 1, 2011 at 10:58 am
  • Hackers, Here is first version of patch, which enable index support of wildcard search in pg_trgm contrib module. The idea of the patch is to extract from wildcard trigrams which should occurs in ...
    Alexander KorotkovAlexander Korotkov
    Dec 11, 2010 at 9:08 pm
    Feb 1, 2011 at 8:16 am
  • Hi, Please see the following plan: postgres=# explain select * from small_table left outer join big_table using (id); QUERY PLAN ...
    Jie LiJie Li
    Dec 28, 2010 at 10:13 am
    Jan 1, 2011 at 11:18 am
Dec 2010
1234
Group Navigation
period‹ prev | Dec 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions185
posts2,584
users144
websitepostgresql.org...
irc#postgresql

144 users for December 2010

Tom Lane: 385 posts Robert Haas: 366 posts Andrew Dunstan: 110 posts Heikki Linnakangas: 101 posts Dimitri Fontaine: 94 posts Magnus Hagander: 91 posts Simon Riggs: 83 posts Josh Berkus: 73 posts Alvaro Herrera: 69 posts Florian Pflug: 63 posts Kevin Grittner: 63 posts Kineticode Billing: 62 posts Pavel Stehule: 50 posts Tomas Vondra: 49 posts Itagaki Takahiro: 48 posts Peter Eisentraut: 46 posts Bruce Momjian: 44 posts Greg Smith: 40 posts Dmitriy Igrishin: 36 posts David Fetter: 35 posts
show more
Archives