FAQ

PostgreSQL > pgsql-hackers > April 2006

Search Discussions

133 discussions - 1,150 posts

  • Just quickly going through what might be needed to support multiple SSL libraries revealed one big problem in libpq-fe.h. #ifdef USE_SSL /* Get the SSL structure associated with a connection */ ...
    Martijn van OosterhoutMartijn van Oosterhout
    Apr 12, 2006 at 3:48 pm
    Apr 16, 2006 at 9:30 pm
  • I have written some experimental code of doing master-slave seqscan in PostgreSQL. During the work, I feel we had enough infrastructure to support parallel query execution. What I did is adding a new ...
    Qingqing ZhouQingqing Zhou
    Apr 6, 2006 at 10:32 am
    Apr 13, 2006 at 10:50 am
  • Hey everyone, I know we started a discussion a month or so ago regarding ideas for SoC projects. However, after reading through the thread, I didn't see us nail down any actual items. As such, we ...
    Jonah H. HarrisJonah H. Harris
    Apr 15, 2006 at 7:05 pm
    Aug 14, 2006 at 12:41 pm
  • I've got an odd issue that I'm not sure how to fix ... or, if fixing is even possible ... I just put into place a FreeBSD 6.x server ... it has 2 jails running on it, and inside of each, I'm trying ...
    Marc G. FournierMarc G. Fournier
    Apr 2, 2006 at 7:52 pm
    May 17, 2006 at 10:38 am
  • In some recent activity on the patches list about responding to bug #2073, http://archives.postgresql.org/pgsql-bugs/2005-11/msg00303.php we've been discussing various possible tweaks to the behavior ...
    Tom LaneTom Lane
    Apr 29, 2006 at 9:54 pm
    May 5, 2006 at 9:36 am
  • I don't think there's much chance it's other code. The index build is a standalone operation in an external script that uses psql (so it is easy to tailor). This script is called as the last ...
    WesWes
    Apr 25, 2006 at 3:06 am
    May 11, 2006 at 2:25 am
  • OK, so what do we want to do? Clearly outputing something everytime pg_autovacuum touches a database isn't ideal. By default, the server logs should show significant events, which this is not. Do we ...
    Bruce MomjianBruce Momjian
    Apr 27, 2006 at 5:38 pm
    May 2, 2006 at 1:42 pm
  • The cost/benefit of that seems very discouraging. Most backup applications allow for a block size to be specified, so it isn't unreasonable to assume that people who really want PITR and ...
    Bruce MomjianBruce Momjian
    Apr 16, 2006 at 1:41 am
    Apr 18, 2006 at 5:26 pm
  • Hi all, I think I've found the cause (or one of the causes) why stats collection is unreliable on Windows and I'm wondering about the best way to go about fixing it. The problem is that process IDs ...
    Peter BrantPeter Brant
    Apr 5, 2006 at 12:56 am
    Apr 5, 2006 at 4:55 pm
  • I ran afoul of these rules the other day when compiling pgsql 8.1 on AIX. The configure scripts are set up to look for "xlc" instead of "cc", and that command invokes cc with "-qalias=ansi", the ...
    TaralTaral
    Apr 26, 2006 at 8:45 pm
    Apr 27, 2006 at 9:59 pm
  • I worked on this ISBN/ISSN/ISMN/EAN13 module about more than a year ago, and I was wondering if it could be made official, I honestly think it's better than the ISBN/ISSN currently included in the ...
    Jeremy KronuzJeremy Kronuz
    Apr 25, 2006 at 5:36 pm
    Sep 10, 2006 at 8:47 pm
  • Gevik Babakhani wrote: Hi, I wouldn't call it ACL_DATABASE_CONNECT, just ACL_CONNECT. Currently we don't have any objects other than databases that need connecting to, but you never know. (It should ...
    Alvaro HerreraAlvaro Herrera
    Apr 23, 2006 at 9:34 pm
    Apr 25, 2006 at 3:17 pm
  • I have followed the discussion from 3 months ago on WAL bypass and wanted to offer some more information. I have long believed that the bottleneck in transaction-oriented systems is the writing of ...
    Martin ScholesMartin Scholes
    Apr 2, 2006 at 11:53 pm
    Apr 7, 2006 at 2:22 pm
  • Hi, I got the following message when I ran pg_dump with -Ft option on Windows XP. pg_dump: [tar archiver] could not generate temporary file name: Permission denied pg_dump calls tmpfile() in ...
    Yoshiyuki AsabaYoshiyuki Asaba
    Apr 20, 2006 at 4:32 am
    Jun 16, 2006 at 9:37 pm
  • I've been looking into Gavin Hamill's recent report of poor performance with PG 8.1 on an 8-way IBM PPC64 box. strace'ing backends shows a lot of semop() calls, indicating blocking at the LWLock or ...
    Tom LaneTom Lane
    Apr 21, 2006 at 5:01 pm
    Aug 26, 2006 at 3:45 pm
  • We (me and Oleg) are glad to present GIN to PostgreSQL. If community will agree, we will commit it to HEAD branch. http://www.sigaev.ru/gin/gin.gz http://www.sigaev.ru/gin/README.txt Install: % cd ...
    Teodor SigaevTeodor Sigaev
    Apr 26, 2006 at 2:23 pm
    Apr 28, 2006 at 4:11 pm
  • Hi, I've prepared a patch for the Describe <- ParameterDescription messaging which is available via current extended query protocol. Usage (and implementation) is explained in the patch's ...
    Volkan YAZICIVolkan YAZICI
    Apr 1, 2006 at 6:43 pm
    Aug 18, 2006 at 7:56 pm
  • I would like to start a discussion regarding the TODO item “%Add a separate TRUNCATE permission” to gain more information. The new TRUNCATE permission: Is it meant to be a general truncating ...
    Gevik BabakhaniGevik Babakhani
    Apr 26, 2006 at 4:48 pm
    Apr 26, 2006 at 7:05 pm
  • Folks, my mailbox is filling with unresolved Win32 bug reports, specifically: integer division shared memory statistics collector rename fsync I have put the emails at the bottom of the patches_hold ...
    Bruce MomjianBruce Momjian
    Apr 20, 2006 at 11:02 am
    Apr 25, 2006 at 1:41 am
  • Quick (real) story to illustrate situation: Some time ago we used to have a server with 2 disk arrays attached to it. They were /mnt/array1 and /mnt/array2. PostgreSQL (8.0) had tablespaces on both. ...
    Bruno Almeida do LagoBruno Almeida do Lago
    Apr 5, 2006 at 5:10 pm
    Apr 17, 2006 at 1:58 pm
  • Folks, I've been warned that Summer of Code is coming up again soon. We need to be ready with proposals which are officially endorsed by the PostgreSQL project. Which means we need: a) Projects which ...
    Josh BerkusJosh Berkus
    Apr 5, 2006 at 4:15 am
    Apr 6, 2006 at 4:39 pm
  • Hi. I have been thinking about this for a while and now that Google Summer of Code is coming I thought I would share this idea. The GCC people have traded their bison/flex parser with a hand written ...
    Jesper PedersenJesper Pedersen
    Apr 25, 2006 at 8:55 pm
    Apr 28, 2006 at 4:40 am
  • I noticed the following compile warnings. Perhaps someone is interested to know about them. /usr/bin/flex -o'pgc.c' pgc.l gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline ...
    Gevik BabakhaniGevik Babakhani
    Apr 24, 2006 at 5:41 pm
    Apr 24, 2006 at 10:22 pm
  • I saw the following in the TODO list. I am currently trying to work on them. I could not understand clearly what needs to be done. Can anybody give me the details for the following so that I can work ...
    Dhanaraj MDhanaraj M
    Apr 22, 2006 at 7:15 am
    Apr 23, 2006 at 8:09 pm
  • Folks, I would like to start a discussion regarding the TODO item "%Allow pg_hba.conf settings to be controlled via SQL" In the past threads we have been talking about some of the options of how this ...
    Gevik BabakhaniGevik Babakhani
    Apr 16, 2006 at 11:14 am
    Apr 17, 2006 at 9:55 pm
  • There was some discussion about the issues relating to using other SSL libraries. In a nutshell, it came down to that we couldn't return anything other than an OpenSSL pointer from PQgetssl because ...
    Martijn van OosterhoutMartijn van Oosterhout
    Apr 16, 2006 at 8:40 pm
    Apr 17, 2006 at 5:58 pm
  • I need a rownum column, like Oracle. I have searched the mailing lists and I don't see a satisfactory solution, so I was wondering write a UDF to implement it, the requirements are: 1. Need to ...
    Juan Manuel Diaz LaraJuan Manuel Diaz Lara
    Apr 8, 2006 at 4:33 pm
    Apr 11, 2006 at 11:51 pm
  • I was wondering (for planning purposes) if anyone knew the status of constraint exclusions moving up to query runtime and working for joins. Is this something that's coming down the pipe in the ...
    Brandon BlackBrandon Black
    Apr 28, 2006 at 3:24 am
    May 10, 2006 at 4:00 am
  • OK, now that I have modified the build system to properly handle the preprocessing, it seems we have a problem with the ASM instructions. Theo? Comments? -- Bruce Momjian http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 28, 2006 at 7:03 pm
    Apr 29, 2006 at 11:58 am
  • mydb=# select to_timestamp('00000000 0300','yyyymmdd hh24mi'); to_timestamp --------------------------- 0001-01-01 03:00:00+01 BC (1 row) Questionable, but probably valid. mydb=# select ...
    Mario WeilguniMario Weilguni
    Apr 6, 2006 at 12:57 pm
    Apr 19, 2006 at 6:52 pm
  • As I reviewed the win32/sema.c, there is some code that I am not clear, can anybody explain please? In semctl(SETVAL): if (semun.val < sem_counts[semNum]) sops.sem_op = -1; else sops.sem_op = 1; /* ...
    Qingqing ZhouQingqing Zhou
    Apr 11, 2006 at 7:35 am
    Apr 19, 2006 at 9:02 am
  • Hello All, I just thought about implementing some two-argument aggregate functions from SQL 2003 (like CORR(x,y), REGR_SLOPE(x,y) etc...) ( http://www.wiscorp.com/SQL2003Features.pdf , page 10) 1) I ...
    Sergey E. KoposovSergey E. Koposov
    Apr 13, 2006 at 1:21 pm
    Apr 15, 2006 at 7:22 pm
  • I havn't been able to find any more serious issues in the Coverity report, now that they've fixed the ereport() issue. A number of the issues it complains about are things we already Assert() for. ...
    Martijn van OosterhoutMartijn van Oosterhout
    Apr 20, 2006 at 11:05 am
    Apr 25, 2006 at 10:16 am
  • I'm getting the following regression errors with a backend built using Visual C++: *** ./expected/float8-exp-three-digits-win32.out Wed Jun 8 23:15:29 2005 --- ./results/float8.out Sun Apr 23 ...
    Magnus HaganderMagnus Hagander
    Apr 23, 2006 at 8:49 pm
    Apr 24, 2006 at 8:38 pm
  • Hi, when dealing with a bug in the postgresql-plr interface I think I found a suboptimal method to process CASE statements. First to the problem: I'm using the Debian packaged version of PLR version ...
    Andreas TilleAndreas Tille
    Apr 11, 2006 at 3:01 pm
    Apr 11, 2006 at 10:33 pm
  • ... because nowhere does it update the "checkAsUser" fields in the view's query to be the OID of the new owner. This means that permission checks about whether the view can access its underlying ...
    Tom LaneTom Lane
    Apr 30, 2006 at 4:34 pm
    Aug 21, 2006 at 5:56 pm
  • Hi, I read the discussion thread once again and unless I am absolutely and totally on the wrong track this is what I understood from the general plan to be. The current pg_hba.conf provides the ...
    Gevik BabakhaniGevik Babakhani
    Apr 20, 2006 at 3:41 pm
    Apr 21, 2006 at 8:46 pm
  • Anybody on this list hear/opine anything pf the GPUSort project for postgresql? I'm working on a radix-sort subcase for tuplesort, and there are similarities. ...
    Mischa SandbergMischa Sandberg
    Apr 11, 2006 at 10:57 pm
    Apr 13, 2006 at 2:19 pm
  • Hello Is possible make transaction commit trigger without patching code now? I finding way , but all usable interfaces are static. I remember on diskussion about it and about changes in LISTEN/NOTIFY ...
    Pavel StehulePavel Stehule
    Apr 5, 2006 at 11:22 am
    Apr 7, 2006 at 3:40 am
  • Hello Folks, This may be a dumb question but please bear a moment with me. About the TODO item “%Allow pg_hba.conf settings to be controlled via SQL“: If in the future we could configure the settings ...
    Gevik BabakhaniGevik Babakhani
    Apr 6, 2006 at 1:45 pm
    Apr 6, 2006 at 3:18 pm
  • Please accept my apologies for this trivial question... I have been reading through the TODO items for the last couple of days and I couldn't stop wondering whether there is history of discussion ...
    Gevik BabakhaniGevik Babakhani
    Apr 26, 2006 at 9:45 pm
    Apr 26, 2006 at 10:16 pm
  • Hi, As advised, I spend a moment reading the code regarding the GRANT and REVOKE In order to add a new privilege to the ACL, I have created a mini patch. Could this be checked to see if I am on the ...
    Gevik BabakhaniGevik Babakhani
    Apr 21, 2006 at 9:49 am
    Apr 21, 2006 at 11:15 pm
  • Apologies if my previous attempts to post this to the mailing list have actually succeeded, but I've seen no evidence of that... While doing some bugzilla testing, I ran into a data page corruption ...
    Kevin BrownKevin Brown
    Apr 17, 2006 at 2:36 am
    Apr 19, 2006 at 12:06 am
  • While we're talking about pgstats... There was some talk a while back about the whole bufferer/collector combination perhaps being unnecessary as well, and that it might be a good idea to simplify it ...
    Magnus HaganderMagnus Hagander
    Apr 5, 2006 at 8:29 pm
    Apr 13, 2006 at 2:39 am
  • Hi, I'm trying to add fields to pg_database in the system catalog. As long as I add fixed-size fields before the VAR LENGTH ones, that's all fine. But adding a VAR LENGTH (text) field initdb fails ...
    Markus SchiltknechtMarkus Schiltknecht
    Apr 11, 2006 at 5:54 pm
    Apr 11, 2006 at 6:48 pm
  • -bugs is getting inundated with windows installer bugs, and people on the list don't seem to be replying to them. Can someone with the installer project add more prominent information about where ...
    Jim NasbyJim Nasby
    Apr 6, 2006 at 1:46 pm
    Apr 7, 2006 at 12:13 pm
  • Some experimentation over the weekend turned up the result that $SUBJECT is a good idea. I had never thought about this much before, figuring that in a heavily-used index the metapage would stay in ...
    Tom LaneTom Lane
    Apr 25, 2006 at 5:44 pm
    Apr 26, 2006 at 5:29 pm
  • Hi, I'm trying to implement my own access method, which uses c++ framework for saving tuples. The framework consists of set of functions, which are implemented in win32 dll. All the functions which ...
    David HokszaDavid Hoksza
    Apr 23, 2006 at 4:18 pm
    Apr 23, 2006 at 7:12 pm
  • Hello 1.11) How can I learn SQL? ... There is also a nice tutorial at http://www.intermedia.net/support/sql/sqltut.shtm, at http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM, and ...
    Pavel StehulePavel Stehule
    Apr 7, 2006 at 8:10 pm
    Apr 13, 2006 at 12:15 pm
  • Is there a reason for why you can't update the OID column other than that no one has bothered to code up the support for it? -- Peter Eisentraut http://developer.postgresql.org/~petere/
    Peter EisentrautPeter Eisentraut
    Apr 10, 2006 at 8:03 am
    Apr 10, 2006 at 4:18 pm
Apr 2006
123
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions133
posts1,150
users136
websitepostgresql.org...
irc#postgresql

136 users for April 2006

Tom Lane: 210 posts Martijn van Oosterhout: 78 posts Bruce Momjian: 75 posts Jim Nasby: 54 posts Alvaro Herrera: 40 posts Jonah H. Harris: 39 posts Stephen Frost: 38 posts Magnus Hagander: 37 posts Gevik Babakhani: 33 posts Dave Page: 23 posts Qingqing Zhou: 21 posts Mark: 17 posts Joshua D. Drake: 17 posts Marc G. Fournier: 17 posts David Wheeler: 16 posts Peter Eisentraut: 16 posts Simon Riggs: 16 posts Andrew Dunstan: 15 posts Greg Stark: 15 posts Hannu Krosing: 15 posts
show more
Archives