FAQ

Search Discussions

121 discussions - 1,990 posts

  • Dear hackers, I have been thinking about ways to have PostgreSQL reject weak passwords. I think the standard recommendation is "use PAM and LDAP", but that requires the user to change the password ...
    Albe LaurenzAlbe Laurenz
    Sep 28, 2009 at 9:54 am
    Oct 20, 2009 at 2:07 pm
  • Hi all, Finally the error logging and autopartitioning patches for COPY that I presented at PGCon are here! Error logging is described here: http://wiki.postgresql.org/wiki/Error_logging_in_COPY ...
    Emmanuel CecchetEmmanuel Cecchet
    Sep 10, 2009 at 2:39 pm
    Nov 10, 2009 at 3:04 am
  • Hi, I'm seeking more powerful "any" pseudotypes. In particular, consider a function foo(type1, type2) returns type3 where type1 and type2 can be both any element type, but not necessarily both of the ...
    Alvaro HerreraAlvaro Herrera
    Sep 8, 2009 at 4:12 pm
    Sep 18, 2009 at 12:44 am
  • It's now been two weeks since we started this CommitFest, so it seems like a good time to review where we are. Here are my thoughts, for what that's worth. Our overall rate of progress is ...
    Robert HaasRobert Haas
    Sep 30, 2009 at 1:22 am
    Jan 26, 2010 at 10:30 am
  • OK, here is the latest version of the Hot Standby patchset. This is about version 30+ by now, but we should regard this as 0.2.1 Patch against CVS HEAD (now): clean apply, compile, no known bugs. ...
    Simon RiggsSimon Riggs
    Sep 15, 2009 at 9:39 pm
    Oct 9, 2009 at 6:09 pm
  • Hackers, Here's the feedback on replacing VACUUM FULL with VACUUM REWRITE: http://it.toolbox.com/blogs/database-soup/getting-rid-of-vacuum-full-feedback-needed-33959 Of note: a) To date, I have yet ...
    Josh BerkusJosh Berkus
    Sep 16, 2009 at 6:11 pm
    Sep 18, 2009 at 8:04 am
  • Hi Itagaki-san, I'm reviewing your patch. Your patch is in good shape. It applies cleanly. All of the things are built as intended (including the two contrib modules). It doesn't include docs but I ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Sep 28, 2009 at 9:27 pm
    Dec 15, 2009 at 4:58 am
  • Here's a half-baked proof of concept for the above approach. This probably needs more testing than I've given it, and I haven't attempted to fix the psql parser or update the documentation, but it's ...
    Robert HaasRobert Haas
    Sep 13, 2009 at 3:52 am
    Sep 21, 2009 at 8:43 pm
  • Here is a patch to implement "Support triggers on columns" in our ToDo list. The syntax is: CREATE TRIGGER name BEFORE UPDATE OF col1, col12, ... ON tbl FOR EACH ROW EXECUTE PROCEDURE func(); I ...
    Itagaki TakahiroItagaki Takahiro
    Sep 3, 2009 at 1:52 am
    Oct 15, 2009 at 12:55 am
  • I have received a requirement for the ability to import ragged CSV files, i.e. files that contain variable numbers of columns per row. The requirement is that extra columns would be ignored and ...
    Andrew DunstanAndrew Dunstan
    Sep 9, 2009 at 8:00 pm
    Sep 13, 2009 at 2:15 am
  • Just a note to say that Hot Standby patch is now on git repository git://git.postgresql.org/git/users/simon/postgres Branch name: hot_standby The complete contents of that repository are BSD licenced ...
    Simon RiggsSimon Riggs
    Sep 26, 2009 at 9:46 am
    Oct 9, 2009 at 5:50 pm
  • Here is a patch to add a GUC parameter "syslog_line_prefix". It adds prefixes to syslog and eventlog. We still have "log_line_prefix", that will be used only for stderr logs. We have a tip that ...
    Itagaki TakahiroItagaki Takahiro
    Sep 14, 2009 at 12:43 am
    Sep 28, 2009 at 8:48 pm
  • Hi, Here is the latest version of Streaming Replication (SR) patch. There were four major problems in the SR patch which was submitted for the last CommitFest. The latest patch has overcome those ...
    Fujii MasaoFujii Masao
    Sep 14, 2009 at 11:24 am
    Oct 7, 2009 at 1:36 am
  • I've attempted to search the archives for references to the SQL LATERAL feature, which AIUI is fairly-frequently requested. Most of the discussion that I've found harks back to 2003, and that seems ...
    Robert HaasRobert Haas
    Sep 7, 2009 at 4:06 am
    Feb 19, 2010 at 3:35 am
  • I posted a message a little over a week ago discussing the timetable for 8.5: http://archives.postgresql.org/pgsql-hackers/2009-08/msg01576.php That thread went off on a number of interesting ...
    Robert HaasRobert Haas
    Sep 2, 2009 at 3:33 am
    Sep 17, 2009 at 5:11 pm
  • Just been looking again at the way FSM works. In fsm_search_avail() we essentially have just a single way for working out how to search the tree. Seems like it would be good to abstract this so that ...
    Simon RiggsSimon Riggs
    Sep 17, 2009 at 3:23 pm
    Oct 3, 2009 at 6:12 am
  • Andrew GierthAndrew Gierth
    Sep 23, 2009 at 2:19 am
    Oct 3, 2009 at 4:20 am
  • From pg_dump/pg_restore section (9.2 of the Todo page on the PostgreSQL Wiki), is the following item "Add comments to output indicating version of pg_dump and of the database server" simply asking ...
    ShakahshakahShakahshakah
    Sep 25, 2009 at 7:04 pm
    Feb 24, 2010 at 2:46 am
  • Andrew GierthAndrew Gierth
    Sep 16, 2009 at 3:32 am
    Feb 23, 2010 at 2:23 am
  • The attached patch is an updated version of reworks for access control facilities, and a short introduction to help reviewing not-obvious part of the patch. List of updates: - Rebased to the latest ...
    KaiGai KoheiKaiGai Kohei
    Sep 14, 2009 at 6:26 am
    Oct 6, 2009 at 2:33 am
  • I've been working on a restructure of some of the syslogger infrastructure with Josh Tolley. Attached is the WIP patch that we have so far. First, the patch removes the logging_collector parameter ...
    Magnus HaganderMagnus Hagander
    Sep 14, 2009 at 7:41 pm
    Sep 28, 2009 at 3:05 pm
  • Given the desire to defer pinning the type of a literal, for better support of user defined types, I think the current semantics of all the conditional expressions: ...
    Kevin GrittnerKevin Grittner
    Sep 8, 2009 at 6:31 pm
    Sep 11, 2009 at 11:02 pm
  • this sounds like a good idea, specially if we add new parameters to the conninfo string and want postgresql's client applications to use them. any one have a preference here? -- Atentamente, Jaime ...
    Jaime CasanovaJaime Casanova
    Sep 10, 2009 at 5:01 am
    Nov 4, 2009 at 5:28 pm
  • Is it possible to convert from a Timestamp to time_t ? I see functions mentioned in utils/timestamp.h for converting between TimestampTz and time_t, but nothing for Timestamp. What is the ...
    Scott MohekeyScott Mohekey
    Sep 14, 2009 at 4:34 am
    Sep 15, 2009 at 11:56 pm
  • All, I've grown to adore the new \ef function editor. It doesn't seem like it would be that difficult to add a view editor as \ev. While editors would also be good for other objects, I don't think we ...
    Josh BerkusJosh Berkus
    Sep 1, 2009 at 6:41 pm
    Feb 23, 2010 at 9:35 pm
  • Here is a patch to implement the following items in our ToDo list: * Add CREATE TABLE LIKE ... INCLUDING COMMENTS * Have CREATE TABLE LIKE copy column storage parameters The syntax is: CREATE TABLE ...
    Itagaki TakahiroItagaki Takahiro
    Sep 7, 2009 at 3:15 am
    Oct 12, 2009 at 7:41 pm
  • Tom, On behalf of the entire PostgreSQL team here in Austria I want to wish you a happy birthday. We hope that you fill be a vital part of PostgreSQL for many years to come. Best regards, Hans-Jürgen ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Sep 18, 2009 at 11:03 am
    Sep 18, 2009 at 11:29 pm
  • We have a number of buildfarm members that have been failing on HEAD consistently for some time. It looks from here that the following actions need to be taken: tapir, cardinal: need a newer version ...
    Tom LaneTom Lane
    Sep 23, 2009 at 2:21 pm
    Oct 16, 2009 at 7:36 pm
  • I realized the truth of $SUBJECT while reading this report: http://archives.postgresql.org/pgsql-general/2009-09/msg00712.php In a standalone backend, postgres.c tries to run StartupXLOG after having ...
    Tom LaneTom Lane
    Sep 19, 2009 at 5:21 pm
    Apr 19, 2010 at 8:18 pm
  • Here we go again. Following Tom's advice to not insert crocks in add_path(), I've instead introduced a noopjoin path type which ignores its inner side. This could possibly be simplified to just a ...
    Robert HaasRobert Haas
    Sep 6, 2009 at 3:16 am
    Sep 19, 2009 at 5:49 pm
  • Hello The origin of this petition is an error produced today by a user on one of our systems. Because of this error many users lost access to their databases. Problem: - -------- If you define in ...
    Rafael MartinezRafael Martinez
    Sep 9, 2009 at 1:46 pm
    Feb 23, 2010 at 9:32 pm
  • Hi, With PG84, I have tried something like this which seem incorrect to me. # SELECT '' AS to_number_2, to_number('-347,58', '99G999'); to_number_2 | to_number -------------+----------- (1 row) After ...
    Jeevan ChalkeJeevan Chalke
    Sep 18, 2009 at 9:47 am
    Feb 23, 2010 at 2:17 am
  • I've grown a bit tired of reading the "'DNSServiceRegistrationCreate' is deprecated" warnings in OS X builds, and I'm also wondering whether any of the recently reported problems with Snow Leopard ...
    Tom LaneTom Lane
    Sep 7, 2009 at 3:17 am
    Sep 8, 2009 at 4:13 pm
  • Please try building by hand and examine the files to find out what the conflict is between these declarations. This is really a -hackers question. cheers andrew
    Andrew DunstanAndrew Dunstan
    Sep 7, 2009 at 5:30 pm
    Sep 8, 2009 at 4:48 am
  • Attached patch extends pg_ctl command with init option. pg_ctl -D /var/lib/postgres [-s] init This should replace usage of initdb command which has problematic name as we already discussed several ...
    Zdenek KotalaZdenek Kotala
    Sep 17, 2009 at 7:41 pm
    Dec 10, 2009 at 6:33 am
  • Not sure that this really belongs on pgsql-committers - maybe pgsql-hackers? No matter what scheme PostgreSQL uses for storing the data, there can be underlying file system limitations. One solution, ...
    Mark MielkeMark Mielke
    Sep 12, 2009 at 7:25 pm
    Sep 14, 2009 at 5:14 pm
  • commitfest.postgresql.org is updated, please submit new patches at https://commitfest.postgresql.org/action/commitfest_view/open Initial reviewing assignments have been sent to -rrreviewers. If you ...
    Robert HaasRobert Haas
    Sep 15, 2009 at 1:14 am
    Sep 15, 2009 at 2:16 pm
  • Hum, why is PG doing an (unchecked) atoi on the user specified port rather than leaving it up to getaddrinfo to resolve the port? It would seem to require changing UNIXSOCK_PATH to accept a string as ...
    Sam MasonSam Mason
    Sep 24, 2009 at 7:51 pm
    Sep 27, 2009 at 3:43 am
  • This patch has broken the no-backup property of the scanner, which is an absolutely unacceptable penalty for such a second-order feature. Please fix or revert. Also, it failed to update psql's ...
    Tom LaneTom Lane
    Sep 25, 2009 at 7:40 pm
    Sep 27, 2009 at 3:29 am
  • I was searching info about PgCluster-II yesterday and there is not much information about it. Do can give to me any report of this? Because I need to know the progress of the project. On PgFoundry, ...
    Marcos Luis Ortiz ValmasedaMarcos Luis Ortiz Valmaseda
    Sep 15, 2009 at 11:30 am
    Sep 20, 2009 at 10:35 am
  • Hackers, Per discussions on two other threads on this list which have apparently reached consensus, we will be going with the following schedule: CF1 7/15 to 8/14 Alpha1 by 8/20 CF2 9/15 to 10/14 ...
    Josh BerkusJosh Berkus
    Sep 2, 2009 at 11:43 pm
    Sep 19, 2009 at 3:43 pm
  • Hi, we have updated our patchset to current 8.5 CVS. The actual patches will be in emails coming as answers to this one. As two patches were already included, the remaining patches are as follows: 1. ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Sep 3, 2009 at 1:21 pm
    Sep 18, 2009 at 7:55 am
  • Attached is a patch to add a couple basic dependency look-up capability functions. They're based off the pg_get_serial_sequence function, and are kind of the inverse of that function in some ...
    Josh WilliamsJosh Williams
    Sep 4, 2009 at 12:46 am
    Feb 23, 2010 at 2:55 am
  • I've done a little experiment with bulk inserts. = heap_bulk_insert() Behaves like heap_insert except it takes an array of tuples (HeapTuple *tups, int ntups). - Grabs a page (same as heap_insert) - ...
    Pierre Frédéric CaillaudPierre Frédéric Caillaud
    Sep 14, 2009 at 2:26 pm
    Sep 25, 2009 at 1:56 pm
  • Folks, Here's what came out for Mozilla, which, I hope you'll pardon my saying so, is a teensy tad more widely used than PostgreSQL has any plans to become. ...
    David FetterDavid Fetter
    Sep 19, 2009 at 1:14 am
    Sep 22, 2009 at 2:33 pm
  • Hackers, I've just had a feature request from a client that we come up with a way to enable JSON input into hstore. This would make hstore much more useful for software developers. First question: ...
    Josh BerkusJosh Berkus
    Sep 14, 2009 at 10:15 pm
    Sep 15, 2009 at 12:35 am
  • Building plperl in CVS HEAD, the link step looks like this: gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing ...
    Tom LaneTom Lane
    Sep 8, 2009 at 3:13 am
    Sep 8, 2009 at 7:30 pm
  • In joinpath.c, match_unsorted_outer() considers materializing the inner side of each nested loop if the inner path is not an index scan, bitmap heap scan, tid scan, material path, function scan, CTE ...
    Robert HaasRobert Haas
    Sep 5, 2009 at 1:02 am
    Sep 12, 2009 at 10:14 pm
  • Following a discussion on the pgsql-admin list < http://archives.postgresql.org/pgsql-admin/2009-09/msg00075.php , I have created a patch to (optionally) allow PostgreSQL to do a LDAP search to ...
    Robert FlemingRobert Fleming
    Sep 17, 2009 at 4:03 pm
    Dec 12, 2009 at 9:36 pm
  • Crap, I just realized I sent to pgadmin hackers by mystake. Meh. Our documentation for COPY (http://www.postgresql.org/docs/8.4/static/sql-copy.html) has the following to say: " The CSV format has no ...
    Magnus HaganderMagnus Hagander
    Sep 3, 2009 at 7:52 am
    Sep 17, 2009 at 9:50 pm
Group Navigation
period‹ prev | Sep 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions121
posts1,990
users147
websitepostgresql.org...
irc#postgresql

147 users for September 2009

Tom Lane: 346 posts Robert Haas: 216 posts Andrew Dunstan: 89 posts Alvaro Herrera: 86 posts Peter Eisentraut: 78 posts Pavel Stehule: 63 posts Heikki Linnakangas: 61 posts Josh Berkus: 57 posts Jeff Davis: 54 posts Simon Riggs: 50 posts David E. Wheeler: 48 posts Kevin Grittner: 43 posts Magnus Hagander: 39 posts Itagaki Takahiro: 36 posts David Fetter: 35 posts Emmanuel Cecchet: 35 posts Hannu Krosing: 27 posts Stephen Frost: 25 posts Dimitri Fontaine: 23 posts Andrew Gierth: 20 posts
show more
Archives