FAQ

Search Discussions

155 discussions - 2,173 posts

  • Can we please change the comment lines below the patch heading to have the real name instead of the postgresql.org ID? Patch by Pavel Stehule Patch by Gurjeet Singh instead of Patch by okbobcz Patch ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 9:38 pm
    Oct 1, 2010 at 6:06 pm
  • Hello The attached patch contains a implementation of "subscripts" function. The functionality of this function is same like generate_subscripts function, but it's based for iteration from plpgsql's ...
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 7:29 pm
    Sep 30, 2010 at 7:29 pm
  • Jayant Kumar did some benchmarking of InnoDB vs. PostgreSQL and PG came out 5 times faster. The benchmark isn't very thoroughly described, but it turns out not to matter. ...
    Robert HaasRobert Haas
    Sep 30, 2010 at 7:26 pm
    Oct 27, 2010 at 1:07 am
  • Hello this patch implement a new iteration construct - iteration over an array. The sense of this new iteration is: * a simple and cleaner syntax * a faster execution - this bring down a number of ...
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 12:46 pm
    Nov 24, 2010 at 6:07 pm
  • Hello This patch add iteration over array to plpgsql now is supported only iteration over scalar array Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 8:03 am
    Sep 30, 2010 at 8:55 am
  • Reference: https://commitfest.postgresql.org/action/patch_view?id=312 The patch from http://archives.postgresql.org/message-id/CA2E4C4762EAE28D68404E75@amenophis does not apply cleanly to the current ...
    Andrew GeeryAndrew Geery
    Sep 30, 2010 at 3:05 am
    Jun 29, 2011 at 10:42 pm
  • Attached is a patch that implements replacing a primary key with another index. This would help overcome the limitation that primary keys cannot be reindexed without taking exclusive locks. The use ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 12:43 am
    Sep 30, 2010 at 8:33 pm
  • Hi, Is there any reason the postmaster.pid and external_pid_file contents to be different? -- Euler Taveira de Oliveira http://www.timbira.com/
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Sep 30, 2010 at 12:18 am
    Oct 19, 2010 at 3:09 am
  • Hello What is the way to get tupledesc from array of records? Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 29, 2010 at 7:23 pm
    Sep 29, 2010 at 7:23 pm
  • Hackers, Any tips / conventional wisdom regarding running postgres on large- ish memory ccNUMA intel machines, such as a 32G dual-quad-core, showing two NUMA nodes of 16G each? I expect each postgres ...
    James RobinsonJames Robinson
    Sep 29, 2010 at 7:15 pm
    Oct 1, 2010 at 1:32 am
  • Hi, Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte ...
    Tatsuo IshiiTatsuo Ishii
    Sep 29, 2010 at 2:23 pm
    Sep 30, 2010 at 6:11 am
  • Does the git.postgresql.org down? Harada-san being also unreachable now. -- KaiGai Kohei <kaigai@kaigai.gr.jp
    KaiGai KoheiKaiGai Kohei
    Sep 29, 2010 at 11:44 am
    Sep 29, 2010 at 12:09 pm
  • When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is it an unavoidable restriction? ...
    Itagaki TakahiroItagaki Takahiro
    Sep 29, 2010 at 7:56 am
    Sep 29, 2010 at 3:25 pm
  • So we've got two patches that implement synchronous replication, and no agreement on which one, if either, should be committed. We have no agreement on how synchronous replication should be ...
    Robert HaasRobert Haas
    Sep 29, 2010 at 2:47 am
    Oct 14, 2010 at 10:28 pm
  • I see this in 9.0 Release note: - Support locale-specific regular expression processing with UTF-8 server encoding (Tom Lane) Locale-specific regular expression functionality includes ...
    Sergey BurladyanSergey Burladyan
    Sep 28, 2010 at 9:35 pm
    Sep 28, 2010 at 10:37 pm
  • Folks, We're almost half way through the commitfest, and so I'll start with: The Good: - Most patches still in play have a reviewer. - It's possible for one person to post 5 reviews in a day. Robert ...
    David FetterDavid Fetter
    Sep 28, 2010 at 9:03 pm
    Sep 29, 2010 at 2:16 am
  • It would crash if input is of unrecognized format. Probably than there's going to be more problems to be concerned with, but just in case, don't crash in -- GJ
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Sep 28, 2010 at 1:31 pm
    Sep 28, 2010 at 3:28 pm
  • Hello I looked on some constructs that helps with iteration over array in plpgsql. I propose a following syntax: FOR var IN [array variable | array expression] LOOP .. END LOOP var - declared ...
    Pavel StehulePavel Stehule
    Sep 28, 2010 at 6:25 am
    Sep 29, 2010 at 5:20 am
  • Hi all, I'm interested in this parallel project, http://wiki.postgresql.org/wiki/Parallel_Query_Execution But I can't find any discussion and current progress in the website, it seems to stop for ...
    Li JieLi Jie
    Sep 28, 2010 at 5:24 am
    Sep 28, 2010 at 11:17 am
  • I've been looking at the bug reported by Kirill Simonov here: http://archives.postgresql.org/pgsql-bugs/2010-09/msg00265.php This is pretty ugly :-(. What we have is select * from A left join (select ...
    Tom LaneTom Lane
    Sep 27, 2010 at 5:15 pm
    Sep 28, 2010 at 1:27 am
  • Dear all, Environement: - OS : Ubuntu 10.04 LTS. - DB: postgresql 8.4. - Connection to postgresql using sslmode = disable Scenario : 1. I use pgadmin to connect/disconnect to the postgresql server on ...
    Guillaume Du PasquierGuillaume Du Pasquier
    Sep 27, 2010 at 3:56 pm
    Sep 27, 2010 at 5:49 pm
  • After some back-and-forth among core and -packagers, we've agreed that we're overdue for update releases for the back branches. Accordingly, we'll be wrapping update tarballs of all active branches ...
    Tom LaneTom Lane
    Sep 27, 2010 at 2:39 pm
    Sep 27, 2010 at 2:39 pm
  • In about a week I propose to have the buildfarm server start to reject results based on snapshots where the newest file is older than the time of the git migration a week ago. That means buildfarm ...
    Andrew DunstanAndrew Dunstan
    Sep 27, 2010 at 12:13 pm
    Oct 15, 2010 at 9:32 pm
  • As has been previously mentioned a couple of times, it should be perfectly possible to use streaming replication to get around the limitations of archive_command/archive_timeout to do log archiving ...
    Magnus HaganderMagnus Hagander
    Sep 27, 2010 at 12:09 pm
    Oct 1, 2010 at 11:01 am
  • Attached is a small patch that adds a few comments for the settings that require restart. Applicable for 9.0+. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer ...
    Devrim GündüzDevrim Gündüz
    Sep 27, 2010 at 8:58 am
    Oct 14, 2010 at 5:18 pm
  • If I have this sql composite type: CREATE TYPE d_type AS ( i integer, e integer, id integer ); and this table: CREATE TABLE my_tab ( d_col d_type NOT NULL ) CREATE INDEX my_tab_d_col_gist ON my_tab ...
    Marios VodasMarios Vodas
    Sep 27, 2010 at 8:27 am
    Sep 27, 2010 at 3:52 pm
  • All, While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables. By "no good way" I mean "no way which does not involve ...
    Josh BerkusJosh Berkus
    Sep 27, 2010 at 5:19 am
    Feb 26, 2011 at 5:49 pm
  • Attached is the patch that tries to speedup prep_buildtree script, which is used in VPATH builds, from our configure script. The idea is to ask `find` to emit directory listing in depth-first order ...
    Gurjeet SinghGurjeet Singh
    Sep 27, 2010 at 2:16 am
    Nov 21, 2010 at 5:31 pm
  • Hi, I noticed that there's no way to specify the location of recovery.conf in postgresql.conf. The pg_hba and pg_ident files can be altered, so I'm wondering why this file can't have a specified ...
    Thom BrownThom Brown
    Sep 26, 2010 at 9:57 pm
    Oct 3, 2010 at 10:38 am
  • Is it posible? Either by using heap_form_tuple or BuildTupleFromCStrings. CREATE TYPE p_type AS ( x double precision, y double precision ); CREATE TYPE d_type AS ( i p_type, e p_type, id integer ); ...
    Marios VodasMarios Vodas
    Sep 26, 2010 at 8:20 pm
    Sep 27, 2010 at 2:11 pm
  • Seems like it's probably a good idea, but I wanted to double-check that no one has a different thought. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
    Robert HaasRobert Haas
    Sep 26, 2010 at 6:26 pm
    Sep 27, 2010 at 8:06 am
  • Uhm, could you stop massively changing the behavior of this script with no discussion at all? I happen to think that this is a distinctly bad idea. It defeats one of the major use cases of the ...
    Robert HaasRobert Haas
    Sep 26, 2010 at 3:48 pm
    Oct 14, 2010 at 9:43 am
  • I have these types: CREATE TYPE p_type AS ( x double precision, y double precision ); CREATE TYPE d_type AS ( i p_type, e p_type, id integer ); CREATE OR REPLACE FUNCTION d_swap(d_type) RETURNS ...
    Marios VodasMarios Vodas
    Sep 26, 2010 at 3:35 pm
    Sep 26, 2010 at 6:36 pm
  • Hello, just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to PostgreSQL 9.0 64bit on the same system. I am working along http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html ...
    Massa, Harald ArminMassa, Harald Armin
    Sep 26, 2010 at 9:42 am
    Sep 29, 2010 at 6:27 pm
  • Hi all. My name is Jose Arthur and I use PostgreSQL for a while, but never contributed to the main project, until now. Since nobody else take this patch to review in this commitfest, I'm going to try ...
    José Arthur Benetasso VillanovaJosé Arthur Benetasso Villanova
    Sep 25, 2010 at 10:55 pm
    Sep 27, 2010 at 1:43 pm
  • I'm not subscribed to pgsql-committers, but apparently under the new git-enabled setup, I'm getting a "Stalled post to pgsql-committers" message for every commit. Fix that please.
    Peter EisentrautPeter Eisentraut
    Sep 25, 2010 at 4:43 pm
    Sep 29, 2010 at 7:16 pm
  • Hello I have problems defining user-defined types and functions in PostgreSQL using a Visual C++ development environment. In order to look for the solution I took the complex.c and complex.source ...
    Esteban ZimanyiEsteban Zimanyi
    Sep 25, 2010 at 3:56 pm
    Sep 28, 2010 at 11:52 pm
  • Hi, It looks like your transition to git has been a success. Your very careful conversion from CVS to git and your exacting scrutiny of the results are a great check that cvs2git is not doing ...
    Michael HaggertyMichael Haggerty
    Sep 25, 2010 at 12:28 pm
    Sep 26, 2010 at 7:01 pm
  • If it resembles cvs2cl then why not name it git2cl? Or git_changelog. Since it doesn't do anything specific to Postgres' git, lets not have any pg in there. Regards, -- gurjeet.singh @ EnterpriseDB - ...
    Gurjeet SinghGurjeet Singh
    Sep 24, 2010 at 10:53 pm
    Sep 25, 2010 at 3:11 am
  • There are some minor stylistic issues with this patch - e.g. lines ending in whitespace, cuddled elses - but those don't look too terribly difficult to fix. I'm more concerned about the fact that I ...
    Robert HaasRobert Haas
    Sep 24, 2010 at 8:01 pm
    Oct 13, 2010 at 4:31 pm
  • Doing "git log tags/REL8_3_6" I see two commits after the one labeled "tag for 8.3.6". The other tags I checked all seem to match what I would expect. I'm not suggesting that anything be done, I just ...
    Jeff DavisJeff Davis
    Sep 24, 2010 at 6:36 pm
    Sep 24, 2010 at 7:06 pm
  • Some voter in Sweden has an interesting sense of humour.... http://alicebobandmallory.com/articles/2010/09/23/did-little-bobby-tables-migrate-to-sweden -- greg
    Greg StarkGreg Stark
    Sep 24, 2010 at 4:18 pm
    Sep 24, 2010 at 4:54 pm
  • I took a quick look at the code, and from what I can tell this is because PQconnectionNeedsPassword() always returns false if a pgpass.conf has been used. There is no handling the case where pgpass ...
    Magnus HaganderMagnus Hagander
    Sep 24, 2010 at 1:23 pm
    Nov 27, 2010 at 4:10 pm
  • Hey all, Here is simple test case of LOB usage, please, note the comments: #include <libpq-fe.h #include <libpq/libpq-fs.h int main(int argc, char* argv[]) { PGconn* c = PQconnectdb("password=test"); ...
    Dmitriy IgrishinDmitriy Igrishin
    Sep 24, 2010 at 1:13 pm
    Sep 27, 2010 at 10:17 pm
  • I have just come across a weird thing. It works for any table and seems to be not documented. SELECT c.name FROM (VALUES(1, 'A', true)) c; SELECT c.name FROM pg_class c; And it does not work in these ...
    Vlad ArkhipovVlad Arkhipov
    Sep 24, 2010 at 10:28 am
    Sep 24, 2010 at 4:17 pm
  • At the moment, to enable logging, a service restart is required. Is there any way to remove this requirement or is there a fundamental reason why it must always be like that? -- Thom Brown Twitter: ...
    Thom BrownThom Brown
    Sep 24, 2010 at 8:34 am
    Sep 24, 2010 at 4:01 pm
  • ... other than it just got forgotten? dolszewski=# create view meh as select * from pg_tables; CREATE VIEW dolszewski=# copy meh to stdout; ERROR: cannot copy from view "meh" HINT: Try the COPY ...
    Josh BerkusJosh Berkus
    Sep 23, 2010 at 8:52 pm
    Sep 23, 2010 at 9:00 pm
  • So my first attempt at using git cherry-pick didn't go so well. The commit in master looks like commit ee63981c1fe26299162b9c7f1218d7e3ef802409 Author: Tom Lane <tgl@sss.pgh.pa.us Date: Thu Sep 23 ...
    Tom LaneTom Lane
    Sep 23, 2010 at 7:52 pm
    Sep 24, 2010 at 3:23 pm
  • Dear All, I have just generate a new patch of MERGE command. One main change in this edition is the removal of RASIE ERROR action from MEREG, because its semantics is not well defined yet. I also ...
    Boxuan ZhaiBoxuan Zhai
    Sep 23, 2010 at 10:31 am
    Nov 12, 2010 at 6:05 pm
  • It's not hard to tell if we're missing a file that ought to be listed in .gitignore --- git status will find that problem soon enough. However, it seems that git isn't so willing to tell you about ...
    Tom LaneTom Lane
    Sep 23, 2010 at 12:54 am
    Sep 24, 2010 at 4:26 pm
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions155
posts2,173
users126
websitepostgresql.org...
irc#postgresql

126 users for September 2010

Tom Lane: 367 posts Robert Haas: 332 posts Heikki Linnakangas: 120 posts Magnus Hagander: 114 posts Pavel Stehule: 77 posts Simon Riggs: 74 posts Kevin Grittner: 73 posts Fujii Masao: 61 posts Bruce Momjian: 58 posts Andrew Dunstan: 54 posts Peter Eisentraut: 53 posts Itagaki Takahiro: 51 posts Alvaro Herrera: 49 posts Markus Wanner: 42 posts David Fetter: 36 posts Dimitri Fontaine: 33 posts Thom Brown: 31 posts Josh Berkus: 25 posts Dave Page: 24 posts David E. Wheeler: 23 posts
show more
Archives