Search Discussions
-
Let me try to outline where I think our goals are for remote administration. I will not comment on Dave's analysis of the patch review process, but I think he has some valid points that this patch ...
Bruce Momjian
Jul 31, 2005 at 3:39 am
Aug 8, 2005 at 7:30 pm -
A Guide to the Constraint Exclusion Feature =========================================== Simon Riggs 2ndQuadrant simon@2ndquadrant.com INTRODUCTION Constraint Exclusion (CE) is an optimizer patch ...
Simon Riggs
Jul 13, 2005 at 10:53 am
Jul 24, 2005 at 7:55 pm -
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=potorooo&dt=2005-07-10%2022:30:03 New sha2 code on Solaris 2.8 / SPARC. Seems like it has problems memcpy'ing to a non-8-byte-aligned uint64 *. ...
Marko Kreen
Jul 11, 2005 at 10:54 am
Jul 16, 2005 at 6:06 pm -
Greetings, The current permissions checks for truncate seem to be excessive. It requires that you're the owner of the relation instead of requiring that you have delete permissions on the relation. ...
Stephen Frost
Jul 7, 2005 at 4:40 pm
Aug 24, 2005 at 12:48 pm -
http://archives.postgresql.org/pgsql-bugs/2005-07/msg00096.php describes what I think is causing octopus to fail. What's also interesting is these patches from the FreeBSD port: ...
Jim C. Nasby
Jul 19, 2005 at 6:54 pm
Jul 30, 2005 at 2:42 am -
Sorry about the existing applications, but this does go directly against the SQL2003 specification. At least from my reading of SQL2003 5.37 ROLE_COLUMN_GRANTS view, which 'Identifies the privileges ...
Stephen Frost
Jul 21, 2005 at 7:53 pm
Jul 26, 2005 at 4:52 pm -
We have four pieces of information when linking a shared library: B: in-tree libraries that we might need (in case of ecpglib: libpq) A: path to those in-tree libraries D: external libraries that we ...
Peter Eisentraut
Jul 4, 2005 at 3:58 pm
Aug 17, 2005 at 11:13 pm -
Hmm ... if it's *not* a version thing then I really do want to know what's causing it. Anyone have an idea why this machine is saying '\u80' where everyone else's python says u'\x80' ? *** ...
Tom Lane
Jul 19, 2005 at 6:49 pm
Aug 3, 2005 at 9:10 am -
Recent cvs versions are failing the following script; create table oidtest(a time default now()) with oids; CREATE OR REPLACE FUNCTION oidtest() RETURNS integer AS $oidtest$ DECLARE insert_oid_var ...
Kevin McArthur
Jul 26, 2005 at 10:36 pm
Jul 27, 2005 at 10:58 pm -
I spent a little time today cleaning up easily-fixed problems that are causing buildfarm failures in various back branches. Hopefully that will result in a few more "green" entries over the new few ...
Tom Lane
Jul 17, 2005 at 3:17 am
Jul 20, 2005 at 8:46 pm -
I'm starting to get results with dbt2 on a 4-way opteron system and wanted to share what I've got so far since people have told me in the past that this architecture is more interesting than the ...
Mark Wong
Jul 12, 2005 at 7:47 pm
Jul 30, 2005 at 12:46 am -
Look at 'firefly' on the pgbuildfarm, and tell me what I need to change to duplicate your setup. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US ...
Larry Rosenman
Jul 25, 2005 at 2:00 pm
Jul 27, 2005 at 1:57 pm -
I have added this comment above the DAYS_PER_MONTH macro: + /* + * DAYS_PER_MONTH is very imprecise. The more accurate value is + * 365.25/12 = 30.4375, or '30 days 10:30:00'. Right now we only + * ...
Bruce Momjian
Jul 21, 2005 at 1:39 pm
Jul 22, 2005 at 7:56 pm -
On my Solaris 9/sparc box with OpenSSL 0.9.8-beta6, the pgcrypto regression tests fail the 3des test. I haven't checked against older versions of OpenSSL; I'll do so when I get a chance. I haven't ...
Michael Fuhr
Jul 5, 2005 at 2:40 pm
Jul 6, 2005 at 4:16 pm -
I am consistently seeing the regression failure shown below on my Windows machine. See http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2005-07-07%2013:54:13 (On the plus side, I am now ...
Andrew Dunstan
Jul 7, 2005 at 2:30 pm
Jul 19, 2005 at 3:05 am -
I've noticed that contrib/pgcrypto/pgcrypto.sql.in doesn't include a volatility category in its CREATE FUNCTION statements, so the functions are all created VOLATILE. Shouldn't most of them be ...
Michael Fuhr
Jul 3, 2005 at 5:32 am
Jul 4, 2005 at 4:43 am -
The latest timezone lib changes seem to have broken Windows and Cygwin builds comprehensively. I assume that this checkin caused the problem: ...
Andrew Dunstan
Jul 5, 2005 at 1:22 pm
Jul 6, 2005 at 9:40 pm -
As previously announced I have committed the update to Autoconf 2.59 as well as updates of mkinstalldirs, install-sh, as well as config.guess and config.sub. This shouldn't have any immediate ...
Peter Eisentraut
Jul 1, 2005 at 6:17 pm
Jul 3, 2005 at 1:14 pm -
I was interested as to if there were plans to develop SQL99 nested tables. I know with AJAX(tm) starting to grow in popularity that the XML features of SQL2003 would prove useful for EnterpriseDB. I ...
Darren Alcorn
Jul 6, 2005 at 8:28 pm
Jul 13, 2005 at 6:19 pm -
I just noticed the "createuser" and "dropuser" pages may need adjustments as well ... are you still working on this? Also, I don't know if you handled it already, but maybe those programs should be ...
Alvaro Herrera
Jul 28, 2005 at 3:44 pm
Sep 23, 2005 at 9:44 pm -
I've applied Alvaro's latest integrated-autovacuum patch. There are still a number of loose ends to be dealt with before beta, though: * Not all the functionality of the current contrib code seems to ...
Tom Lane
Jul 14, 2005 at 2:53 pm
Jul 23, 2005 at 1:15 am -
I've been looking into fixing the --enable-thread-safety option on Windows. At the moment, we have some simple pthread emulation that may be used in libpq if --enable-thread-safety is used. The ...
Dave Page
Jul 21, 2005 at 2:00 pm
Aug 13, 2005 at 1:35 am -
In the latest HEAD, a PL/Perl function that returns a list value instead of a reference causes a segmentation fault: CREATE FUNCTION foo() RETURNS integer[] AS $$ return (1, 2, 3, 4); $$ LANGUAGE ...
Michael Fuhr
Jul 12, 2005 at 1:05 pm
Jul 31, 2005 at 12:35 am -
So far, the CE patch covers only inherited child tables and is only effective when enable_constraint_exclusion is true. There have been various requests for this to work with UNION ALL views and also ...
Simon Riggs
Jul 19, 2005 at 9:23 pm
Jul 30, 2005 at 4:07 am -
Just curious as to whether or not a warning or something should be issued in a case like: SELECT c.* FROM company c, company_summary cs WHERE c.id = cs.id AND cs.detail = 'test' ORDER BY cs.fullname; ...
Marc G. Fournier
Jul 25, 2005 at 9:11 pm
Jul 28, 2005 at 12:23 am -
Hi, I tried the latest cvs this morning (07/22 11:00 CET) and interval test fails. Here's the regression.diffs. *** ./expected/interval.out Fri Jul 22 10:32:21 2005 --- ./results/interval.out Fri Jul ...
Ohp
Jul 22, 2005 at 9:29 am
Jul 25, 2005 at 12:27 pm -
Hi, Does PostgreSQL do the following optimisation: SELECT * FROM diary WHERE date = '2005-05-01' ORDER BY date; or in fact even better (for my situation) SELECT * FROM diary WHERE date BETWEEN ...
Christopher Kings-Lynne
Jul 13, 2005 at 8:05 am
Jul 18, 2005 at 1:30 am -
Is currently anybody working on extending rtree_gist? I have seen, it is moved to core now. I had a look at it and because I have some experience with PGSQL's Gist API, I would do the job. Regards, ...
Janko Richter
Jul 2, 2005 at 11:24 am
Jul 2, 2005 at 5:59 pm -
One pretty silly point: I notice that http://www.pgbuildfarm.org/index.html says "The build farm software does not currently run on Windows". This is out of date no? One not so trivial question: do ...
Tom Lane
Jul 25, 2005 at 3:07 am
Jul 27, 2005 at 3:13 am -
I have just noticed this code in plperl.c: hv_store(plperl_proc_hash, internal_proname, proname_len, newSViv((IV) prodesc), 0); basically, here prodesc is a pointer to a struct, and we are storing it ...
Andrew Dunstan
Jul 10, 2005 at 7:40 pm
Jul 13, 2005 at 1:24 pm -
Hi there, I am new to this list. I have made some additions to multi-byte regression tests ( ./src/test/mb), to include regression tests for copy command. This can be used to test multi-byte ...
Ayush Parashar
Jul 7, 2005 at 8:56 pm
Jun 14, 2006 at 10:27 pm -
Hi all, This small patch improves the performance of INSERT and UPDATE. By my machine, these changes raised the performance about 5%~10% in pgbench. Please take a benchmark in a reliable environment. ...
Hiroki Kataoka
Jul 17, 2005 at 4:29 am
Aug 15, 2005 at 11:14 pm -
Hackers, This is a list of things people mentioned as interesting to do for vacuum/autovacuum, during the last autovacuum discussion thread. Some of them are wishful thinking, others are doable. ...
Alvaro Herrera
Jul 28, 2005 at 12:21 am
Aug 2, 2005 at 7:31 am -
OK, is there any way of setting the keepalive values on AIX? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + ...
Bruce Momjian
Jul 30, 2005 at 6:30 pm
Aug 1, 2005 at 4:19 am -
The email below about FreeBSD's involvement in Google's Summer of Code got me thinking; would there be value in trying to attract college students to working on either PostgreSQL development, or ...
Jim C. Nasby
Jul 19, 2005 at 7:16 pm
Jul 27, 2005 at 3:30 pm -
Hi guys, Would it be useful to have a pg_get_prepared(name) function that returns true or false depending on whether or not there is a prepared query of that name? Perhaps we could have a way of ...
Christopher Kings-Lynne
Jul 15, 2005 at 6:34 am
Jul 16, 2005 at 3:20 pm -
Neil (or anyone else with an opinion), I'm finding several uses in the planner for some new List primitives defined as below. I'd like to push these into list.c, but before that, has anyone got any ...
Tom Lane
Jul 27, 2005 at 10:01 pm
Jul 28, 2005 at 6:42 pm -
Hello, Just for clarification, will the new integrated autovacuum require that statistics are on? Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 ...
Joshua D. Drake
Jul 27, 2005 at 7:53 pm
Jul 27, 2005 at 10:38 pm -
OK, so let's discuss what we really want here. The original submitter wanted locale-dependent output, which seems reasonable, because that's what locale settings are intended for. The current state ...
Peter Eisentraut
Jul 12, 2005 at 12:57 pm
Jul 13, 2005 at 2:31 am -
Hi, I'm looking for a way to hide the souce code of my system (functions). In Oracle, I can wrap it. Is there something that I can use to hide and/or wrap my source code? Att. Márcio A. Sepp ZYON ...
Márcio A. Sepp
Jul 10, 2005 at 7:26 am
Jul 11, 2005 at 6:06 pm -
looks like the latest pgcrypto-patches that just got applied cause widespread failures on the buildfarm machines: http://www.pgbuildfarm.org/cgi-bin/show_status.pl Stefan
Stefan Kaltenbrunner
Jul 10, 2005 at 8:59 am
Jul 10, 2005 at 6:33 pm -
PostgreSQL hackers: 8.0.3 is working great for me on Mac OS X Tiger, but I do get a segfault every time I exit pssql: psql(7466) malloc: *** error for object 0x1806600: incorrect checksum for freed ...
David Wheeler
Jul 14, 2005 at 11:24 pm
Jun 18, 2006 at 5:35 pm -
Should we add the multibyte regression tests to the buildfarm test suite? Does anyone know how portable they are? I guess adding them would be one way to find out. cheers andrew
Andrew Dunstan
Jul 12, 2005 at 5:54 pm
Jul 30, 2005 at 2:37 pm -
Hello, What do you guys think of having a vacuum summary command? E.g.; VACUUM [FULL] [ANALYZE] SUMMARY where summary would only print the last lines of a vacuum verbose? foo= VACUUM SUMMARY; INFO: ...
Joshua D. Drake
Jul 11, 2005 at 7:10 pm
Jul 30, 2005 at 3:21 am -
I can't seem to dump old db's: -bash-2.05b$ pg_dumpall -s -h database-dev dump.sql Password: pg_dumpall: could not connect to database "postgres": FATAL: database "postgres" does not exist Seems that ...
Christopher Kings-Lynne
Jul 8, 2005 at 2:46 am
Jul 8, 2005 at 1:59 pm -
We've seen a couple of bug reports now about how domain constraints aren't checked during input of a parameter that's been deduced to be of a domain type, eg ...
Tom Lane
Jul 8, 2005 at 9:35 pm
Apr 5, 2006 at 2:51 am -
There were several reports of "unable to read/write" on Pg8.0.x win32 port: http://archives.postgresql.org/pgsql-bugs/2005-02/msg00181.php I encounter this several times and finally I catch the ...
Qingqing Zhou
Jul 14, 2005 at 2:17 am
Aug 13, 2005 at 7:34 pm -
After a suitable period of contemplating my navel, I figured out what is going on here: the total costs involved are large enough that the still-fairly-high startup cost of the hash is disregarded by ...
Tom Lane
Jul 22, 2005 at 4:20 pm
Aug 10, 2005 at 10:55 pm -
I'd like to suggest altering the syntax of VACUUM so that it is possible to issue the command VACUUM DATABASE. The keyword DATABASE would be optional, to allow backward compatibility. The reasons for ...
Simon Riggs
Jul 26, 2005 at 8:30 pm
Jul 28, 2005 at 6:21 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 142 |
posts | 1,150 |
users | 130 |
website | postgresql.org... |
irc | #postgresql |
130 users for July 2005
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)