summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-06-14Move thread os defines into template files.Bruce Momjian
2003-06-14Handle threading in two more gethostbyname calls.Bruce Momjian
2003-06-14Make libpq thread-safe with configure --with-threads option.Bruce Momjian
Lee Kindness
2003-06-14Add thread.c for libpq threading, and hook it into libpq/configure.Bruce Momjian
2003-06-13Add --with-threads configure option to control threaded libpq.Bruce Momjian
2003-06-13- Enable FETCH without INTO.Michael Meskes
- Compatibility functions for INFORMIX handling of DECLARE statement.
2003-06-13Okay, recognize freebsd 2.* and 3.* too.Tom Lane
2003-06-13Expect FreeBSD 5.* to have standard float arithmetic.Tom Lane
2003-06-12Add thread-enable compile variables into libpq.Bruce Momjian
2003-06-12Fix SQL function executor for case where last command of a function isTom Lane
not a SELECT. We didn't use to allow that, but we do now.
2003-06-12Install all header files.Michael Meskes
2003-06-12Attached is the complete diff against current CVS.Bruce Momjian
Compiles on BCC 5.5 and VC++ 6.0 (with warnings). Karl Waclawek
2003-06-12Back out patch that got bundled into another patch.Bruce Momjian
2003-06-12New patch with corrected README attached.Bruce Momjian
Also quickly added mention that it may be a qualified schema name. Rod Taylor
2003-06-12Attached is a patch that enhances the output of psql's HTML mode.Bruce Momjian
The output now validates as HTML 4.01 Strict, XHTML 1.0 strict, and XHTML 1.1 (assuming you wrap it in a valid html/body document). It also wraps the output of PGRES_COMMAND_OK if the HTML tag is on, for full compliance: this is why html_escaped_print has to be externalized. Greg Sabino Mullane greg@turnstep.com
2003-06-12Brief note about sequence cache not being cleared in other backends.Bruce Momjian
Actually clear the cache in the backend making the alteration. This follows in the footsteps of setval(). Rod Taylor
2003-06-12IPv6 cleanups.Bruce Momjian
Kurt Roeckx Andrew Dunstan
2003-06-12Back out this patch because it is patched inside a later patch.Bruce Momjian
--------------------------------------------------------------------------- here is a patch that allows CIDR netmasks in pg_hba.conf. It allows two address/mask forms: . address/maskbits, or . address netmask (as now) If the patch is accepted I will submit a documentation patch to cover it. This is submitted by agreement with Kurt Roeckx, who has worked on a patch that covers this and other IPv6 issues.
2003-06-12I succeeded by fixing up setup.py:Bruce Momjian
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv --- setup.py~ Tue Mar 19 08:21:14 2002 +++ setup.py Wed May 14 15:10:30 2003 @@ -30,8 +30,8 @@ optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ] data_files = [ 'libpq.dll' ] else: - include_dirs=['/usr/include/pgsql'] - library_dirs=['usr/lib/pgsql'] + include_dirs=['../../include','../libpq','/usr/include/pgsql'] + library_dirs=['../libpq','/usr/lib/pgsql'] optional_libs=['pq'] data_files = [] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ George Young
2003-06-12Here is a patch that allows CIDR netmasks in pg_hba.conf. It allows twoBruce Momjian
address/mask forms: . address/maskbits, or . address netmask (as now) If the patch is accepted I will submit a documentation patch to cover it. This is submitted by agreement with Kurt Roeckx, who has worked on a patch that covers this and other IPv6 issues. Andrew Dunstan
2003-06-12Up to now, SerializableSnapshot and QuerySnapshot are malloc'ed andBruce Momjian
free'd for every transaction or statement, respectively. This patch puts these data structures into static memory, thus saving a few CPU cycles and two malloc calls per transaction or (in isolation level READ COMMITTED) per query. Manfred Koizar
2003-06-12psql: tab completion for \encodingBruce Momjian
Ian Barwick
2003-06-12I found the libpq function PGunescapeBytea a little slow. It was taking aBruce Momjian
minute and a half to decode a 500Kb on a fairly fast machine. I think the culprit is sscanf. I attach a patch that replaces the function with one used to perform the same task in pyPgSQL (a Python interface to PostgreSQL). This code was written by Billy Allie, author of pyPgSQL. I've changed a few variable names to match those in the original code and removed a bit of Pythonness. Billy has kindly looked at the code and points out that it is slightly stricter than the original implementation and if it encounters an invalid bytea such as '\12C' it drops the unescape '\' and outputs '12C'. The code is licensed by the author under a BSD license. I've performed limited testing of the function by putting JPEGs into PostgreSQL, extracting them using them using the new function and diffing against the original files. The new function is significantly faster on my machine with the JPEGs being decoded in less than a second. I attach a modified libpq example program that I used for my testing. Ben Lamb.
2003-06-11This patch extracts page buffer pooling and the simpleBruce Momjian
least-recently-used strategy from clog.c into slru.c. It doesn't change any visible behaviour and passes all regression tests plus a TruncateCLOG test done manually. Apart from refactoring I made a little change to SlruRecentlyUsed, formerly ClogRecentlyUsed: It now skips incrementing lru_counts, if slotno is already the LRU slot, thus saving a few CPU cycles. To make this work, lru_counts are initialised to 1 in SimpleLruInit. SimpleLru will be used by pg_subtrans (part of the nested transactions project), so the main purpose of this patch is to avoid future code duplication. Manfred Koizar
2003-06-11Add add_missing_from GUC variable.Bruce Momjian
Nigel J. Andrews
2003-06-11Make "log_min_duration_statement" SUSET --- will be adjusted with newBruce Momjian
USERLIMIT patch.
2003-06-11Fix brain damage in deciding which python input converter to use.Tom Lane
2003-06-11Add log_min_duration_statement.Bruce Momjian
Christopher Kings-Lynne
2003-06-11pg_dump and pg_restore were stripping quotes and downcasing some butTom Lane
not all SQL identifiers taken from command line arguments. We decided years ago that that was a bad idea: identifiers taken from the command line should be treated as literally correct. Remove the inconsistent code that has crept in recently. Also fix pg_dump so that the combination of --schema and --table does what you'd expect, namely dump exactly one table from exactly one schema. Per gripe from Deepak Bhole of Red Hat.
2003-06-11Well, the discussion about SSL a bit back perked my interest and I didBruce Momjian
some reading on the subject. 1) PostgreSQL uses ephemeral keying, for its connections (good thing) 2) PostgreSQL doesn't set the cipher list that it allows (bad thing, fixed) 3) PostgreSQL's renegotiation code wasn't text book correct (could be bad, fixed) 4) The rate of renegotiating was insanely low (as Tom pointed out, set to a more reasonable level) I haven't checked around much to see if there are any other SSL bits that need some review, but I'm doing some OpenSSL work right now and'll send patches for improvements along the way (if I find them). At the very least, the changes in this patch will make security folks happier for sure. The constant renegotiation of sessions was likely a boon to systems that had bad entropy gathering means (read: Slowaris /dev/rand|/dev/urand != ANDIrand). The new limit for renegotiations is 512MB which should be much more reasonable. Sean Chittenden
2003-06-11During looking stuff up for a discussion on -general, I realized thatBruce Momjian
I'd placed the check for newly created matching pk rows for on update no action earlier than it needed to be so that it'd check even when the key values hadn't changed. This patch moves it to after checking for NULLs in the old row and comparing the values since the select's probably more expensive. Stephan Szabo
2003-06-11Add missing DLLIMPORT for cpu_index_tuple_cost toBruce Momjian
src/include/optimizer/cost.h. This is required to compile the PostGIS extension module with Cygwin http://postgis.refractions.net Norman Vine
2003-06-11Represent grant options in the information schema.Peter Eisentraut
2003-06-11Add Rendezvous support to postmaster, from Chris CampbellBruce Momjian
2003-06-11Make sure a variable is no longer referenced when it is removed.Michael Meskes
Fixed counting bug in parsing "->" operator. Removed that silly debugging function I accidently committed last night.
2003-06-11Document the -h client flag can use a socket directory as well as a hostBruce Momjian
name.
2003-06-11Remove lock* GUC variables from postgresql.conf.Bruce Momjian
Document why certain GUC variables aren't in postgresql.conf.
2003-06-10Fixed some bugs.Michael Meskes
2003-06-09freeaddrinfo2() does need two parameters after all, per comment byTom Lane
Kurt Roeckx. Add some documentation to try to prevent others from repeating my mistake.
2003-06-08libpq can now talk to either 3.0 or 2.0 protocol servers. It first triesTom Lane
protocol 3, then falls back to 2 if postmaster rejects the startup packet with an old-format error message. A side benefit of the rewrite is that SSL-encrypted connections can now be made without blocking. (I think, anyway, but do not have a good way to test.)
2003-06-06Add -DFRONTEND for non-MinGW Win32 ports.Bruce Momjian
2003-06-06Add defense in assign_session_authorization() against trying to doTom Lane
catalog lookups when not in a transaction. This prevents bizarre failures if someone tries to set a value for session_authorization in postgresql.conf. Per report from Fernando Nasser.
2003-06-06Implement outer-level aggregates to conform to the SQL spec, withTom Lane
extensions to support our historical behavior. An aggregate belongs to the closest query level of any of the variables in its argument, or the current query level if there are no variables (e.g., COUNT(*)). The implementation involves adding an agglevelsup field to Aggref, and treating outer aggregates like outer variables at planning time.
2003-06-05Information schema views about functionsPeter Eisentraut
2003-06-05Support for Intel compiler on LinuxPeter Eisentraut
2003-06-02Make the world at least marginally safe for usernames with embedded spaces.Tom Lane
Per recent gripe.
2003-06-02In src/include/mb/pg_wchar.h we have:Bruce Momjian
#define PG_ENCODING_BE_LAST PG_ISO_8859_8 #define PG_ENCODING_FE_LAST PG_WIN1256 but the last client encoding in the enum list is actually PG_GB18030 and it seems that #define PG_ENCODING_IS_CLIEN_ONLY(_enc) \ (((_enc) > PG_ENCODING_BE_LAST && (_enc) <= PG_ENCODING_FE_LAST) can never be true. I think the define should read #define PG_ENCODING_FE_LAST PG_GB18030 On the other hand, perhaps no-one cares, because PG_ENCODING_IS_CLIEN_ONLY is never used. -- Oliver Elphick Oliver.Elphick@lfix.co.uk
2003-06-02Fixed segfault in forward definition parsing.Michael Meskes
2003-05-31markTargetListOrigin neglected to handle outer-scope Vars properly;Tom Lane
per report from Joe Conway.
2003-05-30Cause pg_dumpall to support the -a, -s, -x options of pg_dump.Tom Lane