- 03 12月, 2004 24 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
handling in SIGPIPE processing; avoid unnecessary pollution of application link-symbol namespace; spell 'pointer to function' in the conventional way.
-
由 Bruce Momjian 提交于
< > o Fix problem with shared memory on the Win32 Terminal Server
-
由 Bruce Momjian 提交于
> throughout to the spellings suggested by your book. Great. A follow-up patch for current CVS HEAD is attached, and available at http://troels.arvin.dk/db/pgsql/conformance/pgsql-sql-conformance- followup.patch The patch - includes a core feature ID that had been left out by mistake (C011) - updates the sql_feature_packages.txt table to reflect changes in SQL:2003 which were not covered properly in my last patch Troels Arvin
-
由 Bruce Momjian 提交于
> > Windows service, it says you can use the -I and -R options. > > > > When I do that and I specify a password with '-P' > (uppercase) then in > > the registry it's saved as '-p' (lowercase) in the > service-commandline > > (ImagePath). This was fixed in v1.21 of pg_autovacuum.c, That rev is tagged for beta3, so you should not be seeing this issue unless you actually have an older version for some reason. http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_autovacuum/p g_autovacuum.c.diff?r1=1.20;r2=1.21;f=h > > Also it removes the quotes I added and I'm not so sure it > would work > > the way it's supposed to, without it. It's not so much that it strips them (that happens automagically), more that it doesn't re-add them when it writes the command line in the registry. The attached patch fixes that by simply quoting all options that may need it. > > If you add DependOnService (a REG_MULTI_SZ an > array-like-thingie) and > > have the name (in this case: pgsql-8.0-beta2-dev3) of a service it > > depends on, it will not fail to start (it will not even try, as > > PostgreSQL is not running), when PostgreSQL already failed. > > > > Maybe it's an idea to specify it on the commandline (what > service to > > depend on). A -E <service> option is added in the attached patch. Dave Page
-
由 Bruce Momjian 提交于
> seconds to 10 seconds. The original number was plucked from thin air > some months ago, and I'd like to review that now based upon further > thought, observation and experience. > > This change has little or no effect on performance, since the interval > is there mainly to avoid repeated respawn attempts if archiver fails at > startup. Archiver start-up time is very quick, so there is little danger > of exceeding 10 seconds. > > On a busy system, if the archiver does die, then many files can build up > in the 60 seconds before respawning. That xlog file backlog could take > some time to clear. This then leaves a larger than normal window of data > loss for a possibly long period. > > It's a minor change only, with no other effect on function. Simon Riggs
-
由 Bruce Momjian 提交于
John Hansen
-
由 Bruce Momjian 提交于
the "ps" argument list on Unix - meaning that there is no way to identify for example the stats processors or the bgwriter. This patch adds this functionality, in a bit of a crufty way. It creates a kernel Event object with the name of what would be in the title. This can be viewed using for example Process Explorer. It's been very handy for me during both debugging and using. I haven't figured a better way, but perhaps someone has one that's less crufty? If not, here is at least a working patch :-) Magnus Hagander
-
由 Bruce Momjian 提交于
the xml2 contrib module. It's against 8.0beta4. It's intended for commit. Markus Bertheau <twanger@bluetwanger.de>
-
由 Bruce Momjian 提交于
Roland Volkmann
-
由 Tom Lane 提交于
very good practice IMHO, but apparently some people think so.
-
由 Bruce Momjian 提交于
David Fetter
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Kenneth Marshall
-
由 Tom Lane 提交于
that readline must depend on libcurses, but it seems more recent ones use libtermcap instead. Allow that case.
-
由 Bruce Momjian 提交于
return "dynamic loading error";
-
由 Bruce Momjian 提交于
> o Improve dlerror() reporting string
-
由 Bruce Momjian 提交于
> * Allow a warm standby system to also allow read-only queries > > This is useful for checking PITR recovery. >
-
由 Tom Lane 提交于
reasons I outlined in pghackers a few days ago. Also, undo someone's overly optimistic decision to reduce tuple state checks from if (...) elog() to Asserts. If I trusted this code more, I might think it was a good idea to disable these checks in production installations. But I don't.
-
由 Bruce Momjian 提交于
> * Fix psql's display of schema information (Neil)
-
由 Bruce Momjian 提交于
handles that, and make solaris debug use no optimization.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 02 12月, 2004 15 次提交
-
-
由 Bruce Momjian 提交于
Euler Taveira de Oliveira
-
由 Bruce Momjian 提交于
calling applications. This is done by blocking sigpipe in the libpq thread and using sigpending/sigwait to possibily discard any sigpipe we generated.
-
由 Neil Conway 提交于
Michael Fuhr. Along the way, fix a bunch of accesses to uninitialized memory, add a mystrdup() routine and use it to cleanup some code.
-
由 Bruce Momjian 提交于
> > * Allow FOR UPDATE queries to do NOWAIT locks >
-
由 Neil Conway 提交于
downloading CVS at cyclic.com site is long defunct, and I changed the text to not overtly recommend CVS 1.10, a now fairly old version. Jon Jensen
-
由 Bruce Momjian 提交于
Jun Kuwamura
-
由 Tom Lane 提交于
escapes --- they aren't simply quoted characters. Problem noted by Antti Salmela. Also fix problem with incorrect handling of multibyte characters when followed by a quantifier.
-
由 Tom Lane 提交于
In particular, there was a mathematical tie between the two possible nestloop-with-materialized-inner-scan plans for a join (ie, we computed the same cost with either input on the inside), resulting in a roundoff error driven choice, if the relations were both small enough to fit in sort_mem. Add a small cost factor to ensure we prefer materializing the smaller input. This changes several regression test plans, but with any luck we will now have more stability across platforms.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Guillaume LELARGE
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
a relation's number of blocks, rather than the possibly-obsolete value in pg_class.relpages. Scale the value in pg_class.reltuples correspondingly to arrive at a hopefully more accurate number of rows. When pg_class contains 0/0, estimate a tuple width from the column datatypes and divide that into current file size to estimate number of rows. This improved methodology allows us to jettison the ancient hacks that put bogus default values into pg_class when a table is first created. Also, per a suggestion from Simon, make VACUUM (but not VACUUM FULL or ANALYZE) adjust the value it puts into pg_class.reltuples to try to represent the mean tuple density instead of the minimal density that actually prevails just after VACUUM. These changes alter the plans selected for certain regression tests, so update the expected files accordingly. (I removed join_1.out because it's not clear if it still applies; we can add back any variant versions as they are shown to be needed.)
-
由 Bruce Momjian 提交于
> * Allow ecpg to work with MSVC and BCC
-
由 Bruce Momjian 提交于
-
- 01 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
< returns in data? > returns in data
-