aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Bug fixes for the 2002-03-08 change.Hiroshi Inoue2002-03-11
| | | | | | | | | | | 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.
* Fixed two bugs in define command in pgc.lMichael Meskes2002-03-10
|
* Add DEFAULT_INDEX_TYPE == "btree", for clarity.Bruce Momjian2002-03-10
|
* Disable brackets in multi-statement rules, as discussed.Bruce Momjian2002-03-10
|
* Guard against NULL strings in SET key=val constructs.Thomas G. Lockhart2002-03-09
| | | | Problem noted by Fernando Nasser.
* Added a check for not calling next() before getting objects from the result set,Dave Cramer2002-03-09
| | | | | | moved the check for columnIndex into same call check at the top of all getXXX added appropriate error
* Code review for improved-hashing patch. Fix some portability issuesTom Lane2002-03-09
| | | | | (char != unsigned char, Datum != uint32); make use of new hash code in dynahash hash tables and hash joins.
* Here is a small patch that cleans up some error reporting in the JDBC ↵Dave Cramer2002-03-09
| | | | 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.
* Wording improvements to runtime.sgml. Add mention in postgresql.confBruce Momjian2002-03-09
| | | | | file that SIGHUP or "pg_ctl reload" are required for changes to take affect on a running server.
* Improve wording of pg_hba.conf file.Bruce Momjian2002-03-08
|
* Remove compile errors.Hiroshi Inoue2002-03-08
|
* 1) Implement SQLParamOptions().Hiroshi Inoue2002-03-08
| | | | | | | | | | | | | 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.
* analyze.o need not depend on parser.h.Tom Lane2002-03-08
|
* Remove unnecessary inclusion.Tom Lane2002-03-08
|
* Fix copying/equality-check bugs in GrantStmt and ConstraintsSetStmt,Tom Lane2002-03-08
| | | | | per reports from Fernando Nasser. Also, rearrange order of declarations in parsenodes.h as suggested by Fernando.
* TODO item done:Bruce Momjian2002-03-08
| | | | * Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
* Add missing colon to getopt() arg.Tom Lane2002-03-08
|
* Add FULL in VACUUM psql completion.Bruce Momjian2002-03-07
|
* Adjust elog() tags so source and regression tests match.Bruce Momjian2002-03-07
|
* Back out psql domain improvements until domain is applied.Bruce Momjian2002-03-07
|
* Back out domain patch until it works properly.Bruce Momjian2002-03-07
|
* Also an small change to the tab-complete feature of psql which allows toBruce Momjian2002-03-07
| | | | | | use tables and views interchangeably. Manuel Sugawara
* Fix syntax error introduced by patch.Bruce Momjian2002-03-06
|
* I've attached a patch which implements Bob Jenkin's hash function forBruce Momjian2002-03-06
| | | | | | | | | | | | | | | | | | | 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>
* Enable ALTER TABLE ADD PRIMARY KEY for pg_dump, for performance reasonsBruce Momjian2002-03-06
| | | | | | | | | | | 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>
* Here is a diff of changes to the psql source code implementing a simpleBruce Momjian2002-03-06
| | | | | | | 'list domains' command '\dD'. This is the interface component of rbt@zort.ca's domain backend modifications. Jonathan Eisler
* Ok. Updated patch attached.Bruce Momjian2002-03-06
| | | | | | | | | | | | | | | | | | | | | | | | | | | | - 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
* Modify ALTER TABLE OWNER to change index ownership; code cleanup.Bruce Momjian2002-03-06
| | | | Neil Conway
* Add new elog() levels to stored procedure languages. plperl DEBUG hackBruce Momjian2002-03-06
| | | | still needed because only removed in 7.4.
* Add libpgeasy example file.Bruce Momjian2002-03-06
|
* Synced parser with backend.Michael Meskes2002-03-06
|
* Improve elog descriptions.Bruce Momjian2002-03-06
|
* Add missing Unicode multibyte files.Bruce Momjian2002-03-06
|
* Change made to elog:Bruce Momjian2002-03-06
| | | | | | | | | | | | | | | | | | | 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.
* changed Cancel to cancelDave Cramer2002-03-06
|
* backed out changes for cancel, no need to look for two 'Z' responsesDave Cramer2002-03-05
|
* Patch by Nicolas Verger to correctly propogate SQLWarning to the Statement ↵Dave Cramer2002-03-05
| | | | and ResultSet
* fixed cancel query bug introduced by patchDave Cramer2002-03-05
|
* At this moment, --enable-debug adds debugging information to most of theBruce Momjian2002-03-05
| | | | | | | | | | parts o f postgresql. The jdbc drivers are never compiled with debugging support. This p atch make sure that debugging information is added to the jdbc jar when the --en able-debug is added. This was usefull for me for debugging some java jdbc poolin g objects but this might perhaps be usefull for other people too? Dries Verachtert
* Prevent failed passwords from being echoed to server logs, for security.Bruce Momjian2002-03-05
|
* Prevent failed passwords from being echoed to server logs, for security.Bruce Momjian2002-03-05
|
* Adds \du documentation line for \? in psqls help.cBruce Momjian2002-03-05
| | | | | | | Thought I saw a patch earlier converting docs to use []s, so this uses them. Rod Taylor
* Back out old version and update with newer patch of:Bruce Momjian2002-03-05
| | | | | | Fix for non-blocking connections in libpq Bernhard Herzog
* > Tatsuo Ishii wrote:Bruce Momjian2002-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > > > > It was made to cope with encoding such as an Asian bloc in 7.2Beta2. > > > > > > > > Added ServerEncoding > > > > Korean (JOHAB), Thai (WIN874), > > > > Vietnamese (TCVN), Arabic (WIN1256) > > > > > > > > Added ClientEncoding > > > > Simplified Chinese (GBK), Korean (UHC) > > > > > > > > > > > > > http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2b2.newencoding.diff.tar.gz > > > > (608K) > > > > > > Looks good. I need some people to review this for me. > > > > For me they look good too. The only missing part is a > > documentation. I will ask him to write it up. If he couldn't, I will > > do it for him. > > > The diff is 3mb > > > but appears to address only additions to multibyte. I have attached a > > > list of files it modifies. Also, look at the sizes of the mb/ > > > directory. It is getting large: > > > > > > 4 ./CVS > > > 6 ./Unicode/CVS > > > 3433 ./Unicode > > > 6197 . > > > > Yes. We definitely need the on-the-fly encoding addition capability: > > i.e. CREATE CHRACTER SET in the future... > > -- > > Tatsuo Ishii > > > > Address chainge. http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2.newencoding.diff.gz Add PsqlODBC and document ...etc patch. Eiji Tokuya
* I attach a version of my toast-slicing patch, against current CVSBruce Momjian2002-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (current as of a few hours ago.) This patch: 1. Adds PG_GETARG_xxx_P_SLICE() macros and associated support routines. 2. Adds routines in src/backend/access/tuptoaster.c for fetching only necessary chunks of a toasted value. (Modelled on latest changes to assume chunks are returned in order). 3. Amends text_substr and bytea_substr to use new methods. It now handles multibyte cases -and should still lead to a performance improvement in the multibyte case where the substring is near the beginning of the string. 4. Added new command: ALTER TABLE tabname ALTER COLUMN colname SET STORAGE {PLAIN | EXTERNAL | EXTENDED | MAIN} to parser and documented in alter-table.sgml. (NB I used ColId as the item type for the storage mode string, rather than a new production - I hope this makes sense!). All this does is sets attstorage for the specified column. 4. AlterTableAlterColumnStatistics is now AlterTableAlterColumnFlags and handles both statistics and storage (it uses the subtype code to distinguish). The previous version of my patch also re-arranged other code in backend/commands/command.c but I have dropped that from this patch.(I plan to return to it separately). 5. Documented new macros (and also the PG_GETARG_xxx_P_COPY macros) in xfunc.sgml. ref/alter_table.sgml also contains documentation for ALTER COLUMN SET STORAGE. John Gray
* I was digging through the GiST code, and figured I'd fix up some of theBruce Momjian2002-03-05
| | | | | | | | | | | | "bad smell" in that code. Stuff like function parameters that aren't used, typos in the comments, comparison between signed and unsigned ints, etc. Attached is a pretty trivial patch; it compiles, but beyond that completely untested. Unless anyone sees any problems, please apply for 7.3. Neil Conway
* Here's a patch against 7.1.3 that fixes a problem with sending largerBruce Momjian2002-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | queries over non-blocking connections with libpq. "Larger" here basically means that it doesn't fit into the output buffer. The basic strategy is to fix pqFlush and pqPutBytes. The problem with pqFlush as it stands now is that it returns EOF when an error occurs or when not all data could be sent. The latter case is clearly not an error for a non-blocking connection but the caller can't distringuish it from an error very well. The first part of the fix is therefore to fix pqFlush. This is done by to renaming it to pqSendSome which only differs from pqFlush in its return values to allow the caller to make the above distinction and a new pqFlush which is implemented in terms of pqSendSome and behaves exactly like the old pqFlush. The second part of the fix modifies pqPutBytes to use pqSendSome instead of pqFlush and to either send all the data or if not all data can be sent on a non-blocking connection to at least put all data into the output buffer, enlarging it if necessary. The callers of pqPutBytes don't have to be changed because from their point of view pqPutBytes behaves like before. It either succeeds in queueing all output data or fails with an error. I've also added a new API function PQsendSome which analogously to PQflush just calls pqSendSome. Programs using non-blocking queries should use this new function. The main difference is that this function will have to be called repeatedly (calling select() properly in between) until all data has been written. AFAICT, the code in CVS HEAD hasn't changed with respect to non-blocking queries and this fix should work there, too, but I haven't tested that yet. Bernhard Herzog
* Previous patch to mark UNION outputs with common typmod (if any) breaksTom Lane2002-03-05
| | | | | | three-or-more-way UNIONs, as per example from Josh Berkus. Cause is a fragile assumption that one tlist's entries will exactly match another. Restructure code to make that assumption a little less fragile.
* Doug Fields patch to prevent exception being thrown on zero length arraysDave Cramer2002-03-05
|
* patch from Zhenbang WeiDave Cramer2002-03-05
| | | | | The errors_zh_TW.properties must be translated using native2ascii or it will raise an exception. Please replace the old file.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-26 05:32:28 +0000