FAQ

PostgreSQL > pgsql-hackers > March 2010

Search Discussions

142 discussions - 1,314 posts

  • Hello this patch contains a string formatting function "format" postgres=# select format('some message: % (current user: %)', current_date, current_user); format ...
    Pavel StehulePavel Stehule
    Mar 9, 2010 at 2:31 pm
    Feb 17, 2011 at 5:37 pm
  • I've now for the second time found myself wanting to specify an explicit psqlrc file instead of just parsing ~/.psqlrc, so attached is a patch that accepts the PSQLRC environment variable to control ...
    Magnus HaganderMagnus Hagander
    Mar 4, 2010 at 10:00 pm
    Feb 17, 2011 at 4:14 am
  • All, We've got two locations and some individuals signed up for a test-fest this weekend. Would it be possible to do an alpha release this week? It would really help to be testing later code than ...
    Josh BerkusJosh Berkus
    Mar 28, 2010 at 8:40 pm
    Apr 6, 2010 at 6:54 am
  • I introduced myself in the thread "Proposal: access control jails (and introduction as aspiring GSoC student)", and we discussed jails and session-local variables. But, as Robert Haas suggested, ...
    Joseph AdamsJoseph Adams
    Mar 28, 2010 at 8:48 pm
    Apr 7, 2010 at 12:05 am
  • Dear friends, As a reminder, I took part in the development of pgAdmin and I am not looking for a flame war. I would like to point out Drupal community efforts (including myself) to write down the ...
    François PérouFrançois Pérou
    Mar 5, 2010 at 1:56 pm
    Mar 8, 2010 at 9:17 pm
  • I have completed the 9.0 release notes: http://developer.postgresql.org/pgdocs/postgres/release-9-0.html I kept the 9.0-alpha release notes in the SGML because people might want to compare them with ...
    Bruce MomjianBruce Momjian
    Mar 20, 2010 at 4:02 am
    Apr 5, 2010 at 4:15 am
  • One awkward omission in the new built-in standby mode, mainly used for streaming replication, is that there is no easy way to delete old archived files like you do with the %r parameter to ...
    Heikki LinnakangasHeikki Linnakangas
    Mar 17, 2010 at 9:37 am
    Jun 14, 2010 at 12:37 pm
  • How can a pl/pgsql trigger change the values of dynamic fields in NEW record ? By "dynamic" I mean that the field name is a variable in the trigger context. I've been told it's easy to do with ...
    StrkStrk
    Mar 9, 2010 at 5:32 pm
    Mar 17, 2010 at 1:12 pm
  • Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many on the main 9.0 open ...
    Bruce MomjianBruce Momjian
    Mar 13, 2010 at 3:28 am
    Mar 19, 2010 at 11:16 am
  • Hi, http://archives.postgresql.org/pgsql-hackers/2010-01/msg01672.php On win32, the blocking libpq functions like PQconnectdb() and PQexec() are uninterruptible since they use the vanilla select() ...
    Fujii MasaoFujii Masao
    Mar 10, 2010 at 9:10 am
    Apr 19, 2010 at 2:17 pm
  • We have planner method parameters for many important parts of the planner. We don't have any parameter for join removal, AFAIK. The first question I get asked is "can I see the tables it removed?". ...
    Simon RiggsSimon Riggs
    Mar 29, 2010 at 8:34 am
    Mar 29, 2010 at 9:57 pm
  • Hello, I'm Joey Adams, and I'm interested in applying for Google Summer of Code to work on PostgreSQL. I'm a former GSoC student (I worked on CCAN last year), and a strong C programmer, though I am ...
    Joseph AdamsJoseph Adams
    Mar 22, 2010 at 4:36 am
    Mar 27, 2010 at 7:31 pm
  • A few days ago there was a thread on one of our lists where someone was suprised it took as much i/o to delete data as it took to insert it in the first place. At first this does seem surprising but ...
    Greg StarkGreg Stark
    Mar 16, 2010 at 3:29 pm
    Mar 22, 2010 at 9:57 pm
  • Exclusion constraints are good. There's a few annoyances around them, that are minor but feel should be addressed for 9.0. * Exclusion indexes are created with the suffix "_exclusion". That's a very ...
    Simon RiggsSimon Riggs
    Mar 22, 2010 at 1:40 pm
    Jun 3, 2010 at 1:47 am
  • Hi, I have some questions about 9.0 release note. I'd like to work for some of them if required. Comments welcome. * Allow per-tablespace sequential and random page cost variables ...
    Takahiro ItagakiTakahiro Itagaki
    Mar 30, 2010 at 5:37 am
    Apr 6, 2010 at 2:17 am
  • I've run across a couple of stumbling blocks when building on Win32 (specifically, XP + MinGW): 1. PostgreSQL's private versions of inet_aton etc. can conflict with similar functions in other ...
    Dag-Erling SmørgravDag-Erling Smørgrav
    Mar 10, 2010 at 2:22 pm
    Mar 12, 2010 at 10:52 am
  • Hello Current form of function detail isn't too practical (see screenshot 1) we can move source code to separate area (maybe we can add rownumbers) see screenshot 2 (it is only mockup, real ...
    Pavel StehulePavel Stehule
    Mar 21, 2010 at 12:03 pm
    Mar 23, 2010 at 7:58 am
  • I just got confused for +10 minutes by an incorrect .pgpass password, so I found new interest in improving this reported behavior. ;-) The attached patch reports the fact that .pgpass was used if the ...
    Bruce MomjianBruce Momjian
    Mar 10, 2010 at 2:52 am
    Mar 13, 2010 at 2:58 pm
  • Hackers, Enclosed is a patch to add a -C option to initdb to allow you to easily append configuration directives to the generated postgresql.conf file for use in programmatic generation. In my case, ...
    David ChristensenDavid Christensen
    Mar 29, 2010 at 5:05 am
    Jul 23, 2010 at 1:52 pm
  • All, Currently, the only way for admin scripts to get individual data items out of pg_controldata (such as the next XID or the catalog version) is via grep and regex. Given that people are going to ...
    Josh BerkusJosh Berkus
    Mar 4, 2010 at 8:52 pm
    Mar 9, 2010 at 3:18 pm
  • I have PostgreSQL 8.4 installed on Windows XP, and am using Visual Studio 2005 to write a C-Language function. I have the most basic hello-world type example (just the 'add_one' function from ...
    Kevin FlanaganKevin Flanagan
    Mar 5, 2010 at 12:30 am
    Mar 9, 2010 at 8:00 am
  • There appears to be some significant misunderstanding of what can be done effectively using the various *_init settings for plperl. In particular, some people have got an expectation that modules ...
    Andrew DunstanAndrew Dunstan
    Mar 3, 2010 at 12:34 am
    Mar 8, 2010 at 8:55 pm
  • I rebased the patch to HEAD. Is the patch still required for 9.0? If not, I'd remove the open item of the smart shutdown during recovery. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE ...
    Fujii MasaoFujii Masao
    Mar 30, 2010 at 9:09 am
    Apr 13, 2010 at 2:16 pm
  • Hi Tom, While setting timezone using SET command (say GMT+3:30), postgres sometimes crashes randomly. After debugging into the code, it is observed that if tzload() call fails in pg_tzset() for ...
    Jeevan ChalkeJeevan Chalke
    Mar 11, 2010 at 10:57 am
    Mar 12, 2010 at 7:49 pm
  • BTW, it looks like the MSVC build scripts don't bother to make sure that USE_LIBXSLT is defined (or not) correctly --- at least I can't see any reference to that symbol in the Windows-specific files. ...
    Tom LaneTom Lane
    Mar 1, 2010 at 7:50 pm
    Mar 4, 2010 at 11:53 am
  • I discovered tonight that if you shut down a server, create recovery.conf with standby_mode = 'on', and start it back up again, you get this: LOG: database system was shut down at 2010-03-30 22:34:09 ...
    Robert HaasRobert Haas
    Mar 31, 2010 at 2:40 am
    Apr 19, 2010 at 9:58 pm
  • Hi, I did some more testing on ecpg and found that allowing variables as cursor names seems to produce more problems than I anticipated. But then maybe it's just some missing checks to throw out ...
    Michael MeskesMichael Meskes
    Mar 29, 2010 at 11:34 am
    Apr 13, 2010 at 4:40 am
  • People have been talking about a parallel version of pg_dump a few times already. I have been working on some proof-of-concept code for this feature every now and then and I am planning to contribute ...
    Joachim WielandJoachim Wieland
    Mar 29, 2010 at 2:47 pm
    Apr 1, 2010 at 1:51 pm
  • I was looking at this recent nonrepeatable buildfarm failure: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=polecat&dt=2010-03-11%2021:45:10 which has several instances of the known "pgstat ...
    Tom LaneTom Lane
    Mar 12, 2010 at 12:04 am
    Mar 12, 2010 at 11:20 pm
  • Has anyone ever noticed that the order of pg_stat_activity timestamp columns is illogical: xact_start | timestamp with time zone | query_start | timestamp with time zone | backend_start | timestamp ...
    Bruce MomjianBruce Momjian
    Mar 17, 2010 at 8:42 pm
    Apr 26, 2010 at 2:23 pm
  • Just noticed a problem popping up sometimes with the new multi-threaded pgbench. This is on a Linux RPM build (the alpha4 set) compiled with '--disable-thread-safety'. Still trying to nail down ...
    Greg SmithGreg Smith
    Mar 15, 2010 at 3:41 pm
    Mar 23, 2010 at 8:37 am
  • Is it an expected behavior? postgres= CREATE SEQUENCE s; CREATE SEQUENCE postgres= ALTER TABLE s RENAME sequence_name TO abcd; ALTER TABLE postgres= CREATE TABLE t (a int primary key, b text); ...
    KaiGai KoheiKaiGai Kohei
    Mar 3, 2010 at 2:20 am
    Mar 13, 2010 at 1:08 am
  • 12

    GSoC

    I have some idea of implementing am image database system, which will let you search against the image and fingerprint: The idea crudely is the following: I want to implement a image database system: ...
    Anindya Jyoti RoyAnindya Jyoti Roy
    Mar 29, 2010 at 8:13 pm
    Mar 31, 2010 at 12:07 am
  • I noticed while doing work with very large arrays that several functions such as array_length detoast the entire array instead of only what is required. I found the solution to be just unpacking the ...
    Mike LewisMike Lewis
    Mar 31, 2010 at 7:40 am
    Aug 5, 2010 at 6:06 pm
  • After snapshotting my master using hot backup to create a workable slave instance, I created recovery.conf on the slave and tried to get it to connect to the master and stream WAL. This led to the ...
    Robert HaasRobert Haas
    Mar 31, 2010 at 3:06 am
    Apr 1, 2010 at 9:21 am
  • Hello I wrote some small patch, that allow preloading of selected ispell dictionary. It solve the problem with slow tsearch initialisation with some language configuration. This patch is most simple ...
    Pavel StehulePavel Stehule
    Mar 19, 2010 at 10:39 am
    Mar 24, 2010 at 2:46 pm
  • LOG: connection authorized: user=foo database=replication Currently, when the primary accepts the connection from the standby, it emits the above message. But "database=replication" is not accurate ...
    Fujii MasaoFujii Masao
    Mar 24, 2010 at 1:52 am
    Mar 24, 2010 at 12:54 pm
  • Hi, With the implementation of deferred unique constraints, we need to go back to the index second time to check whether the unique check is valid. Say a situation occurs like this a) the first ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Mar 23, 2010 at 9:53 am
    Mar 23, 2010 at 7:03 pm
  • Hi, In 2 of 3 pq_setkeepalives* functions we have the #DEFINE involving even this conditional: """ if (port == NULL || IS_AF_UNIX(port- laddr.addr.ss_family)) return STATUS_OK; """ but in ...
    Jaime CasanovaJaime Casanova
    Mar 13, 2010 at 4:48 am
    Mar 13, 2010 at 8:15 pm
  • I encountered a core dump running PL/Perl installcheck with a very recent git HEAD of PostgreSQL and a not quite so recent git HEAD of perl. The cause is a subtle difference between SvTYPE(sv) == ...
    Tim BunceTim Bunce
    Mar 5, 2010 at 3:27 pm
    Mar 10, 2010 at 10:43 pm
  • Well, I can easily make it do what you expect, and I don't see many error returns in that area of the code, so I just wrote a patch that does what you would expect rather than throw an error. test= ...
    Bruce MomjianBruce Momjian
    Mar 3, 2010 at 3:34 am
    Mar 3, 2010 at 10:30 pm
  • Hello all, I'm writing some extension and I have a hot code path that has a lot of double (C type) data and needs to output NUMERIC tuple data. The current methods I can find in the code to convert ...
    Theo SchlossnagleTheo Schlossnagle
    Mar 1, 2010 at 8:24 pm
    Mar 3, 2010 at 8:37 pm
  • It is a bug report in a corner case. When we assign "SECURITY DEFINER" attribute on plpgsql_call_handler(), it makes server process crashed. postgres=# ALTER FUNCTION plpgsql_call_handler() security ...
    KaiGai KoheiKaiGai Kohei
    Mar 19, 2010 at 7:23 am
    Mar 23, 2010 at 1:42 am
  • Since the buildfarm is mostly green these days, I took some time to look into the few remaining consistent failures. One is that gothic_moth and codlin_moth fail on contrib/tsearch2 in the 8.2 ...
    Tom LaneTom Lane
    Mar 10, 2010 at 11:37 pm
    Mar 12, 2010 at 7:40 am
  • I rebased the patch to HEAD. Should I think that the patch has been rejected because it has remained pending for about one month? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION ...
    Fujii MasaoFujii Masao
    Mar 30, 2010 at 9:15 am
    Apr 7, 2010 at 6:13 am
  • Hi, I noticed a problem with the source code of 9.0Alpha 4. In parse_agg.c, there is a call made to transformSortClause. 00098 torder = transformSortClause ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Mar 16, 2010 at 11:50 am
    Mar 17, 2010 at 4:00 pm
  • Hello There are some wrong in our implementation NISortDictionary. After initialisation is ts_cache memory context 55MB long and pg takes 190MB. dispell_init cspell: 1024 total in 1 blocks; 136 free ...
    Pavel StehulePavel Stehule
    Mar 11, 2010 at 3:29 pm
    Mar 11, 2010 at 7:32 pm
  • Dominic, sorry you didn't get any reply to your bug report from October, but it was picked up by Robert Haas in January: http://archives.postgresql.org/pgsql-hackers/2010-01/msg00478.php and is now ...
    Bruce MomjianBruce Momjian
    Mar 7, 2010 at 6:08 pm
    Mar 9, 2010 at 1:16 am
  • This isn't working. The Windows ports are all saying "permission denied" but apparently that's not because errno is set to EPERM. Anyone know how to detect "permission denied" errors from open() on ...
    Greg StarkGreg Stark
    Mar 1, 2010 at 1:26 pm
    Mar 1, 2010 at 6:35 pm
  • in a 9.0devel, primary+standby, cvs from 2010.03.04 01:30 With three patches: new_smart_shutdown_20100201.patch extend_format_of_recovery_info_funcs_v4.20100303.patch ...
    Erik RijkersErik Rijkers
    Mar 4, 2010 at 4:00 pm
    Apr 24, 2010 at 10:39 pm
Mar 2010
123
Group Navigation
period‹ prev | Mar 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions142
posts1,314
users119
websitepostgresql.org...
irc#postgresql

119 users for March 2010

Tom Lane: 207 posts Robert Haas: 121 posts Bruce Momjian: 94 posts Simon Riggs: 63 posts Andrew Dunstan: 59 posts Pavel Stehule: 56 posts Fujii Masao: 54 posts Josh Berkus: 51 posts Heikki Linnakangas: 40 posts Gokulakannan Somasundaram: 30 posts Magnus Hagander: 26 posts Greg Smith: 25 posts Kevin Grittner: 24 posts Peter Eisentraut: 24 posts David Fetter: 23 posts Takahiro Itagaki: 21 posts Alvaro Herrera: 20 posts Greg Stark: 20 posts Jaime Casanova: 16 posts Dimitri Fontaine: 15 posts
show more
Archives