FAQ

Search Discussions

74 discussions - 241 posts

  • We have implemented a patch which can be used by connection pools for instance. RESECT CONNECTION cleans up a backend so that it can be reused. Temp tables, LISTEN / NOTIFY stuff, WITH HOLD cursors, ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Dec 30, 2004 at 7:12 pm
    Apr 25, 2006 at 2:12 pm
  • Hi, This patch just implement a function that returns the uptime of the postmaster. The docs are included too. Another TODO item could be implement a function that returns the startup time. If nobody ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Dec 19, 2004 at 8:53 pm
    Jun 15, 2005 at 12:53 pm
  • Greetings, Small patch to clean up the grammer a bit by adding 'GroupId', 'SchemaName' and 'SavePointId'. I noticed these issues while beginning work on 'Group Ownership'. Any questions/comments, ...
    Stephen FrostStephen Frost
    Dec 29, 2004 at 3:46 pm
    Jun 10, 2005 at 5:41 pm
  • Folks, We have implemented SELECT FOR UPDATE NOWAIT for PostgreSQL. The patch attached to this email contains all the required code including ECPG updates and some documentation. It would be nice if ...
    Hans-Juergen SchoenigHans-Juergen Schoenig
    Dec 27, 2004 at 10:34 am
    Aug 8, 2005 at 8:26 pm
  • Hi: Attached is a loadable module (and a small backend patch) that allows a client to list the available query plans (created with PREPARE, or with a 'parse' protocol message) on a particular ...
    David BrownDavid Brown
    Dec 22, 2004 at 8:11 pm
    Jan 2, 2005 at 2:18 pm
  • Here is a sample patch for automatically adding the year/julian date to the libpq.rc file. It requires moving libpq.rc to libpq.rc.in and then making the Makefile modifications attached. I also ...
    Bruce MomjianBruce Momjian
    Dec 15, 2004 at 4:46 am
    Dec 19, 2004 at 2:16 am
  • I found that function gen_salt() in contrib/pgcrypto had bug on win32. I patched contrib/pgcrypto/random.c file.
    Korea PostgreSQL Users' GroupKorea PostgreSQL Users' Group
    Dec 5, 2004 at 3:53 pm
    Dec 6, 2004 at 7:24 pm
  • Here's a patch containing the function SPI_iterate_query_roots(...). I'm optimistic so it's complete with documentation :-) I think that this function is needed so that PL/<lang authors like myself ...
    Thomas HallgrenThomas Hallgren
    Dec 1, 2004 at 7:16 pm
    Dec 2, 2004 at 3:09 am
  • Hi, The attached patch adds the optional REFERENCES syntax in CREATE TRIGGER statement to make an automatic alias for OLD/NEW record during trigger setup. The implementation of this new feature makes ...
    HyipHyip
    Dec 10, 2004 at 10:10 pm
    Jun 20, 2005 at 11:49 pm
  • Hackers, Here is the LockObject patch I was able to come up with. It's almost the same patch that Rod Taylor published two years ago; basically, it expands LOCKTAG with a ClassId attribute, and ...
    Alvaro HerreraAlvaro Herrera
    Dec 20, 2004 at 2:40 am
    Dec 21, 2004 at 12:22 am
  • This page shows the differences between Latin1 & Latin9: http://www.cs.tut.fi/~jkorpela/latin9.html The diffs are: 164: the euro symbol. (sql_ascii = 'E')??? 166: an S with a symbol above (sql_ascii ...
    Jaime CasanovaJaime Casanova
    Dec 17, 2004 at 9:03 pm
    Dec 20, 2004 at 7:01 pm
  • Hello, Here's a patch I added against plperl, originally against beta5, now against rc1. It simply checks with GetDatabaseEncoding() if the current database is in UTF-8, and if so, sets the UTF-8 ...
    David KamholzDavid Kamholz
    Dec 5, 2004 at 6:50 pm
    Jun 15, 2005 at 12:35 am
  • I have always thought that an example of how to maintain a summary table via triggers would be nice... but until the other day, had not attempted to do one, so contributing a simplified version ...
    Mark KirkwoodMark Kirkwood
    Dec 29, 2004 at 3:04 am
    Jan 15, 2005 at 3:39 am
  • Seems to be a neverending story :-) Version numbers don't update properly on postgres.exe when doing make clean/make. It works for all other exes and dlls. I beleive this is just a case of "make ...
    Magnus HaganderMagnus Hagander
    Dec 30, 2004 at 9:31 pm
    Dec 31, 2004 at 7:13 pm
  • pgxs on darwin is currently broken. The behavior before was to use -bundle_loader with a bogus directory that didn't exist. It should be using $(DESTDIR)$(bindir) instead of something based off of ...
    Sean ChittendenSean Chittenden
    Dec 17, 2004 at 1:53 am
    Dec 17, 2004 at 3:53 am
  • I see. Our test is: int strerror_r(int, char *, size_t); but AIX is: int strerror_r(int, char *, int); OK, I added an #ifndef _AIX to use 'int' for the 3rd arg for AIX. Yea, that is an effect of the ...
    Bruce MomjianBruce Momjian
    Dec 14, 2004 at 12:48 pm
    Dec 16, 2004 at 6:09 pm
  • Note: This patch is intended for 8.1 (as was the original). I believe the previous patch I submitted to convert Unix epoch to timestamptz contains a bug relating to its use of AT TIME ZONE. Please ...
    Michael GlaesemannMichael Glaesemann
    Dec 12, 2004 at 1:14 pm
    Jun 12, 2005 at 11:38 am
  • This patch adds another plpgsql trigger example to the chapter. It uses the emp table again, but shows how to audit changes into another table (emp_audit). I think this is a beneficial addition as ...
    Mark KirkwoodMark Kirkwood
    Dec 2, 2004 at 8:34 pm
    Dec 5, 2004 at 7:58 am
  • Hackers, Here is the current shared dependency patch I promised. (The new files are src/include/catalog/pg_shdepend.h and src/backend/catalog/pg_shdepend.c). The big problem with the current patch is ...
    Alvaro HerreraAlvaro Herrera
    Dec 16, 2004 at 1:57 am
    Dec 17, 2004 at 6:50 pm
  • We should prevent pg_resetxlog from being run as root: it writes new files to $PGDATA, so running the tool as root will result in those files being owned by root, which makes the data directory ...
    Neil ConwayNeil Conway
    Dec 12, 2004 at 10:57 pm
    Dec 14, 2004 at 2:00 am
  • True, but I documented that in the patch. Look also in fe-print.c. Looks like a lot of popen writes in there. I can do it but it will be harder. OK, patch attached. I already sent it but who knows ...
    Bruce MomjianBruce Momjian
    Dec 2, 2004 at 3:45 am
    Dec 2, 2004 at 11:35 pm
  • Greetings, Small patch to move get_grosysid() from catalog/aclchk.c to utils/cache/lsyscache.c where it can be used by other things. Also cleans up both get_usesysid() and get_grosysid() a bit. This ...
    Stephen FrostStephen Frost
    Dec 29, 2004 at 5:08 pm
    Jan 27, 2005 at 11:36 pm
  • OK, it took me a while to figure this out, but it is similar to the problem we have on AIX. AIX shared libraries don't track other libraries needed by the shared library, and non-shared libraries ...
    Bruce MomjianBruce Momjian
    Dec 14, 2004 at 11:31 pm
    Dec 16, 2004 at 6:13 pm
  • We made now translated server messages for 8.0. Please add for "ko" locale. It just only server messages. this file's charset is utf-8.
    Korea PostgreSQL Users' GroupKorea PostgreSQL Users' Group
    Dec 13, 2004 at 6:09 am
    Dec 13, 2004 at 10:54 pm
  • I didn't realise until Bruce told me just now that I was on the hook for this. I guess i should keep my big mouth shut. (Yeah, that's gonna happen ...) Anyway, here's a tiny patch that does what I ...
    Andrew DunstanAndrew Dunstan
    Dec 2, 2004 at 11:58 pm
    Dec 3, 2004 at 5:13 pm
  • entab did not compile for me (cvs head), as gcc 3.3.5 #error's on <varargs.h . This patch includes <stdarg.h and also converts arg declaration to ANSI style, because K&R varargs are mystery to me. -- ...
    Marko KreenMarko Kreen
    Dec 14, 2004 at 8:17 pm
    May 27, 2005 at 3:16 pm
  • Yes. As things stand, this is the only change that seems safe. Here's a very short patch that implements this change within BufferSync in bufmgr.c - No algorithm changes - No error message changes - ...
    Simon RiggsSimon Riggs
    Dec 31, 2004 at 12:09 am
    Dec 31, 2004 at 11:51 am
  • Hi, NetBSD mac68k's gcc does not define __mc68000__, but __m68k__ The following patch makes the oldstyle_length test pass on this platform The change in miscinit is not necessary but for consistency ...
    Rémi ZaraRémi Zara
    Dec 26, 2004 at 10:29 pm
    Dec 27, 2004 at 5:24 am
  • I was egtting a compile error complaining (in effect) abour the lack of a pid_t type when attempting a compile with MSVC. The attached patch, which move the definition up in the file win32.h before ...
    Andrew DunstanAndrew Dunstan
    Dec 26, 2004 at 6:33 pm
    Dec 26, 2004 at 7:21 pm
  • Attached patch solves the problem for me.Didn't see anything of the problem you described about hangs in my implementation. Probably because mine exits at the first sign of a linebreak. //Magnus
    Magnus HaganderMagnus Hagander
    Dec 19, 2004 at 3:50 pm
    Dec 20, 2004 at 5:42 pm
  • Uh, what was the TODO here? I forgot. --------------------------------------------------------------------------- John Hansen wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us ...
    Bruce MomjianBruce Momjian
    Dec 1, 2004 at 10:21 pm
    Dec 1, 2004 at 11:37 pm
  • Hi, Sorry to give these separately... postgres-fr.po is due to a translation error, pg_ctl-fr.po is an update. Please apply, thank you very much. -- Guillaume. <!-- http://abs.traduc.org/ ...
    Guillaume LELARGEGuillaume LELARGE
    Dec 21, 2004 at 11:11 pm
    Jan 3, 2005 at 10:39 pm
  • Dear Sir, I am working as Teacher in college. I am teaching PostgreSQL to student. I am facing problem in running CURSOR. version of postgresql is 7.3.2 Cursor creation and fetching works fine. but , ...
    Ramesh phuleRamesh phule
    Dec 31, 2004 at 5:27 am
    Dec 31, 2004 at 6:09 am
  • hello, i've attached a patch for the following bug report: http://archives.postgresql.org/pgsql-ports/2004-09/msg00008.php in essence, if configure detects that the environment is sunos4, s_lock.c ...
    AyanAyan
    Dec 29, 2004 at 3:57 pm
    Dec 29, 2004 at 11:50 pm
  • Getting a win32 compiler error based on yesterday's update to pg_ctl.c. It's a 1 liner (1081): if (StartServiceCtrlDispatcher(st)) == 0) to if (StartServiceCtrlDispatcher(st) == 0) or, as I prefer it ...
    Merlin MoncureMerlin Moncure
    Dec 22, 2004 at 11:36 pm
    Dec 23, 2004 at 12:04 am
  • Hi all, Here is the last update for french .po files. Please apply to current branch. Thanks. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://traduc.postgresqlfr.org/ --
    Guillaume LELARGEGuillaume LELARGE
    Dec 20, 2004 at 8:49 pm
    Dec 21, 2004 at 11:14 am
  • Changes the doc's to reflect what the user will find as default. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    Robert TreatRobert Treat
    Dec 13, 2004 at 5:53 am
    Dec 18, 2004 at 4:21 am
  • Final translations; please apply. Regards, Aleksander
    Aleksander KmetecAleksander Kmetec
    Dec 16, 2004 at 6:30 am
    Dec 16, 2004 at 11:31 am
  • Please apply these files. two update files : pg_controldata-ko.po, initdb-ko.po tow new translated files: pg_ctl-ko.po, pg_resetxlog-ko.po Regards
    Ioseph KimIoseph Kim
    Dec 16, 2004 at 4:04 am
    Dec 16, 2004 at 11:27 am
  • I translated 4 files. plz apply them. Regards
    Korea PostgreSQL Users' GroupKorea PostgreSQL Users' Group
    Dec 15, 2004 at 5:17 pm
    Dec 15, 2004 at 5:48 pm
  • Hi, http://postgresql.gunduz.org/translation/PostgreSQL-8.0/PgSQL-DilDosyalari/postgres-tr.po fixes the error, per http://developer.postgresql.org/~petere/nlsstatus/po-current/postgres-tr.po.err ...
    Devrim GündüzDevrim Gündüz
    Dec 15, 2004 at 12:55 am
    Dec 15, 2004 at 5:40 pm
  • I guess this has to be saved for 8.1... shame. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    Robert TreatRobert Treat
    Dec 14, 2004 at 1:47 am
    Dec 14, 2004 at 11:10 am
  • Hi, Here are the latest update for the french 8.0 .po files. Please, apply. Thanks. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://traduc.postgresqlfr.org/
    Guillaume LELARGEGuillaume LELARGE
    Dec 13, 2004 at 9:27 pm
    Dec 13, 2004 at 9:49 pm
  • Please add 2 po files for version 8.0.
    Korea PostgreSQL Users' GroupKorea PostgreSQL Users' Group
    Dec 13, 2004 at 1:56 pm
    Dec 13, 2004 at 4:30 pm
  • Hi, This little patch change my e-mail address in the FAQ. If it's possible yet, please apply it to HEAD. ===== Euler Taveira de Oliveira euler[at]yahoo_com_br Converse com seus amigos em tempo real ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Dec 10, 2004 at 10:00 pm
    Dec 13, 2004 at 3:37 am
  • laurie.burrow@powerconv.alstom.com noticed a problem with pg_get_viewdef in prettyprint mode. create table gnrcitm (gnrcitmid int); create table gnrcitmothrref (idntfyrefid int, gnrcitmid int); ...
    Andreas PflugAndreas Pflug
    Dec 10, 2004 at 8:52 pm
    Dec 13, 2004 at 12:34 am
  • Attached patch has been tested on Cygwin and found to work as expected when initdb fails during make check - I don't have access to a FreeBSD machine to do a test buildfarm run. cheers andrew
    Andrew DunstanAndrew Dunstan
    Dec 11, 2004 at 9:34 pm
    Dec 12, 2004 at 3:34 pm
  • Hi, We've updated the Turkish translations: http://postgresql.gunduz.org/translation/PostgreSQL-8.0/PgSQL-DilDosyalari/initdb-tr.po ...
    Devrim GündüzDevrim Gündüz
    Dec 11, 2004 at 1:15 pm
    Dec 11, 2004 at 8:19 pm
  • Hello Peter, Attached please find newer Russian translation updates. For 8.0: pg_dump-ru.po.gz initdb-ru.po.gz psql-ru.po.gz For both, 7.4 and 8.0 branches: postgres-ru.po.gz Thanks, -s
    Serguei MokhovSerguei Mokhov
    Dec 11, 2004 at 4:01 am
    Dec 11, 2004 at 8:09 pm
  • Folks, Please find enclosed a patch to the pl/perl documents that clafies the scope of global data and gives an example of storing a code reference. Cheers, D -- David Fetter david@fetter.org ...
    David FetterDavid Fetter
    Dec 10, 2004 at 7:22 pm
    Dec 11, 2004 at 8:04 pm
Group Navigation
period‹ prev | Dec 2004 | next ›
Group Overview
grouppgsql-patches @
categoriespostgresql
discussions74
posts241
users48
websitepostgresql.org
irc#postgresql

48 users for December 2004

Tom Lane: 50 posts Bruce Momjian: 47 posts Peter Eisentraut: 21 posts Alvaro Herrera: 10 posts Andrew Dunstan: 9 posts Korea PostgreSQL Users' Group: 9 posts Euler Taveira de Oliveira: 7 posts Stephen Frost: 6 posts Guillaume LELARGE: 5 posts Thomas Hallgren: 5 posts Hyip: 4 posts Christopher Kings-Lynne: 4 posts Magnus Hagander: 4 posts Mark Kirkwood: 4 posts Marko Kreen: 4 posts Neil Conway: 4 posts Andreas Zeugswetter: 3 posts David Brown: 3 posts Jaime Casanova: 3 posts Sean Chittenden: 3 posts
show more
Archives