summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2002-03-11Bug fixes for the 2002-03-08 change.Hiroshi Inoue
1) Put back the error message for SQLError(). 2) Change Disallow premature to handle the SELECTed result. 3) Put back the behavior of AUTUCOMMIT mode change. 4) Fix SQLColumns for ODBC3.0. 5) Improve the handling of variable bookmark in ODBC3.0. 6) Enable Recognize Unique Index Button.
2002-03-11Fix markupPeter Eisentraut
2002-03-11Uppercase class selectors, to work with browsers that follow the standards.Peter Eisentraut
2002-03-11Back out this for Peter:Bruce Momjian
> This simple patch fixes broken Makefile, broken ApplySnapshot and > makes all utilities honour --verbose command line option. > > -- > Yours, Alexey V. Borzov, Webmaster of RDW.ru >
2002-03-10Fixed two bugs in define command in pgc.lMichael Meskes
2002-03-10Update and remove items:Bruce Momjian
< * Remove brackets as multi-statement rule grouping, must use parens (Bruce) > * -Remove brackets as multi-statement rule grouping, must use parens (Bruce) 458d457 < * Remove USING clause from pg_get_indexdef() if index is btree (Bruce)
2002-03-10Add DEFAULT_INDEX_TYPE == "btree", for clarity.Bruce Momjian
2002-03-10Disable brackets in multi-statement rules, as discussed.Bruce Momjian
2002-03-09Guard against NULL strings in SET key=val constructs.Thomas G. Lockhart
Problem noted by Fernando Nasser.
2002-03-09Added a check for not calling next() before getting objects from the result set,Dave Cramer
moved the check for columnIndex into same call check at the top of all getXXX added appropriate error
2002-03-09Code review for improved-hashing patch. Fix some portability issuesTom Lane
(char != unsigned char, Datum != uint32); make use of new hash code in dynahash hash tables and hash joins.
2002-03-09Here is a small patch that cleans up some error reporting in the JDBC ↵Dave Cramer
driver. PSQLExceptions are thrown instead of SQLExceptions and if a warning is received while waiting for the backend secret key, that warning is chained to the new Connection object instead of generating an exception. A couple new error messages have been added.
2002-03-09Wording improvements to runtime.sgml. Add mention in postgresql.confBruce Momjian
file that SIGHUP or "pg_ctl reload" are required for changes to take affect on a running server.
2002-03-08Improve wording of pg_hba.conf file.Bruce Momjian
2002-03-08Remove compile errors.Hiroshi Inoue
2002-03-081) Implement SQLParamOptions().Hiroshi Inoue
2) Handle Multiple results and implement SQLMoreResult(). 3) Improve multibyte handling thanks to Eiji Tokuya. 4) Add new options. LF <-> CR/LF converion. TRUE is -1 (for VB). 5) Introduce unicode(UCS-2) support. 6) Reduce the length of connection strings. 7) Improve SQLError, SQLGetDiagRec(ODBC 3.0). 8) Implement SQLTablePrivileges(). 9) Miscellaneous changes for ODBC 3.0 support.
2002-03-08analyze.o need not depend on parser.h.Tom Lane
2002-03-08Remove unnecessary inclusion.Tom Lane
2002-03-08Fix copying/equality-check bugs in GrantStmt and ConstraintsSetStmt,Tom Lane
per reports from Fernando Nasser. Also, rearrange order of declarations in parsenodes.h as suggested by Fernando.
2002-03-08Remove async TODO.detail file.Bruce Momjian
2002-03-08Update TODO items that are completed.Bruce Momjian
2002-03-08TODO item done:Bruce Momjian
* Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
2002-03-08Mark as done:Bruce Momjian
> * -Change DEBUG startup tag to LOG (Bruce)
2002-03-08AddBruce Momjian
> * Prevent aggregates from being used in rule WHERE clauses
2002-03-08Add missing colon to getopt() arg.Tom Lane
2002-03-07Add FULL in VACUUM psql completion.Bruce Momjian
2002-03-07Adjust elog() tags so source and regression tests match.Bruce Momjian
2002-03-07Back out psql domain improvements until domain is applied.Bruce Momjian
2002-03-07Back out domain patch until it works properly.Bruce Momjian
2002-03-07Also an small change to the tab-complete feature of psql which allows toBruce Momjian
use tables and views interchangeably. Manuel Sugawara
2002-03-06Fix syntax error introduced by patch.Bruce Momjian
2002-03-06I've attached a patch which implements Bob Jenkin's hash function forBruce Momjian
PostgreSQL. This hash function replaces the one used by hash indexes and the catalog cache. Hash joins use a different, relatively poor-quality hash function, but I'll fix that later. As suggested by Tom Lane, this patch also changes the size of the fixed hash table used by the catalog cache to be a power-of-2 (instead of a prime: I chose 256 instead of 257). This allows the catcache to lookup hash buckets using a simple bitmask. This should improve the performance of the catalog cache slightly, since the previous method (modulo a prime) was slow. In my tests, this improves the performance of hash indexes by between 4% and 8%; the performance when using btree indexes or seqscans is basically unchanged. Neil Conway <neilconway@rogers.com>
2002-03-06Enable ALTER TABLE ADD PRIMARY KEY for pg_dump, for performance reasonsBruce Momjian
so index is not on table during COPY. > > AFAICT, the patch I posted to -patches a little while to enable the > > usage of ALTER TABLE ADD PRIMARY KEY by pg_dump hasn't been applied, nor > > is it in the unapplied patches list. I was under the impression that > > this was in the queue for application -- did it just get lost? Neil Conway <neilconway@rogers.com>
2002-03-06alter table doc cleanups.Bruce Momjian
Neil Conway
2002-03-06This simple patch fixes broken Makefile, broken ApplySnapshot andBruce Momjian
makes all utilities honour --verbose command line option. -- Yours, Alexey V. Borzov, Webmaster of RDW.ru
2002-03-06Here is a diff of changes to the psql source code implementing a simpleBruce Momjian
'list domains' command '\dD'. This is the interface component of rbt@zort.ca's domain backend modifications. Jonathan Eisler
2002-03-06Ok. Updated patch attached.Bruce Momjian
- domain.patch -> source patch against pgsql in cvs - drop_domain.sgml and create_domain.sgml -> New doc/src/sgml/ref docs - dominfo.txt -> basic domain related queries I used for testing [ ADDED TO /doc] Enables domains of array elements -> CREATE DOMAIN dom int4[3][2]; Uses a typbasetype column to describe the origin of the domain. Copies data to attnotnull rather than processing in execMain(). Some documentation differences from earlier. If this is approved, I'll start working on pg_dump, and a \dD <domain> option in psql, and regression tests. I don't really feel like doing those until the system table structure settles for pg_type. CHECKS when added, will also be copied to to the table attributes. FK Constraints (if I ever figure out how) will be done similarly. Both will lbe handled by MergeDomainAttributes() which is called shortly before MergeAttributes(). Rod Taylor
2002-03-06Modify ALTER TABLE OWNER to change index ownership; code cleanup.Bruce Momjian
Neil Conway
2002-03-06Update docs for new stored procedure error levels.Bruce Momjian
2002-03-06Add new elog() levels to stored procedure languages. plperl DEBUG hackBruce Momjian
still needed because only removed in 7.4.
2002-03-06Add libpgeasy example file.Bruce Momjian
2002-03-06Synced parser with backend.Michael Meskes
2002-03-06Update reference pages for new INFO, NOTICE, WARNING elog() levels.Bruce Momjian
2002-03-06Update docs for new INFO, NOTICE, WARNING elog() levels.Bruce Momjian
2002-03-06Improve elog descriptions.Bruce Momjian
2002-03-06Add missing Unicode multibyte files.Bruce Momjian
2002-03-06Change made to elog:Bruce Momjian
o Change all current CVS messages of NOTICE to WARNING. We were going to do this just before 7.3 beta but it has to be done now, as you will see below. o Change current INFO messages that should be controlled by client_min_messages to NOTICE. o Force remaining INFO messages, like from EXPLAIN, VACUUM VERBOSE, etc. to always go to the client. o Remove INFO from the client_min_messages options and add NOTICE. Seems we do need three non-ERROR elog levels to handle the various behaviors we need for these messages. Regression passed.
2002-03-06Add name:Bruce Momjian
> * Improve concurrency of hash indexes (Neil Conway)
2002-03-06 changed Cancel to cancelDave Cramer
2002-03-05backed out changes for cancel, no need to look for two 'Z' responsesDave Cramer