FAQ

Search Discussions

135 discussions - 1,327 posts

  • BTW, I was just looking over Knuth's discussion of sorting again, and realized that there is still something more that could be done within the existing sort framework. We currently use standard ...
    Tom LaneTom Lane
    Mar 7, 2006 at 11:14 pm
    Mar 10, 2006 at 11:59 am
  • A thread on -general (http://archives.postgresql.org/pgsql-general/2006-03/msg01023.php) recently ended in the idea that the pgAdmin 'adminpack' be included as an 'official' PostgreSQL contrib ...
    Dave PageDave Page
    Mar 27, 2006 at 1:12 pm
    Apr 13, 2006 at 1:50 pm
  • PostgreSQL Anniversary Summit ============================= Call for Contributions ---------------------- The PostgreSQL Anniversary Summit will take place on July 8 and 9, 2006, in Toronto, Canada. ...
    Peter EisentrautPeter Eisentraut
    Mar 1, 2006 at 10:52 am
    Mar 12, 2006 at 7:05 pm
  • Dear PostgreSQL Hackers, I recently ran into an issue where I was having trouble compiling PostgreSQL with PL/Perl. Although Mac OS X 10.4 comes with a dynamic Perl, I long ago compiled my own Perl, ...
    David WheelerDavid Wheeler
    Mar 31, 2006 at 7:46 pm
    Apr 21, 2006 at 10:01 pm
  • Hello, I've been trying to get a local mirror of the cvs repository, but my connection attempts using rsync to cvsup.postgresql.org are always refused when I try to actually retrieve the pgsql-cvs ...
    Joel MillerJoel Miller
    Mar 23, 2006 at 9:39 pm
    Apr 10, 2006 at 12:29 am
  • One of the key points influencing performance of certain operations is the amount of memory that is available to them. Sorts, Materialize, Hash Joins and Aggs and hashed subquery plans all want lots ...
    Simon RiggsSimon Riggs
    Mar 16, 2006 at 3:35 pm
    Apr 23, 2006 at 3:05 pm
  • Hi I read a post in the archives saying about storing explain output directly into tables. Is this feature present in postgres now?? I have a software in which I need to display the explain output in ...
    Akshat NairAkshat Nair
    Mar 23, 2006 at 5:30 am
    Apr 13, 2006 at 7:27 am
  • Hi all! while playing on a new box i noticed that postgresql does not seem to be able to cope with very large settings for maintenance_work_mem. For a test I created a single table with 5 integer ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Mar 4, 2006 at 10:03 am
    Mar 11, 2006 at 6:23 pm
  • We already have good support of type development. It's not clear to me that this would buy us anything at all. It seems like modularisation for the sake of it. The real issue is what types and type ...
    Andrew DunstanAndrew Dunstan
    Mar 22, 2006 at 3:13 am
    Mar 24, 2006 at 5:10 pm
  • Hello PostgreSQL Developers, I'm the CTO of Coverity, Inc., a company that does static source code analysis to look for defects in code. You may have heard of us or of our technology from its days at ...
    Ben ChelfBen Chelf
    Mar 6, 2006 at 5:57 am
    Mar 10, 2006 at 10:02 am
  • Hi all, i would like to work on control setting pg_hba.conf via SQL....( cf TODO List ), and i would know if the pg_hda.conf must be replaced by pg_hba table ? Emmanuel BERTHOULE
    BERTHOULE EmmanuelBERTHOULE Emmanuel
    Mar 29, 2006 at 9:13 pm
    Apr 1, 2006 at 6:14 pm
  • Hi, I tried pg_freespacemap and found strange result: test=# select * from pg_freespacemap where blockfreebytes = 0; blockid | relfilenode | reltablespace | reldatabase | relblocknumber | ...
    Tatsuo IshiiTatsuo Ishii
    Mar 7, 2006 at 2:08 pm
    Apr 26, 2006 at 10:46 pm
  • I was just looking at the behavior of src/port/qsort.c on the test case that Jerry Sievers was complaining about in pgsql-admin this morning. I found out what the real weak spot is: it's got nothing ...
    Tom LaneTom Lane
    Mar 16, 2006 at 7:37 pm
    Mar 21, 2006 at 9:47 pm
  • This email is a preliminary design for the implementation of synonyms in PostgreSQL. Comments and suggestions are welcomed. BACKGROUND Synonyms are database objects which can be used in place of ...
    Jonah H. HarrisJonah H. Harris
    Mar 9, 2006 at 4:35 pm
    Mar 10, 2006 at 11:19 pm
  • Trying to work in the new role features into the information schema, I noticed that there might be a few incompatibilities between the implementation and what the SQL standard would like to see. The ...
    Peter EisentrautPeter Eisentraut
    Mar 23, 2006 at 10:54 pm
    Jul 28, 2006 at 7:02 pm
  • I apologize for the lameness of this question upfront :) Does anyone know how to add a fixed-length char field to pg_class? I need to avoid the cost of variable-length so I tried to add the ...
    Jonah H. HarrisJonah H. Harris
    Mar 30, 2006 at 4:46 pm
    Apr 4, 2006 at 5:21 am
  • Hi, I'm currently investigating the feasibility of an alternative PL/Java implementation that would use shared memory to communicate between a JVM and the backend processes. I would very much like to ...
    Thomas HallgrenThomas Hallgren
    Mar 24, 2006 at 10:51 am
    Mar 29, 2006 at 1:14 am
  • Background: Domains lay the groundwork for inherited basetypes or subtypes. By defining a domain and overriding operators and possibly creating an operator class, then a domain can be created which ...
    EleinElein
    Mar 24, 2006 at 7:01 pm
    Apr 11, 2006 at 2:36 am
  • Huh, I thought what he actually told was that the file was released under BSD license. Maybe I missed it, but I didn't see him asking to remove the copyright. We certainly have copyrights attributed ...
    Alvaro HerreraAlvaro Herrera
    Mar 8, 2006 at 10:23 pm
    Mar 11, 2006 at 3:38 pm
  • I'm updating the information schema for SQL:2003. I'm having some difficulties with the "sequences" view. It should look approximately like this (uninteresting stuff omitted): CREATE VIEW sequences ...
    Peter EisentrautPeter Eisentraut
    Mar 22, 2006 at 8:41 pm
    Mar 23, 2006 at 6:03 pm
  • Folks, Wanted to update you on a few things regarding speaking at the upcoming PostgreSQL Anniversary Summit: -- There are only 13 days left to submit a proposal. Please do so. We'd rather not be ...
    Josh BerkusJosh Berkus
    Mar 18, 2006 at 1:54 am
    Mar 20, 2006 at 2:19 pm
  • Hello all, Below is an email thread regarding a possible bug in PostgreSQL on Windows 2003. Any help or advice anyone can give on this would be much appreciated. All the best, James Hughes --- EMAIL ...
    James_hughesJames_hughes
    Mar 1, 2006 at 8:16 am
    Mar 30, 2006 at 10:32 am
  • Greetings, After helping a user on irc, I was wondering if there would be any objection to my making a patch that would: 1) expose DEFAULT_PGSOCKET_DIR via a libpq call 2) add this information to the ...
    Larry RosenmanLarry Rosenman
    Mar 28, 2006 at 10:23 pm
    Mar 29, 2006 at 5:14 am
  • Hi there, I and Teodor are going to give a talk on conference "Corporate database systems-2006" here in Moscow and we need info about new features planned in 8.2 release. Bruce, do you have a list of ...
    Oleg BartunovOleg Bartunov
    Mar 21, 2006 at 12:47 pm
    Mar 27, 2006 at 10:16 am
  • I have some odd results from timing two versions of an update query, and was hoping to get a better handle on how to interpret this. The query does an update of one table. One version does three NOT ...
    Kevin GrittnerKevin Grittner
    Mar 23, 2006 at 12:09 am
    Mar 25, 2006 at 5:55 pm
  • Hi guys, I've been trying to build the cvs checkout of 8.1.3 on my freebsd 4.9 box with a STATIC psql utility. I keep getting failures trying to hook in libreadline I think: lreadline -lcrypt ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 16, 2006 at 1:23 am
    Mar 24, 2006 at 1:25 am
  • Hi all! During my testing of large work_mem and maintainence_work_mem setting wrt to CREATE INDEX and sorting I encountered a number of things wrt to doing various operations on such a large table ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Mar 10, 2006 at 5:40 pm
    Mar 14, 2006 at 6:39 pm
  • [ redirecting to a more appropriate mailing list ] "Alex bahdushka" <bahdushka@gmail.com writes: I think what's happened here is that VACUUM FULL moved the only tuple off page 1 of the relation, then ...
    Tom LaneTom Lane
    Mar 27, 2006 at 3:22 pm
    Apr 10, 2006 at 10:04 pm
  • I could have swore that this worked in earlier releases of Postgresql i.e. 7.4. CREATE TABLE public.test ( junk double NOT NULL, CONSTRAINT junk_pkey PRIMARY KEY (junk) )WITHOUT OIDS; Now it gives a ...
    Tony CadutoTony Caduto
    Mar 23, 2006 at 11:31 pm
    Mar 24, 2006 at 9:58 am
  • Hi, I'm trying to extend the CREATE INDEX statement with a fillfactor clause. In Gram.y, I did this: IndexStmt: CREATE index_opt_unique INDEX index_name ON qualified_name access_method_clause '(' ...
    TmorelliTmorelli
    Mar 3, 2006 at 9:14 pm
    Mar 8, 2006 at 9:45 pm
  • See $SUBJECT. It seems to me this is a bad idea for much the same reasons that we recently decided default index operator classes should not be namespace-specific: ...
    Tom LaneTom Lane
    Mar 27, 2006 at 5:18 pm
    Mar 28, 2006 at 4:31 pm
  • We generally don't worry about point releases too much unless there's a pretty serious bug, so it'll probably take a while. Unfortunately I don't know of anyone building nightly binaries. This is ...
    Jim C. NasbyJim C. Nasby
    Mar 24, 2006 at 1:21 pm
    Mar 27, 2006 at 8:38 am
  • Hi, We have been having a short talk with Devrim this evening about the pgnixInstaller[1] project he started[2] a while ago. I have briefly read over the thread following the project announce, ...
    Enver ALTINEnver ALTIN
    Mar 23, 2006 at 4:51 am
    Mar 24, 2006 at 1:55 pm
  • Imagine the following scenario: Function 'A' returns SETOF 'x'. It will issue a query using SPI that calls function 'B'. This function returns SETOF 'y'. Each tuple of 'x' is formed from some data in ...
    Thomas HallgrenThomas Hallgren
    Mar 22, 2006 at 2:32 pm
    Mar 22, 2006 at 9:39 pm
  • Someone sent the following request to the Debian bug tracking system: """ It'd be nice if the .psql_history file were per-database. This is because the commands executed on different databases are ...
    Peter EisentrautPeter Eisentraut
    Mar 17, 2006 at 4:23 pm
    Mar 17, 2006 at 10:28 pm
  • Ok, I've coded up a patch that changes the code to use a mutex instead. Patch attached. You can get a precompiled postgres.exe at http://www.hagander.net/download/postgres.exe_mutex.zip. You need to ...
    Magnus HaganderMagnus Hagander
    Mar 12, 2006 at 2:45 pm
    Mar 15, 2006 at 11:48 am
  • I was talking with Jonathan Gennick about the INS/UPD/DEL RETURNING stuff, and he recommended looking into the way DB2 handles similar functionality. After looking into it a bit, it's more inline ...
    Jonah H. HarrisJonah H. Harris
    Mar 12, 2006 at 4:11 pm
    Mar 13, 2006 at 11:15 pm
  • This may be a newbie question, but according to the 7.4 docs, an ACCESS EXCLUSIVE lock is only acquired by the ALTER TABLE, DROP TABLE, REINDEX, CLUSTER, and VACUUM FULL commands. However, when ...
    Seth M GreenSeth M Green
    Mar 1, 2006 at 11:55 pm
    Mar 5, 2006 at 11:28 pm
  • I'm creating user-defined server extensions, written in C per the manual "31.9. C-Language Functions". Everything works well, but only if I fully link the .so such that there are *no* unresolved ...
    Craig A. JamesCraig A. James
    Mar 2, 2006 at 9:48 pm
    Mar 3, 2006 at 9:53 pm
  • Hi folks, Please find attached a patch that implements SQL92-compatible updatable views. The patch introduces new semantics into the rule system: implicit and explicit rules. Implicit rules are ...
    Bernd HelmleBernd Helmle
    Mar 10, 2006 at 10:21 am
    Jun 16, 2006 at 6:50 pm
  • What sense is this supposed to make? = begin; BEGIN = blah; ERROR: ... = commit; ROLLBACK ^^^^^^^^ Even if this is justifiable, this behavior is not documented (in any obvious place). -- Peter ...
    Peter EisentrautPeter Eisentraut
    Mar 17, 2006 at 9:14 am
    Mar 17, 2006 at 3:50 pm
  • I really don't see why or how this is an improvement. But if no one else cares about it, so be it ... I wonder what would have happened if I had stuck my name in the autovacuum.c, pg_shdepend.c or ...
    Alvaro HerreraAlvaro Herrera
    Mar 9, 2006 at 11:22 pm
    Mar 13, 2006 at 10:21 am
  • With the BSD license, there really isn't any restriction to enforce, so the copyright owner is pretty meaningless. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If ...
    Bruce MomjianBruce Momjian
    Mar 10, 2006 at 2:18 am
    Mar 11, 2006 at 4:44 pm
  • Folks, From the earlier discussion, it appears that there is a variety of opinions on what the COPY delimiter should be in pg_dump. This patch allows people to set it and the NULL string. Thanks to ...
    David FetterDavid Fetter
    Mar 8, 2006 at 3:47 pm
    Mar 9, 2006 at 2:16 am
  • No, not yet. Personally I'm unconvinced that we should depend on libcurl: if it's going to use openldap to do LDAP work, then the only good reason to use libcurl rather than openldap directly is if ...
    Tom LaneTom Lane
    Mar 5, 2006 at 8:20 pm
    Mar 7, 2006 at 7:57 am
  • Has anyone else been finding the recent behavior of CVS-tip psql to be a disimprovement? I've gotten sufficiently annoyed with it that I'm ready to propose reverting this patch: 2006-02-11 16:55 ...
    Tom LaneTom Lane
    Mar 4, 2006 at 5:08 pm
    Mar 5, 2006 at 11:34 pm
  • Is it worth allowing this: select count(*) from users_users where position('ch' in username) = 0; To be able to use an index, like: select count(*) from users_users where username like 'ch%'; At the ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 24, 2006 at 2:49 am
    Mar 24, 2006 at 10:01 am
  • Hi, A PL/Java user reports that his backend runs out of memory when he uses PL/Java to execute huge queries towards a remote database and return the result. PL/Java is designed not to collect data in ...
    Thomas HallgrenThomas Hallgren
    Mar 20, 2006 at 10:47 am
    Mar 22, 2006 at 6:33 am
  • Considering the amount of bug repotrs that get their first question as "what's the locale" and "what's the encoding", should we perhaps add those fields to the bug reporting form? And if we should, ...
    Magnus HaganderMagnus Hagander
    Mar 16, 2006 at 9:33 am
    Mar 17, 2006 at 2:53 am
  • Several of the new uninstall scripts give errors, particularly those that drop types and their support objects. To see an example: createdb foo psql -d foo -f ltree.sql psql -d foo -f ...
    Michael FuhrMichael Fuhr
    Mar 1, 2006 at 3:19 am
    Mar 7, 2006 at 4:12 pm
Group Navigation
period‹ prev | Mar 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions135
posts1,327
users155
websitepostgresql.org...
irc#postgresql

155 users for March 2006

Tom Lane: 240 posts Bruce Momjian: 87 posts Andrew Dunstan: 50 posts Jim Nasby: 48 posts Martijn van Oosterhout: 47 posts Jonah H. Harris: 39 posts Alvaro Herrera: 37 posts Simon Riggs: 36 posts Peter Eisentraut: 34 posts Josh Berkus: 28 posts Thomas Hallgren: 24 posts Luke Lonergan: 23 posts Hannu Krosing: 22 posts Mark Dilger: 21 posts Stefan Kaltenbrunner: 21 posts Marc G. Fournier: 20 posts Magnus Hagander: 19 posts Mark Kirkwood: 18 posts Stephan Szabo: 17 posts Stephen Frost: 17 posts
show more
Archives