FAQ

PostgreSQL > pgsql-hackers > October 2009

Search Discussions

133 discussions - 1,903 posts

  • Per discussion at the developer meeting back in Ottawa, attached is an initial patch that implements reading a directory of configuration files instead of just one. The idea being that something like ...
    Magnus HaganderMagnus Hagander
    Oct 24, 2009 at 1:41 pm
    Nov 12, 2009 at 11:10 am
  • As most of you will recall, plpgsql currently acts as though identifiers in SQL queries should be resolved first as plpgsql variable names, and only failing that do they get processed as names of the ...
    Tom LaneTom Lane
    Oct 18, 2009 at 5:25 pm
    Nov 9, 2009 at 11:18 pm
  • I believe the attached patch is ready for review at the next commitfest. It does the following: - Adds a userset GUC called application_name. - Allows application_name to be reported in ...
    Dave PageDave Page
    Oct 16, 2009 at 11:58 am
    Oct 21, 2009 at 4:14 pm
  • A useful feature found in other DBMSs such as MS SQL Server that has been requested on these lists a few times, is the ability for a client application to report its name to the server. This ...
    Dave PageDave Page
    Oct 13, 2009 at 3:02 pm
    Oct 21, 2009 at 7:04 pm
  • Folks, At the moment, user-accessible RULEs have, as far as I know, just two sane uses: * Writing to VIEWs * Routing writes to partitions And the second is pretty thin, given the performance issues ...
    David FetterDavid Fetter
    Oct 4, 2009 at 5:54 pm
    Oct 8, 2009 at 11:06 am
  • Currently random_page_cost is a GUC. I propose that this could be set per-table. I think this is a good idea for widely-wanted planner hints. This way You can say "I do NOT want this table to be ...
    Marcin mankMarcin mank
    Oct 19, 2009 at 9:10 pm
    Nov 9, 2009 at 11:56 pm
  • The attached patch is a revised version based on the previous discussions at: http://archives.postgresql.org/message-id/20090929105431.GO17756@tamriel.snowman.net ...
    KaiGai KoheiKaiGai Kohei
    Oct 2, 2009 at 6:45 am
    Oct 28, 2009 at 2:07 pm
  • Folks, As we move forward, we run into increasingly complex situations under the general rubric of concurrency. What test frameworks are already out there that we can use in our regression test ...
    David FetterDavid Fetter
    Oct 7, 2009 at 4:18 pm
    Oct 13, 2009 at 8:36 am
  • I'd like to improve partitioning feature in 8.5. Kedar-san's previous work is wonderful, but I cannot see any updated patch. ...
    Itagaki TakahiroItagaki Takahiro
    Oct 29, 2009 at 2:15 am
    Nov 12, 2009 at 10:54 am
  • I took a look at this and it seems fairly straightforward. It basically requires (1) deciding where and how to store per-tablespace defaults, (2) making those defaults conveniently available to ...
    Robert HaasRobert Haas
    Oct 25, 2009 at 4:06 pm
    Nov 3, 2009 at 1:37 pm
  • I tried making a functional index based on an expression containing the 2 argument regexp_matches() function. Is there a reason why this function is not marked immutable instead of normal? regards, ...
    Rod TaylorRod Taylor
    Oct 14, 2009 at 8:21 pm
    Oct 21, 2009 at 4:53 pm
  • In chapter "36.4 Rules and Privileges" we show an example of using a view to expose part of a table to other users, keeping other rows private: private, the others are of interest for the secretary ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 22, 2009 at 10:03 am
    Feb 20, 2010 at 9:21 pm
  • I would like to propose a change in the way privilege checking is done with inheritance hierarchies. Currently, selecting from a table that has children requires explicit privileges on all the ...
    Peter EisentrautPeter Eisentraut
    Oct 3, 2009 at 6:46 am
    Oct 20, 2009 at 8:10 pm
  • Now that the samehost/samenet patch is in, I wonder if it wouldn't be a good idea to replace this part of the default pg_hba.conf file: # IPv4 local connections: host all all 127.0.0.1/32 ...
    Tom LaneTom Lane
    Oct 1, 2009 at 2:08 am
    Oct 3, 2009 at 11:11 pm
  • I've made progress in implementing writeable CTEs (repo at git://git.postgresql.org/git/writeable_cte.git , branch actually_write) and I've hit a few corner-cases which have lead me to think that we ...
    Marko TiikkajaMarko Tiikkaja
    Oct 7, 2009 at 9:08 pm
    Oct 19, 2009 at 3:50 pm
  • I haven't objections to do that, we don't planned that because we know sceptical relation of community to hints :) -- Teodor Sigaev E-mail: teodor@sigaev.ru WWW: http://www.sigaev.ru/
    Teodor SigaevTeodor Sigaev
    Oct 12, 2009 at 3:08 pm
    Apr 29, 2010 at 8:42 am
  • So I compiled postgres with Solaris 10 and have problems running it. # ./pg_ctl ld.so.1: pg_ctl: fatal: relocation error: R_AMD64_32: file /usr/local/postgres64/lib/libpq.so.5: symbol (unknown): ...
    U235sentinelU235sentinel
    Oct 8, 2009 at 1:49 am
    Oct 21, 2009 at 2:43 pm
  • Folks, I'd like to see about removing the following GUCs: add_missing_from (should be off) array_nulls (should be on) commit_delay (no need for this knob) commit_siblings (no need for this knob) ...
    David FetterDavid Fetter
    Oct 20, 2009 at 5:49 pm
    Oct 21, 2009 at 5:45 am
  • Background info: Fedora/Red Hat folks (not Tom...) changed license in PostgreSQL spec file from BSD to MIT with the following notice: # PG considers their license to be simplified BSD, but it's more ...
    Devrim GündüzDevrim Gündüz
    Oct 25, 2009 at 10:17 pm
    Oct 27, 2009 at 11:07 am
  • I'd like to propose adding a new GUC to limit the amount of memory a backend can allocate for its own use. The problem this addresses is that sometimes one needs to set work_mem fairly high to get ...
    DavegDaveg
    Oct 1, 2009 at 10:34 am
    Oct 2, 2009 at 1:18 am
  • Folks, We have some really silly legacy stuff in PostgreSQL, the silliest of which, as far as I've found, is the add_missing_from GUC. Since it's been deprecated, as in off by default, since 8.1, I'd ...
    David FetterDavid Fetter
    Oct 16, 2009 at 5:04 pm
    Oct 19, 2009 at 12:07 pm
  • Whilst fooling with the default ACLs patch I noticed that there's a pre-existing bug in CREATE OR REPLACE FUNCTION. It will let you replace a function if pg_proc_ownercheck passes, which these days ...
    Tom LaneTom Lane
    Oct 1, 2009 at 10:42 pm
    Oct 2, 2009 at 5:57 pm
  • When I run ./configure, I get (...warning..) (If you are using the official distribution of PostgreSQL then you do not need to worry about this because the Flex output is pre-generated.) Well, I am ...
    Simon RiggsSimon Riggs
    Oct 14, 2009 at 6:03 pm
    Feb 22, 2010 at 9:17 pm
  • Now that we've got a hopefully-non-broken implementation of SELECT FOR UPDATE locking as a plan node, we can finally contemplate fixing two misbehaviors that are called out on the SELECT reference ...
    Tom LaneTom Lane
    Oct 26, 2009 at 2:34 am
    Oct 27, 2009 at 9:06 pm
  • I'm working on WHEN clause support in triggers. I heard that the feature is in the SQL standard. We can rewrite triggers that uses suppress_redundant_updates_trigger ...
    Itagaki TakahiroItagaki Takahiro
    Oct 15, 2009 at 9:25 am
    Oct 16, 2009 at 3:21 pm
  • Hi, it seems like we can't do this. At least a get this error: db=# alter table pg_largeobject set tablespace otro; ERROR: permission denied: "pg_largeobject" is a system catalog but pg_largeobject ...
    Jaime CasanovaJaime Casanova
    Oct 5, 2009 at 11:19 pm
    Oct 2, 2012 at 3:08 am
  • Updated patch attached. Per discussion, this: - Changes the envvar name to PGAPPNAME - Removes support for setting application_name in the startup packet, and instead sends an explicit SET command as ...
    Dave PageDave Page
    Oct 22, 2009 at 1:07 pm
    Jan 21, 2010 at 7:52 pm
  • But it will set GET DIAGNOSTIC ... = ROW_COUNT, am I being told on IRC. I was really suprised FOUND is not set by EXECUTE in 8.3 when doing a partitioning UPDATE trigger (we partition a summary table ...
    Dimitri FontaineDimitri Fontaine
    Oct 22, 2009 at 8:35 pm
    Nov 10, 2009 at 2:23 pm
  • Hi Can someone help me how to repair the problem below, I'm using Postgres 8.2.5: - after appeared the erros below in selects, vacuum and dump in one table: 2009-10-16 16:07:06 BRT 192.168.0.87 ...
    João Eugenio MarynowskiJoão Eugenio Marynowski
    Oct 22, 2009 at 4:29 pm
    Oct 26, 2009 at 8:56 pm
  • Hi, In the gram.y, under a_expr rule under the subrule "a_expr NOT SIMILAR TO a_expr %prec SIMILAR" the action is as follows { FuncCall *n = makeNode(FuncCall); n- funcname = ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Oct 27, 2009 at 1:22 am
    Nov 4, 2009 at 11:18 pm
  • Greetings, I'd like to propose a potential patch, and wanted to get preliminary feedback on it before I started looking into the design. Summary: Add a string key space to the advisory lock ...
    Christophe PettusChristophe Pettus
    Oct 26, 2009 at 5:54 am
    Oct 27, 2009 at 11:50 pm
  • I've started looking at the following TODO item: "Improve deferrable unique constraints for cases with many conflicts" and Tom's suggestion that the rows to be checked can be stored in a bitmap, ...
    Dean RasheedDean Rasheed
    Oct 7, 2009 at 5:14 pm
    Oct 27, 2009 at 4:18 pm
  • UTF8 encoding text files with BOM (Byte Order Mark) are commonly used in Windows, though BOM was designed for UTF16 text originally. However, psql cannot read such format even if we set client ...
    Itagaki TakahiroItagaki Takahiro
    Oct 20, 2009 at 5:40 am
    Oct 24, 2009 at 9:33 pm
  • by using latest v8 engine from google, is it possible to build PL/Js just like other PL in Postgre? such as PL/PHP what should i learn if i want to build PL/Js? thanks in advance. regards, Kis GB
    Kiswono PrayogoKiswono Prayogo
    Oct 7, 2009 at 8:03 am
    Oct 8, 2009 at 4:43 am
  • In http://archives.postgresql.org/message-id/26545.1255140067@sss.pgh.pa.us I suggested that we should push the actual execution (not just queuing) of non-deferred AFTER triggers into the new ...
    Tom LaneTom Lane
    Oct 28, 2009 at 10:45 pm
    Nov 1, 2009 at 4:12 pm
  • Hi, I'm writing two functions "parse_url_key" and "parse_url_record" which will have one text argument and will return a record or a specific column of it. Theses functions are calling ...
    Samuel ROZESamuel ROZE
    Oct 21, 2009 at 3:32 pm
    Oct 21, 2009 at 8:06 pm
  • I took a look at 2-pg85-sqlda-10-ctxdiff.patch. Starting from CVS HEAD of roughly 2009-10-03 05:00 UTC, prerequisite patches 1a-1h applied cleanly. 2-pg85-sqlda hit a trivial whitespace reject in ...
    Noah MischNoah Misch
    Oct 4, 2009 at 6:08 am
    Oct 15, 2009 at 12:54 am
  • I would like to add a temporal contrib module. The most important piece would be adding a period data type and some support functions. Jeff Davis and I both have temporal projects on pgFoundry, and ...
    Scott BaileyScott Bailey
    Oct 29, 2009 at 7:31 am
    Nov 5, 2009 at 8:38 am
  • Developers, I'm a senior developer for a small Company working on modifications to both MySQL and PostgreSQL to support better usage reporting for DBAs. The project is called ExtSQL. Most of our work ...
    John MurtariJohn Murtari
    Oct 30, 2009 at 4:07 pm
    Oct 31, 2009 at 10:53 pm
  • Howdy, Very excited about the new `DO` command in 8.5a2. I read through the patch review thread and found that, like me, Dim had expected it to behave more like a lambda than a simple command. And ...
    David E. WheelerDavid E. Wheeler
    Oct 26, 2009 at 7:00 pm
    Oct 26, 2009 at 11:21 pm
  • I'm working on alternative version of VACUUM FULL, which is like CLUSTER but sort tuples in ctid order without index. The original discussion is here: [HACKERS] Feedback on getting rid of VACUUM FULL ...
    Itagaki TakahiroItagaki Takahiro
    Oct 23, 2009 at 3:10 am
    Nov 12, 2009 at 1:22 pm
  • plv8js is a procedural language add-on for PostgreSQL, which means you can define Javascript functions that run inside a PostgreSQL server using google V8 Engine. anyone who want to contribute in ...
    Kiswono PrayogoKiswono Prayogo
    Oct 27, 2009 at 3:29 am
    Nov 1, 2009 at 5:42 am
  • I am starting to plan a few features that are important for temporal data, and one prerequisite for several of them is the ability to find an operator that fills a certain role. For instance, one ...
    Jeff DavisJeff Davis
    Oct 23, 2009 at 5:27 am
    Oct 24, 2009 at 8:10 pm
  • Hello this is syntax column(table) necessary still? postgres=# select a(x) from x; a ──── 10 (1 row) Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Oct 22, 2009 at 6:51 am
    Oct 22, 2009 at 3:47 pm
  • The Hot Standby patch changes lock_twophase_recover() so that when we're starting up from Hot Standby mode to normal operation, as opposed to crash recovery, we assume that all AccessExcusiveLocks ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 21, 2009 at 4:37 pm
    Oct 22, 2009 at 7:22 am
  • I saw a recent blog entry where someone came up with a solution for expiring idle connections ( http://dividebyzeroexception.blogspot.com/2009/10/implementing-waittimeout-in-postgresql.html) and I ...
    Thom BrownThom Brown
    Oct 9, 2009 at 4:25 pm
    Oct 11, 2009 at 6:25 am
  • Hello, following this old discussion: http://archives.postgresql.org/pgsql-patches/2008-03/msg00402.php i modifies the patch to use the "CREATE [OR REPLACE] LANGUAGE" syntax. If the patch is ok, i ...
    Andreas 'ads' ScherbaumAndreas 'ads' Scherbaum
    Oct 6, 2009 at 11:58 am
    Oct 6, 2009 at 5:01 pm
  • On http://www.postgresql.org/docs/8.4/interactive/protocol.html we say: "Higher level features built on this protocol (for example, how libpq passes certain environment variables when the connection ...
    Dave PageDave Page
    Oct 13, 2009 at 4:25 pm
    Feb 22, 2010 at 6:12 pm
  • Hackers, A slew of settings in postgresql.conf, including work_mem, search_path, DateStyle, and about 80 others are effectively just defaults for new connections, since they can be changed by any ...
    Josh BerkusJosh Berkus
    Oct 13, 2009 at 5:13 am
    Feb 22, 2010 at 6:09 pm
  • Could someone clarify why this (from PG 8.4) # \du List of roles Role name | Attributes | Member of ---------------+-------------+------------ admin | Create role | {} : Create DB postgres | ...
    Peter EisentrautPeter Eisentraut
    Oct 21, 2009 at 12:28 pm
    Nov 1, 2009 at 6:35 pm
Oct 2009
123
Group Navigation
period‹ prev | Oct 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions133
posts1,903
users134
websitepostgresql.org...
irc#postgresql

134 users for October 2009

Tom Lane: 336 posts Robert Haas: 170 posts Simon Riggs: 90 posts Peter Eisentraut: 82 posts Dave Page: 74 posts Alvaro Herrera: 64 posts Pavel Stehule: 58 posts Heikki Linnakangas: 56 posts Andrew Dunstan: 53 posts Itagaki Takahiro: 48 posts Kevin Grittner: 47 posts Josh Berkus: 46 posts Greg Smith: 39 posts Bruce Momjian: 38 posts Jeff Davis: 37 posts Greg Stark: 36 posts David Fetter: 34 posts David E. Wheeler: 33 posts KaiGai Kohei: 33 posts Dimitri Fontaine: 32 posts
show more
Archives