aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Disallow dollar sign in operator names, instead allow it as a non-firstTom Lane2003-06-19
| | | | | | | character in identifiers. The first change eliminates the current need to put spaces around parameter references, as in "x<=$2". The second change improves compatibility with Oracle and some other RDBMSes. This was discussed and agreed to back in January, but did not get done.
* Fixed fetch into char * and added missing prototype for an Informix function.Michael Meskes2003-06-19
|
* Change clusterdb and vacuumdb into C programs.Peter Eisentraut2003-06-18
|
* Make FLOAT(p) measure the precision p in bits, not decimal digits, toTom Lane2003-06-17
| | | | | match the SQL standard. Document FLOAT and FLOAT(p) notations in datatype.sgml. Per recent pghackers discussion.
* More information schema views.Peter Eisentraut2003-06-17
|
* Add missing file to clean target.Peter Eisentraut2003-06-17
|
* Fixed several more parsing bugs.Michael Meskes2003-06-17
|
* Fix error line numbers reported for errors in plpgsql_parse_word andTom Lane2003-06-17
| | | | siblings.
* Fix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did notTom Lane2003-06-16
| | | | work at all, and neither case behaved sanely for negative intervals.
* Fixed two small bugs.Michael Meskes2003-06-16
|
* Allow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals,Tom Lane2003-06-16
| | | | | | | | | silently resolving them to type TEXT. This is comparable to what we do when faced with UNKNOWN in CASE, UNION, and other contexts. It gets rid of this and related annoyances: select distinct f1, '' from int4_tbl; ERROR: Unable to identify an ordering operator '<' for type unknown This was discussed many moons ago, but no one got round to fixing it.
* Adjust nestloop-with-inner-indexscan plan generation so that we catchTom Lane2003-06-15
| | | | | | | some cases of redundant clauses that were formerly not caught. We have to special-case this because the clauses involved never get attached to the same join restrictlist and so the existing logic does not notice that they are redundant.
* Replace cryptic 'Unknown kind of return type' messages with somethingTom Lane2003-06-15
| | | | hopefully a little more useful.
* Cause GROUP BY clause to adopt ordering operators from ORDER BY whenTom Lane2003-06-15
| | | | | | both clauses specify the same targets, rather than always using the default ordering operator. This allows 'GROUP BY foo ORDER BY foo DESC' to be done with only one sort step.
* index() -> strchr().Tom Lane2003-06-15
|
* Typo in version number.Michael Meskes2003-06-15
|
* Some minor changes for new version numbering.Michael Meskes2003-06-15
|
* Ecpg cleanups for prototypes.Bruce Momjian2003-06-15
|
* Run autoconf/autoheader for ecpg change.Bruce Momjian2003-06-15
|
* Make ecpg thread safe.Bruce Momjian2003-06-15
| | | | Lee Kindness
* Move thread os defines into template files.Bruce Momjian2003-06-14
|
* Handle threading in two more gethostbyname calls.Bruce Momjian2003-06-14
|
* Make libpq thread-safe with configure --with-threads option.Bruce Momjian2003-06-14
| | | | Lee Kindness
* Add thread.c for libpq threading, and hook it into libpq/configure.Bruce Momjian2003-06-14
|
* Add --with-threads configure option to control threaded libpq.Bruce Momjian2003-06-13
|
* - Enable FETCH without INTO.Michael Meskes2003-06-13
| | | | - Compatibility functions for INFORMIX handling of DECLARE statement.
* Okay, recognize freebsd 2.* and 3.* too.Tom Lane2003-06-13
|
* Expect FreeBSD 5.* to have standard float arithmetic.Tom Lane2003-06-13
|
* Add thread-enable compile variables into libpq.Bruce Momjian2003-06-12
|
* Fix SQL function executor for case where last command of a function isTom Lane2003-06-12
| | | | not a SELECT. We didn't use to allow that, but we do now.
* Install all header files.Michael Meskes2003-06-12
|
* Attached is the complete diff against current CVS.Bruce Momjian2003-06-12
| | | | | | Compiles on BCC 5.5 and VC++ 6.0 (with warnings). Karl Waclawek
* Back out patch that got bundled into another patch.Bruce Momjian2003-06-12
|
* New patch with corrected README attached.Bruce Momjian2003-06-12
| | | | | | Also quickly added mention that it may be a qualified schema name. Rod Taylor
* Attached is a patch that enhances the output of psql's HTML mode.Bruce Momjian2003-06-12
| | | | | | | | | | | 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
* Brief note about sequence cache not being cleared in other backends.Bruce Momjian2003-06-12
| | | | | | | Actually clear the cache in the backend making the alteration. This follows in the footsteps of setval(). Rod Taylor
* IPv6 cleanups.Bruce Momjian2003-06-12
| | | | | Kurt Roeckx Andrew Dunstan
* Back out this patch because it is patched inside a later patch.Bruce Momjian2003-06-12
| | | | | | | | | | | | | | | | --------------------------------------------------------------------------- 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.
* I succeeded by fixing up setup.py:Bruce Momjian2003-06-12
| | | | | | | | | | | | | | | | | | | 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
* Here is a patch that allows CIDR netmasks in pg_hba.conf. It allows twoBruce Momjian2003-06-12
| | | | | | | | | | | | | | | 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
* Up to now, SerializableSnapshot and QuerySnapshot are malloc'ed andBruce Momjian2003-06-12
| | | | | | | | | 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
* psql: tab completion for \encodingBruce Momjian2003-06-12
| | | | Ian Barwick
* I found the libpq function PGunescapeBytea a little slow. It was taking aBruce Momjian2003-06-12
| | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* This patch extracts page buffer pooling and the simpleBruce Momjian2003-06-11
| | | | | | | | | | | | | | | | | 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
* Add add_missing_from GUC variable.Bruce Momjian2003-06-11
| | | | Nigel J. Andrews
* Make "log_min_duration_statement" SUSET --- will be adjusted with newBruce Momjian2003-06-11
| | | | USERLIMIT patch.
* Fix brain damage in deciding which python input converter to use.Tom Lane2003-06-11
|
* Add log_min_duration_statement.Bruce Momjian2003-06-11
| | | | Christopher Kings-Lynne
* pg_dump and pg_restore were stripping quotes and downcasing some butTom Lane2003-06-11
| | | | | | | | | 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.
* Well, the discussion about SSL a bit back perked my interest and I didBruce Momjian2003-06-11
| | | | | | | | | | | | | | | | | | | | | | | | | | 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-15 04:43:43 +0000