FAQ

Search Discussions

162 discussions - 2,641 posts

  • This patch is still a few bricks shy of a load ... within a few moments of starting to look at it I'd noticed two different failure conditions regression=# \d box_tbl Table "public.box_tbl" Column | ...
    Tom LaneTom Lane
    Jan 23, 2009 at 6:28 pm
    Feb 26, 2009 at 4:09 pm
  • I have re-reviewed the SE-PostgreSQL patch set. I don't want to talk about here whether the security model is appropriate, how foreign keys are to be handled etc. I want to discuss that I really ...
    Peter EisentrautPeter Eisentraut
    Jan 28, 2009 at 10:18 am
    Mar 18, 2009 at 1:07 am
  • I am using a library that links with and initializes libcrypto (ie. CRYPTO_set_locking_callback) but not SSL. This causes problems even when using PQinitSSL(FALSE) because things like ...
    Andrew ChernowAndrew Chernow
    Jan 29, 2009 at 8:12 pm
    Mar 31, 2009 at 1:49 am
  • Recovery doesn't have a test framework as yet. I would like to add one for this release, especially since we have so much recovery-related code being added to the release (and manual testing is so ...
    Simon RiggsSimon Riggs
    Jan 11, 2009 at 4:34 pm
    Jan 13, 2009 at 3:03 pm
  • The current project is not in good shape. Feature freeze is coming and nothing is committed. Currently there are three patches in the game: 1) Space reservation ...
    Zdenek KotalaZdenek Kotala
    Jan 27, 2009 at 1:44 pm
    Feb 13, 2009 at 1:11 pm
  • I've been reviewing and massaging the so called recovery infra patch. To recap, the goal is to: - start background writer during (archive) recovery - skip the shutdown checkpoint at the end of ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 28, 2009 at 10:05 am
    Feb 26, 2009 at 7:59 pm
  • Latest version of Hot Standby includes new deferred cancellation for conflict resolution and further refactoring. http://wiki.postgresql.org/wiki/Hot_Standby#Usage [Please note that max_standby_delay ...
    Simon RiggsSimon Riggs
    Jan 22, 2009 at 10:33 pm
    Feb 3, 2009 at 5:16 pm
  • Here it is gzip'd since I'm afraid the last might not have made it through due to size.. Stephen
    Stephen FrostStephen Frost
    Jan 2, 2009 at 11:11 pm
    Jan 15, 2009 at 4:22 pm
  • WSACleanup is not really needed during a PQfinish. Its horribly slow if the library ref count is 0 and it actually unloads the winsock library, adds 225ms to PQfinish. Solution: A) Call WSAStartup ...
    Andrew ChernowAndrew Chernow
    Jan 15, 2009 at 10:18 pm
    Feb 6, 2009 at 7:24 pm
  • I just did a fresh import of my alpha database into 8.4 and noticed that the size of the database had increased significantly: 8.4: 6.3G 8.3: 4.9G Tracking it down the main difference seems to a ...
    Alex HunsakerAlex Hunsaker
    Jan 2, 2009 at 4:31 am
    Jan 7, 2009 at 2:45 pm
  • Where I work they make extensive use of Postgresql. One of the things they typically want to know about are lock waits. Out of the box in there is not much in the way of tracking for such, ...
    Mark KirkwoodMark Kirkwood
    Jan 25, 2009 at 11:58 pm
    Mar 1, 2010 at 6:53 am
  • Hi, I have been testing in recent, the Synch Replication(Synch rep 0114 (Jan 14, 2009) ) on PostgreSQL version 8.4 (postgresql-8.4devel_20081229.tar.bz2) I followed the steps in Readme as well used ...
    Smitap3Smitap3
    Jan 30, 2009 at 11:32 am
    Apr 23, 2009 at 2:29 pm
  • Something happened about 80 hours ago that caused my mingw buildfarm member (gcc 3.4.2 on Win XP Pro SP2) to hang at the check stage. It looks like it's hung in initdb. I wonder if it could be this ...
    Andrew DunstanAndrew Dunstan
    Jan 24, 2009 at 11:50 pm
    Feb 12, 2009 at 12:54 pm
  • Howdy, Is it intentional that `LIMIT NULL` means the same as `LIMIT ALL`? If so, I'd like to submit a patch to document it, because I've found it useful in SQL functions: ...
    David E. WheelerDavid E. Wheeler
    Jan 31, 2009 at 10:28 pm
    Feb 7, 2009 at 9:35 pm
  • This post is a follow-up of an off-list discussion with Nathan Boley. All references to FOR UPDATE apply to FOR SHARE as well. create table a(i int, j int); insert into a values(1, 10); insert into a ...
    Jeff DavisJeff Davis
    Jan 24, 2009 at 6:50 pm
    Feb 4, 2009 at 5:47 pm
  • I asked the author of the QuickLZ algorithm about licensing... Sounds like he is willing to cooperate. This is what I got from him: -- Sincerely, Stephen R. van den Berg.
    Stephen R. van den BergStephen R. van den Berg
    Jan 5, 2009 at 1:30 am
    Jan 6, 2009 at 3:12 pm
  • The foreign_data test case is failing when I run "make installcheck" against a server that's been initialized with a locale other than C (en_GB.UTF-8). The reason is the different ordering of upper ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 9, 2009 at 2:12 pm
    Feb 2, 2009 at 7:51 am
  • The attached patch from Aidan Van Dyk zeros out the end of WAL files to improve their compressibility. (The patch was originally sent to 'general' which explains why it was lost until now.) Would ...
    Bruce MomjianBruce Momjian
    Jan 8, 2009 at 9:39 pm
    Jan 10, 2009 at 1:35 am
  • I can see two ways forward: 1) We document bluntly that ORDER BY + FOR UPDATE can return unordered results, or 2) We prohibit ORDER BY + FOR UPDATE, like we do with a number of other clauses. (There ...
    Peter EisentrautPeter Eisentraut
    Jan 12, 2009 at 1:27 pm
    Jan 22, 2009 at 10:58 pm
  • I've mentioned before that I don't like the slotid stuff. From an architectural point of view, we should try to keep the extra communication between primary and standby to a minimum, for the sake of ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 8, 2009 at 6:30 pm
    Jan 16, 2009 at 12:54 am
  • I am now warning that we have an unusually large number of open items that must be either completed or moved to the TODO list before 8.4 can be released. Everyone knows about the commit fest wiki ...
    Bruce MomjianBruce Momjian
    Jan 6, 2009 at 3:21 pm
    Jan 9, 2009 at 1:21 am
  • Based on the comments below, are we sure constraint_exclusion still needs to be a parameter and can't be on by default? --------------------------------------------------------------------------- ...
    Bruce MomjianBruce Momjian
    Jan 7, 2009 at 5:16 am
    Jan 8, 2009 at 5:35 am
  • I have recently fixed the configure script to recognize Python 3.0. But note that building and running PL/Python with Python 3.0 does not actually work. It looks like several symbols have been ...
    Peter EisentrautPeter Eisentraut
    Jan 8, 2009 at 9:38 am
    May 29, 2009 at 10:52 pm
  • Hello, O.k. so I admit I probably should have known this already but I didn't. Normally I setup logging to use -%a.log. However I had a requirement today that is having me setup a flat filename... as ...
    Joshua D. DrakeJoshua D. Drake
    Jan 13, 2009 at 8:39 pm
    Feb 24, 2009 at 12:10 pm
  • All, Attached is an updated patch for column-level privileges. This is a very minor change to use get_rel_name(), so the main point of this is to update the general community on the status of the ...
    Stephen FrostStephen Frost
    Jan 16, 2009 at 4:58 am
    Feb 7, 2009 at 1:36 am
  • I attached second version of space reservation patch. You can see first version here: http://archives.postgresql.org/pgsql-hackers/2008-12/msg00886.php I thought about Heikki'es comments and I ...
    Zdenek KotalaZdenek Kotala
    Jan 27, 2009 at 12:06 pm
    Feb 2, 2009 at 5:54 pm
  • As the patch stands, there's no way to disable hot standby. The server always opens for read-only connections as soon as it can. That might not be what you want. I think we need a GUC to ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 23, 2009 at 8:35 am
    Feb 2, 2009 at 10:43 am
  • AIX 4.3 was released in late 1999, so I thought it was worth mentioning. I only have AIX 4.3 and 6.1, so I have no idea how AIX 5 handles this. AIX 6.1 works fine. Anyways, the service argument to ...
    Andrew ChernowAndrew Chernow
    Jan 23, 2009 at 2:18 pm
    Jan 23, 2009 at 9:13 pm
  • This is V4 patch to improve file read during startup for review. Basic algorithm is same as V3 but works with Gregory's fadvise patch. ...
    Koichi SuzukiKoichi Suzuki
    Jan 12, 2009 at 1:21 pm
    Mar 16, 2009 at 12:39 pm
  • Hey folks, I am trying to add "GRANT SELECT ON ALL TABLES" to postgres, as it has been quite few times now - where I had to write a procedure for that. I kind of looked around, and more or less know ...
    Grzegorz JaskiewiczGrzegorz Jaskiewicz
    Jan 31, 2009 at 4:47 pm
    Feb 3, 2009 at 3:43 pm
  • Attached are patches to fix the following compiler warnings that I see when using gcc 4.3.2. MASTER warning: tablecmds.c: In function 'DropErrorMsgWrongType': tablecmds.c:601: warning: format not a ...
    Alan LiAlan Li
    Jan 17, 2009 at 9:44 am
    Jan 21, 2009 at 10:30 am
  • http://wiki.postgresql.org/wiki/Hot_Standby v8 - resolves a dozen minor issues. Dev build with various debugging enabled. Expect clean v10 on Friday. All outstanding items from emails now listed on ...
    Simon RiggsSimon Riggs
    Jan 14, 2009 at 11:55 pm
    Jan 19, 2009 at 3:27 pm
  • Now that we are two months into the final commit fest, it is time to finalize all the open patches so we can target a February beta. The two major outstanding patches are: o SE-PostgreSQL: The author ...
    Bruce MomjianBruce Momjian
    Jan 4, 2009 at 3:34 am
    Jan 24, 2009 at 11:44 pm
  • Hi,, My job, I maintainer some postgres server for clients. We have many PL/(Java, Perl, Ruby, Python, R) and to more easy administration, I worked new little psql attribute to list languages com ...
    Fernando IkeFernando Ike
    Jan 30, 2009 at 5:34 pm
    Jul 28, 2009 at 12:18 pm
  • Quick patch to mention CITEXT in the parts of the FAQ that discuss case-insensitive comparisons. Best, David
    David E. WheelerDavid E. Wheeler
    Jan 8, 2009 at 6:28 pm
    Jul 1, 2009 at 4:33 pm
  • IMO, composite types on insert/update should work as they do on select: SELECT foo FROM foo; -- works, returning type foo INSERT INTO foo VALUES '(something)'::foo -- fails, but we have a workaround: ...
    Merlin MoncureMerlin Moncure
    Jan 28, 2009 at 5:04 pm
    Jan 30, 2009 at 9:50 pm
  • Attached is a patch that adds a namespace capability to reloptions. It works this way: alter table foo set (namespace.option = value) Currently the only namespace that does anything is "toast". What ...
    Alvaro HerreraAlvaro Herrera
    Jan 13, 2009 at 11:27 pm
    Feb 3, 2009 at 5:53 pm
  • The hot standby patch has some hacks to decide which full-page-images can be restored holding an exclusive lock and which ones need a vacuum-strength lock. It's not very pretty as is, as mentioned in ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 9, 2009 at 4:31 pm
    Jan 20, 2009 at 7:56 pm
  • Hey all, I recently had pg_dump produce a non-restorable dump for one of my databases. I can't share the dump itself, but I can describe what went wrong. This database had a user-defined composite ...
    Brendan JurdBrendan Jurd
    Jan 15, 2009 at 9:07 pm
    Jan 18, 2009 at 9:30 pm
  • In thinking about how to communicate to users about reducing continuous archiving storage requirements, I realized we don't mention pglesslog in our official documentation. The attached patch ...
    Bruce MomjianBruce Momjian
    Jan 11, 2009 at 2:10 am
    Jan 15, 2009 at 1:21 am
  • This is a proposed patch to document disabling the statistics collector pg_dump activity, and give a bit more visibility to the PGOPTIONS environment variable supported by libpq. It is an alternative ...
    Bryce NesbittBryce Nesbitt
    Jan 21, 2009 at 1:22 am
    Feb 10, 2009 at 12:56 am
  • Q1: select '' union all select '' Q2: select '' union all select * from (select '' ) as s version: PostgreSQL 8.3.1, compiled by Visual C++ build 1400 Hi All, Q1 works just fine, but Q2 fails with: ...
    Gurjeet SinghGurjeet Singh
    Jan 6, 2009 at 6:23 am
    Jan 6, 2009 at 10:14 pm
  • I just noticed these warnings on pgevent/mingw. I guess we've probably been living with it for years, but it would be nice to get it clean. (There are also some similar warnings earlier in the build ...
    Andrew DunstanAndrew Dunstan
    Jan 31, 2009 at 2:08 pm
    Feb 3, 2009 at 2:58 pm
  • The attached patch adds support for the Windows 7 beta which we've had a few reports of incompatibility with. When we startup using pg_ctl on Windows, we create a job object (a logical grouping of ...
    Dave PageDave Page
    Jan 27, 2009 at 10:35 am
    Jan 28, 2009 at 11:19 am
  • You mean like this? fprintf(output, _("Informational\n")); fprintf(output, _(" Modifiers: S = show system objects + = Additional detail\n")); fprintf(output, _(" \\l[+] list all databases\n")); ...
    Bruce MomjianBruce Momjian
    Jan 6, 2009 at 11:22 pm
    Jan 7, 2009 at 3:29 am
  • Hi, We are implementing table partitioning feature to support - the attached commands. The syntax conforms to most of the suggestion mentioned in ...
    Amit GuptaAmit Gupta
    Jan 22, 2009 at 12:38 pm
    Feb 10, 2009 at 3:02 pm
  • Dear All, I apologize if this has been discussed before. I have tried to search to the mailing list and could not find an exact answer. Currently, Postgres uses Knuth's Algorithm 5.4.2D to perform ...
    Don MarvickDon Marvick
    Jan 29, 2009 at 8:11 am
    Feb 5, 2009 at 2:54 am
  • Should this consider the distdir target in /GNUmakefile.in too? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
    Alvaro HerreraAlvaro Herrera
    Jan 15, 2009 at 12:54 am
    Jan 15, 2009 at 3:18 am
  • Hi, I attached the updated version of Synch Rep patch (v5) on wiki. The description of "User Overview" is also already updated. http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#Synch_Rep ...
    Fujii MasaoFujii Masao
    Jan 10, 2009 at 10:17 am
    Jan 14, 2009 at 2:41 am
  • I have updated all the source files for a 2009 copyright; seems the commit message was suppressed due to its size. Tom found a few more and I have adjusted for those as well. -- Bruce Momjian ...
    Bruce MomjianBruce Momjian
    Jan 1, 2009 at 6:25 pm
    Jan 2, 2009 at 4:00 am
Group Navigation
period‹ prev | Jan 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions162
posts2,641
users142
websitepostgresql.org...
irc#postgresql

142 users for January 2009

Tom Lane: 361 posts Bruce Momjian: 225 posts Simon Riggs: 210 posts Heikki Linnakangas: 148 posts Robert Haas: 133 posts Peter Eisentraut: 106 posts Alvaro Herrera: 103 posts Magnus Hagander: 79 posts Stephen Frost: 77 posts Greg Stark: 73 posts Joshua D. Drake: 62 posts Andrew Dunstan: 61 posts KaiGai Kohei: 61 posts Josh Berkus: 47 posts Andrew Chernow: 43 posts Jeff Davis: 39 posts Kevin Grittner: 38 posts Zdenek Kotala: 32 posts Dave Page: 31 posts Jaime Casanova: 28 posts
show more
Archives