[PATCHES] Implementing RESET CONNECTION ...

2004-12-30 Thread Hans-Jürgen Schönig
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, open transactions, prepared statements and GUCs are cleaned up. I hope we have not missed

[PATCHES] Win32 version numbers not correct (again, but this one is easy)

2004-12-30 Thread Magnus Hagander
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 clean not properly removing win32ver.o. See attached patch. //Magnus backend_clean.patch

Re: [PATCHES] Win32 version numbers not correct (again, but this one is easy)

2004-12-30 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: 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 clean not properly removing win32ver.o. See attached patch. Hmm, is that the only place we

Re: [PATCHES] [HACKERS] Bgwriter behavior

2004-12-30 Thread Simon Riggs
On Mon, 2004-12-27 at 22:21, Bruce Momjian wrote: Should we consider at least adjusting the meaning of bgwriter_percent? 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 -

Re: [PATCHES] [HACKERS] Bgwriter behavior

2004-12-30 Thread Bruce Momjian
Simon Riggs wrote: On Mon, 2004-12-27 at 22:21, Bruce Momjian wrote: Should we consider at least adjusting the meaning of bgwriter_percent? 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

Re: [PATCHES] Win32 version numbers not correct (again, but this one is easy)

2004-12-30 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: Hmm, is that the only place we missed it? Might be worth diffing a make distclean'd tree against a virgin one. I was under the impression we only wanted a new version number with a configure run, however, I can see that make clean

[PATCHES] reqd patch

2004-12-30 Thread ramesh phule
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 , 1) refcursor datatype is not recognised by postgres 2) fetch curs1 into

Re: [PATCHES] reqd patch

2004-12-30 Thread Michael Fuhr
On Thu, Dec 30, 2004 at 09:26:48PM -0800, ramesh phule wrote: Subject: [PATCHES] reqd patch To: pgsql-patches@postgresql.org I'm not sure what reqd patch has to do with your question -- a subject with the word cursor would be more appropriate since that's the topic. Also, pgsql-patches is