Commit Graph

  • b6a7948294 Make ALTER TABLE RENAME COLUMN update column names of indexes that refer to the renamed column. Brent Verner, with a little help from tgl. Tom Lane 2001-10-08 18:40:04 +00:00
  • 7249562fe3 Remove redundant code, update comments, cause CURRENT_TIME to agree with CURRENT_TIME(n). Tom Lane 2001-10-08 18:16:59 +00:00
  • c7c280f655 Update TODO list. Bruce Momjian 2001-10-08 17:10:11 +00:00
  • 6d5be886bc Fix include file so library is binary compatible again. Michael Meskes 2001-10-08 08:08:42 +00:00
  • bbea129681 Update TODO list. Bruce Momjian 2001-10-08 03:23:37 +00:00
  • 85801a4dbd Rearrange fmgr.c and relcache so that it's possible to keep FmgrInfo lookup info in the relcache for index access method support functions. This makes a huge difference for dynamically loaded support functions, and should save a few cycles even for built-in ones. Also tweak dfmgr.c so that load_external_function is called only once, not twice, when doing fmgr_info for a dynamically loaded function. All per performance gripe from Teodor Sigaev, 5-Oct-01. Tom Lane 2001-10-06 23:21:45 +00:00
  • a965750abf While playing around with trying to add foreign keys to the \d table display in psql, I noticed that tableinfo.triggers is not used once it is set. Bruce Momjian 2001-10-06 14:41:17 +00:00
  • c3291aed20 Fix shared library builds for MacOS X. Peter Eisentraut 2001-10-05 21:15:38 +00:00
  • 9110ef4de6 Move psql's zh_TW.po to the right place. Peter Eisentraut 2001-10-05 21:14:35 +00:00
  • 6ec644057a Update TODO list. Bruce Momjian 2001-10-05 20:43:09 +00:00
  • ee973be9c2 files attached are Traditional Chinese translations translated and modified from Simplified Chinese translations for backend, pgsql, pg_dump and libpq. I've appended their names to zh_TW.po. Bruce Momjian 2001-10-05 19:05:54 +00:00
  • 453ef3f81f Attached is the updated version of the patch, which matches on words as opposed to lines, which means that all of the following work in psql: Bruce Momjian 2001-10-05 19:01:13 +00:00
  • b78efb6d82 Make sure each call to ECPGraise is logged. Michael Meskes 2001-10-05 17:37:07 +00:00
  • 8a52b893b3 Further cleanup of dynahash.c API, in pursuit of portability and readability. Bizarre '(long *) TRUE' return convention is gone, in favor of just raising an error internally in dynahash.c when we detect hashtable corruption. HashTableWalk is gone, in favor of using hash_seq_search directly, since it had no hope of working with non-LONGALIGNable datatypes. Simplify some other code that was made undesirably grotty by promixity to HashTableWalk. Tom Lane 2001-10-05 17:28:13 +00:00
  • 343318028f ouput -> output Bruce Momjian 2001-10-05 15:50:11 +00:00
  • 583096a7f9 > > I am quite sure that all AIX Versions accept the CLOBBER method, > > thus I ask you to apply the following patch, to make it work. Bruce Momjian 2001-10-05 15:47:48 +00:00
  • c83137a025 Fixed typo in proproc.y Michael Meskes 2001-10-05 06:39:23 +00:00
  • 7547b0104a Define CEST as a synonym for Central European Savings Time per Jan Varga <varga@utcru.sk> Fix up spacing and formatting. Thomas G. Lockhart 2001-10-05 06:38:59 +00:00
  • bd97e4e7be Implement explicit date/time precision per SQL99 spec. Use CAST() mechanism to define CURRENT_TIME and CURRENT_TIMESTAMP. Thomas G. Lockhart 2001-10-05 06:37:42 +00:00
  • c24e5ddf5f Don't try to hack pg_description if not superuser. (Really want a COMMENT ON LARGE OBJECT command instead, but no time for it now.) Fix some code that would not work with OIDs > 2G. Tom Lane 2001-10-04 22:39:34 +00:00
  • a50696c9e1 Finetuning for legalnotice in print output. Add some "ASCII markup" for text output. Peter Eisentraut 2001-10-04 22:30:14 +00:00
  • ede3a1ea16 Finetuning for better print formatting Peter Eisentraut 2001-10-04 22:28:44 +00:00
  • ddcf1bca74 Replace simplelists with itemizedlists for better formatting Peter Eisentraut 2001-10-04 22:27:58 +00:00
  • 334368fb68 Rewording Peter Eisentraut 2001-10-04 22:27:18 +00:00
  • 536394e73a Fix spacing to get proper URL formatting in print output Peter Eisentraut 2001-10-04 22:26:27 +00:00
  • 255bd588a7 Hack for Jade vs TeX interpretation of "--" Peter Eisentraut 2001-10-04 22:25:48 +00:00
  • 03b0a589d1 Consider interpreting a function call as a trivial (binary-compatible) type coercion after failing to find an exact match in pg_proc, but before considering interpretations that involve a function call with one or more argument type coercions. This avoids surprises wherein what looks like a type coercion is interpreted as coercing to some third type and then to the destination type, as in Dave Blasby's bug report of 3-Oct-01. See subsequent discussion in pghackers. Tom Lane 2001-10-04 22:06:46 +00:00
  • 1ca0874faa Ooops, I was a little too enthusiastic about suppressing default index opclasses; they might be default for some other datatype, in which case we mustn't suppress 'em. Tom Lane 2001-10-04 22:00:10 +00:00
  • 3f8a50c013 Plug memory leaks introduced by dynamic-search-path changes. From Teodor Sigaev. Tom Lane 2001-10-04 19:13:55 +00:00
  • 38633cf891 Make the world safe for atttypmod=0 ... this didn't use to mean anything, but timestamp now wants it to mean something. Tom Lane 2001-10-04 17:52:24 +00:00
  • dd154dde59 Make current_time deliver a fractional-second answer. Tom Lane 2001-10-04 17:10:11 +00:00
  • 67bf0fc111 elog command need to use unicode conversion too. Bruce Momjian 2001-10-04 15:48:37 +00:00
  • 25ec484722 This patch adds reporting of tcl global variable errorInfo which contains stack trace. One problem, after this patch errors will generate multiline ERROR messages. Is it acceptable or do I need split it and generate multiple singleline messages? Bruce Momjian 2001-10-04 15:47:41 +00:00
  • 60553337d7 Attached is a patch which deals with Bruce Momjian 2001-10-04 15:46:49 +00:00
  • 96471bf106 Using strtol() on int8 values (input parameters or result sets) in plpython would result in numeric overflows causing the backend to terminate abruptly. Bruce Momjian 2001-10-04 15:45:49 +00:00
  • a6020b396b I've just finished the Chinese NLS support(zh_CN part) files translation, the attachement is those four files. (.tar.gz file, with the directory, root is $PGSRC). Tested on some Linux platform. Bruce Momjian 2001-10-04 15:44:14 +00:00
  • 7ff432c9ad 1. Implemented binary search in array Bruce Momjian 2001-10-04 15:41:14 +00:00
  • 720ca220a9 Attached please find an initiation of the NLS effort for the 'postgresql' component. It includes 'ru.po', which should be added to /src/backend/po/ and a typical patch for nls.mk with the 'ru' entry added in the AVAIL_LANGUAGES. Bruce Momjian 2001-10-04 15:38:28 +00:00
  • 5cf1b4b65a Remove ChangeLog. No one has defended its existence, and a few people want it removed. Bruce Momjian 2001-10-04 15:28:33 +00:00
  • 1392cbd0ed AdjustTimeForTypmod has the same bug ... Tom Lane 2001-10-04 15:14:22 +00:00
  • 04d975f0ca Make regress tests safe for variable-resolution timestamps. Tom Lane 2001-10-04 14:51:06 +00:00
  • 64dff0beac Fix some problems in new variable-resolution-timestamp code. Tom Lane 2001-10-04 14:49:57 +00:00
  • c4566933b1 Change some 7.2 mentions to version macro. Bruce Momjian 2001-10-04 04:46:43 +00:00
  • 864059c2c1 Update TODO list. Bruce Momjian 2001-10-04 04:24:24 +00:00
  • 1d75834722 Update TODO list. Bruce Momjian 2001-10-04 04:23:13 +00:00
  • f03b7ba0de Add dependency for regexec.c Tatsuo Ishii 2001-10-04 04:16:16 +00:00
  • 62d62e79b7 Add dependency for like.c Tatsuo Ishii 2001-10-04 04:13:40 +00:00
  • 219bd1e4fb Optimization for single byte encodings. Tatsuo Ishii 2001-10-04 02:15:47 +00:00
  • a2a0f7b79b Update TODO list. Bruce Momjian 2001-10-03 22:27:58 +00:00
  • fcd2e372a7 Consistently use gcc's __attribute__((format)) to check sprintf-style format strings wherever possible. Remarkably, this exercise didn't turn up any inconsistencies, but it seems a good idea for the future. Tom Lane 2001-10-03 21:58:28 +00:00
  • 2e5fda7b7e DROP AGGREGATE and COMMENT ON AGGREGATE now accept the expected syntax 'aggname (aggtype)'. The old syntax 'aggname aggtype' is still accepted for backwards compatibility. Fix pg_dump, which was actually broken for most cases of user-defined aggregates. Clean up error messages associated with these commands. Tom Lane 2001-10-03 20:54:22 +00:00
  • 16def00ffb Update error message wording for format_type change. Tom Lane 2001-10-03 19:24:36 +00:00
  • 9488aad618 Remove no-longer-used macros. Tom Lane 2001-10-03 19:18:42 +00:00
  • 2d6b1f29fb Update incorrect expected file. Use 'timestamp without time zone' datatype in test, to try to avoid any dependency on local time zone. Tom Lane 2001-10-03 18:39:12 +00:00
  • 1226816e4e Update for GIST. Bruce Momjian 2001-10-03 18:38:06 +00:00
  • c8ae5c2de1 Update TODO list. Bruce Momjian 2001-10-03 18:36:03 +00:00
  • 683e47ae70 Update TODO list. Bruce Momjian 2001-10-03 18:35:41 +00:00
  • 5c35b5973b Teach format_type about time/timestamp precision, so that pg_dump and psql's \d option work properly. Tom Lane 2001-10-03 18:32:42 +00:00
  • 2684f15e46 Add missing TIMESTAMPTZ case. Tom Lane 2001-10-03 18:25:59 +00:00
  • 873dd24313 Update TODO list. Bruce Momjian 2001-10-03 17:38:41 +00:00
  • b3580dc571 Update TODO list. Bruce Momjian 2001-10-03 17:38:13 +00:00
  • 2b7ccb17e1 Some further kibitzing on cachability of datetime functions. In particular, mark all I/O functions that can produce or consume a date as noncachable, in light of existence of DateStyle variable. Tom Lane 2001-10-03 17:22:05 +00:00
  • 4a147ba641 Update TODO list. Bruce Momjian 2001-10-03 16:05:43 +00:00
  • cf44762642 Update for latest regression tests. Tom Lane 2001-10-03 15:51:48 +00:00
  • 77be5f9451 AdjustTimestampForTypmod does not work (at least not portably) on -infinity and +infinity. Put TIMESTAMP_NOT_FINITE guard into the routine, instead of forgetting it at some call sites. Fixes regression test failures here. Tom Lane 2001-10-03 15:50:48 +00:00
  • a390975cc1 Neatnik fetishism. Tom Lane 2001-10-03 15:42:12 +00:00
  • 3e1beda2cd Implement precision support for timestamp and time, both with and without time zones. SQL99 spec requires a default of zero (round to seconds) which is set in gram.y as typmod is set in the parse tree. We *could* change to a default of either 6 (for internal compatibility with previous versions) or 2 (for external compatibility with previous versions). Evaluate entries in pg_proc wrt the iscachable attribute for timestamp and other date/time types. Try to recognize cases where side effects like the current time zone setting may have an effect on results to decide whether something is cachable or not. Thomas G. Lockhart 2001-10-03 05:29:27 +00:00
  • a51de40fb6 Minor fixup in spacing for tabular information. Thomas G. Lockhart 2001-10-03 05:24:22 +00:00
  • af9747c375 Fix up bad indenting in a few places. Thomas G. Lockhart 2001-10-03 05:23:12 +00:00
  • a5dafa3177 Tweak to test HAVE_GETOPT_H before including <getopt.h>, so as to build on systems without. Tom Lane 2001-10-02 22:38:43 +00:00
  • f2c657375d Add CREATE OR REPLACE FUNCTION syntax to allow replacing a function definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry. Tom Lane 2001-10-02 21:39:36 +00:00
  • f24fe14162 Updated URLs. Vince Vielhaber 2001-10-02 14:21:26 +00:00
  • fecbeedc7e Re-added Tom's patch fixing my setlocale patch. I accidently deleted it. Michael Meskes 2001-10-02 14:08:28 +00:00
  • f02ffdf4bd Update TODO list. Bruce Momjian 2001-10-02 01:21:16 +00:00
  • c53457b5a6 Update TODO list. Bruce Momjian 2001-10-02 01:20:46 +00:00
  • 7ac746957c Update TODO list. Bruce Momjian 2001-10-02 01:20:14 +00:00
  • 80ba0da5ce Update TODO list. Bruce Momjian 2001-10-02 01:20:05 +00:00
  • c7a7107f41 Revise shmget() and semget() failure messages to mention the possibility of coping by reducing shared_buffers/max_connections settings. Tom Lane 2001-10-01 23:26:55 +00:00
  • d7bdfab492 Fix typo (block size is 8 kB not 8192 kB). Tom Lane 2001-10-01 22:44:31 +00:00
  • 95b2a2a34f Fix wording. Bruce Momjian 2001-10-01 21:47:24 +00:00
  • 1929a90b69 Change pg_dump to produce CREATE INDEX commands by using the backend's pg_get_indexdef() function, rather than reaching into the system catalogs for itself. This eliminates a fair amount of redundant code. Also, since I just changed pg_get_indexdef() to suppress display of default index opclasses, this will mean that 7.2 and later dumps will not mention opclasses unless they are non-default opclasses. Should make life easier for future index opclass reorganizations. Tom Lane 2001-10-01 21:31:52 +00:00
  • e5bbf19659 Extend pg_get_indexdef() to know about index predicates. Also, tweak it to suppress index opclass output for opclasses that are the default for their datatype; only non-default opclasses are shown explicitly. This is expected to improve portability of the CREATE INDEX command across future versions of Postgres --- we've changed index opclasses too often in the past to think we won't do so again. Tom Lane 2001-10-01 20:15:26 +00:00
  • 0648d78ac4 Make inclusion logic for sys/sem.h and sys/ipc.h consistent across all the files that need them. Per trouble report from Teodor. Tom Lane 2001-10-01 18:16:35 +00:00
  • 6d18c038b7 Fix a couple of stray // comments. Tom Lane 2001-10-01 17:53:12 +00:00
  • 77d2622498 Add sys/types.h for FreeBSD compile. Bruce Momjian 2001-10-01 17:52:34 +00:00
  • 735594ff08 Update docs for 7.2 mention where appropriate. Bruce Momjian 2001-10-01 17:46:46 +00:00
  • 87fd2dbe7c Clean up a little more carefully around fork of pgstat subprocess. Partial support for BEOS (not sure whether second fork of grandchild process needs these extra calls or not; someone who has BEOS will need to test it). Tom Lane 2001-10-01 16:48:37 +00:00
  • 43cadb9231 Add missing pgcrypto files. Bruce Momjian 2001-10-01 16:12:23 +00:00
  • 998cebc4db Update to "7.2". Bruce Momjian 2001-10-01 15:44:45 +00:00
  • dca4f8e3bb Run autoconf. Bruce Momjian 2001-10-01 15:33:55 +00:00
  • 034895125d > > > > > - PostgreSQL requires to be compiled with --enable-multibyte > > > > > and --enable-unicode-convertion if it ought to work correctly > > > > > with Tcl/Tk >= 8.1 (client or server side). > > > > > > > > > > - PL/Tcl needs to be changed to use pg_do_encoding_conversion > > > > > if it runs on a Tcl version >= 8.1 . > > > > > > > I'll do pl/tcl part in the next version of patch. Using this approach we > > > > can eliminate overhead for databases in UNICODE. > > > > > > Any progress on this? I'd prefer to get rid of this --enable-pltcl-utf > > > option before release. > > > > Done > > > > Next version removes --enable-pltcl-utf switch and enables embedded > > utf conversion of pgsql if tcl version >=8.1 and --enable-unicode-conversion Bruce Momjian 2001-10-01 15:33:31 +00:00
  • 9f09e8362b - Fixed truncate bug. - Added patch by Christof Petig <christof.petig@wtal.de> to clean up ecpglib. Michael Meskes 2001-10-01 12:02:28 +00:00
  • a59881aae1 Keep the contents of TIDs not the pointers. Tid scan has been broken for 7.1. Hiroshi Inoue 2001-10-01 09:38:14 +00:00
  • 8ae8ddbb8e Update multibyte Japanese doc Tatsuo Ishii 2001-10-01 08:16:38 +00:00
  • 5999e78fc4 Another round of cleanups for dynahash.c (maybe it's finally clean of portability issues). Caller-visible data structures are now allocated on MAXALIGN boundaries, allowing safe use of datatypes wider than 'long'. Rejigger hash_create API so that caller specifies size of key and total size of entry, not size of key and size of rest of entry. This simplifies life considerably since each number is just a sizeof(), and padding issues etc. are taken care of automatically. Tom Lane 2001-10-01 05:36:17 +00:00
  • f58179669a Suppress timestamp_ops for backwards compatibility with 7.1 pg_dump. Tom Lane 2001-10-01 04:19:18 +00:00
  • a8443da57a Remove C++ style comment. Some compilers won't accept it. Tatsuo Ishii 2001-10-01 02:31:33 +00:00
  • 464f20cf7b Fix a compile error on a platform that does not have PAM. Tatsuo Ishii 2001-10-01 02:26:36 +00:00
  • 9a23885f72 Add pgstattuple Tatsuo Ishii 2001-10-01 01:52:38 +00:00
  • 95d4821b1c Make libpq++ safe again for older C++ compilers. Do 'using namespace std' only if configure found it was safe to do so; do not assume const_cast is available. Tom Lane 2001-09-30 22:30:37 +00:00