hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-19 21:07:07 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 21cf6b2166 Remove unused drop TODO.detail. Bruce Momjian 2002-08-02 20:03:48 +00:00
  • 7c63a0db29 No need for TODO.detail link anymore: Bruce Momjian 2002-08-02 20:03:23 +00:00
  • 543409a752 Done: Bruce Momjian 2002-08-02 20:02:56 +00:00
  • 38bb77a5d1 ALTER TABLE DROP COLUMN works. Patch by Christopher Kings-Lynne, code review by Tom Lane. Remaining issues: functions that take or return tuple types are likely to break if one drops (or adds!) a column in the table defining the type. Need to think about what to do here. Tom Lane 2002-08-02 18:15:10 +00:00
  • 5e6528adf7 * -Remove LockMethodTable.prio field, not used (Bruce) Bruce Momjian 2002-08-01 05:18:34 +00:00
  • 7dfc7e9e8c 1) Improve the handling of the queries like (select ..) union (select ..) whose first non-space character is '('. 2) Handle Insert .. () VALUES (). Hiroshi Inoue 2002-08-01 03:07:50 +00:00
  • ce7565ab91 Instead of having a configure-time DEFAULT_ATTSTATTARGET, store -1 in attstattarget to indicate 'use the default'. The default is now a GUC variable default_statistics_target, and so may be changed on the fly. Along the way we gain the ability to have pg_dump dump the per-column statistics target when it's not the default. Patch by Neil Conway, with some kibitzing from Tom Lane. Tom Lane 2002-07-31 17:19:54 +00:00
  • 8be3cfbbd5 Done: Bruce Momjian 2002-07-31 03:13:16 +00:00
  • 52457ca6af Move backend_pid to functions/misc. Bruce Momjian 2002-07-31 02:27:29 +00:00
  • 1107531c91 Rename pid function to backend_pid(). Bruce Momjian 2002-07-31 01:49:13 +00:00
  • f67cb71961 Add function to access backend pid, pg_stat_get_backend_mypid. Bruce Momjian 2002-07-31 00:40:40 +00:00
  • b8efa8755c Done: Bruce Momjian 2002-07-31 00:40:20 +00:00
  • 4ad658cac9 Teach pg_dump to dump user-defined operator classes. For the moment, this only works against 7.3 or later databases; the pushups required to do it without regprocedure/regtype/etc seem more trouble than they're worth, considering that existing users aren't expecting pg_dump support for this. Tom Lane 2002-07-30 21:56:04 +00:00
  • 2c2c43d05f Updated: Bruce Momjian 2002-07-30 19:47:09 +00:00
  • b30ccbe32a Clarification from Tom: Bruce Momjian 2002-07-30 19:43:20 +00:00
  • f514bb3e25 Would it be wise to have the plsql.sgml file renamed to plpgsql.sgml? All of the internal tags are of the latter. Bruce Momjian 2002-07-30 19:36:13 +00:00
  • 6c01708c46 Added for Neil Conway: Bruce Momjian 2002-07-30 19:34:05 +00:00
  • 76099408f6 If we're cleaning out _deadcode, might as well zap this one too. Tom Lane 2002-07-30 18:54:59 +00:00
  • 45e584a445 Replace ad-hoc insertions into pg_opclass and friends with CREATE OPERATOR CLASS commands. Tom Lane 2002-07-30 18:48:34 +00:00
  • ad63a551b2 Remove last recipe file. Bruce Momjian 2002-07-30 18:44:01 +00:00
  • 937aef3545 Ensure that src/tutorial gets cleaned by top-level make clean. Tom Lane 2002-07-30 17:47:58 +00:00
  • 65b6868b13 Replace ad-hoc insertions into pg_opclass and friends with CREATE OPERATOR CLASS commands. Further tweaking of documentation for same. Tom Lane 2002-07-30 17:34:37 +00:00
  • ea2d97414c Use Max/Min macros, not MAX/MIN, to eliminate portability issues. Tom Lane 2002-07-30 17:32:10 +00:00
  • 620abeb271 Done: > o -Generate failure on short COPY lines rather than pad NULLs Bruce Momjian 2002-07-30 16:56:15 +00:00
  • 6e9893047e The attached patch removes the last remnants of support for 'tioga recipes', whatever those are -- Peter E. killed most of it a couple days ago, but this patch removes the rest. Most of it was #ifdef'ed out anyway. Bruce Momjian 2002-07-30 16:55:45 +00:00
  • 874148fe34 IMPROVED VERSION APPLIED: Bruce Momjian 2002-07-30 16:55:06 +00:00
  • 1dedbf2da5 Add ltree data type to contrib, from Teodor Sigaev and Oleg Bartunov. Bruce Momjian 2002-07-30 16:40:34 +00:00
  • 210e64fe08 Added support for schemas and quotes in tab-complete.c, as well as a few other things: Bruce Momjian 2002-07-30 16:35:05 +00:00
  • 578e71fee5 This should fix a bug where a row that was updated or deleted that had another row inserted/updated to its old value during the same statement or other statements before the integrity check for noaction would incorrectly error. This could happen in deferred constraints or due to triggers or functions. It's effectively a reworking of the previous patch that did a not exists to instead do a separate check. Bruce Momjian 2002-07-30 16:33:21 +00:00
  • 9f1fc1080e Since we're depending on %option noyywrap in the main scanner now, we may as well use it in all our flex files. Make all the flex files have a consistent set of options. Tom Lane 2002-07-30 16:33:08 +00:00
  • 74780590d8 Add tablefunc to contrib makefile. Bruce Momjian 2002-07-30 16:32:20 +00:00
  • 41f862ba87 As mentioned above, here is my contrib/tablefunc patch. It includes three functions which exercise the tablefunc API. Bruce Momjian 2002-07-30 16:31:11 +00:00
  • 23a8b77d42 Here are two patches. The guc_and_tablefunc patch addresses the two changes mentioned above, and also adds a new function to the tablefunc API. The tablefunc API change adds the following function: Bruce Momjian 2002-07-30 16:20:03 +00:00
  • ceb438ed8c This patch fixes one serious bug (runaway INSERT) and a few rare (and hard to reproduce) error conditions. Bruce Momjian 2002-07-30 16:08:33 +00:00
  • bf7d8e4299 Update contributions link. Bruce Momjian 2002-07-30 15:05:17 +00:00
  • 79d35b41aa added tests for crossReferences Dave Cramer 2002-07-30 13:22:38 +00:00
  • 55695148df changed test user back to test Dave Cramer 2002-07-30 13:22:02 +00:00
  • c82fed3d87 Added DataSource code and tests submitted by Aaron Mulder Dave Cramer 2002-07-30 11:41:10 +00:00
  • 6410c22265 changes for new Datasource Dave Cramer 2002-07-30 11:38:13 +00:00
  • 6bdbe4ca2c Move alarm timers to proper location. Bruce Momjian 2002-07-30 05:35:53 +00:00
  • c2d0ebce75 Rewrite xindex.sgml for CREATE OPERATOR CLASS. catalogs.sgml finally contains descriptions of every single system table. Update 'complex' tutorial example too. Tom Lane 2002-07-30 05:24:56 +00:00
  • b6440a7ece Make statement_timeout apply to entire query string, not per statement. Bruce Momjian 2002-07-30 05:13:06 +00:00
  • a89fc4e6de --enable-syslog no longer required to use syslog. Bruce Momjian 2002-07-30 04:24:54 +00:00
  • 5bf55525c3 Move item: Bruce Momjian 2002-07-30 03:12:37 +00:00
  • 122b0cd86f Update FAQ. Bruce Momjian 2002-07-30 01:35:29 +00:00
  • 67d0cb2d77 Fix a bug about automatic client_encoding setting. Hiroshi Inoue 2002-07-30 00:48:02 +00:00
  • be347dcba6 Update FAQ. Bruce Momjian 2002-07-29 23:56:53 +00:00
  • b5eebc1fd4 Centralize code for interpreting schema references, which had gotten copied more places than I first thought it would. This fixes a bug: a couple of these places were neglecting to enforce USAGE access on explicitly-referenced schemas. Tom Lane 2002-07-29 23:46:35 +00:00
  • 7b970bc1bc Use aclcheck_error() in place of ad-hoc permissions complaints. Tom Lane 2002-07-29 23:44:44 +00:00
  • ea4686e3e1 Implement CREATE/DROP OPERATOR CLASS. Work still remains: need more documentation (xindex.sgml should be rewritten), need to teach pg_dump about it, need to update contrib modules that currently build pg_opclass entries by hand. Original patch by Bill Studenmund, grammar adjustments and general update for 7.3 by Tom Lane. Tom Lane 2002-07-29 22:14:11 +00:00
  • b9459c6adb Fix from Neil Conway: Bruce Momjian 2002-07-29 21:41:19 +00:00
  • a28375140c Fix minor coding error: don't ReleaseSysCache until after last use of cache entry. Tom Lane 2002-07-29 20:45:44 +00:00
  • c6b2838685 Fix typo. Remove #ifdef MULTIBYTE Tatsuo Ishii 2002-07-29 08:04:55 +00:00
  • 06ad580f75 Structure reference pages consistently. Document that structure. Add information about environment variables. Peter Eisentraut 2002-07-28 15:22:21 +00:00
  • b02c56f584 Clean documentation subtree during make clean. Peter Eisentraut 2002-07-28 15:19:59 +00:00
  • b0c3c48eb3 Assemble portability modules into libpgport library. Some makefile simplifications. Peter Eisentraut 2002-07-27 20:10:05 +00:00
  • c3fdf8925e Fix a bug about the handling of CX parameter of the connection string reported by Sergey Smirnov. Hiroshi Inoue 2002-07-26 08:45:54 +00:00
  • 40c44166dc Fouth (and final) phase of restructuring to add jdbc3 support. Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSetMetaData.java Removed Files: jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/ResultSetMetaData.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/ResultSetMetaData.java Barry Lind 2002-07-26 05:29:35 +00:00
  • 68c6eff945 Third phase of restructuring to add jdbc3 support. Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java Removed Files: jdbc/org/postgresql/jdbc1/CallableStatement.java jdbc/org/postgresql/jdbc2/CallableStatement.java jdbc/org/postgresql/jdbc2/UpdateableResultSet.java Barry Lind 2002-07-25 22:45:28 +00:00
  • 73eb2dfe77 Remove extra comma. Peter Eisentraut 2002-07-25 20:52:59 +00:00
  • 0345f58496 Implement DROP CONVERSION Add regression test Tatsuo Ishii 2002-07-25 10:07:13 +00:00
  • 8d600a7d1f Second phase of restructuring to add jdbc3 support. Barry Lind 2002-07-24 22:08:45 +00:00
  • 43515ba3f8 Remove _deadcode. Peter Eisentraut 2002-07-24 19:16:43 +00:00
  • 739adf32ee Remove unused system table columns: Peter Eisentraut 2002-07-24 19:11:14 +00:00
  • a78777558c Add mention of copyright year update. Bruce Momjian 2002-07-24 17:58:24 +00:00
  • f7ba1db755 Done: Bruce Momjian 2002-07-24 17:42:12 +00:00
  • 19a20e04bd Add Japanese README explaining how to add new conversion. English README will come soon... Tatsuo Ishii 2002-07-24 07:05:41 +00:00
  • 88b74dcddf Add pg_conversion system catalog. Update description for multibyte support. Tatsuo Ishii 2002-07-24 05:51:56 +00:00
  • b4b3c63b2b Done: Bruce Momjian 2002-07-23 23:28:36 +00:00
  • 1e3187366c Initial restructuring to add jdbc3 support. There was a significant amount of duplicated code between the jdbc1 and jdbc2. This checkin restructures the code so that the duplication is removed so that the jdbc3 support can be added without adding yet another copy of everything. Also many classes were renamed to avoid confusion with multiple different objects having the same name. The timestamp tests were also updated to add support for testing timestamp without time zone in addition to timestamp with time zone Barry Lind 2002-07-23 03:59:55 +00:00
  • e9c013f4bd Add unique index on pg_cast.oid, and document pg_cast table. Peter Eisentraut 2002-07-22 20:23:19 +00:00
  • a7ffd69d4c Fix typo. Tatsuo Ishii 2002-07-22 13:00:00 +00:00
  • 8d25d5c5c7 Add CREATE CONVERSION/DROP CONVERSOION reference manual Tatsuo Ishii 2002-07-22 08:57:15 +00:00
  • fa5c512e60 Corrected Makefile and preproc.y for big_bison branch. Michael Meskes 2002-07-21 11:16:07 +00:00
  • 4be24fe88f Fixed some minor typos. Michael Meskes 2002-07-21 11:09:41 +00:00
  • 8b5cabd324 Re-committing the whole big_bison tag. Michael Meskes 2002-07-21 08:26:52 +00:00
  • 2297f3982b Re-Committed old file. Michael Meskes 2002-07-21 08:20:07 +00:00
  • f9d74d75e7 Schema TODO.detail file not needed anymore. Bruce Momjian 2002-07-21 04:39:52 +00:00
  • b70b78656b Tweak CreateTrigger() so that the OID used in the name of an RI_ConstraintTrigger is the same OID assigned to the pg_trigger row. This reduces consumption of OIDs and may ease debugging. Tom Lane 2002-07-20 19:55:38 +00:00
  • 17b28503d0 Mark items as done: Bruce Momjian 2002-07-20 16:45:07 +00:00
  • c33a6343cd Code review for SHOW output changes; fix horology expected files for new SHOW output format. Tom Lane 2002-07-20 15:12:56 +00:00
  • a58930bbd5 Synced parser yet again. Michael Meskes 2002-07-20 08:24:18 +00:00
  • d4803f5513 Fix regression tests for new SHOW output. Bruce Momjian 2002-07-20 06:32:53 +00:00
  • 63cfc6a8e8 Fix problems caused by code drift of API for without-oids. Bruce Momjian 2002-07-20 06:17:43 +00:00
  • b34cbe006f The attached patch fixes 2 trivial warnings generated by bison 1.35, as a result of Peter's recent CREATE CAST changes. Bruce Momjian 2002-07-20 05:58:34 +00:00
  • 1ac7db4468 I can't remember who said they were working on schema related psql changes, but I kept finding myself wishing I could see what schema a table or view exists in when I use \dt, \dv, etc. So, here is a patch which does just that. Bruce Momjian 2002-07-20 05:57:31 +00:00
  • 1ce03603cc > 2. This patch includes the same Table Function API fixes that I > submitted on July 9: > > http://archives.postgresql.org/pgsql-patches/2002-07/msg00056.php > > Please disregard that one *if* this one is applied. If this one is > rejected please go ahead with the July 9th patch. Bruce Momjian 2002-07-20 05:49:28 +00:00
  • b6d2faaf24 Hello, i noticed that win32 native stopped working/compiling after the SSL merge . So i took the opportunity to fix some stuff: Bruce Momjian 2002-07-20 05:43:31 +00:00
  • 1430271e99 Add new configure files for missing-oid patch. Bruce Momjian 2002-07-20 05:39:46 +00:00
  • dcbacde2e3 Patch problems caused by code drift since OID patch creation. Bruce Momjian 2002-07-20 05:37:45 +00:00
  • e36f9cd440 Manually apply part of oid patch that didn't apply cleanly. Bruce Momjian 2002-07-20 05:29:01 +00:00
  • b0f5086e41 oid is needed, it is added at the end of the struct (after the null bitmap, if present). Bruce Momjian 2002-07-20 05:16:59 +00:00
  • 38dd3ae7d0 The attached patch fixes a build problem with GEQO when using the PX recombination operator, changes some elog() messages from LOG to DEBUG1, puts some debugging functions inside the appropriate #ifdef (not enabled by default), and makes a few other minor cleanups. Bruce Momjian 2002-07-20 04:59:10 +00:00
  • aec814b548 Add new vacuum regression test files. Bruce Momjian 2002-07-20 04:58:14 +00:00
  • e77054e029 This patch fixes a regression caused by my recent changes to heap tuple header. The fix is based on the thought that HEAP_MOVED_IN is not needed any more as soon as HEAP_XMIN_COMMITTED has been set. So in tqual.c and vacuum.c the HEAP_MOVED bits are cleared when HEAP_XMIN_COMMITTED is set. Bruce Momjian 2002-07-20 04:57:13 +00:00
  • cdf4b9aff2 Apply patches from Neil Conway. Tatsuo Ishii 2002-07-20 03:02:01 +00:00
  • 009d593c48 Small performance improvement --- use indexscan not heapscan to find pg_statistic rows to delete while dropping a relation. Tom Lane 2002-07-19 22:21:17 +00:00
  • 59a471fc4c Make note that ALTER TABLE can change table owner these days. Tom Lane 2002-07-19 18:53:50 +00:00
  • 33b3c95200 Complete TODO item: Bruce Momjian 2002-07-19 17:35:11 +00:00
  • d7d741afbe Done: Bruce Momjian 2002-07-19 17:26:35 +00:00