Commit Graph

  • 76fc795e5c Fix bug in pg_convert() per report from MaC.Yui. It pfree() wrong pointer. Tatsuo Ishii 2002-08-19 04:58:26 +00:00
  • 10b374aecf Fix bug in pg_convert() per report from MaC.Yui. It pfree() wrong pointer. Tatsuo Ishii 2002-08-19 04:08:08 +00:00
  • d35dc342f1 Fix broken tag. Tatsuo Ishii 2002-08-19 04:05:00 +00:00
  • f4ad5e8d18 Clean up leftover bugs from recent COPY feature patch --- missed required changes to copyfuncs/equalfuncs. Tom Lane 2002-08-19 00:40:15 +00:00
  • 5f6a27f8f9 Add missing copyfuncs/equalfuncs entries, including T_Null which has been missing forever; surprising it wasn't noticed before. The other additions are, um, sloppiness in certain recent feature additions. Tom Lane 2002-08-19 00:11:53 +00:00
  • 6fb05e06a3 Improve obsolete comment. Tom Lane 2002-08-19 00:10:03 +00:00
  • 0556e9cfae Fix small copy-and-pasteo. Tom Lane 2002-08-18 21:05:32 +00:00
  • e1b040a7c3 Fix potential buffer overrun in cube_out(), per report from Bruno Wolff. Tom Lane 2002-08-18 20:15:52 +00:00
  • 22bfa72068 Remove optimization whereby parser would make only one sort-list entry when two equal() targetlist items were to be added to an ORDER BY or DISTINCT list. Although indeed this would make sorting fractionally faster by sometimes saving a comparison, it confuses the heck out of later stages of processing, because it makes it look like the user wrote DISTINCT ON rather than DISTINCT. Bug reported by joe@piscitella.com. Tom Lane 2002-08-18 18:46:15 +00:00
  • 7f32f0f034 Synced parser with backend. Michael Meskes 2002-08-18 14:32:21 +00:00
  • 315a9ca32e Make CREATE CONSTRAINT TRIGGER check for REFERENCES privilege on both master and slave tables. Peter Eisentraut 2002-08-18 11:20:05 +00:00
  • c828ec8820 Make pg_dump output more portable and more pleasing to look at. Peter Eisentraut 2002-08-18 09:36:26 +00:00
  • 41298cf8a6 Add #include <sys/time.h>. Tom Lane 2002-08-18 03:47:08 +00:00
  • 2efb8e8070 Code review for 'at character n' patch --- point at proper end of a token scanned by multiple lex rules. Tom Lane 2002-08-18 03:35:08 +00:00
  • 2c6b34d959 Add db-local user names, per discussion on hackers. Bruce Momjian 2002-08-18 03:03:26 +00:00
  • 4b26e7d24b More changes to match new error format. Bruce Momjian 2002-08-18 03:00:17 +00:00
  • c9a524000d Use variable for format to suppress overly-anal-retentive gcc warning about %c Tom Lane 2002-08-18 02:48:41 +00:00
  • 06b604b737 Modify regression tests to match new error reporting format from Gavin. Bruce Momjian 2002-08-18 02:48:29 +00:00
  • 3dd8369f77 Back out tcl patch, per Tom Lane: Bruce Momjian 2002-08-18 01:39:43 +00:00
  • 5bf6af6cf4 Add includes for prototype using timeval. Bruce Momjian 2002-08-18 01:35:40 +00:00
  • 1c69f13447 Clean up compile warnings. Bruce Momjian 2002-08-18 00:06:01 +00:00
  • e16591038a Fix typo. Tom Lane 2002-08-17 20:24:51 +00:00
  • d04e9137c9 Reverse out XLogDir/-X write-ahead log handling, per discussion. Original patch from Thomas. Bruce Momjian 2002-08-17 15:12:07 +00:00
  • 7c02c86d0f Add: Bruce Momjian 2002-08-17 15:09:41 +00:00
  • a8d27511c7 Done: Bruce Momjian 2002-08-17 13:14:07 +00:00
  • fc68e44062 Add lock file. Bruce Momjian 2002-08-17 13:11:43 +00:00
  • 54124240ae In that case, attached is a patch which locates the beginning of the offending token more efficiently (per your suggestion of using scanbuf). The new patch does the same as before: Bruce Momjian 2002-08-17 13:06:50 +00:00
  • 82119a696e [ Newest version of patch applied.] Bruce Momjian 2002-08-17 13:04:19 +00:00
  • f0ed4311b6 Add libpq connection timeout parameter. Bruce Momjian 2002-08-17 12:33:18 +00:00
  • b7214a877c What I have done for libpgtcl: Everytime if I do PQconsumeInput (when the backend channel gets readable) I check for the return value. (0 == error) and generate a notification manually, e.g. fixed string connection_closed) and pass it to the TCL event queue. The only other thing I had to do is to comment out removing all pending events in PgStopNotifyEventSource whenever the connection was unexpectedly closed (so the manually generated event will not be deleted). Bruce Momjian 2002-08-17 12:19:31 +00:00
  • b813554dbd Improve documentation of trigger firing queue handling, cleanup. Bruce Momjian 2002-08-17 12:15:49 +00:00
  • 2132ac89bf Editorial corrections. Tom Lane 2002-08-17 05:07:18 +00:00
  • 8bca70fad5 Broken markup. Tom Lane 2002-08-17 04:09:18 +00:00
  • 675a7b8280 Cleanup. Tom Lane 2002-08-17 04:06:48 +00:00
  • cdfc54db6f Fix broken Makefiles. Tom Lane 2002-08-17 04:03:36 +00:00
  • d383b734f8 Add missing links. Tom Lane 2002-08-17 03:38:43 +00:00
  • 08f245bfd4 Add doc file for pg_resetxlog. Bruce Momjian 2002-08-17 02:45:29 +00:00
  • 33e3c9b085 Add files for pg_resetxlog. Bruce Momjian 2002-08-17 02:44:24 +00:00
  • 6945ea3445 Move pg_controldata to /bin. Bruce Momjian 2002-08-17 02:43:08 +00:00
  • a208ea72bc Modify pg_dump to dump foreign-key constraints as constraints, not as sets of triggers. Also modify psql \d command to show foreign key constraints as such and hide the triggers. pg_get_constraintdef() function added to backend to support these. From Rod Taylor, code review and some editorialization by Tom Lane. Tom Lane 2002-08-16 23:01:21 +00:00
  • 8dabef838c Code review for patch to dump primary and unique constraints as constraints, rather than as CREATE INDEX commands. Tom Lane 2002-08-16 21:03:42 +00:00
  • ad7d3bddea Make domain types indexable. Rod Taylor & Tom Lane. Tom Lane 2002-08-16 20:55:09 +00:00
  • 141539c31e Improve wording. Bruce Momjian 2002-08-16 20:36:25 +00:00
  • cd1f4087c9 Move pg_controldata from /contrib to src/bin. Bruce Momjian 2002-08-16 20:34:06 +00:00
  • 7ffe65fefb removed duplicate code from jdbc2 classes Dave Cramer 2002-08-16 19:37:57 +00:00
  • b3766d9fa5 applied patch to fix encoding bug supplied by Jun Kawai Dave Cramer 2002-08-16 19:35:46 +00:00
  • 369e2b6afa Applied patch for MD5 bug submitted by Jun Kawai Dave Cramer 2002-08-16 19:34:57 +00:00
  • 875364e5ff Performance tweaks to StringBuffer suggested by hhaag@gmx.de Barry Lind 2002-08-16 17:51:38 +00:00
  • ab0f98518c Add "few": Bruce Momjian 2002-08-16 17:05:18 +00:00
  • fa9d7c1c13 Add blank line. Bruce Momjian 2002-08-16 15:13:13 +00:00
  • 8c8a56ee2d Add: Bruce Momjian 2002-08-16 15:12:43 +00:00
  • 8352113169 This patch improves the "Client Authentication" section of the user's guide in a few minor ways. Bruce Momjian 2002-08-16 04:48:16 +00:00
  • b4794bfb54 This patch improves the "Database Users and Permissions" section of the Administrator's Guide. This section needs a lot more work, but this is a start anyway... Bruce Momjian 2002-08-16 04:47:43 +00:00
  • 83a0d895ca Added: Bruce Momjian 2002-08-16 04:45:44 +00:00
  • 2f7e3a2ffc Added: Bruce Momjian 2002-08-16 04:31:52 +00:00
  • 6debc56bbc Remove interfaces/ssl. Was unclaimed stuff that had no more usefulness. Bruce Momjian 2002-08-16 04:29:15 +00:00
  • 52f8c56a41 Done: > o -Prevent loss of indexes, permissions, inheritance Bruce Momjian 2002-08-15 17:47:24 +00:00
  • ea1954fc35 Done: Bruce Momjian 2002-08-15 17:46:46 +00:00
  • b1a5f87209 Tom Lane wrote: > There's no longer a separate call to heap_storage_create in that routine > --- the right place to make the test is now in the storage_create > boolean parameter being passed to heap_create. A simple change, but > it passeth patch's understanding ... Bruce Momjian 2002-08-15 16:36:08 +00:00
  • 38294db64b Reorder entry to be alphabetical to match others. Bruce Momjian 2002-08-15 14:26:15 +00:00
  • 1991fe74e1 This fixes some text as well as enforces the use of "drop table cascade" since we moved from an implicate to explicate implementation. Bruce Momjian 2002-08-15 03:33:36 +00:00
  • 4f1ac055f1 Well, that certainly appeared to be very straight forward. pg.py and syscat.py scripts were both modified. pg.py uses it to cache a list of pks (which is seemingly does for every db connection) and various attributes. syscat uses it to walk the list of system tables and queries the various attributes from these tables. Bruce Momjian 2002-08-15 03:32:36 +00:00
  • 147aa84c1a http://archives.postgresql.org/pgsql-bugs/2002-06/msg00086.php and never saw a fix offered up. Since I'm gearing up to use Postgres and Python soon, I figured I'd have a hand at trying to get this sucker addressed. Apologies if this has already been plugged. I looked in the archives and never saw a response. Bruce Momjian 2002-08-15 03:31:45 +00:00
  • db147006c1 Backed out. It is part of a later patch. Bruce Momjian 2002-08-15 03:04:07 +00:00
  • 2860041bf0 August 13, 2002 Use parser of OpenFTS v0.33. Bruce Momjian 2002-08-15 03:02:08 +00:00
  • 1276356268 PostgreSQL 7.2.1 Documentation Chapter 1. libpq - C Library 1.3. Command Execution Functions 1.3.3. Escaping binary strings for inclusion in SQL queries Bruce Momjian 2002-08-15 03:00:59 +00:00
  • 88bd306832 > Neil Conway <nconway@klamath.dyndns.org> writes: > > This patch improves the documentation of the UPDATE and ALTER TABLE > > commands to elaborate on the effect of specifying an "ONLY" clause. > > Unfortunately this is still only half the truth ... see the > SQL_INHERITANCE configuration variable. Bruce Momjian 2002-08-15 02:59:18 +00:00
  • 66eb8df6a4 The attached patch changes most of the usages of sprintf() to snprintf() in contrib/. I didn't touch the places where pointer arithmatic was being used, or other areas where the fix wasn't trivial. I would think that few, if any, of the usages of sprintf() were actually exploitable, but it's probably better to be paranoid... Bruce Momjian 2002-08-15 02:58:29 +00:00
  • 7f4981f4af I'm giving a try at some TODO items. Currently it's the turn of the PGPASSWORDFILE environment variable. I have modified libpq to make use of this variable. I present the first cut here. Bruce Momjian 2002-08-15 02:56:19 +00:00
  • 46aaa5dda3 Appears there is a problem finding the opclass when indexing a domain. Bruce Momjian 2002-08-15 02:53:35 +00:00
  • 45e2544584 As discussed on several occasions previously, the new anonymous composite type capability makes it possible to create a system view based on a table function in a way that is hopefully palatable to everyone. The attached patch takes advantage of this, moving show_all_settings() from contrib/tablefunc into the backend (renamed all_settings(). It is defined as a builtin returning type RECORD. During initdb a system view is created to expose the same information presently available through SHOW ALL. For example: Bruce Momjian 2002-08-15 02:51:27 +00:00
  • 4c4854c458 The second enables tab-complete to analyze. It ignores schema stuff (so does every tab-completion command AFAICS) Bruce Momjian 2002-08-15 02:49:04 +00:00
  • dc8705531d Really truly enable encrypted passwords by default. Tom Lane 2002-08-14 23:02:59 +00:00
  • b20f80f0b3 Enable encrypted passwords by default. Bruce Momjian 2002-08-14 22:07:56 +00:00
  • b3dd55c651 Added support for JDBC3. The driver will now build under JDBC3 (i.e. Java 1.4). This concludes my changes that restructured the code to support JDBC3. The jdbc unit tests were also resturctured to allow different tests between jdbc2 and jdbc3, although currently make check (aka ant test) for JDBC3 just runs the JDBC2 tests. Of special note the largeobject/PGblob and PGclob classes have been moved under the jdbc2/jdbc3 specific directories as they now differ by jdbc version. Also note that this checkin removes the PostgresqlDataSource and files in the xa directory. A recent checkin has added new datasource support that replaces the functionality provided by these classes. Barry Lind 2002-08-14 20:35:40 +00:00
  • 64a0649432 Update text: Bruce Momjian 2002-08-14 18:39:05 +00:00
  • 5b74309053 Update: Bruce Momjian 2002-08-14 17:45:20 +00:00
  • dec918479f I guess I'd vote for changing the code to be Bruce Momjian 2002-08-14 05:49:22 +00:00
  • 538b101595 Fix memory leak in SetClientEncoding(). Tatsuo Ishii 2002-08-14 05:33:34 +00:00
  • fcbc87c1ee Add: Bruce Momjian 2002-08-14 04:58:17 +00:00
  • 561e25ad71 Oops, not done: Bruce Momjian 2002-08-14 03:41:09 +00:00
  • 596ba5ecc4 Updated: Bruce Momjian 2002-08-14 03:40:41 +00:00
  • 106c733c34 Spacing improvement. Bruce Momjian 2002-08-14 03:01:43 +00:00
  • 293ab5abf3 Fix spacing. Bruce Momjian 2002-08-14 02:51:13 +00:00
  • 9f19f3c836 Added: Bruce Momjian 2002-08-14 02:49:42 +00:00
  • 969e0246ed Add Cyrillic and other encodings for encoding conversion. Patches submitted by Kaori Inaba (i-kaori@sra.co.jp). Tatsuo Ishii 2002-08-14 02:45:10 +00:00
  • d3bd1a00bc Remove namedatalen from TODO.detail. No longer needed. Bruce Momjian 2002-08-14 02:28:30 +00:00
  • e9a0de8b3f Done: Bruce Momjian 2002-08-14 02:24:47 +00:00
  • c028c2a703 Put back old code. Bruce Momjian 2002-08-13 21:04:36 +00:00
  • f340648939 Update for longer NAMEDATALEN. Bruce Momjian 2002-08-13 20:41:13 +00:00
  • 46bb23ac01 Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per discussion on hackers. Bruce Momjian 2002-08-13 20:40:44 +00:00
  • f8b4a2e0f0 Fix tuple-chain-moving tests to handle marked-for-update tuples correctly (they are not part of a chain). When failing to find a parent tuple in an update chain, emit a warning and abandon repair_frag, but do not give an error as before. This should eliminate the infamous 'No one parent tuple was found' failure, which we now realize is not a can't-happen condition but a perfectly valid database state. Per recent pghackers discussion. Tom Lane 2002-08-13 20:14:24 +00:00
  • 0affc29e1e Make sure that t_ctid is reset to equal t_self in heap_delete and heap_mark4update; this avoids situations where a deleted tuple might look like it is chained to something else. Also, cause all the WAL redo routines to set t_ctid to equal t_self, rather than leaving it undefined as before. Make heap_xlog_clean set the page's LSN and SUI correctly. All per past discussions in pghackers, ranging back to last December. Tom Lane 2002-08-13 20:11:03 +00:00
  • 1e4c4f9eb7 Remove obsolete uses of lanispl. Only used in pg_dump now, but can be removed altogether if pg_dump doesn't need it anymore. Peter Eisentraut 2002-08-13 17:22:08 +00:00
  • ccf15026e6 Add bitmap index mention. Bruce Momjian 2002-08-13 05:08:35 +00:00
  • b6d8df67d3 Update: Bruce Momjian 2002-08-13 04:32:28 +00:00
  • 282a5884de Correct description of sequence privileges. Peter Eisentraut 2002-08-12 20:02:09 +00:00
  • c024fa4cb5 Remove use of __P so that <sys/cdefs.h> is not needed. Per suggestion from Martin Renters. Tom Lane 2002-08-12 15:24:07 +00:00
  • 1ccc2451c6 Convert possibly-unsafe sprintf's to snprintf's. Tom Lane 2002-08-12 14:47:46 +00:00
  • b47c4ddc7f Buffer-overrun paranoia. Tom Lane 2002-08-12 14:35:26 +00:00