FAQ

Search Discussions

139 discussions - 1,612 posts

  • The biggest turn off that most people experience when using PostgreSQL is that psql does not support memorable commands. I would like to implement the following commands as SQL, allowing them to be ...
    Simon RiggsSimon Riggs
    Jul 15, 2010 at 3:00 pm
    Sep 21, 2010 at 11:55 am
  • http://www.sigaev.ru/misc/builtin_knngist_core-0.8.gz http://www.sigaev.ru/misc/builtin_knngist_itself-0.8.gz http://www.sigaev.ru/misc/builtin_knngist_proc-0.8.gz ...
    Teodor SigaevTeodor Sigaev
    Jul 22, 2010 at 3:31 pm
    Mar 3, 2011 at 10:55 am
  • The attached patch is a part of efforts to support security label on database objects. It adds statement support to manage security label of relations. Right now, object labeling except for ...
    KaiGai KoheiKaiGai Kohei
    Jul 14, 2010 at 5:34 am
    Oct 13, 2010 at 3:59 am
  • I think we pretty much have conceptual agreement on the shape of the solution to this problem: when a view is created with CREATE SECURITY VIEW, restrict functions and operators that might disclose ...
    Robert HaasRobert Haas
    Jul 8, 2010 at 1:08 pm
    Oct 20, 2010 at 2:50 pm
  • Hi, for quite some time, I've been under the impression, that there's still one disadvantage left from using processes instead of threads: we can only use statically sized chunks of shared memory. ...
    Markus WannerMarkus Wanner
    Jul 2, 2010 at 11:49 pm
    Aug 10, 2010 at 1:29 am
  • Hi, here's a review of the \sf and \ef [num] patch from http://archives.postgresql.org/message-id/162867791003290927y3ca44051p80e697bc6b19de29@mail.gmail.com == Formatting == The patch has some small ...
    Jan UrbańskiJan Urbański
    Jul 16, 2010 at 2:26 pm
    Aug 14, 2010 at 2:09 pm
  • This patch turns the existing autovacuum launcher into an always running process, partly called the coordinator. If autovacuum is disabled, the coordinator process still gets started and keeps ...
    Markus WannerMarkus Wanner
    Jul 13, 2010 at 2:31 pm
    Sep 27, 2010 at 8:01 am
  • Hi, The attached patch provides core of synchronous replication feature based on streaming replication. I added this patch into CF 2010-07. The code is also available in my git repository: ...
    Fujii MasaoFujii Masao
    Jul 14, 2010 at 6:50 am
    Aug 16, 2010 at 12:50 pm
  • Hi all. I'm wondering about PGSQL scalability. In particular I have two main topics in my mind: 1. What'd be the behavior of the query planner in the case I have a single huge table with hundreds or ...
    Vincenzo RomanoVincenzo Romano
    Jul 29, 2010 at 5:09 pm
    Oct 8, 2010 at 4:10 pm
  • EnterpriseDB asked me to develop the attached patch to reduce the on-disk size of numeric and to submit it for inclusion in PG 9.1. After searching the archives, I found a possible design for this by ...
    Robert HaasRobert Haas
    Jul 9, 2010 at 2:58 pm
    Aug 4, 2010 at 5:35 pm
  • Hi, From the code I understood that when executing a query "normally", in READ COMMITTED mode, we take a new snapshot for every query that comes out of rewrite. But in an EXPLAIN ANALYZE, we only ...
    Marko TiikkajaMarko Tiikkaja
    Jul 22, 2010 at 5:43 pm
    Feb 17, 2011 at 8:17 pm
  • This is a work-in-progress patch of my GSoC project: Add JSON datatype to PostgreSQL. It provides the following: * JSON datatype: A TEXT-like datatype for holding JSON-formatted text. Although the ...
    Joseph AdamsJoseph Adams
    Jul 23, 2010 at 6:19 am
    Sep 19, 2010 at 9:11 am
  • Dear All, This is ZHAI BOXUAN, a student of gSoC 2010. My project is to add merge command in postgres. This is the first submission of our codes, which has finished the parser, analyzer and rewriter ...
    Boxuan ZhaiBoxuan Zhai
    Jul 10, 2010 at 2:26 am
    Jul 17, 2010 at 12:31 pm
  • I reported a problem here: http://archives.postgresql.org/pgsql-bugs/2010-07/msg00173.php Perhaps I used a poor subject line, but I believe it's a serious issue. That reproducible sequence seems like ...
    Jeff DavisJeff Davis
    Jul 27, 2010 at 6:12 pm
    Jul 29, 2010 at 4:17 pm
  • Hi, I'm reviewing "Multibyte charater set in levenshtein function" patch. https://commitfest.postgresql.org/action/patch_view?id=304 The main logic seems to be good, but I have some comments about ...
    Itagaki TakahiroItagaki Takahiro
    Jul 12, 2010 at 4:46 am
    Sep 2, 2010 at 2:58 am
  • Hello I looked on patch https://commitfest.postgresql.org/action/patch_view?id=334 .This patch moves function xml_is_well_formed from contrib xm2 to core. * Is the patch in context diff format? yes * ...
    Pavel StehulePavel Stehule
    Jul 29, 2010 at 1:22 pm
    Aug 13, 2010 at 6:43 pm
  • At the developer meeting, I promised to do the work of documenting how committers should use git. So here's a first version. http://wiki.postgresql.org/wiki/Committing_with_Git Note that while anyone ...
    Robert HaasRobert Haas
    Jul 21, 2010 at 4:22 pm
    Aug 5, 2010 at 9:43 am
  • I have some concerns related to the upcoming conversion to git and how we're going to avoid having things get messy as people start using the new repository. git has a lot more flexibility and power ...
    Robert HaasRobert Haas
    Jul 20, 2010 at 6:34 pm
    Jul 24, 2010 at 7:24 pm
  • Hi, We ran into a problem on 9.0beta3 with check constraints using table inheritance in a multi-level hierarchy with multiple inheritance. A test script is provided below and a proposed patch is ...
    Henk EntingHenk Enting
    Jul 29, 2010 at 11:04 am
    Aug 3, 2010 at 7:04 pm
  • We had a report of the above error from a pgAdmin user testing 1.12.0b3 with PG 9.0b3. The (highly simplified) query below works fine as a superuser: SELECT pg_get_expr(proargdefaults, ...
    Dave PageDave Page
    Jul 13, 2010 at 3:32 pm
    Aug 9, 2010 at 4:38 pm
  • Hi, I have get a edition that the merge command can run. It accept the standard merge command and can do UPDATE, INSERT and DELETE actions now. But we cannot put additional qualification for actions. ...
    Boxuan ZhaiBoxuan Zhai
    Jul 27, 2010 at 5:04 am
    Aug 4, 2010 at 3:26 pm
  • Kris JurkaKris Jurka
    Jul 22, 2010 at 9:34 pm
    Sep 18, 2010 at 8:16 pm
  • The loadable module doesn't "gain control" here it simplify kicks-in after, and in addition to, normal checking. That just means you have the option of failing for additional reasons. We're not ...
    Simon RiggsSimon Riggs
    Jul 9, 2010 at 2:51 pm
    Jul 12, 2010 at 6:46 am
  • Hi All, Every identifier is downcase & truncated by function "downcase_truncate_identifier()" before using it. But since the function "downcase_truncate_identifier()" is not multibyte-charecter ...
    Rajanikant ChirmadeRajanikant Chirmade
    Jul 7, 2010 at 4:35 am
    Nov 23, 2010 at 7:28 pm
  • Hi, I've been working on modularizing Postgres-R to ease review and maybe allow code reuse. As threatened at the Cluster Meeting in Tokyo and again at CHAR(10), I'm now presenting more results of ...
    Markus WannerMarkus Wanner
    Jul 13, 2010 at 2:31 pm
    Jul 26, 2010 at 11:50 am
  • *i wrote to pgsql-bugs@postgresql.org they tell me write to pgsql-performance@postgresql.org they tell me write here* *I don`t whant know how optimize query myself (i know it), and i think it must do ...
    ZotovZotov
    Jul 20, 2010 at 5:57 am
    Jul 28, 2010 at 2:35 pm
  • In the previous discussions of how to migrate from cvs to git, we've all agreed we should kill the keyword expansion that we have now. I don't think, however, that we ever decided what to do with the ...
    Magnus HaganderMagnus Hagander
    Jul 7, 2010 at 9:01 am
    Jul 15, 2010 at 6:04 pm
  • With logging_collector enabled, all the postgres log files are created with mode 0600. This makes life complicated if users other than "postgres" need to be able to examine the log files as well. ...
    Martin PihlakMartin Pihlak
    Jul 1, 2010 at 4:13 pm
    Jul 16, 2010 at 10:35 pm
  • hello everybody, we are currently facing some serious issues with cross correlation issue. consider: 10% of all people have breast cancer. we have 2 genders (50:50). if i select all the men with ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Jul 14, 2010 at 10:13 am
    Jul 15, 2010 at 2:14 pm
  • Hello I enhanced DO statement syntax to allowing a parameters. Syntax is relative simple: do ([varname] vartype := value, ...) $$ ... $$ It allows to pass a content of psql variables to inline code ...
    Pavel StehulePavel Stehule
    Jul 4, 2010 at 6:42 am
    Jul 5, 2010 at 3:32 am
  • Tom and, I believe, also Andrew have expressed some concerns about the space that will be taken up by having multiple copies of the git repository on their systems. While most users can probably get ...
    Robert HaasRobert Haas
    Jul 20, 2010 at 5:04 pm
    Jul 22, 2010 at 9:34 am
  • Here is a proof of concept for per-column collation support. Here is how it works: When creating a table, an optional COLLATE clause can specify a collation name, which is stored (by OID) in ...
    Peter EisentrautPeter Eisentraut
    Jul 13, 2010 at 6:25 pm
    Aug 18, 2010 at 5:56 pm
  • /me bangs gavel I hereby declare the 2010-07 CommitFest closed to further patch submissions, as it is now officially "In Progress". We have one month to provide initial review of the patches which ...
    Kevin GrittnerKevin Grittner
    Jul 15, 2010 at 2:44 pm
    Sep 13, 2010 at 12:00 pm
  • Here's a status update on the git conversion, as well as a call for some help mainly in testing. After testing a bunch of tools, I've found that using cvs2git is by far the best option when keeping ...
    Magnus HaganderMagnus Hagander
    Jul 21, 2010 at 8:40 pm
    Aug 31, 2010 at 11:21 am
  • In src/include/mb/pg_wchar.h , there is a function unicode_to_utf8 , but no corresponding utf8_to_unicode . However, there is a static function called utf2ucs that does what utf8_to_unicode would do. ...
    Joseph AdamsJoseph Adams
    Jul 25, 2010 at 2:35 am
    Aug 18, 2010 at 7:55 pm
  • Hi, I've been working on writeable CTEs during the last couple of months, but right now it looks like I'm going to miss the first commit fest for 9.1. I was trying to make it work by expanding all ...
    Marko TiikkajaMarko Tiikkaja
    Jul 12, 2010 at 6:14 pm
    Aug 15, 2010 at 11:37 am
  • I've been poking at the FTS problem example recently submitted by Artur Dabrowski. It contains an index declared like so: CREATE INDEX idx_keywords_ger ON search_tab USING gin ...
    Tom LaneTom Lane
    Jul 31, 2010 at 3:53 am
    Aug 1, 2010 at 8:03 pm
  • Should we do this? Patch attached. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
    Robert HaasRobert Haas
    Jul 14, 2010 at 2:48 pm
    Jul 20, 2010 at 7:34 pm
  • Hi, I've been reviewing this patch for the last few days. Here it is : * Submission review * Is the patch in context diff format? Yes * Does it apply cleanly to the current CVS HEAD? Yes * Does it ...
    Marc CousinMarc Cousin
    Jul 20, 2010 at 11:47 am
    Aug 2, 2010 at 8:11 pm
  • I think we should consider postponing beta4. I count eleven non-documentation, 9.0-specific bug fix on REL9_0_STABLE, but there are currently five items on the open 9.0 issues list, at least one of ...
    Robert HaasRobert Haas
    Jul 27, 2010 at 6:04 pm
    Jul 28, 2010 at 11:36 pm
  • In the following scenario, we can see orphan comments. session.1 session.2 ---------------------- ---------------------- 1: CREATE TYPE my_typ AS (a int, b text); 2: BEGIN; 3: COMMENT ON TYPE my_typ ...
    KaiGai KoheiKaiGai Kohei
    Jul 6, 2010 at 7:23 am
    Jul 9, 2010 at 11:49 am
  • Is there a reason we don't have t_self as one of the system columns that you can examine from SQL? I'd propose its addition otherwise.
    Alvaro HerreraAlvaro Herrera
    Jul 5, 2010 at 5:41 pm
    Jul 7, 2010 at 8:44 pm
  • AIUI, this is the plan we decided on. So: - Someone (presumably Bruce) needs to run pgindent. Any reason to wait any longer on that? - Someone will need to branch the tree after the wrap and stamp it ...
    Robert HaasRobert Haas
    Jul 5, 2010 at 2:48 pm
    Jul 6, 2010 at 7:28 pm
  • Patch implements much more accuracy estimation of cost for GIN index scan than generic cost estimation function. Basic idea is described on PGCon-2010: ...
    Teodor SigaevTeodor Sigaev
    Jul 2, 2010 at 12:33 pm
    Oct 18, 2010 at 12:57 am
  • Hello I am working on to_array, to_string functions and I am looking on string_to_array function. I am surprised so this function is marked as immutable postgres=# select ...
    Pavel StehulePavel Stehule
    Jul 20, 2010 at 9:31 am
    Jul 29, 2010 at 5:20 pm
  • Quoting "wiki.postgresql.org/wiki/Alter_column_position<http://wiki.postgresql.org/wiki/Alter_column_position " : "The idea of allowing re-ordering of column position is not one the postgresql ...
    NilsonNilson
    Jul 27, 2010 at 9:32 pm
    Jul 28, 2010 at 4:34 pm
  • We need to decide what email addresses committers will use on the new git repository when they commit. Although I think we have more votes (at least from committers) for always having author == ...
    Robert HaasRobert Haas
    Jul 21, 2010 at 4:54 pm
    Jul 27, 2010 at 7:17 pm
  • Using as a starting point the old bitmap patch in: http://archives.postgresql.org/message-id/20081101000154.GO27872@fune I re-applied and re-worked the patch to see what kind of improvements over ...
    Leonardo FLeonardo F
    Jul 1, 2010 at 1:23 pm
    Jul 22, 2010 at 3:56 pm
  • (1) Exclusion constraints support for operators where "x <operator x" is false (tiny patch) https://commitfest.postgresql.org/action/patch_view?id=307 (2) btree_gist support for searching on < ("not ...
    Itagaki TakahiroItagaki Takahiro
    Jul 12, 2010 at 8:17 am
    Aug 3, 2010 at 7:53 pm
  • Working on the git conversion with keywords, and I've noticed a couple of strange things that don't come up the same way in git. All of these are in non-code files, but they do defeat the "identical ...
    Magnus HaganderMagnus Hagander
    Jul 20, 2010 at 1:12 pm
    Jul 20, 2010 at 7:19 pm
Group Navigation
period‹ prev | Jul 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions139
posts1,612
users132
websitepostgresql.org...
irc#postgresql

132 users for July 2010

Robert Haas: 329 posts Tom Lane: 176 posts Pavel Stehule: 76 posts Simon Riggs: 59 posts Kevin Grittner: 58 posts Peter Eisentraut: 54 posts Andrew Dunstan: 43 posts Bruce Momjian: 40 posts Fujii Masao: 37 posts Magnus Hagander: 34 posts Markus Wanner: 32 posts Alvaro Herrera: 30 posts KaiGai Kohei: 30 posts Joshua D. Drake: 26 posts Yeb Havinga: 26 posts Dimitri Fontaine: 25 posts Takahiro Itagaki: 24 posts Stephen Frost: 22 posts David Fetter: 20 posts Andres Freund: 19 posts
show more
Archives