FAQ

PostgreSQL > pgsql-hackers > July 2005

Search Discussions

142 discussions - 1,150 posts

  • 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 MomjianBruce 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 RiggsSimon 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 KreenMarko 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 FrostStephen 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. NasbyJim 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 FrostStephen 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 EisentrautPeter 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 LaneTom 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 McArthurKevin 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 LaneTom 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 WongMark 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 RosenmanLarry 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 MomjianBruce 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 FuhrMichael 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 DunstanAndrew 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 FuhrMichael 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 DunstanAndrew 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 EisentrautPeter 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 AlcornDarren 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 HerreraAlvaro 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 LaneTom 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 PageDave 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 FuhrMichael 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 RiggsSimon 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. FournierMarc 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 ...
    OhpOhp
    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-LynneChristopher 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 RichterJanko 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 LaneTom 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 DunstanAndrew 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 ParasharAyush 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 KataokaHiroki 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 HerreraAlvaro 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 MomjianBruce 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. NasbyJim 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-LynneChristopher 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 LaneTom 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. DrakeJoshua 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 EisentrautPeter 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. SeppMá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 KaltenbrunnerStefan 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 WheelerDavid 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 DunstanAndrew 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. DrakeJoshua 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-LynneChristopher 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 LaneTom 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 ZhouQingqing 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 LaneTom Lane
    Jul 22, 2005 at 4:20 pm
    Aug 10, 2005 at 10:55 pm
  • Who copied? I've been to mysql site 2 mn ago (did'nt occur since at least 6 months) title says : Mysql: The world most advanced opensource database. Isn't it the title for postgresql? It seems weird ...
    OhpOhp
    Jul 29, 2005 at 5:33 pm
    Jul 30, 2005 at 8:25 am
  • 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 RiggsSimon Riggs
    Jul 26, 2005 at 8:30 pm
    Jul 28, 2005 at 6:21 am
Jul 2005
123
Group Navigation
period‹ prev | Jul 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions142
posts1,150
users130
websitepostgresql.org...
irc#postgresql

130 users for July 2005

Tom Lane: 220 posts Bruce Momjian: 110 posts Andrew Dunstan: 85 posts Jim C. Nasby: 47 posts Simon Riggs: 39 posts Stephen Frost: 37 posts Michael Fuhr: 35 posts Marko Kreen: 31 posts Alvaro Herrera: 29 posts Josh Berkus: 29 posts Christopher Kings-Lynne: 25 posts Larry Rosenman: 25 posts Dave Page: 24 posts Joshua D. Drake: 21 posts Peter Eisentraut: 21 posts Marc G. Fournier: 19 posts David Fetter: 14 posts Greg Stark: 13 posts Mark Wong: 13 posts Neil Conway: 13 posts
show more
Archives