Search Discussions
-
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 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 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. 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. 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 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 ...
Wes
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 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 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 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 ...
Taral
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 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 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 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 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 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 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 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 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 Momjian
Apr 20, 2006 at 11:02 am
Apr 25, 2006 at 1:41 am -
12
Control File
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 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 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 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 Babakhani
Apr 24, 2006 at 5:41 pm
Apr 24, 2006 at 10:22 pm -
11
TODO items..
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 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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Eisentraut
Apr 10, 2006 at 8:03 am
Apr 10, 2006 at 4:18 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 133 |
posts | 1,150 |
users | 136 |
website | postgresql.org... |
irc | #postgresql |
136 users for April 2006
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)