FAQ

Search Discussions

73 discussions - 445 posts

  • Ok people, Here I present the nested transactions patch and the phantom Xids patch that goes with it. Please review, test and comment. Missing: rollback of SET CONSTRAINTS and GUC vars. -- Alvaro ...
    Alvaro HerreraAlvaro Herrera
    Jun 18, 2004 at 1:33 am
    Jun 30, 2004 at 2:32 am
  • Per previous patch, win32 required the check for admin privs to be moved from main.c into postmaster.c, because elog was not available at this time. While working on fixing that all the way (moving ...
    Magnus HaganderMagnus Hagander
    Jun 14, 2004 at 8:49 pm
    Jun 24, 2004 at 9:16 pm
  • Gavin SherryGavin Sherry
    Jun 30, 2004 at 2:19 pm
    Jul 12, 2004 at 4:24 am
  • This applied patch changes the way pg_ctl starts on Win32. Using START, it is not possible to quote the executable name, who's directory might have spaces: START /B /program files/x.exe The fix is to ...
    Bruce MomjianBruce Momjian
    Jun 11, 2004 at 1:00 am
    Jun 16, 2004 at 2:50 am
  • I have make the changes suggested after I posted my last patch, I have also make several additional improvements. it needs to be tested more, but since the deadline is coming up so soon, I wanted to ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jun 29, 2004 at 2:44 pm
    Jul 17, 2004 at 4:09 pm
  • The attached patch includes serverlog rotation with minimal shared memory usage as discussed and functions to access it. Regards, Andreas
    Andreas PflugAndreas Pflug
    Jun 28, 2004 at 10:55 am
    Jul 15, 2004 at 2:56 pm
  • Hello, The purpose of this patch is to fix an error when log_destination is set to 'eventlog' value in postgresql.conf files. If you launch postmaster and see after fir log in windows event report ...
    Laurent BallesterLaurent Ballester
    Jun 1, 2004 at 10:37 pm
    Jun 20, 2004 at 9:29 am
  • The attached patch (and 2 new files incorporating previous eloglvl.[ch] as before) has the following changes over previously sent patch (fixes all by me): - fix null <- undef mappings - fix ...
    Andrew DunstanAndrew Dunstan
    Jun 30, 2004 at 8:14 pm
    Jul 1, 2004 at 8:38 pm
  • Hackers, Here is the latest installment of the nested transactions patch. What's in the current patch: - transaction block support. The user can start subtransactions inside each transaction block ...
    Alvaro HerreraAlvaro Herrera
    Jun 8, 2004 at 10:24 pm
    Jun 18, 2004 at 11:30 pm
  • Since I believe that retrieving the logs easily without server file access is a feature that's welcomed by many users, here's my proposal. The attached diff will - add a guc-variable log_filename - ...
    Andreas PflugAndreas Pflug
    Jun 8, 2004 at 6:27 pm
    Jun 19, 2004 at 3:05 am
  • An untested patch to update the password file. Something that bugged me a lot is that I tried to find the format of the file for testing the patch, and I couldn't find anything anywhere in the docs. ...
    Alvaro HerreraAlvaro Herrera
    Jun 27, 2004 at 10:49 pm
    Jul 12, 2004 at 7:56 pm
  • From an idea of Bruce, the attached patch implements the function pg_tablespace_databases(oid) RETURNS SETOF oid which delivers as set of database oids having objects in the selected tablespace, ...
    Andreas PflugAndreas Pflug
    Jun 28, 2004 at 11:24 am
    Jul 6, 2004 at 3:00 pm
  • Here is an updated version of your patch. I removed the tablespace part because we are going to have real tablespaces in 7.5 rather than initlocation hacks. I added documention of the new guc ...
    Bruce MomjianBruce Momjian
    Jun 2, 2004 at 8:40 pm
    Jul 11, 2004 at 12:19 am
  • Does this: The files belonging to this database system will be owned by user "chriskl". This user must also own the server process. The database cluster will be initialized with locale C. The ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 21, 2004 at 6:50 am
    Jul 5, 2004 at 1:29 pm
  • Hi, This patch adds the following options to pg_dumpall, to be passed to pg_dump: -S, --superuser=NAME -O, --no-owner -X disable-dollar-quoting, --disable-dollar-quoting -X disable-triggers, ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 25, 2004 at 6:32 am
    Jul 19, 2004 at 9:38 pm
  • L.S., I've made a patch against PostgreSQL 7.4.3 to be able to compile 'libpq' and 'psql' with Digital Mars C++. As Digital Mars C++ doesn't support 'popen()' and 'pclose()' calls yet, I was in need ...
    Hans Oesterholt-DijkemaHans Oesterholt-Dijkema
    Jun 23, 2004 at 9:41 am
    Jul 10, 2004 at 5:37 am
  • Hi, The win32 port doesn't have a native user space spinlock implementation yet. Attached is an untested patch - could someone test it? I don't have Visual C++. -- Manfred
    Manfred SpraulManfred Spraul
    Jun 30, 2004 at 5:19 pm
    Jul 10, 2004 at 1:32 am
  • I enclose a working set of context diff patches and new files to make PITR archiving work, as of cvstip (NOW). You'll see the new options in the postgresql.conf...though you may wish to use ...
    Simon RiggsSimon Riggs
    Jun 15, 2004 at 3:34 pm
    Jun 25, 2004 at 8:57 pm
  • Kris JurkaKris Jurka
    Jun 24, 2004 at 12:27 pm
    Jul 21, 2004 at 1:35 am
  • PITR Archive Recovery, 28 June 2004 What's in this patch? - All of what was in previous PITR Archival patch, including reworking of all the archiver startup/shutdown code to match that of pgstat - ...
    Simon RiggsSimon Riggs
    Jun 28, 2004 at 8:59 pm
    Jul 2, 2004 at 7:27 am
  • Here's a rough first cut, close to application state but not a finished work. Might be pushed for time over the next week, so if there are major criticisms it might need someone else to pick this up ...
    Claudio NatoliClaudio Natoli
    Jun 16, 2004 at 1:48 pm
    Jun 24, 2004 at 6:38 pm
  • Fabien COELHOFabien COELHO
    Jun 8, 2004 at 2:00 pm
    Jun 10, 2004 at 3:50 am
  • Dennis BjorklundDennis Bjorklund
    Jun 30, 2004 at 1:18 pm
    Jul 13, 2004 at 4:51 pm
  • Gavin SherryGavin Sherry
    Jun 24, 2004 at 10:31 am
    Jul 13, 2004 at 3:06 am
  • I know it's late in the day, but ... Attached is a patch and 2 replacement files for plperl. The work has been done under the auspices of the plperlng project on pgfoundry. The code (which has been ...
    Andrew DunstanAndrew Dunstan
    Jun 27, 2004 at 2:14 pm
    Jun 29, 2004 at 9:52 pm
  • Ok, I have an 1st cut patch for pg_autovacuum integration into the backend. Please apply this patch to CVS or at least review and let me know what I need to change to get it applied to CVS. This ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jun 16, 2004 at 6:19 am
    Jun 16, 2004 at 2:20 pm
  • The comment describing cost_nonsequential_access() says that the two functions "meet in the middle". They meet at random_page_cost/2, however, not in the middle between 1 and random_page_cost. For ...
    Manfred KoizarManfred Koizar
    Jun 8, 2004 at 8:14 am
    Jun 8, 2004 at 7:50 pm
  • This patch fixes strerror_r() by checking the return type from configure. --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Jun 7, 2004 at 10:39 pm
    Jun 8, 2004 at 1:46 am
  • The following patch adds start/stop times for pg_dump and pg_dumpall when verbose output is selected: -- -- PostgreSQL database cluster dump -- Started on 2004-06-04 01:01:35 EDT -- -- -- PostgreSQL ...
    Bruce MomjianBruce Momjian
    Jun 4, 2004 at 5:03 am
    Jun 5, 2004 at 4:57 am
  • Dear patchers, I have two minor patches that are being submitted but which do not appear yet in the "official" patch queue on the web site: http://momjian.postgresql.org/cgi-bin/pgpatches I ...
    Fabien COELHOFabien COELHO
    Jun 30, 2004 at 11:34 am
    Jun 30, 2004 at 3:21 pm
  • OK, looks like the error below is a Win32 thing. The patch attached #ifdef'd out the permissions check on the private key file as it won't work under Windows anyway (a similar check in postmaster.c ...
    Dave PageDave Page
    Jun 20, 2004 at 9:15 pm
    Jun 25, 2004 at 3:10 pm
  • Dennis BjorklundDennis Bjorklund
    Jun 24, 2004 at 10:05 pm
    Jun 25, 2004 at 5:40 am
  • OK, that cured that one - thanks. The current solution does an "rmdir /q /s $PGDATA" if the datadir was created, and "del /q /s $PGDATA" if the directory already existed. The second case will not ...
    Dave PageDave Page
    Jun 19, 2004 at 10:04 pm
    Jun 20, 2004 at 8:33 am
  • The attached patch adds some index entries pointing to the cursor reference pages. Please apply. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl ) Thou shalt study thy libraries and strive not to ...
    Alvaro HerreraAlvaro Herrera
    Jun 17, 2004 at 3:46 am
    Jun 17, 2004 at 2:20 pm
  • It certainly doesn't. There still was a bug with the locale stuff, though - the GUC variable was not set in the child processes. So "show lc_collate" would *always* return "C", for example. attached ...
    Magnus HaganderMagnus Hagander
    Jun 7, 2004 at 7:24 pm
    Jun 11, 2004 at 3:54 am
  • I have been working on integrating pg_autovacuum into the backend. I have used Tom's recent work on the bgwriter as an example. This patch accomplishes the following: * pg_autovacuum is now started ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jun 7, 2004 at 5:39 am
    Jun 8, 2004 at 6:45 pm
  • Here is a trivial fix for some error messages that was not translated before. I've also gotten rid of some cut and paste of strings. That doesn't always work (like in this case) when translating. -- ...
    Dennis BjorklundDennis Bjorklund
    Jun 27, 2004 at 7:39 am
    Jul 29, 2004 at 2:50 pm
  • Hi, This is the final patch that adds OWNER TO commands to every object. This includes tablespaces. I have also added RENAME TO on tablespaces. Full docs changes are included (+ 3 new files that must ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 23, 2004 at 4:49 am
    Jul 11, 2004 at 1:01 pm
  • Fabien COELHOFabien COELHO
    Jun 25, 2004 at 2:19 pm
    Jul 2, 2004 at 3:39 pm
  • Gavin SherryGavin Sherry
    Jun 20, 2004 at 2:31 am
    Jun 20, 2004 at 12:58 pm
  • Hi, Here are some updates for REL7_4. Please apply it before release 7.4.3. http://www.ufgnet.ufg.br/euler/pg_update_7_4_3.tar.gz Regards, -- Euler Taveira de Oliveira euler (at) ufgnet.ufg.br ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Jun 9, 2004 at 9:47 pm
    Jun 11, 2004 at 5:49 pm
  • While trying to pg_constraint JOIN pg_index ON indrelid=conrelid AND conkey=indkey I noticed (once again) that these columns have different types (although describing the same thing), and there's no ...
    Andreas PflugAndreas Pflug
    Jun 6, 2004 at 11:31 pm
    Jun 7, 2004 at 8:08 am
  • OK, This version works wonderfully on my production database. Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 29, 2004 at 3:57 am
    Jul 13, 2004 at 2:59 am
  • Sorry - the last version didn't make all the necessary doc changes. Apply this instead. Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 28, 2004 at 5:59 am
    Jul 12, 2004 at 8:23 pm
  • Hi, win32 doesn't support a static initializer for mutexes, thus the first user must initialize the lock. The problem are concurrent "first" users - the pthread_mutex_t initialization must be ...
    Manfred SpraulManfred Spraul
    Jun 30, 2004 at 5:25 pm
    Jul 12, 2004 at 2:23 pm
  • Pavel StehulePavel Stehule
    Jun 23, 2004 at 7:24 pm
    Jul 6, 2004 at 2:21 am
  • Here's a patch dealing with the unchecked mallocs and strdups in guc.c. Rather than mixing in palloc and TopMemoryContext into the code (would be rather messy given that most allocs actually falls ...
    Thomas HallgrenThomas Hallgren
    Jun 27, 2004 at 7:14 pm
    Jul 5, 2004 at 11:15 pm
  • Gavin SherryGavin Sherry
    Jun 23, 2004 at 8:00 am
    Jul 5, 2004 at 8:10 pm
  • Hi, This patch fixes pg_dump for the existing ownership and acl problems. It does not address the known damaged acls after an ownership change. It's hacky (although officially hacky :) ) in regards ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 29, 2004 at 2:11 am
    Jun 29, 2004 at 2:55 am
  • Corrects a wrong filename separation. Please apply. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl ) You liked Linux a lot when he was just the gawky kid from down the block mowing your lawn or ...
    Alvaro HerreraAlvaro Herrera
    Jun 27, 2004 at 10:43 pm
    Jun 27, 2004 at 10:59 pm
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouppgsql-patches @
categoriespostgresql
discussions73
posts445
users35
websitepostgresql.org
irc#postgresql

35 users for June 2004

Bruce Momjian: 103 posts Tom Lane: 88 posts Andreas Pflug: 31 posts Alvaro Herrera: 25 posts Andrew Dunstan: 22 posts Magnus Hagander: 20 posts Simon Riggs: 20 posts Christopher Kings-Lynne: 18 posts Dave Page: 18 posts Gavin Sherry: 14 posts Peter Eisentraut: 11 posts Fabien COELHO: 9 posts Matthew T. O'Connor: 7 posts Dennis Bjorklund: 6 posts Euler Taveira de Oliveira: 6 posts Laurent Ballester: 6 posts Serguei Mokhov: 6 posts Manfred Koizar: 5 posts Claudio Natoli: 4 posts Manfred Spraul: 4 posts
show more
Archives