FAQ

PostgreSQL > pgsql-hackers > October 2012

Search Discussions

136 discussions - 1,580 posts

  • SYNTAX: ALTER SYSTEM SET configuration_parameter = value COMMENT 'value'; DESIGN IDEA: (a) have a postgresql.conf.auto (b) add a default include for postgresql.conf.auto at the beginning of ...
    Amit KapilaAmit Kapila
    Oct 29, 2012 at 1:31 pm
    Jan 12, 2013 at 7:43 am
  • Not many RULE-lovers out there, once you've tried to use them. Allowing RULEs complicates various things and can make security more difficult. For 9.3, I suggest we create a DDL trigger by default ...
    Simon RiggsSimon Riggs
    Oct 11, 2012 at 7:28 pm
    Oct 22, 2012 at 11:18 pm
  • Hi all, One of the outputs on the discussions about the integration of pg_reorg in core was that Postgres should provide some ways to do REINDEX, CLUSTER and ALTER TABLE concurrently with low-level ...
    Michael PaquierMichael Paquier
    Oct 3, 2012 at 1:14 am
    Dec 19, 2012 at 2:25 am
  • Based on a previous thread (http://archives.postgresql.org/pgsql-hackers/2012-10/msg00131.php) I have put together a first attempt of a pg_ping utility. I am attaching two patches. One for the ...
    Phil SorberPhil Sorber
    Oct 13, 2012 at 9:19 pm
    Dec 25, 2012 at 6:47 am
  • Hi, With the help of Cédric, here's a patch changing the TRUNCATE TABLE command, adding the IF EXISTS option to allow the presence in the list of tables of a missing or invisible table. This meets ...
    Sébastien LardièreSébastien Lardière
    Oct 9, 2012 at 8:33 am
    Oct 18, 2012 at 7:03 pm
  • 1. These operations think they can use ordinary heap_update operations to change pg_index entries when they don't have exclusive lock on the parent table. The lack of ex-lock means that another ...
    Tom LaneTom Lane
    Oct 5, 2012 at 11:56 pm
    Nov 30, 2012 at 12:56 am
  • Hmm, I think we need to step back a bit. I've never liked the way replication_timeout works, where it's the user's responsibility to set wal_receiver_status_interval < replication_timeout. It's not ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 1, 2012 at 10:39 am
    Jan 9, 2013 at 4:04 am
  • This problem has been discussed before. Those familiar with the subject please skip the next paragraph. When autovacuum finds a substantial amount of empty pages at the end of a relation, it attempts ...
    Jan WieckJan Wieck
    Oct 24, 2012 at 8:20 pm
    Dec 11, 2012 at 8:38 pm
  • Hi, I've just noticed a change of LOCK command behavior between 9.1 and 9.2, and I'm not sure whether this is expected or not. Let's use a very simple table CREATE TABLE x (id INT); Say there are two ...
    Tomas VondraTomas Vondra
    Oct 10, 2012 at 8:21 pm
    Nov 26, 2012 at 4:12 pm
  • Sequences, as defined by SQL Standard, provide a series of unique values. The current implementation on PostgreSQL isolates the generation mechanism to only a single node, as is common on many ...
    Simon RiggsSimon Riggs
    Oct 15, 2012 at 9:34 pm
    Oct 18, 2012 at 3:43 pm
  • Hallo postgresql and replication hackers This mail is an additional RFC which proposes a simple way to extend the new logical replication feature so it can cover most usages of skytools/pgq/londiste ...
    Hannu KrosingHannu Krosing
    Oct 16, 2012 at 8:56 am
    Oct 26, 2012 at 8:28 pm
  • The security of MD5 authentication is brought up every now and then, most recently here: http://archives.postgresql.org/pgsql-hackers/2012-08/msg00586.php. The NIST competition mentioned in that ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 10, 2012 at 10:41 am
    Oct 23, 2012 at 4:53 pm
  • It has been a fact that the RETURNING clause on an INSERT will return multiple rows with the same order as multiple VALUES have been fed. eg: INSERT INTO tbl1(code) VALUES ('abc'), ('def'), ('agh') ...
    P. ChristeasP. Christeas
    Oct 17, 2012 at 12:39 pm
    Oct 22, 2012 at 3:24 am
  • Can we please expose the internal hash id of the statements in pg_stat_statements? I know there was discussions about it earlier, and it wasn't done with an argument of it not being stable between ...
    Magnus HaganderMagnus Hagander
    Oct 1, 2012 at 7:57 am
    Nov 15, 2012 at 9:44 pm
  • Hi, PL/pgsql seems to have a strange restriction regarding "RETURN". Normally, you can write "RETURN <expression ". But if the function returns a row type, then you can only write "RETURN variable" ...
    Robert HaasRobert Haas
    Oct 8, 2012 at 2:42 pm
    Dec 7, 2012 at 4:29 am
  • Since Simon stirred up a hornets nest suggesting deprecation of a number of features, I figured I'd take it one step further and suggest removal of some previously deprecated features :) In ...
    Magnus HaganderMagnus Hagander
    Oct 18, 2012 at 11:20 am
    Nov 5, 2012 at 10:15 pm
  • The attached patch would add the FET timezone abbreviation to the Default list _and_ the list of european abbreviations. - mb
    Marc BalmerMarc Balmer
    Oct 6, 2012 at 9:18 am
    Oct 9, 2012 at 3:40 pm
  • I've noticed, doing some reporting queries once, that index scans fail to saturate server resources on compute-intensive queries. Problem is, just after fetching a page, postgres starts computing ...
    Claudio FreireClaudio Freire
    Oct 18, 2012 at 8:30 pm
    Nov 6, 2012 at 1:53 pm
  • As discussed on other threads, Hash Indexes are currently a broken feature and bring us into disrepute. I describe them as broken because they are neither crash safe, nor could they properly be ...
    Simon RiggsSimon Riggs
    Oct 14, 2012 at 1:46 pm
    Oct 19, 2012 at 9:17 am
  • People, The commitfest currently in progress seems to have ground to a halt. We really need to get things moving, because we're three weeks onto it and there is a large number of patches still ...
    Alvaro HerreraAlvaro Herrera
    Oct 10, 2012 at 3:19 pm
    Nov 5, 2012 at 6:34 pm
  • Folks, One chronic problem users encounter is this one: 1. User creates new table 2. User inserts 45 records into new table. 3. Time passes. 4. User creates a query which joins against new table. 5 ...
    Josh BerkusJosh Berkus
    Oct 12, 2012 at 11:53 pm
    Oct 15, 2012 at 7:39 pm
  • As per the last discussion for this patch, performance data needs to be provided before this patch's Review can proceed further. So as per your suggestion and from the discussions about this patch, I ...
    Amit kapilaAmit kapila
    Oct 13, 2012 at 7:56 am
    Jan 10, 2013 at 9:26 am
  • Hi, Working on the Event Trigger next patch series, one of the challenge to address is deparsing the DDL commands so that the User Defined Function used by the trigger definition has that ...
    Dimitri FontaineDimitri Fontaine
    Oct 5, 2012 at 12:48 pm
    Nov 4, 2012 at 8:20 pm
  • Rushabh Lathia of the EnterpriseDB development team and I have been doing some testing of the extended query protocol and have found a case where it causes an assertion failure. Here's how to ...
    Robert HaasRobert Haas
    Oct 19, 2012 at 4:19 pm
    Oct 22, 2012 at 5:24 am
  • Hackers, I’ve discovered something a bit disturbing at $work. We’re migrating (slowly) from Oracle to PostgreSQL, and in some cases are using oracle_fdw to copy data over. Alas, there are a fair ...
    David E. WheelerDavid E. Wheeler
    Oct 6, 2012 at 12:55 am
    Oct 9, 2012 at 12:49 pm
  • Hi all, I see there's already a TODO for allowing pg_restore to accept multiple --table arguments[1], but would folks support adding this capability to various other commands which currently accept ...
    Josh KupershmidtJosh Kupershmidt
    Oct 28, 2012 at 11:31 pm
    Dec 14, 2012 at 3:14 pm
  • Hi, This patch adds an empty row before each section header in the error codes table in the docs. I tried not putting an empty row before the first section, but it looks better to always have an ...
    Karl O. PincKarl O. Pinc
    Oct 26, 2012 at 2:03 pm
    Dec 10, 2012 at 7:48 pm
  • This contains all the consolidated data and comparison for both the approaches: The difference of this testcase as compare to previous one is that it has default value of wal_page_size ( 8K ) as ...
    Amit kapilaAmit kapila
    Oct 16, 2012 at 9:23 am
    Oct 29, 2012 at 2:40 pm
  • Hey, this is my first post to the -hackers lists, so be merciful ;-) I created a patch which implements MAP_HUGETLB for sysv shared memory segments (PGSharedMemoryCreate). It is based on tests of Tom ...
    Christian KruseChristian Kruse
    Oct 29, 2012 at 8:14 pm
    Dec 21, 2012 at 8:37 pm
  • I just had this thought a few minutes ago, discussed it briefly with RhodiumToad on #postgresql and wanted to put it out here for discussion. Feel free to rip it apart. It probably is a bit ...
    Jan WieckJan Wieck
    Oct 27, 2012 at 5:02 am
    Nov 6, 2012 at 3:12 am
  • Hello I should to search distinct values based on similarity postgres=# explain select nazobce, nazobce <- 'Benešov' from obce order by nazobce <- 'Benešov' limit 10 ; QUERY PLAN ...
    Pavel StehulePavel Stehule
    Oct 22, 2012 at 1:11 pm
    Oct 26, 2012 at 6:56 am
  • Hackers, Any plans to implement a documentation standard for extensions? I would love to see `make install` create the necessary man pages and perhaps even HTML (with a link added in the proper ...
    David E. WheelerDavid E. Wheeler
    Oct 25, 2012 at 5:31 pm
    Nov 2, 2012 at 4:16 pm
  • Hey folks, It seems like right now when you want to create an index concurrently, the index creation will get canceled if you cancel the statement (i.e. you must keep your statement open). Is there a ...
    David LeeDavid Lee
    Oct 27, 2012 at 11:20 pm
    Oct 29, 2012 at 8:50 pm
  • Is the lack of support of cstring in PLs just laziness/ovelook or is there a good reason why PL languages do not support cstring type arguments and return values ? I'm currently adding this to ...
    Hannu KrosingHannu Krosing
    Oct 10, 2012 at 12:33 pm
    Oct 11, 2012 at 11:18 am
  • I was wondering recently if there was any command line tool that utilized PQping() or PQpingParams(). I searched the code and couldn't find anything and was wondering if there was any interest to ...
    Phil SorberPhil Sorber
    Oct 3, 2012 at 3:01 am
    Oct 10, 2012 at 5:18 pm
  • Per http://archives.postgresql.org/pgsql-hackers/2012-10/msg00167.php This brings to mind a lot of issues we see reported among our users: I see the problem of database connections shared among ...
    Daniel FarinaDaniel Farina
    Oct 3, 2012 at 10:09 pm
    Oct 9, 2012 at 6:58 pm
  • Hello, Using PostgreSQL 9.2.1 on Windows, I am facing a strange character set issue with a UTF-8 database. Maybe this is expected, but want to be sure that I am not missing something. On Windows, I ...
    Sebastien FLAESCHSebastien FLAESCH
    Oct 18, 2012 at 7:26 am
    Jan 11, 2013 at 10:16 pm
  • Hi, One of my colleagues, Jehan-Guillaume de Rorthais, found a weird behaviour of the "-c" command line option in the pg_restore tool while doing a training. Here is the following steps he followed ...
    Guillaume LelargeGuillaume Lelarge
    Oct 13, 2012 at 2:47 pm
    Oct 20, 2012 at 9:41 pm
  • A while ago I noticed that in some places we strdup/pg_strdup() optarg strings from getopt(), and in some places we don't. If we needed the strdup(), the missing cases should generate errors. If we ...
    Bruce MomjianBruce Momjian
    Oct 8, 2012 at 6:40 pm
    Oct 13, 2012 at 7:28 pm
  • Hi, I am trying to identify foreign scans uniquely.I am trying to do that by struct ForeignScanState,but I am confused as to how I can identify the scan. Is there a member of ForeignScanState that ...
    Atri SharmaAtri Sharma
    Oct 6, 2012 at 6:33 pm
    Oct 8, 2012 at 1:20 pm
  • While looking around to fix the pg_malloc(0) issue, I noticed that various other pieces of code such as pg_basebackup have essentially identical functions, except they're called xmalloc(). I propose ...
    Tom LaneTom Lane
    Oct 2, 2012 at 4:02 pm
    Oct 4, 2012 at 2:19 pm
  • See the CAVEATS here: https://developer.apple.com/library/mac/#documentation/Darwin/Reference/ManPages/man2/fork.2.html Apparently fork() without exec() isn't all that well supported. Noticed while ...
    Alvaro HerreraAlvaro Herrera
    Oct 3, 2012 at 4:06 pm
    Oct 3, 2012 at 10:57 pm
  • While investigating a ruby-pg issue [1], we noticed that a libpq SSL connection can fail, if the running application uses OpenSSL for other work, too. Root cause is the thread local error queue of ...
    Lars KanisLars Kanis
    Oct 23, 2012 at 8:09 am
    Dec 10, 2012 at 11:54 pm
  • I looked into the complaint of unreasonable planner runtime in bug #7626, http://archives.postgresql.org/pgsql-bugs/2012-10/msg00232.php In the given example, the indexed relation "foo" has join ...
    Tom LaneTom Lane
    Oct 30, 2012 at 9:57 pm
    Nov 5, 2012 at 8:19 pm
  • There was a thread in January of 2012 where we discussed the idea of pulling system table/column name descriptions from the SGML docs and creating SQL comments for them ...
    Bruce MomjianBruce Momjian
    Oct 12, 2012 at 5:29 pm
    Oct 16, 2012 at 1:37 am
  • Hackers, I have a database with 94059 entries in pg_class. Things are mostly working fine but psql tab completion is frustratingly slow (around 2.5 seconds on this box). I poked around in psql a bit ...
    Merlin MoncureMerlin Moncure
    Oct 10, 2012 at 1:33 pm
    Oct 12, 2012 at 8:42 pm
  • Hi, I would like to work on psql \ds improvements. Here's my idea : - in src/bin/psql/describe.c, add a new function : listSequences(*pattern, verbose) wich will list sequences and remove code ...
    Julien TachoiresJulien Tachoires
    Oct 7, 2012 at 9:07 pm
    Oct 8, 2012 at 6:58 pm
  • Hello Hackers! So, currently the only way to see if a function is security definer or not is to directly query pg_proc. This is both irritating, and I think perhaps dangerous since security definer ...
    Jon ErdmanJon Erdman
    Oct 27, 2012 at 3:30 pm
    Dec 29, 2012 at 6:56 pm
  • Hello I did review of pgbench patch http://archives.postgresql.org/pgsql-hackers/2012-09/msg00737.php * this patch is cleanly patched * I had a problem with doc make[1]: Entering directory ...
    Pavel StehulePavel Stehule
    Oct 2, 2012 at 6:09 pm
    Dec 18, 2012 at 12:08 pm
  • I don't see Sébastien's message, but I made the same mistake in my patch. Another one is attached with copyfuncs and equalfuncs. I did a grep for DeallocateStmt and I don't believe I have missed ...
    Vik ReykjaVik Reykja
    Oct 9, 2012 at 2:44 pm
    Dec 6, 2012 at 2:21 pm
Oct 2012
123
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions136
posts1,580
users137
websitepostgresql.org...
irc#postgresql

137 users for October 2012

Tom Lane: 208 posts Simon Riggs: 91 posts Alvaro Herrera: 88 posts Andres Freund: 77 posts Robert Haas: 76 posts Amit Kapila: 61 posts Peter Geoghegan: 49 posts Bruce Momjian: 47 posts Joshua Berkus: 47 posts Andrew Dunstan: 41 posts Pavel Stehule: 39 posts Heikki Linnakangas: 33 posts Peter Eisentraut: 31 posts Daniel Farina: 27 posts Stephen Frost: 25 posts Dimitri Fontaine: 22 posts Greg Stark: 22 posts Noah Misch: 22 posts Fujii Masao: 21 posts Hannu Krosing: 21 posts
show more
Archives