aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Attached is a patch to remove some redundant code in the JDBC driver.Bruce Momjian2001-08-10
| | | | | | | | | | | * Merges identical code from org.postgresql.jdbc[1|2].Statement into org.postgresql.Statement. * Moves escapeSQL() method from Connection to Statement (the only place it's used) * Minor cleanup of the new isolation level stuff. * Minor cleanup of version string handling. Anders Bengtsson
* 1. null-safe interface to GiSTBruce Momjian2001-08-10
| | | | | | | | | | | | | | (as proposed in http://fts.postgresql.org/db/mw/msg.html?mid=1028327) 2. support for 'pass-by-value' arguments - to test this we used special opclass for int4 with values in range [0-2^15] More testing will be done after resolving problem with index_formtuple and implementation of B-tree using GiST 3. small patch to contrib modules (seg,cube,rtree_gist,intarray) - mark functions as 'isstrict' where needed. Oleg Bartunov
* Patch to LOCK multiple tables in one LOCK command.Bruce Momjian2001-08-10
| | | | Neil Padgett
* Update TODO list.Bruce Momjian2001-08-10
|
* Update TODO list.Bruce Momjian2001-08-10
|
* Add new files for the preparation.Hiroshi Inoue2001-08-10
|
* This should be the right expected file.Peter Eisentraut2001-08-09
|
* Use format_type sibling in backend error messages, so the user seesPeter Eisentraut2001-08-09
| | | | consistent type naming.
* No longer a need for -Wno-errorPeter Eisentraut2001-08-09
|
* Update branding for 7.1.3, no HISTORY yet.Bruce Momjian2001-08-09
|
* corrections from the DocNotesPeter Eisentraut2001-08-09
|
* Fix Cygwin build, per Jason Tishler.Tom Lane2001-08-09
|
* Add TOAST table to the set of relkinds known to \d.Tom Lane2001-08-09
|
* 0 -> OPeter Eisentraut2001-08-08
|
* some clarifications inspired by the DocNotesPeter Eisentraut2001-08-07
|
* Update README for fuzzystrmatch description.Bruce Momjian2001-08-07
|
* Sorry - I should have gotten to this sooner. Here's a patch which you shouldBruce Momjian2001-08-07
| | | | | | | | | be able to apply against what you just committed. It rolls soundex into fuzzystrmatch. Remove soundex/metaphone and merge into fuzzystrmatch. Joe Conway
* I think you replaced too many things with put(...Bruce Momjian2001-08-07
| | | | | | | | | | | | | Here is a context diff from latest cvs And I see why you couldn't apply the last diff, the setCatalog diff has been backed out, that was causing the compile problem in the first place. This following one needs to be applied to allow the current cvs to compile Dave Cramer
* A small patch to keep postgres working on the latest BeOS.Bruce Momjian2001-08-07
| | | | Cyril VELTER
* Per this discussion, here's a patch to implement both levenshtein() andBruce Momjian2001-08-07
| | | | | | | | | | | | | | | | | | metaphone() in a contrib. There seem to be a fair number of different approaches to both of these algorithms. I used the simplest case for levenshtein which has a cost of 1 for any character insertion, deletion, or substitution. For metaphone, I adapted the same code from CPAN that the PHP folks did. A couple of questions: 1. Does it make sense to fold the soundex contrib together with this one? 2. I was debating trying to add multibyte support to levenshtein (it would make no sense at all for metaphone), but a quick search through the contrib directory found no hits on the word MULTIBYTE. Should worry about adding multibyte support to levenshtein()? Joe Conway
* Fix thinko (revealed by gcc warning).Tom Lane2001-08-07
|
* Russian translation by Serguei MokhovPeter Eisentraut2001-08-07
|
* Czech translation for psql from Karel ZakPeter Eisentraut2001-08-07
|
* Add a check for end of client connection before expecting a passwordPeter Eisentraut2001-08-07
| | | | response, to avoid noise in the server log.
* Doesn't seem to be much point in keeping this README up to date anymore,Tom Lane2001-08-06
| | | | | since it's completely redundant with regress.sgml. I think we agreed to remove it awhile back, actually, but no one got around to doing it.
* Update now-obsolete example of platform-specific regression comparisonTom Lane2001-08-06
| | | | files.
* Use a fixed error message for ERANGE to avoid duplicate test result files.Peter Eisentraut2001-08-06
| | | | Add some resultmap entries for SCO OpenServer.
* Seems like a bad idea to free() a string we are about to use in anTom Lane2001-08-06
| | | | error message.
* Modify partial-index-predicate applicability tester to test whetherTom Lane2001-08-06
| | | | | | clauses are equal(), before trying to match them up using btree opclass inference rules. This allows it to recognize many simple cases involving non-btree operations, for example 'x IS NULL'. Clean up code a little.
* Evaluate LIMIT/OFFSET expressions with ExecEvalExprSwitchContext, notTom Lane2001-08-06
| | | | ExecEvalExpr, to avoid possible memory leak.
* Do not pre-expand localedir as substituted in the makefile, so that 'makePeter Eisentraut2001-08-06
| | | | install prefix=elsewhere' works.
* update from upstreamPeter Eisentraut2001-08-06
|
* Check that the data directory does not have group or world access; removePeter Eisentraut2001-08-06
| | | | a similar check on postgresql.conf.
* Add QueryIsRule gram.y reset.Bruce Momjian2001-08-06
|
* Surely the pg_stat interrogation functions must not be marked proiscachable.Tom Lane2001-08-06
|
* Show index predicate when doing \d on a partial index.Tom Lane2001-08-05
|
* Endeavor to make pgstats buffer process (a) safe and (b) useful.Tom Lane2001-08-05
| | | | | | | | Make sure it exits immediately when collector process dies --- in old code, buffer process would hang around and compete with the new buffer process for packets. Make sure it doesn't block on writing the pipe when the collector falls more than a pipeload behind. Avoid leaking pgstats FDs into every backend.
* Remove no-longer-needed fcntl call (I'm not sure it *ever* did anythingTom Lane2001-08-05
| | | | useful, in fact).
* Back out LOCK A,B,C patch at Tom's suggestion.Bruce Momjian2001-08-04
|
* Compile fix for jdbc1.Bruce Momjian2001-08-04
|
* This patch is because Hurd does not support NOFILE. It is against currentBruce Momjian2001-08-04
| | | | | | | | | | | | cvs. The Debian bug report says, "The upstream source makes use of NOFILE unconditionalized. As the Hurd doesn't have an arbitrary limit on the number of open files, this is not defined. But _SC_OPEN_MAX works fine and returns 1024 (applications can increase this as they want), so I suggest the below diff. Please forward this upstream, too." Oliver Elphick
* This patch adds the following to the FTI module:Bruce Momjian2001-08-04
| | | | | | | | | | | | | | | | | | | | | | * The ability to index more than one column in a table with a single trigger. * All uses of sprintf changed to snprintf to prevent users from crashing Postgres. * Error messages made more consistent * Some changes made to bring it into line with coding requirements for triggers specified in the docs. (ie. check you're a trigger before casting your context) * The perl script that generate indices has been updated to support indexing multiple columns in a table. * Fairly well tested in our development environment indexing a food database's brand and description fields. The size of the fti index is around 300,000 rows. * All docs and examples upgraded. This includes specifying more efficient index usage that was specified before, better examples that don't produce duplicates, etc. Christopher Kings-Lynne & Brett
* Add LOCK A,B,C functionality as LOCK A;LOCK B;LOCK C; as agreed.Bruce Momjian2001-08-04
| | | | Neil Padgett
* Looks okay in a quick glance, except error message spelling is poor:Bruce Momjian2001-08-04
| | | | | | | | | | | ! #define ARRISNULL(x) ( (x) ? ( ( ARR_NDIM(x) == NDIM ) ? ( ( ARRNELEMS( x ) ) ? 0 : 1 ) : ( ( ARR_NDIM(x) ) ? (elog(ERROR,"Array is not one-dimentional: %d di mentions", ARR_NDIM(x)),1) : 1 ) ) : 1 ) Should be "one-dimensional" and "dimensions". Bruce, would you fix that when you apply it? Tom
* 1. Fixed error with empty array ( '{}' ),Bruce Momjian2001-08-04
| | | | | | | test data changed to include such data 2. Test a dimension of an array ( we support only one-dimension) Oleg Bartunov
* > 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, theBruce Momjian2001-08-04
| | | | | | | | | | | | check > in convert.c > does not consider the fact that the value in the field has been altered to > be a '1' if the > backend handed it a 't'. The net result being that the first row on any > subsequent queries > has all it's boolean set to 0. Aidan Mountford
* Attached is a patch that does the following:Bruce Momjian2001-08-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1) improves performance of commit/rollback by reducing number of round trips to the server 2) uses 7.1 functionality for setting the transaction isolation level 3) backs out a patch from 11 days ago because that code failed to compile under jdk1.1 Details: 1) The old code was doing the following for each commit: commit begin set transaction isolation level xxx thus a call to commit was performing three round trips to the database. The new code does this in one round trip as: commit; begin; set transaction isolation level xxx In a simple test program that performs 1000 transactions (where each transaction does one simple select inside that transaction) has the following before and after timings: Client and Server on same machine old new --- --- 1.877sec 1.405sec 25.1% improvement Client and Server on different machines old new --- --- 4.184sec 2.927sec 34.3% improvement (all timings are an average of four different runs) 2) The driver was using 'set transaction isolation level xxx' at the begining of each transaction, instead of using the new 7.1 syntax of 'set session characteristics as transaction isolation level xxx' which only needs to be done once instead of for each transaction. This is done conditionally (i.e. if server is 7.0 or older do the old behaviour, else do the new behaviour) to not break backward compatibility. This also required the movement of some code to check/test database version numbers from the DatabaseMetaData object to the Connection object. 3) Finally while testing, I discovered that the code that was checked in 11 days ago actually didn't compile. The code in the patch for Connection.setCatalog() used Properties.setProperty() which only exists in JDK1.2 or higher. Thus compiling the JDBC1 driver failed as this method doesn't exist. Thus I backed out that patch. Barry Lind
* Fix handling of SIGCHLD, per recent pghackers discussion: on someTom Lane2001-08-04
| | | | | | | platforms system(2) gets confused unless the signal handler is set to SIG_DFL, not SIG_IGN. pgstats.c now uses pqsignal() as it should, not signal(). Also, arrange for the stats collector process to show a reasonable ID in 'ps', rather than looking like a postmaster.
* Fix residual breakage from Windows socket-errno patch: the routinesTom Lane2001-08-03
| | | | that should use regular errno, not WSAGetLastError(), now do so again.
* Fix win32.mak to support MULTIBYTE build --- it was pulling in severalTom Lane2001-08-03
| | | | | backend files that it shouldn't anymore, causing compile failures. Per report from Darko Prenosil.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 05:51:49 +0000