FAQ

Search Discussions

185 discussions - 2,170 posts

  • I posted a note about a week ago which drew far less commentary than I expected, regarding the timetable for the release of 8.5. http://archives.postgresql.org/pgsql-hackers/2009-08/msg01256.php ...
    Robert HaasRobert Haas
    Aug 23, 2009 at 1:18 am
    Sep 14, 2009 at 2:30 pm
  • psql currently uses the ASCII characters '-' '|' and '+' to render tables. However, most modern terminal emulators are capable of displaying characters other than ASCII, including box drawing ...
    Roger LeighRoger Leigh
    Aug 22, 2009 at 4:09 pm
    Nov 9, 2009 at 10:52 pm
  • This patch removes flatfiles.c for good. It doesn't change the keeping of locks in dbcommands.c and user.c, because at least some of them are still required. Regarding sync commits that previously ...
    Alvaro HerreraAlvaro Herrera
    Aug 31, 2009 at 10:53 pm
    Jan 31, 2010 at 10:59 pm
  • I've now read most of this patch, and I think there are some things that need rework, and perhaps debate about what we want. 1. As I already mentioned, I think the mixed-notation business is a bad ...
    Tom LaneTom Lane
    Aug 9, 2009 at 6:31 pm
    Feb 24, 2010 at 6:52 am
  • ... for the simple reason that nobody is maintaining it. Wheeler just pointed out to me today that the OSX startup script hasn't been updated since 7.4 and contains misinformation and dangerous ...
    Josh BerkusJosh Berkus
    Aug 19, 2009 at 6:18 pm
    Aug 27, 2009 at 6:54 am
  • So, after successful, and helpful Saturday with llvm's clang static checker, I decided to run it against postgresql's source code. Result can be seen at: ...
    Grzegorz JaskiewiczGrzegorz Jaskiewicz
    Aug 23, 2009 at 4:26 pm
    Oct 3, 2009 at 6:27 am
  • Here's a first rough cut of Linux script which attempts to launch PostgreSQL as a somewhat LSB conforming application. It's very lightly tested and I haven't gone through to confirm that every corner ...
    Kevin GrittnerKevin Grittner
    Aug 26, 2009 at 11:40 pm
    Sep 30, 2009 at 5:32 pm
  • The attached patch provides access control features on largeobject. This patch adds the ownership and two permissions (SELECT and UPDATE) on largeobjects. The two permissions controls reader and ...
    KaiGai KoheiKaiGai Kohei
    Aug 28, 2009 at 4:07 am
    Oct 15, 2009 at 2:53 pm
  • I love using postgresql, and have for a long time. I'm involved with almost a hundred postgresql installs. But this is the first time I've gotten into the code. Renumbering networks happens often, ...
    Stef WalterStef Walter
    Aug 13, 2009 at 11:19 pm
    Oct 1, 2009 at 2:01 am
  • Hi, I think the case for machine-readable error fields is well made and doesn't need any further push. So, what do we need to make it happen? Here's my proposal. First we need several new error ...
    Alvaro HerreraAlvaro Herrera
    Aug 4, 2009 at 5:12 pm
    Aug 6, 2009 at 6:25 pm
  • Is there a good reason for $subject, other than that the code is entangled with other ALTER TABLE code? The new SET DISTINCT might be equally affected.
    Peter EisentrautPeter Eisentraut
    Aug 7, 2009 at 1:59 pm
    Jul 28, 2010 at 3:20 pm
  • As we are approaching the first alpha release, let's think about how to tag and label it and how to schedule those two operations with respect to one another. The typical process for, say, a beta ...
    Peter EisentrautPeter Eisentraut
    Aug 3, 2009 at 11:32 am
    Aug 10, 2009 at 3:41 pm
  • Hi, There's a longstanding TODO item, in subject. Previous discussion was here: http://archives.postgresql.org/pgsql-hackers/2006-09/msg02341.php In looking what it would take to implement it, I find ...
    Alvaro HerreraAlvaro Herrera
    Aug 11, 2009 at 10:19 pm
    Oct 3, 2009 at 11:31 am
  • I received the following pg_migrator bug report today and was able to reproduce the reported failure when using composite types: test= SELECT * FROM breakmigrator; ERROR: cache lookup failed for type ...
    Bruce MomjianBruce Momjian
    Aug 5, 2009 at 10:33 pm
    Dec 2, 2009 at 4:41 pm
  • Peter, There's another question for alpha releases: are we going to build docs? Either for www.postgresql.org, or for PGDATA/docs? I think we need some kind of docs up, otherwise we'll get little ...
    Josh BerkusJosh Berkus
    Aug 3, 2009 at 8:09 pm
    Aug 7, 2009 at 1:30 am
  • What is "hot" and "standby" about the proposed "hot standby" feature? The way I understand these terms in a replication/cluster scenario are: cold - If the first node dies, you need to start the ...
    Peter EisentrautPeter Eisentraut
    Aug 11, 2009 at 9:31 am
    Aug 12, 2009 at 5:25 pm
  • The tiny patch attached fixes a long-standing peeve of mine (and at least one of my clients'), namely that the target list printed in viewdefs are unreadable. example output now looks like this: ...
    Andrew DunstanAndrew Dunstan
    Aug 26, 2009 at 12:54 pm
    Feb 23, 2010 at 4:30 pm
  • I think that we should be looking at making pgindent runnable by lone hackers at home in their patched trees. That way they fix their patches by simply running it when it's run on the CVS tree, ...
    Alvaro HerreraAlvaro Herrera
    Aug 10, 2009 at 10:03 pm
    Aug 12, 2009 at 1:58 pm
  • Dear friends, I have been using PostgreSQL since 6.3 releases and I am a real fan. Of course, I never use nor trust MySQL to deliver data. Now I use Drupal 6.3 with PostgreSQL 8.4. I loose a lot of ...
    Jean-Michel PouréJean-Michel Pouré
    Aug 21, 2009 at 4:27 pm
    Aug 24, 2009 at 8:17 pm
  • OK, since there was no clear consensus or volunteer for preparing release notes for alpha 1, I have started something. Let me know what you think. (reStructuredText, if you want to play around)
    Peter EisentrautPeter Eisentraut
    Aug 11, 2009 at 10:27 pm
    Aug 17, 2009 at 10:15 pm
  • With the talk about adding compression to pg_dump lately, I've been wondering if tables and indexes could be compressed too. So I've implemented a quick on-the-fly compression patch for postgres ...
    PFCPFC
    Aug 6, 2009 at 9:37 am
    Aug 12, 2009 at 8:46 am
  • [ moving to -hackers ] If this topic has been discussed previously, please point me to the earlier threads. Why aren't we more opportunistic about freezing tuples? For instance, if we already have a ...
    Jeff DavisJeff Davis
    Aug 13, 2009 at 9:32 pm
    Aug 17, 2009 at 2:39 pm
  • What is the status of hot standby and synchronous replication? Is there a design specification? Who are the lead developers? Who is assisting? What open item do we have for each feature? Where is the ...
    Bruce MomjianBruce Momjian
    Aug 11, 2009 at 1:51 am
    Aug 13, 2009 at 8:20 pm
  • hello hackers, i have problems dropping an existing empty tablespace. here is a reduced example: AscheMobil:~ asche$ cat test2.sql CREATE TABLESPACE testspace LOCATION '/opt/postgresql/data2'; CREATE ...
    Jan OttoJan Otto
    Aug 16, 2009 at 11:28 am
    Nov 10, 2009 at 7:04 pm
  • Dear Friends, First, thank you very much for considering a fix on the GROUP BY issue. I am starting a new thread about another issue: It seems that DELETE cannot understand INNER JOINS and needs ...
    Jean-Michel PouréJean-Michel Pouré
    Aug 22, 2009 at 7:40 am
    Aug 25, 2009 at 2:20 pm
  • I found following core file of PG 8.4.0 on my system (Solaris Nevada b119): fe8ae42d _dowrite (85bf6e8, 3a, 8035e3c, 80350e8) + 8d fe8ae743 _ndoprnt (85bf6e8, 8035ec8, 8035e3c, 0) + 2ba fe8b322d ...
    Zdenek KotalaZdenek Kotala
    Aug 21, 2009 at 1:21 pm
    Aug 24, 2009 at 6:48 pm
  • The attached tiny patch sets the <explain root element for auto-explain XML output, so it looks something like this: <explain xmlns="http://www.postgresql.org/2009/explain" <Plan <Node-Type ...
    Andrew DunstanAndrew Dunstan
    Aug 17, 2009 at 9:49 pm
    Aug 20, 2009 at 4:49 pm
  • Let us consider the ordering of real numbers in postgres. As you can see from the results below it has clearly returned the correct results. select( 1.0000000000000000 = 1.0000000000000002 ); = f ...
    Paul MatthewsPaul Matthews
    Aug 7, 2009 at 1:30 pm
    Aug 9, 2009 at 5:32 am
  • Hi all, Here is a short patch implementing a new feature in pgbench so as to allow shell commands to be launched in a transaction file of pgbench. the user has just to add at the beginning of the ...
    Michael PaquierMichael Paquier
    Aug 7, 2009 at 3:23 am
    Oct 26, 2009 at 6:50 am
  • Hi, This seems to be the last holdup for flatfiles.c. This patch removes usage of that code in autovacuum launcher, instead making it go through the most basic relcache initialization so that it is ...
    Alvaro HerreraAlvaro Herrera
    Aug 31, 2009 at 3:05 pm
    Sep 1, 2009 at 8:14 am
  • Sometime since Friday, somebody (probably Peter) "fixed" things so that "make install" at the top level of the tree insists on building the SGML documentation first. I regard this as utterly ...
    Tom LaneTom Lane
    Aug 18, 2009 at 3:30 pm
    Oct 2, 2009 at 9:42 am
  • Folks, While debugging an error with Aziz (postgres_newbie) Sharief in the #postgresql IRC channel, I found a major POLA violation: $ psql Welcome to psql 8.3.7, the PostgreSQL interactive terminal. ...
    David FetterDavid Fetter
    Aug 24, 2009 at 4:12 pm
    Aug 25, 2009 at 2:40 pm
  • Like some ancient precursor to the modern hypot()enuse the dreaded ill-tempered HYPOT()amus lurks in the recesses of geo_ops.c and geo_decls.h. And many a line of code has been swallowed by its ...
    Paul MatthewsPaul Matthews
    Aug 23, 2009 at 3:54 am
    Aug 25, 2009 at 10:59 am
  • Hi, I've noticed that on 8.4.0, commits can take a long time when a temp table is repeatedly filled and truncated within a loop. A very contrived example is begin; create or replace function ...
    Todd A. CookTodd A. Cook
    Aug 5, 2009 at 5:59 pm
    Aug 23, 2009 at 7:25 pm
  • Attached is a proof-of-concept patch which shows that this idea makes it possible to start backends without the pg_database flat file, and that the required search of pg_database can be done with an ...
    Tom LaneTom Lane
    Aug 11, 2009 at 11:11 pm
    Aug 12, 2009 at 8:48 pm
  • Attached is a patch to implement the idea discussed here: http://archives.postgresql.org/pgsql-hackers/2009-08/msg01137.php If VACUUM freezes one tuple on a page, it's likely that there are others on ...
    Jeff DavisJeff Davis
    Aug 17, 2009 at 1:36 am
    Feb 23, 2010 at 11:04 pm
  • Attached patch adds YAML output option to explain: explain (format YAML) select * from information_schema.columns; -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200908281414 ...
    Greg Sabino MullaneGreg Sabino Mullane
    Aug 28, 2009 at 7:17 pm
    Aug 31, 2009 at 8:06 pm
  • In XLogInsert (src/backend/access/transam/xlog.c), the part that adds back-up blocks into the rdata chain is described: /* * Make additional rdata chain entries for the backup blocks, so that we * ...
    Jeff JanesJeff Janes
    Aug 19, 2009 at 4:22 pm
    Dec 16, 2009 at 7:22 pm
  • Last night I had to deal with a puzzled user of version 8.4 who found postgres refused to start but didn't log any error. It turned out that there was an error in the pg_hba.conf file, and the client ...
    Andrew DunstanAndrew Dunstan
    Aug 24, 2009 at 12:39 pm
    Aug 24, 2009 at 7:28 pm
  • Since Alvaro is talking about error messages in another thread, I figured I should post this idea now as well. Something that keeps annoying me a lot when trying to look through what comes out of ...
    Magnus HaganderMagnus Hagander
    Aug 5, 2009 at 11:44 am
    Aug 10, 2009 at 3:47 pm
  • In reference to: http://archives.postgresql.org/message-id/6534f7ae0811181547v1dc1f096g6222e8273b461606@mail.gmail.com Had to fix a lot of bit rot, but otherwise looks good. My updated patch ...
    Joe ConwayJoe Conway
    Aug 4, 2009 at 1:45 am
    Aug 5, 2009 at 4:14 pm
  • After the thread started by Andrew McNamara a while ago: http://archives.postgresql.org/message-id/E419F08D-B908-446D-9B1E-F3520163CE9C@object-craft.com.au the question was left hanging if other ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 31, 2009 at 8:39 am
    Feb 18, 2010 at 3:26 am
  • Using \d on, say, information schema views is completely hilarious because the column name/data type information is usually scrolled off the screen by the immense view definition. Could we change ...
    Peter EisentrautPeter Eisentraut
    Aug 30, 2009 at 9:02 pm
    Oct 31, 2009 at 5:37 pm
  • Backups always take too long... COPY TO is CPU bound... A few days of coding later, I think I'm on to something. First the results. All tables are cached in RAM (not in shared_buffers though). ...
    Pierre Frédéric CaillaudPierre Frédéric Caillaud
    Aug 11, 2009 at 12:48 pm
    Aug 18, 2009 at 10:53 am
  • Due to a thread about the neglect of the sample start scripts I took a look at the current Linux file. There's certainly room for several improvements, but some of them might require discussion. ...
    Kevin GrittnerKevin Grittner
    Aug 20, 2009 at 3:32 pm
    Mar 4, 2010 at 5:06 pm
  • We can choose different encodings from platform-dependent one for database, but postgres writes serverlogs in the database encoding. As the result, serverlogs are filled with broken characters. The ...
    Itagaki TakahiroItagaki Takahiro
    Aug 17, 2009 at 1:53 am
    Oct 17, 2009 at 12:25 am
  • Here is a WIP patch for a foreign data wrapper based dblink. It integrates dblink module into core and adds a new functionality, automatic transaction management. The new interface of dblink is ...
    Itagaki TakahiroItagaki Takahiro
    Aug 19, 2009 at 8:07 am
    Sep 20, 2009 at 4:48 pm
  • WALInsertLock is heavily contended and likely always will be even if we apply some of the planned fixes. Some callers of WALInsertLock are more important than others * Writing new Clog or Multixact ...
    Simon RiggsSimon Riggs
    Aug 28, 2009 at 7:06 pm
    Aug 31, 2009 at 8:49 am
  • There was recently another go-round on the postgis-devel list about the same problem Mark Cave-Ayland complained about last year: http://archives.postgresql.org/pgsql-hackers/2008-06/msg00384.php ...
    Tom LaneTom Lane
    Aug 17, 2009 at 5:37 pm
    Aug 22, 2009 at 7:35 pm
  • pg_proc.probin is currently declared as being type bytea. Perhaps that had some real utility once upon a time, but no currently defined procedural language stores binary data there. In fact, the only ...
    Tom LaneTom Lane
    Aug 4, 2009 at 2:03 am
    Aug 4, 2009 at 2:59 pm
Group Navigation
period‹ prev | Aug 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions185
posts2,170
users150
websitepostgresql.org...
irc#postgresql

150 users for August 2009

Tom Lane: 405 posts Robert Haas: 179 posts Alvaro Herrera: 138 posts Andrew Dunstan: 112 posts Bruce Momjian: 91 posts Peter Eisentraut: 89 posts Kevin Grittner: 85 posts Greg Stark: 83 posts Josh Berkus: 70 posts Pavel Stehule: 61 posts Magnus Hagander: 46 posts David Fetter: 42 posts Boszormenyi Zoltan: 39 posts Sam Mason: 36 posts Heikki Linnakangas: 35 posts Jeff Davis: 26 posts Michael Meskes: 24 posts Grzegorz Jaskiewicz: 23 posts Paul Matthews: 21 posts Pierre Frédéric Caillaud: 21 posts
show more
Archives