FAQ

Search Discussions

44 discussions - 216 posts

  • Following patch is a minor addition to postgres.c that allows the two existing statement logging techniques to work with V3 exec. This then allows statement logging with PostgreSQL 8.0+ for JDBC and ...
    Simon RiggsSimon Riggs
    Apr 11, 2005 at 9:43 pm
    May 24, 2005 at 4:18 am
  • This patch is a cleaned up version of Euler Taveira de Oliveira's patch implementing DELETE ... USING. I removed a bunch of unused code (no need to tlist transformations), updated ...
    Neil ConwayNeil Conway
    Apr 4, 2005 at 10:16 am
    Apr 9, 2005 at 4:14 am
  • During recent tuning of the TPC-C workload, I produced the following patch to force COPY to leave some space in each data block when it loads data into heap relations. Rationale for this was to ...
    Simon RiggsSimon Riggs
    Apr 12, 2005 at 8:03 am
    Apr 20, 2005 at 4:09 pm
  • The chance that num_held_lwlocks is beyond MAX_SIMUL_LWLOCKS is similar to the chance that failed to grasp a spinlock in 1 minute, so they should be treated in the same way. This is mainly to prevent ...
    Qingqing ZhouQingqing Zhou
    Apr 8, 2005 at 2:23 am
    Apr 9, 2005 at 5:26 am
  • I finally got it working. I had to make major changes to the build file. The new attached bcc32.mak should build on your 8.0.X system, and this file will be in 8.0.3. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Apr 29, 2005 at 4:23 am
    May 1, 2005 at 4:26 am
  • Pavel StehulePavel Stehule
    Apr 19, 2005 at 1:41 pm
    May 26, 2005 at 11:00 am
  • The example given in create domain seems to be broken. ISTM it requires some extra escaping to be usable (at least in my goings on today it sure was, and I the entries in pg_constraint sure seem to ...
    Robert TreatRobert Treat
    Apr 30, 2005 at 10:12 pm
    May 2, 2005 at 1:57 am
  • Here is a reformatting of the VACUUM VERBOSE FSM output so it outputs from a single INFO output command: INFO: free space map contains information about: 49 relations, limit 1000 relations 35 pages ...
    Bruce MomjianBruce Momjian
    Apr 23, 2005 at 8:55 pm
    Apr 24, 2005 at 3:51 am
  • WIP patch to perform a switch from one log file to next when we do a pg_stop_backup(), including wal replay handling at recovery time. Patch currently crashes server at various points, so don't stare ...
    Simon RiggsSimon Riggs
    Apr 19, 2005 at 6:47 pm
    Jul 29, 2005 at 3:22 pm
  • Some minor updates to comments.
    Simon RiggsSimon Riggs
    Apr 21, 2005 at 11:38 pm
    Apr 24, 2005 at 3:34 pm
  • This patch changes int2_avg_accum() and int4_avg_accum() use the nodeAgg performance hack Tom introduced recently. This means we can avoid copying the transition array for each input tuple if these ...
    Neil ConwayNeil Conway
    Apr 4, 2005 at 11:19 am
    Apr 6, 2005 at 11:56 pm
  • Hackers, Here is another attempt at the shared locks patch. This is a radically different approach, using Xmax in the tuples and SLRU areas instead of the lock manager. The idea is that a tuple's ...
    Alvaro HerreraAlvaro Herrera
    Apr 18, 2005 at 11:23 pm
    Apr 24, 2005 at 7:16 pm
  • I have trouble understanding the current output of VACUUM VERBOSE when it displays FSM information. The current output is: INFO: free space map: 49 relations, 17266 pages stored; 18768 total pages ...
    Bruce MomjianBruce Momjian
    Apr 23, 2005 at 4:23 am
    Apr 23, 2005 at 6:13 pm
  • In SQL that uses 'like' operator, wchareq is used to compare character. At the head of wchareq, length of character is compared by using pg_mblen. Therefore, pg_mblen is executed many times, and it ...
    A_ogawaA_ogawa
    Apr 12, 2005 at 2:10 pm
    May 26, 2005 at 2:00 pm
  • This patch fixes a bug in the error message emitted by pg_restore on an incorrect -F argument: write_msg() expects its first parameter to be a "module name", not the format string. Patch applied to ...
    Neil ConwayNeil Conway
    Apr 29, 2005 at 7:09 am
    Apr 30, 2005 at 8:04 am
  • I haven't done the work yet to add a column to pg_aggregate, so this just knows about optimizing a couple of hard-wired cases (int4 and text). Other than that it's reasonably complete, I think. ...
    Tom LaneTom Lane
    Apr 11, 2005 at 5:40 am
    Apr 14, 2005 at 9:33 am
  • I have access to a system with locale of UTF-8. cvstip would no longer initdb on this system, as a result of recent renaming of UTF-8 to UTF8. i.e. [userid@systemname ~]$ locale LANG=en_US.UTF-8 ...
    Simon RiggsSimon Riggs
    Apr 11, 2005 at 11:26 pm
    Apr 12, 2005 at 2:53 pm
  • I never heard any discussion on whether this should be backpatched to 8.0.X. Should it? --------------------------------------------------------------------------- pgman wrote: -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Apr 7, 2005 at 7:17 pm
    Apr 7, 2005 at 10:13 pm
  • Quick patch to adress a recent concern on the mailing list about adding an errant "TO" when we already have a TO. Since TO cannot be a valid column name (we must quote it), we can simply ignore the ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 12, 2005 at 3:05 am
    May 25, 2005 at 10:12 pm
  • The original comment of why we are safe without protection of critical section is confusing. Index: xlog.c =================================================================== RCS file: ...
    Qingqing ZhouQingqing Zhou
    Apr 21, 2005 at 10:14 am
    Apr 25, 2005 at 1:42 am
  • Patch applied. Thanks. Sorry for the delay in applying. --------------------------------------------------------------------------- David Fetter wrote: -- Bruce Momjian | http://candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Apr 19, 2005 at 3:37 am
    Apr 19, 2005 at 3:56 am
  • In response to Bruce's recent question, and remembering the recent scolding received about removing a "LEFT" from an unrelated patch :), here's a patch that does that and nothing more: removes all ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 12, 2005 at 3:00 am
    Apr 13, 2005 at 1:22 am
  • This patch updates a number of urls in a number of files. Most are just poinitng to the TODO list within the main website. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    Robert TreatRobert Treat
    Apr 10, 2005 at 4:38 am
    May 11, 2005 at 4:13 pm
  • GCC 4.0 includes a new warning option, -Wformat-literal, that emits a warning when a variable is used as a format string for printf() and similar functions (if the variable is derived from untrusted ...
    Neil ConwayNeil Conway
    Apr 29, 2005 at 8:21 am
    Apr 30, 2005 at 9:10 am
  • I have Postgres 8.0.1 on Solaris 9 Sparc machine running in "usr/local/pgsql" directory and my source is in "postgresql-8.0.1/src/pl/plpgsql/src" directory. In "sqlstate.diff" file it is looking " ...
    Dinesh PandeyDinesh Pandey
    Apr 20, 2005 at 6:24 am
    Apr 20, 2005 at 1:58 pm
  • Hi, I have installed PostgreSQL 8.0.1 on Solaris 9. I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language. In Oracle we can get error message from "SQLERRM" keyword and ...
    Dinesh PandeyDinesh Pandey
    Apr 18, 2005 at 5:20 am
    Apr 18, 2005 at 5:42 am
  • This patch changes the use of varargs.h to stdarg.h as required by GCC. Niels Breet Index: halt.c =================================================================== RCS file: ...
    Niels BreetNiels Breet
    Apr 4, 2005 at 8:23 pm
    Apr 15, 2005 at 4:29 am
  • Remove an unused variable waitingForSignal in /storage/lmgr/proc.c. I guess it was there because orignally PG uses singals to implement ProcWaitForSignal() stuff, so we may need to remember the ...
    Qingqing ZhouQingqing Zhou
    Apr 11, 2005 at 3:12 am
    Apr 15, 2005 at 4:19 am
  • Well, I've re-run the checks several times after a clean make and it does not crash anymore. So the patch seems to help ! Please consider applying it. Regards, Rém Zara -- Rémi Zara ...
    Rémi ZaraRémi Zara
    Apr 14, 2005 at 8:14 pm
    Apr 14, 2005 at 8:54 pm
  • Much to my chagrin, I recently noticed that I forgot to convert the pgstat fork() code to use fork_process() when I applied the original fork_process() patch a few months ago. This patch does that. ...
    Neil ConwayNeil Conway
    Apr 7, 2005 at 7:56 am
    Apr 8, 2005 at 1:00 am
  • Now that DELETE has a USING clause, we should be able to make add_missing_from=false the default in 8.1; the attached patch implements this and updates the documentation. Barring any objections, I'll ...
    Neil ConwayNeil Conway
    Apr 7, 2005 at 7:04 am
    Apr 8, 2005 at 1:00 am
  • Patch to show check information when listing domains via \dD in psql. Per question by Edmund Bacon on the pgsql-general list. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 ...
    Greg Sabino MullaneGreg Sabino Mullane
    Apr 3, 2005 at 1:12 pm
    Apr 6, 2005 at 5:24 am
  • This file was whacked by pgindent before it knew it shouldn't remove braces around single statements (for PG_TRY macros). This patch fixes it. Please apply. Index: ...
    Alvaro HerreraAlvaro Herrera
    Apr 5, 2005 at 7:34 pm
    Apr 6, 2005 at 4:34 am
  • Hi, http://postgresql.gunduz.org/translation/PostgreSQL-8.0/PgSQL-DilDosyalari/initdb-tr.po http://postgresql.gunduz.org/translation/PostgreSQL-8.0/PgSQL-DilDosyalari/libpq-tr.po ...
    Devrim GündüzDevrim Gündüz
    Apr 2, 2005 at 4:16 pm
    Apr 2, 2005 at 6:45 pm
  • Hi, We've updated Turkish Translations for PostgreSQL 8.0.2: http://postgresql.gunduz.org/translation/PostgreSQL-8.0/PgSQL-DilDosyalari/pg_config-tr.po ...
    Devrim GündüzDevrim Gündüz
    Apr 2, 2005 at 1:28 pm
    Apr 2, 2005 at 3:55 pm
  • The following applied patch allows Borland C to build libpq, and improves the structure of the MSC makefile. I almost got BCC to build psql but got an error with popen() which I could not find a fix. ...
    Bruce MomjianBruce Momjian
    Apr 29, 2005 at 4:24 am
    Apr 29, 2005 at 4:24 am
  • Please apply the following patch to correct a small mistake in a translation file. cvs diff: Diffing src/bin/psql/po Index: src/bin/psql/po/es.po ...
    Alvaro HerreraAlvaro Herrera
    Apr 24, 2005 at 6:42 pm
    Apr 24, 2005 at 6:42 pm
  • Hi, How to include "EXCEPTION" handling block in PL/TCL function. I have attached below an e-mail program written in PL/TCL function. I want to log messages into a table from a function "log_error" ...
    Dinesh PandeyDinesh Pandey
    Apr 18, 2005 at 5:10 am
    Apr 18, 2005 at 5:10 am
  • OK, so we don't put URL's in ulink's because the URL is always generated, but we can put words in ulink and the URL will still be printed. Rather than back out the patch I made the adjustments ...
    Bruce MomjianBruce Momjian
    Apr 9, 2005 at 3:52 am
    Apr 9, 2005 at 3:52 am
  • Fixed some messages, thanks.
    Zhenbang WeiZhenbang Wei
    Apr 9, 2005 at 2:31 am
    Apr 9, 2005 at 2:31 am
  • I've applied the attached patch to HEAD: it fixes the spelling of the "ABSOLUTE" keyword, and completes FETCH <sth <sth with FROM and IN, rather than FROM and TO (since the latter is not valid ...
    Neil ConwayNeil Conway
    Apr 4, 2005 at 7:21 am
    Apr 4, 2005 at 7:21 am
  • The pg_autovacuum said the best way to use it is running it from SysV initscript, but unfortunnally the works has not been made. I made it for mandrakelinux inclusion and should work on Redhat too. ...
    Olivier ThauvinOlivier Thauvin
    Apr 1, 2005 at 9:05 pm
    Apr 1, 2005 at 9:05 pm
  • The attached patch overhauls the query planner to store all query plans and cache all query results in a Microsoft Excel spreadsheet via ODBC.
    Ed L.Ed L.
    Apr 1, 2005 at 4:27 pm
    Apr 1, 2005 at 4:27 pm
  • I have applied the following attached patch to CVS to fix the \df display problem you reported. We might remove the test it at some point but at least now it works as in previous releases. ...
    Bruce MomjianBruce Momjian
    Apr 1, 2005 at 5:30 am
    Apr 1, 2005 at 5:30 am
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
grouppgsql-patches @
categoriespostgresql
discussions44
posts216
users32
websitepostgresql.org
irc#postgresql

32 users for April 2005

Bruce Momjian: 51 posts Tom Lane: 41 posts Neil Conway: 31 posts Simon Riggs: 13 posts Alvaro Herrera: 11 posts Qingqing Zhou: 9 posts Greg Sabino Mullane: 6 posts Heikki Linnakangas: 6 posts Dinesh Pandey: 5 posts Peter Eisentraut: 5 posts F Guidi: 4 posts Andrew Dunstan: 3 posts Michael Paesold: 3 posts Pavel Stehule: 3 posts Robert Treat: 3 posts A_ogawa: 2 posts Christopher Kings-Lynne: 2 posts Devrim Gündüz: 2 posts Euler Taveira de Oliveira: 2 posts Mark Kirkwood: 2 posts
show more
Archives