Commit Graph

  • 42423c7195 Manually indent gram.y to be consistent. Bruce Momjian 2002-06-17 20:27:43 +00:00
  • 134a1c8178 Use KAME accessor macros for addr8. Bruce Momjian 2002-06-17 15:55:09 +00:00
  • 9e1c5fba03 Fix missing 'buf' variable in SSL sources and add missing includes. Bruce Momjian 2002-06-17 15:23:36 +00:00
  • 7005e4c076 Fix SSL DEBUG levels to match CVS elog flags. Bruce Momjian 2002-06-17 15:19:28 +00:00
  • 0bb61f4af8 Back out accidental COPY data changes. Bruce Momjian 2002-06-17 15:01:45 +00:00
  • 507ed0332a Repair AlterTableOwner --- was failing for relations with indexes. Tom Lane 2002-06-17 14:31:32 +00:00
  • 2fabb99388 Fixed parser bug concerning octal numbers in single quotes. Michael Meskes 2002-06-17 13:23:27 +00:00
  • e4cd7c315f Rename DEBUG to DEBUG1 in SSL code. Bruce Momjian 2002-06-17 07:33:25 +00:00
  • 10f05d8127 Merge ALTER GROUP ADD/DROP rules by creating add_drop action. Bruce Momjian 2002-06-17 07:00:27 +00:00
  • f91ee129a7 Simplify optional WITH handling in CREATE USER, ALTER USER, CREATE GROUP. Make WITH optional in CREATE DATABASE for consistency. Bruce Momjian 2002-06-17 05:40:32 +00:00
  • 0daee96ed1 implemented refresh row Dave Cramer 2002-06-16 18:26:53 +00:00
  • 0dbfea39f3 Remove KSQO from GUC and move file to _deadcode. Bruce Momjian 2002-06-16 00:09:12 +00:00
  • b50cbbd66b Fix up memory leakage created by recent changes. Tom Lane 2002-06-15 22:25:40 +00:00
  • 62d4526114 Ooops, fix busted markup. Tom Lane 2002-06-15 22:15:03 +00:00
  • 32fecad80a Clean up gcc warnings. Avoid the bad habit of putting externs in .c files rather than a header file where they belong. Pay some modicum of attention to picking global routine names that aren't likely to conflict with surrounding applications. Tom Lane 2002-06-15 22:06:09 +00:00
  • c63bc32c2c Fix up gcc warnings, improve comments. Tom Lane 2002-06-15 21:52:31 +00:00
  • 2da3742cf5 Add a little more material to the new section about evaluation order. Tom Lane 2002-06-15 21:28:55 +00:00
  • eb1ad5b4b5 Patch for current_schemas to optionally include implicit ... Bruce Momjian 2002-06-15 20:03:51 +00:00
  • 79ff2e96de PATCH SSL_pending() checks in libpq/fe-misc.c: Bruce Momjian 2002-06-15 20:01:31 +00:00
  • 6e8a1a6717 WriteBuffer return value: Bruce Momjian 2002-06-15 19:59:59 +00:00
  • 82b14b62ca Update LOG_PID to mention it doesn't control syslog. Bruce Momjian 2002-06-15 19:58:53 +00:00
  • 918e864f14 Remove some pre-WAL relics: SharedBufferChanged BufferRelidLastDirtied BufferTagLastDirtied BufferDirtiedByMe Bruce Momjian 2002-06-15 19:55:38 +00:00
  • 3c35face41 This patch wraps all accesses to t_xmin, t_cmin, t_xmax, and t_cmax in HeapTupleHeaderData in setter and getter macros called HeapTupleHeaderGetXmin, HeapTupleHeaderSetXmin etc. Bruce Momjian 2002-06-15 19:54:24 +00:00
  • 7882179994 The normal operation of our servers is to have tcpip_sockets enabled, but occasionally I may need to shut down the server and restart it w/o tcpip sockets. Postmaster has the -i option to turn on tcpip connections, but it wasn't immediately clear how to easily or temporarily turn it off (when it's been enabled in postgresql.conf). Bruce Momjian 2002-06-15 19:52:56 +00:00
  • dbbd13bdb5 Fix for TAB completion using GRANT DELETE in psql. Bruce Momjian 2002-06-15 19:43:47 +00:00
  • 6b9e742458 The macaddr datatype understands most formats of MAC address, except 12 hex digits with no separators, eg 00AABBCCDDEE. This is easily remedied with the following patch (against 7.2.1): Bruce Momjian 2002-06-15 19:39:33 +00:00
  • cd7be4d947 Noted with versions 7.0.3, 7.1.3, and 7.2.1: Bruce Momjian 2002-06-15 19:37:48 +00:00
  • eeb1dd5068 On Wed, 2002-05-29 at 01:41, Tom Lane wrote: > > > Is it a good idea to provide an example (such as the above), or should I > > just try and describe the behaviour? > > Examples are generally good things ... Bruce Momjian 2002-06-15 19:34:51 +00:00
  • 240de617fb The method PgLargeObject::LOid() is missing an implementation in the .cc file. Bruce Momjian 2002-06-15 19:30:40 +00:00
  • d54ae2aff2 Add C++ indent tool. Bruce Momjian 2002-06-15 19:13:04 +00:00
  • 2e58024066 This patch fixes a few minor problems with libpq++: remove the deprecated PQExec(" ") in the wrapper around PQnotifies(), fix the Makefile for the examples so that they will actually compile properly (with the exception of #5, which depends on internal headers), make a minor change to libpq++.h so that "make examples" now works on my machine, update some documentation, fix some grammatical problems, and remove some of the more hideous comments. Bruce Momjian 2002-06-15 18:49:29 +00:00
  • 7e49585cad Back-patch 7.3 fix to fully parenthesize UNION/EXCEPT/INTERSECT queries in ruleutils output. The previous partial parenthesization was a hack to get around grammar restrictions that have since been fixed; and as Sam O'Connor pointed out, there were cases where it didn't work. Tom Lane 2002-06-15 18:38:10 +00:00
  • 133df7ce70 Add LOCALTIME and LOCALTIMESTAMP functions per SQL99 standard. Remove ODBC-compatible empty parentheses from calls to SQL99 functions for which these parentheses do not match the standard. Update the ODBC driver to ensure compatibility with the ODBC standard for these functions (e.g. CURRENT_TIMESTAMP, CURRENT_USER, etc). Include a new appendix in the User's Guide which lists the labeled features for SQL99 (the labeled features replaced the "basic", "intermediate", and "advanced" categories from SQL92). features.sgml does not yet split this list into "supported" and "unsupported" lists. Thomas G. Lockhart 2002-06-15 03:00:09 +00:00
  • bad5fe9797 Search the existing regular expression cache as a ring buffer. Will optimize the case for repeated calls for the same expression, which seems to be the most common case. Formerly, always searched from the first entry. May want to look at the least-recently-used algorithm to make sure it is identifying the right slots to reclaim. Seems silly to do math when it seems that we could simply use an incrementing counter... Thomas G. Lockhart 2002-06-15 02:49:47 +00:00
  • e62660080c Add NetBSD/MIPS as a supported platform. Thomas G. Lockhart 2002-06-15 02:41:56 +00:00
  • 63a354c4bb Make encryption of stored passwords the default, as discussed months ago. Bruce Momjian 2002-06-15 01:29:50 +00:00
  • 579eab9880 Remove pfrees of cached pg_pwd file, per Tom Lane. Bruce Momjian 2002-06-15 00:52:23 +00:00
  • fd8b153912 added empty result set testing Dave Cramer 2002-06-14 14:01:36 +00:00
  • 6e2fab0a41 added empty result set testing Dave Cramer 2002-06-14 10:56:13 +00:00
  • 1ed4a922b8 Yet another SSL patch. :-) This one adds some informational messages on the server, if DebugLvl >= 2. Bruce Momjian 2002-06-14 04:38:04 +00:00
  • eb7afc1407 SSL patch that adds support for optional client certificates. Bruce Momjian 2002-06-14 04:36:58 +00:00
  • b8b6691e52 Patch that checks ownership and permissions on server static private key. (You want it to be a regular file owned by the database process, with 0400 or 0600 permissions.) Bruce Momjian 2002-06-14 04:35:02 +00:00
  • 8f44024639 SSL patch to periodically renegotiate session key. Bruce Momjian 2002-06-14 04:33:53 +00:00
  • 55d053233c SSL support for ephemeral DH keys. Bruce Momjian 2002-06-14 04:31:49 +00:00
  • 19570420f5 UPDATED PATCH: Bruce Momjian 2002-06-14 04:23:17 +00:00
  • eb43af3210 Back out SSL changes. Newer patch available. Bruce Momjian 2002-06-14 04:09:37 +00:00
  • a9bd17616e Attached are a revised set of SSL patches. Many of these patches are motivated by security concerns, it's not just bug fixes. The key differences (from stock 7.2.1) are: Bruce Momjian 2002-06-14 03:56:47 +00:00
  • 15378a53f8 Add support for GB18030 Tatsuo Ishii 2002-06-14 03:30:56 +00:00
  • b1313e3474 Suppress 'owner of datatype appears to be invalid' warning message for undefined (shell) types. Tom Lane 2002-06-13 20:02:31 +00:00
  • c66eb00adc Allow ANALYZE to run in a transaction. Bruce Momjian 2002-06-13 19:52:02 +00:00
  • deec3cb91c Add: Bruce Momjian 2002-06-13 18:01:38 +00:00
  • ad579a9e43 Add Win32 thread to TODO.detail. Bruce Momjian 2002-06-13 18:00:47 +00:00
  • f67a931aa4 Make WHERE conditions pulled up from subqueries be executed before outer WHERE conditions, if there is no reason to do it differently. Tom Lane 2002-06-13 15:10:25 +00:00
  • b1ac89f594 removed personal test parameters Dave Cramer 2002-06-13 14:37:30 +00:00
  • bbc9b759d6 Add PLACING to the list of reserved keywords. Added as a token in the last update to support the new OVERLAY() function. Thomas G. Lockhart 2002-06-13 14:16:43 +00:00
  • 5598cbf641 Added test for newly implemented updateable result sets Dave Cramer 2002-06-13 14:06:11 +00:00
  • 603c46d8ce changes to accomodate updateable resultset mostly just call setSqlQuery on execute Dave Cramer 2002-06-13 14:02:50 +00:00
  • 7873bed77c Implemented updateable result sets based on raghu nidagal implementation Dave Cramer 2002-06-13 13:52:16 +00:00
  • ad88ee1e04 changed some commented out messages to use the Driver.debug and fixed first to read the underlying data into rowbuffer Dave Cramer 2002-06-13 13:48:28 +00:00
  • 3f857600b2 added messages for updateable result sets Dave Cramer 2002-06-13 13:43:02 +00:00
  • 14f72b9a4d Add GB18030 support. Contributed by Bill Huang <bill_huanghb@ybb.ne.jp> (ODBC support has not been committed yet. left for Hiroshi...) Tatsuo Ishii 2002-06-13 08:30:22 +00:00
  • 620dbc98cd make namein multibyte aware Tatsuo Ishii 2002-06-13 06:19:45 +00:00
  • 9310caf589 Update for new SGML file. Bruce Momjian 2002-06-13 05:54:00 +00:00
  • 2d237c7c18 Move disk usage section into its own section. Bruce Momjian 2002-06-13 05:15:22 +00:00
  • 5612949ff8 Add section on showing disk usage. Bruce Momjian 2002-06-13 04:36:50 +00:00
  • ecb5269404 Further tweaks to support display of sort keys in EXPLAIN --- initial implementation didn't work for Sort nodes associated with Append plans. Tom Lane 2002-06-13 03:40:49 +00:00
  • 59c325bb73 Repair for bug #691 --- CREATE TABLE AS column aliases fail to be applied when the select is a UNION (or other set-operation). Tom Lane 2002-06-13 02:04:46 +00:00
  • 2ed878d31d Mention vacuum for relpages. Bruce Momjian 2002-06-13 00:54:05 +00:00
  • 9bba67aa9b Add script to show disk space per db. Bruce Momjian 2002-06-13 00:21:52 +00:00
  • 4f8795eb71 Improve query. Bruce Momjian 2002-06-12 23:42:48 +00:00
  • 7e20a2e74f Add mention of query showing pages used. Bruce Momjian 2002-06-12 23:41:50 +00:00
  • e6e577490d Add to ecpg: Bruce Momjian 2002-06-12 23:39:49 +00:00
  • 6b3f0ef1db Cleanup. Bruce Momjian 2002-06-12 21:20:59 +00:00
  • 5a8f555e41 Add -q option to oid2name. Add sample session to README. Bruce Momjian 2002-06-12 21:09:09 +00:00
  • 0f865e17e2 Applied Lee Kindness' patch to fix one of memory allocation with floating point numbers. Michael Meskes 2002-06-12 12:06:53 +00:00
  • 0484700cda 1) Fix a bug *double error message*. 2) Fix a bug *passowrd prompt in case of md5 authentication*. 3) Improve the DSN setup dialog. Hiroshi Inoue 2002-06-12 02:27:44 +00:00
  • 237fb9bbc6 Allow createdb to create comments in current db, not template1. Bruce Momjian 2002-06-11 22:21:01 +00:00
  • 435941440b Mark as done: Bruce Momjian 2002-06-11 21:28:17 +00:00
  • 062d8b9ebd Fix markup typo. Thomas G. Lockhart 2002-06-11 16:00:17 +00:00
  • ea01a451cc Implement SQL99 OVERLAY(). Allows substitution of a substring in a string. Implement SQL99 SIMILAR TO as a synonym for our existing operator "~". Implement SQL99 regular expression SUBSTRING(string FROM pat FOR escape). Extend the definition to make the FOR clause optional. Define textregexsubstr() to actually implement this feature. Update the regression test to include these new string features. All tests pass. Rename the regular expression support routines from "pg95_xxx" to "pg_xxx". Define CREATE CHARACTER SET in the parser per SQL99. No implementation yet. Thomas G. Lockhart 2002-06-11 15:44:38 +00:00
  • 090dd22de6 Implement SQL99 OVERLAY(). Allows substitution of a substring in a string. Implement SQL99 SIMILAR TO as a synonym for our existing operator "~". Implement SQL99 regular expression SUBSTRING(string FROM pat FOR escape). Extend the definition to make the FOR clause optional. Define textregexsubstr() to actually implement this feature. Update the regression test to include these new string features. All tests pass. Rename the regular expression support routines from "pg95_xxx" to "pg_xxx". Define CREATE CHARACTER SET in the parser per SQL99. No implementation yet. Thomas G. Lockhart 2002-06-11 15:32:33 +00:00
  • 469cb65aca Katherine Ward wrote: > Changes to avoid collisions with WIN32 & MFC names... > 1. Renamed: > a. PROC => PGPROC > b. GetUserName() => GetUserNameFromId() > c. GetCurrentTime() => GetCurrentDateTime() > d. IGNORE => IGNORE_DTF in include/utils/datetime.h & utils/adt/datetim > > 2. Added _P to some lex/yacc tokens: > CONST, CHAR, DELETE, FLOAT, GROUP, IN, OUT Jan Wieck 2002-06-11 13:40:53 +00:00
  • 3b993acf19 Fix link. Bruce Momjian 2002-06-11 10:36:16 +00:00
  • 3a9f82bf78 Update performance section. Bruce Momjian 2002-06-11 10:29:54 +00:00
  • b465f5307f The patch does the following: Allows you to set the loglevel at runtime by adding ?loglevel=X to the connection URL, where 1 = INFO and 2 = DEBUG. Automatically turns on logging by calling DriverManager.setPrintWriter(new PrintWriter(System.out)) if one is not already set. Adds a Driver.info() message that prints out the version number Adds member variables logDebug and logInfo that can be checked before making logging methods calls Adds a build number to the version number string. This build number will need to be manually incremented when we see fit. Barry Lind 2002-06-11 02:55:16 +00:00
  • 8d1c1d40ec Update fsync FAQ item. Bruce Momjian 2002-06-11 02:22:41 +00:00
  • c86fac2787 Fix link. Bruce Momjian 2002-06-10 20:45:07 +00:00
  • fc53730c94 Move ruler to separate sections. Bruce Momjian 2002-06-10 19:49:59 +00:00
  • 9aac62305b Add item for plpgsql temp table access. Bruce Momjian 2002-06-10 19:47:57 +00:00
  • 090319b20f Fix spacing. Bruce Momjian 2002-06-10 16:13:54 +00:00
  • 6146200219 Update new Russian FAQ, from Victor Vislobokov Bruce Momjian 2002-06-08 04:23:45 +00:00
  • 4cb53d71b9 Remove DEBUG_LEVEL from postgresql.conf. Now uses CLIENT/SERVER_MIN_MESSAGES. Bruce Momjian 2002-06-08 04:08:19 +00:00
  • 585fef1671 Improve readability of factorial, from Florian Weimer. Bruce Momjian 2002-06-07 23:43:17 +00:00
  • 8a3f34b558 Fix for factorial(0::int2) returning 1, from sugita@sra.co.jp. Bruce Momjian 2002-06-07 23:41:53 +00:00
  • a67387b6b4 Please apply attached patch to contrib/intarray (7.2, 7.3). Bruce Momjian 2002-06-07 21:53:09 +00:00
  • 74a8af099f Please apply attached patch to contrib/intarray (7.2, 7.3). Bruce Momjian 2002-06-07 21:52:33 +00:00
  • 2f297a2fcf The attached patch fixes a problem with InstallXLogFileSegment()'s use of link() under Cygwin: Bruce Momjian 2002-06-07 21:47:45 +00:00
  • 31d9184239 None. Bruce Momjian 2002-06-07 20:22:33 +00:00
  • ccab6f7402 Remove int16 from libpgeasy examples. Improve error reporting. Bruce Momjian 2002-06-07 16:53:40 +00:00
  • 936ff27696 fixed bug reported by cc.ais40@wanadoo.fr where getObject was returning an Integer for a smallint datatype instead of a Short Barry Lind 2002-06-07 16:46:24 +00:00