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 importan
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
Des
"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
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
-
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 buf
Tom Lane wrote:
> "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
> > patc
Bruce Momjian 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" perhaps shoul
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 cu
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 i