FAQ

Search Discussions

145 discussions - 1,431 posts

  • If there are no objections, I'm going to remove the following items from the list at http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Open_Items finishing posix_fadvise patch Push to TODO change ...
    Tom LaneTom Lane
    Apr 5, 2009 at 1:31 am
    Apr 12, 2009 at 5:56 pm
  • So I started to look at what might be involved in teaching plpgsql about standard_conforming_strings, and was soon dismayed by the sheer epic nature of its failure to act like the core lexer. It was ...
    Tom LaneTom Lane
    Apr 10, 2009 at 9:54 pm
    May 29, 2009 at 6:50 am
  • Hello I was surprised so PostgreSQL doesn't support this basic output format. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Apr 10, 2009 at 4:16 pm
    Aug 11, 2009 at 9:41 am
  • Hello, I am sending small patch, that allows hooking transformation stage of parser. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Apr 11, 2009 at 4:01 pm
    Sep 18, 2009 at 2:44 am
  • Folks, Here's a patch that adds a "Function Type" column to \df while removing the now-redundant \da. Cheers, David. -- David Fetter <david@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: ...
    David FetterDavid Fetter
    Apr 13, 2009 at 7:23 pm
    Mar 3, 2010 at 12:34 am
  • Hello I am thinking about global temp tables. One possible solution is creating global temporary table like normal table and in planner stage check using this table. When some global temporary table ...
    Pavel StehulePavel Stehule
    Apr 27, 2009 at 8:44 pm
    May 13, 2009 at 2:01 am
  • Per previous discussion. http://archives.postgresql.org/message-id/8066.1229106059@sss.pgh.pa.us http://archives.postgresql.org/message-id/603c8f070904021926g92eb55sdfc68141133957c1@mail.gmail.com I ...
    Robert HaasRobert Haas
    Apr 4, 2009 at 4:13 am
    Aug 3, 2009 at 2:18 pm
  • Hi, Following the discussion here http://archives.postgresql.org/message-id/49D9E986.8010604@pse-consulting.de , I wrote a small patch which rotates the last XLog file on shutdown so that the archive ...
    Guillaume SmetGuillaume Smet
    Apr 8, 2009 at 7:11 pm
    May 30, 2009 at 7:37 pm
  • I've got my git clone set up, a copy of GCC 4.4 (and other compilers) at the ready, and am glad to help out on low-level scut work. Anybody need anything done? splint? valgrind? Let me know. xoxo, ...
    Andy LesterAndy Lester
    Apr 29, 2009 at 9:27 pm
    May 2, 2009 at 9:36 am
  • [ oops, forgot to send this to -hackers before ] I think this is about the only sensible option, but my reasoning is somewhat different. My original intuition was that array_to_string and ...
    Sam MasonSam Mason
    Apr 1, 2009 at 2:39 pm
    Apr 7, 2009 at 4:06 pm
  • Whichever way the current discussion about Unicode literals turns out, it's clear that plpgsql is not up to speed on matching the core lexer's behavior --- it's wrong anyway with respect to ...
    Tom LaneTom Lane
    Apr 14, 2009 at 8:37 pm
    Apr 19, 2009 at 5:34 pm
  • The pgsql-admin list has just seen another instance where careless use of prepared transactions brought down a database, and the DBA (who had no idea what a prepared transaction even was) had no idea ...
    Tom LaneTom Lane
    Apr 22, 2009 at 5:48 pm
    May 5, 2009 at 4:03 pm
  • Dear pgsql hackers, The encryption options http://www.postgresql.org/docs/8.3/static/encryption-options.html fall short for my thread case. Consider the case where all users of a machine are trusted ...
    Sam HallidaySam Halliday
    Apr 23, 2009 at 11:43 am
    Apr 28, 2009 at 8:24 am
  • Hi , We are working on a patch<http://archives.postgresql.org/pgsql-hackers/2009-03/msg00897.php to automate partitioning in PostgreSQL. For Range partitions, we have proposed the syntax which is as ...
    Kedar PotdarKedar Potdar
    Apr 21, 2009 at 11:50 am
    Apr 22, 2009 at 3:52 pm
  • Hi. While PostgreSQL is a great database, it lacks some fundamental Unicode support. I want to present some points that have--to my knowledge--not been addressed so far. In the following text, it is ...
    - -- -
    Apr 13, 2009 at 5:24 pm
    Apr 20, 2009 at 11:05 am
  • I have added this TODO item: Consider honoring standard_conforming_strings in PL/pgSQL function bodies * http://archives.postgresql.org/pgsql-bugs/2008-03/msg00102.php Are we every going to enable ...
    Bruce MomjianBruce Momjian
    Apr 9, 2009 at 3:16 pm
    Apr 13, 2009 at 7:16 pm
  • Seems I'm bad at communicating in english, so here is C variant of my proposal to bring \u escaping into extended strings. Reasons: - More people are familiar with \u escaping, as it's standard in ...
    Marko KreenMarko Kreen
    Apr 16, 2009 at 5:49 pm
    Sep 25, 2009 at 12:38 pm
  • Currently, the ACL_SELECT_FOR_UPDATE privilege is defined as an alias of ACL_UPDATE as follows: at src/include/nodes/parsenodes.h: : /* Currently, SELECT ... FOR UPDATE/FOR SHARE requires UPDATE ...
    KaiGai KoheiKaiGai Kohei
    Apr 17, 2009 at 5:04 am
    May 11, 2009 at 3:00 am
  • While investigating some performance problems recently I've had cause to think about the way PostgreSQL uses hash joins. So here are a few thoughts. Some of these have been brought up before. 1. When ...
    Robert HaasRobert Haas
    Apr 3, 2009 at 2:08 am
    Apr 8, 2009 at 3:03 am
  • On further review, this did work in 8.3 when released. I think it got broken here: http://archives.postgresql.org/pgsql-committers/2008-06/msg00336.php because that change is preventing the ...
    Tom LaneTom Lane
    Apr 15, 2009 at 4:34 pm
    Apr 20, 2009 at 11:13 am
  • Hi, using v8.3.5 and a number of client libraries (java, python, pgadmin) and playing about with arrays. They all return arrays as text, is it possible to configure postgresql to return an array in ...
    John ListerJohn Lister
    Apr 7, 2009 at 7:03 pm
    Apr 8, 2009 at 3:46 pm
  • Hello, this my proposal is very simple. It help to people who have to manage large or complex database system. Important data are date of creating and date of altering tables and stored procedures. ...
    Pavel StehulePavel Stehule
    Apr 13, 2009 at 6:09 pm
    Apr 14, 2009 at 11:04 pm
  • Andrew GierthAndrew Gierth
    Apr 6, 2009 at 11:54 pm
    Apr 10, 2009 at 9:35 pm
  • I wrote a little perl script to perform a basic sanity check to keywords in gram.y and kwlist.h. It checks that all lists are in alphabetical order, all keywords present in gram.y are listed in ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 28, 2009 at 8:33 am
    May 1, 2009 at 8:27 am
  • If I have locale set to C, I can do this: regression=# create database u8 encoding 'utf8'; CREATE DATABASE regression=# create database l1 encoding 'latin1' template u8; CREATE DATABASE Had I had any ...
    Tom LaneTom Lane
    Apr 23, 2009 at 5:46 pm
    May 6, 2009 at 12:41 am
  • We still have a little work to do on dependencies in parallel pg_restore. The current test compares the candidate's locking dependencies with those of the running jobs, and allows the candidate is ...
    Andrew DunstanAndrew Dunstan
    Apr 10, 2009 at 4:49 am
    Apr 13, 2009 at 12:41 am
  • I've been thinking about this some more and would like someone else to check my work. The goal here is to handle a semi-join implemented as a hash join by unique-ifying the inner rel as we are ...
    Robert HaasRobert Haas
    Apr 12, 2009 at 4:01 am
    May 10, 2009 at 3:05 am
  • Hi, log_directory is automatically created if not present when starting the database server. But, stats_temp_directory is not created. Why? ISTM that current behavior is undesirable. Is it worth ...
    Fujii MasaoFujii Masao
    Apr 14, 2009 at 8:02 am
    Feb 26, 2010 at 3:06 am
  • Hello, I was digging through the optimizer code and have a question regarding the edge recombination crossover (ERX) of the GEQO. It might be completely stupid and therefore I apologize for this in ...
    Tobias ZahnTobias Zahn
    Apr 20, 2009 at 8:32 pm
    May 28, 2009 at 2:15 am
  • I hit a problem with libtcl.so that LDFLAGS is not propagated. The same problem is with other PL languages as well. Is it intention or a bug? thanks Zdenek
    Zdenek KotalaZdenek Kotala
    Apr 23, 2009 at 2:50 pm
    Apr 24, 2009 at 4:46 am
  • Hi Tom-san. I want to solve one problem before the release of 8.4. However, since it also seems to be the new feature, if not enough for 8.4, you may suggest that it is 8.5. In Japan, the local file ...
    Hiroshi SaitoHiroshi Saito
    Apr 7, 2009 at 4:40 pm
    Apr 14, 2009 at 8:41 pm
  • Hi. There's a TODO item about making COMMENT ON accept an expression. The grammar change is simple (SConst|NULL_P- a_expr), but as far as I can see, there are no similar utility commands that take ...
    Abhijit Menon-SenAbhijit Menon-Sen
    Apr 11, 2009 at 4:47 am
    Apr 11, 2009 at 11:04 pm
  • I'm a bit unsatisfied with this output because it doesn't tell me the plan it used to construct the CTE being scanned. rhaas=# explain with wumpus as (select * from foo where id < 200) select * from ...
    Robert HaasRobert Haas
    Apr 5, 2009 at 1:40 pm
    Apr 6, 2009 at 10:32 am
  • I see that the recently committed changes typically use ngettext in this style: ereport(msglevel, /* translator: %d always has a value larger than 1 */ (errmsg(ngettext("drop cascades to %d other ...
    Tom LaneTom Lane
    Apr 26, 2009 at 6:29 pm
    May 28, 2009 at 2:13 pm
  • Hi. I found the current planner doesn't care about "lossy mode" on Bitmap Scan. I think costs of following two plans are equal now. (a) Having enough work_mem = normal Bitmap Scan. (b) Having less ...
    HigeponHigepon
    Apr 28, 2009 at 5:39 am
    May 8, 2009 at 7:45 am
  • We are still having trouble with the service controller pg_ctl.exe vanishing after some period of time. Hence I am doing debug builds from the source tree according to the instructions found at: ...
    Dann CorbitDann Corbit
    Apr 28, 2009 at 6:47 pm
    Apr 28, 2009 at 10:21 pm
  • Hi, Some time ago I noticed that in postmaster.c there's a corner case which probably causes postmaster to exit in out-of-memory condition. See BackendStartup, near the bottom, there's a call to ...
    Alvaro HerreraAlvaro Herrera
    Apr 6, 2009 at 11:03 pm
    May 4, 2009 at 2:26 am
  • This is more of a hackers discussion. I am forwarding there. -Hackers, Do we have a history on this file? Joshua D. Drake -- PostgreSQL - XMPP: jdrake@jabber.postgresql.org Consulting, Development, ...
    Joshua D. DrakeJoshua D. Drake
    Apr 21, 2009 at 3:39 pm
    Apr 21, 2009 at 11:38 pm
  • Considering the following sequence: create table t(a int primary key); alter table t drop constraint t_pkey; insert into t values(null); ERROR: null value in column "a" violates not-null constraint ...
    Jacky LengJacky Leng
    Apr 2, 2009 at 7:53 am
    Apr 7, 2009 at 9:15 pm
  • Hi, I've noticed a difference in 8.3.7 vs 8.4 (via git branch -r) behaviour 8.3 ---- testdb= create table foo (bar bigserial primary key with (fillfactor=75)); NOTICE: CREATE TABLE will create ...
    Khee ChinKhee Chin
    Apr 3, 2009 at 7:14 pm
    Apr 3, 2009 at 9:00 pm
  • Hi, Does anyone know why a tablespace directory isn't automatically created in recovery? I think that it's troublesome to create all the directories before recovery. Regards, -- Fujii Masao NIPPON ...
    Fujii MasaoFujii Masao
    Apr 30, 2009 at 7:57 pm
    May 1, 2009 at 10:38 pm
  • GCC 4.4 produces a bunch of new compiler warnings against 8.4; see attached output. Some of these are related to our old friend fastgetattr(), but it's a bit too late for me to make sense of it now. ...
    Peter EisentrautPeter Eisentraut
    Apr 22, 2009 at 11:00 pm
    May 1, 2009 at 2:49 pm
  • On poking into this, it's a bit uglier to do than I first thought. pg_proc.proargdefaults has to be the text representation of an expression tree. This means that to do it directly in pg_proc.h would ...
    Tom LaneTom Lane
    Apr 6, 2009 at 11:24 pm
    Apr 8, 2009 at 11:47 pm
  • Is it possible to print which key value is duplicated when 'Duplicate key value violates unique constraint' occurs? Foreign key violation error reports such kind of information.
    Vlad ArkhipovVlad Arkhipov
    Apr 1, 2009 at 3:52 am
    Aug 1, 2009 at 8:02 pm
  • When postgreSQL is compiled with --thread-safe that libpq should be thread safe. But it is not true when somebody call fork(). The problem is that fork() forks only active threads and some mutex can ...
    Zdenek KotalaZdenek Kotala
    Apr 14, 2009 at 11:53 am
    May 30, 2009 at 2:51 am
  • The Windows installation service uses pg_ctl to perform the network start-up operation. This program starts up the postmaster and exits. The net effect of performing the operation in this manner is ...
    Dann CorbitDann Corbit
    Apr 10, 2009 at 3:11 pm
    May 13, 2009 at 1:52 pm
  • Hi The following query is distilled down from a real production query for ease of reproduction: SELECT 1 AS id , 2 AS tmpl_id WHERE FALSE -- (in production, only rarely will this clause return a row) ...
    Ian BarwickIan Barwick
    Apr 18, 2009 at 3:12 pm
    Apr 19, 2009 at 8:56 am
  • Grant, I'm originator of this thread and PostgreSQL is also a big user of the Snowball project, so we also are very interested in the vital activity of the project. However, I see issue with license, ...
    Oleg BartunovOleg Bartunov
    Apr 1, 2009 at 8:52 pm
    Apr 1, 2009 at 10:22 pm
  • Hi! I need to recover deleted rows from table. After I delete those rows I stopped postgres immediately and create tar archive of database. I found solution ...
    Anton EgorovAnton Egorov
    Apr 26, 2009 at 6:41 pm
    May 1, 2009 at 10:43 am
  • Hi, I've been trying to sort a column that performs some calculations, but postgres says this: ERROR: invalid attnum: -12851. I was searching on the source code, and I guess the error araises around ...
    Werner EchezuriaWerner Echezuria
    Apr 26, 2009 at 8:50 pm
    Apr 27, 2009 at 3:19 pm
Group Navigation
period‹ prev | Apr 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions145
posts1,431
users135
websitepostgresql.org...
irc#postgresql

135 users for April 2009

Tom Lane: 311 posts Robert Haas: 96 posts Bruce Momjian: 72 posts Heikki Linnakangas: 61 posts Alvaro Herrera: 51 posts David Fetter: 50 posts Peter Eisentraut: 45 posts Kevin Grittner: 44 posts Andrew Dunstan: 42 posts Greg Stark: 35 posts Fujii Masao: 33 posts Pavel Stehule: 32 posts Simon Riggs: 26 posts Josh Berkus: 25 posts Sam Mason: 23 posts Magnus Hagander: 19 posts David E. Wheeler: 17 posts Marko Kreen: 17 posts Zdenek Kotala: 16 posts Dave Page: 15 posts
show more
Archives