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

Commit Graph

  • 51b2b6433b Cleanup up psql \connect and \pset pager setting display, Dennis Bj?rklund. Bruce Momjian 2003-03-10 15:46:03 +00:00
  • aa83bc04e0 Restructure parsetree representation of DECLARE CURSOR: now it's a utility statement (DeclareCursorStmt) with a SELECT query dangling from it, rather than a SELECT query with a few unusual fields in it. Add code to determine whether a planned query can safely be run backwards. If DECLARE CURSOR specifies SCROLL, ensure that the plan can be run backwards by adding a Materialize plan node if it can't. Without SCROLL, you get an error if you try to fetch backwards from a cursor that can't handle it. (There is still some discussion about what the exact behavior should be, but this is necessary infrastructure in any case.) Along the way, make EXPLAIN DECLARE CURSOR work. Tom Lane 2003-03-10 03:53:52 +00:00
  • db825e3743 pg_restore failed to restore blobs if -X disable-triggers is specified. Tom Lane 2003-03-09 19:38:59 +00:00
  • b9e8ffcd5d pg_restore failed to restore blobs if -X disable-triggers is specified. Tom Lane 2003-03-09 19:38:52 +00:00
  • dd04e958c8 tuplestore_donestoring() isn't needed anymore, but provide a no-op macro definition so as not to create compatibility problems. Tom Lane 2003-03-09 03:34:10 +00:00
  • aa60eecc37 Revise tuplestore and nodeMaterial so that we don't have to read the entire contents of the subplan into the tuplestore before we can return any tuples. Instead, the tuplestore holds what we've already read, and we fetch additional rows from the subplan as needed. Random access to the previously-read rows works with the tuplestore, and doesn't affect the state of the partially-read subplan. This is a step towards fixing the problems with cursors over complex queries --- we don't want to stick in Materialize nodes if they'll prevent quick startup for a cursor. Tom Lane 2003-03-09 02:19:13 +00:00
  • 899c711070 Back ported patches from head to 7.3 branch (fixes for NPE in result set absolute() and NPE when logging enabled) Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/util/PSQLException.java Barry Lind 2003-03-08 06:09:37 +00:00
  • 05a966fca4 Applied patch from Paul Sorenson to correctly handle schema names in updateable result sets. Applied patch from Rich Cullingford to fix a NPE in the absolute() method of result set. Applied patch from Tarjei Skorgenes to fix a NPE when logging is enabled. Barry Lind 2003-03-08 06:06:55 +00:00
  • f93672e2c9 Not done: Bruce Momjian 2003-03-08 04:23:05 +00:00
  • b4bb288e5b Reorder items and mark some as completed. Bruce Momjian 2003-03-08 03:03:49 +00:00
  • 6ee060f201 Cleanup and reorganization. - Added a private api layer (org.postgresql.core.Base*) - Cleaned up public api (org.postgresql.PG*) - Added consistent headers and copywrite info - Removed deprecated Serialize functionality - Cleaned up imports - Moved some files to more appropriate locations Barry Lind 2003-03-07 18:39:46 +00:00
  • 2e6887df63 Add to mmap emails. Bruce Momjian 2003-03-07 17:43:26 +00:00
  • b7e089fdbb Update FAQ. Bruce Momjian 2003-03-07 05:49:10 +00:00
  • 650a854936 Update Russian FAQ, from Viktor Vislobokov. Bruce Momjian 2003-03-07 05:46:51 +00:00
  • f069bd0560 Tweak dependency code to suppress NOTICEs generated by new method for cleaning out temp namespaces. We don't really want the server log to be cluttered with 'Drop cascades to table foo' every time someone uses a temp table... Tom Lane 2003-03-06 22:55:03 +00:00
  • f7cffbbbd7 Tweak dependency code to suppress NOTICEs generated by new method for cleaning out temp namespaces. We don't really want the server log to be cluttered with 'Drop cascades to table foo' every time someone uses a temp table... Tom Lane 2003-03-06 22:54:49 +00:00
  • 8afc577123 Add missing --globals-only (long form of -g). Tom Lane 2003-03-06 21:45:57 +00:00
  • 0c693b4926 Add missing --globals-only (long form of -g). Tom Lane 2003-03-06 21:45:52 +00:00
  • 086c0712a7 Add: Bruce Momjian 2003-03-06 19:53:07 +00:00
  • 601a2c970c Add for protocol changes: Bruce Momjian 2003-03-06 19:52:20 +00:00
  • 4144c7b629 Remove: Bruce Momjian 2003-03-06 18:39:18 +00:00
  • 17bb6b3792 Done: Bruce Momjian 2003-03-06 18:05:00 +00:00
  • 1d57374114 Use poll(2) in preference to select(2), if available. This solves problems in applications that may have a large number of files open, such that libpq's socket number exceeds the range supported by fd_set. From Chris Brown. Tom Lane 2003-03-06 03:16:55 +00:00
  • 235d5fa666 Add: Bruce Momjian 2003-03-06 02:29:44 +00:00
  • 4b6c198a6a Add code to dump contents of free space map into $PGDATA/global/pg_fsm.cache at database shutdown, and then load it again at database startup. This preserves our hard-won knowledge of free space across restarts (given an orderly shutdown, that is). Tom Lane 2003-03-06 00:04:27 +00:00
  • 21591967bc Turns out new IN implementation has got some problems in an UPDATE or DELETE with inherited target table. Fix it; add a regression test. Also, correct ancient misspelling of 'inherited'. Tom Lane 2003-03-05 20:01:04 +00:00
  • d8e2689e32 Repair bug reported by Laurent Perez: bad plan generated when UPDATE or DELETE of an inheritance tree references another inherited relation. This bug has been latent since 7.1; I'm still not quite sure why 7.1 and 7.2 don't manifest it (at least, they don't crash on a simple test case). Tom Lane 2003-03-05 18:38:26 +00:00
  • 147fbf9c6e Repair bug reported by Laurent Perez: bad plan generated when UPDATE or DELETE of an inheritance tree references another inherited relation. This bug has been latent since 7.1; I'm still not quite sure why 7.1 and 7.2 don't manifest it (at least, they don't crash on a simple test case). Tom Lane 2003-03-05 18:38:14 +00:00
  • 391eb5e5b6 Reimplement free-space-map management as per recent discussions. Adjustable threshold is gone in favor of keeping track of total requested page storage and doling out proportional fractions to each relation (with a minimum amount per relation, and some quantization of the results to avoid thrashing with small changes in page counts). Provide special- case code for indexes so as not to waste space storing useless page free space counts. Restructure internal data storage to be a flat array instead of list-of-chunks; this may cost a little more work in data copying when reorganizing, but allows binary search to be used during lookup_fsm_page_entry(). Tom Lane 2003-03-04 21:51:22 +00:00
  • 6b305090ed Prevent clustering on incomplete indexes: partial indexes are verboten, as are non-amindexnulls AMs unless first column is attnotnull. Tom Lane 2003-03-03 04:37:48 +00:00
  • a455c94257 Prevent clustering on incomplete indexes: partial indexes are verboten, as are non-amindexnulls AMs unless first column is attnotnull. Tom Lane 2003-03-03 04:37:37 +00:00
  • d28cd2273b Improve description of geometric operators. Tom Lane 2003-03-03 03:31:23 +00:00
  • b9ddb63307 Correct/edit comments for geometric operators. No change except to pg_description entries, so I did not force initdb. Tom Lane 2003-03-03 03:30:46 +00:00
  • 30a695d356 Be smart about outer-join qualifications that mention only one side of the join, per recent discussion on pgsql-sql. Not clear that this will come up often in real queries, but it's not any more expensive to do it right, so we may as well do it right. Tom Lane 2003-03-02 23:46:34 +00:00
  • 73e3fad1e8 Repair memory leak introduced by recent change to make SPI return a tupdesc even with zero tuples returned: some plpgsql routines assumed they didn't need to do SPI_freetuptable() after retrieving no tuples. Tom Lane 2003-03-02 20:45:59 +00:00
  • a1dbe521bc Repair memory leak introduced by recent change to make SPI return a tupdesc even with zero tuples returned: some plpgsql routines assumed they didn't need to do SPI_freetuptable() after retrieving no tuples. Tom Lane 2003-03-02 20:45:47 +00:00
  • 4b60df3aa6 Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897. Tom Lane 2003-02-27 21:37:24 +00:00
  • 191ef2b407 Change EXTRACT(EPOCH FROM timestamp) so that a timestamp without time zone is assumed to be in local time, not GMT. This improves consistency with other operations, which all assume local timezone when it matters. Per bug #897. Tom Lane 2003-02-27 21:36:58 +00:00
  • f08392b55a Back patch bug fix to quote function. D'Arcy J.M. Cain 2003-02-27 10:43:50 +00:00
  • db34282fe3 Back patch bug fix to quote function. D'Arcy J.M. Cain 2003-02-27 10:42:12 +00:00
  • 3d1a1e85cf up build number to 202 for a new development build Barry Lind 2003-02-27 05:58:08 +00:00
  • 4c943c87c1 A little cleanup. Removing an unnecessary method. Barry Lind 2003-02-27 05:56:27 +00:00
  • 1cc55168d7 Added support for SSL in the jdbc driver Barry Lind 2003-02-27 05:45:44 +00:00
  • 9ff872a272 The quote function should return a string suitable for dropping into a query string. This fixes a bug where bool types sometimes returned with a string that could not be dropped into a query. D'Arcy J.M. Cain 2003-02-26 13:16:50 +00:00
  • 84666801ed Remove REWRITE_INVOKE_MAX in favor of making an accurate check for recursion in RewriteQuery(); also, detect recursion in fireRIRrules(), so as to catch self-referential views per example from Ryan VanderBijl. Minor code restructuring to make it easier to catch recursive case. Tom Lane 2003-02-25 23:47:43 +00:00
  • aedd189a5c Allow SET CONNECTION to be followed by connection object without leading "TO" or "=". Allow whenever statement to list function without parameters. Michael Meskes 2003-02-25 15:58:03 +00:00
  • d47a0f7c76 Backport a fix from 7.4 to 7.3 to better handle case in updateable result sets. This backports part of the fix made in version 1.11. Barry Lind 2003-02-24 16:38:25 +00:00
  • bf3e675384 Avoid using a separate query to fetch the default expressions for columns. Improved version of patch by mallah@trade-india.com. Tom Lane 2003-02-24 03:54:06 +00:00
  • 0797bb5c50 During VACUUM FULL, truncate off any deletable pages that are at the end of a btree index. This isn't super-effective, since we won't move nondeletable pages, but it's better than nothing. Also, improve stats displayed during VACUUM VERBOSE. Tom Lane 2003-02-24 00:57:17 +00:00
  • 3981f2195f Remove no-longer-used FixBTree GUC variable. Tom Lane 2003-02-23 23:27:21 +00:00
  • 61b22d3aab btree page recycling can be done as soon as page's next-xact label is older than current Xmin; we don't have to wait till it's older than GlobalXmin. Tom Lane 2003-02-23 23:20:52 +00:00
  • 3bbd6af37c Adjust btbulkdelete logic so that only one WAL record is issued while deleting multiple index entries on a single index page. This makes for a very substantial reduction in the amount of WAL traffic during a large delete operation. Tom Lane 2003-02-23 22:43:09 +00:00
  • 13dadef8b5 Improve coding of log_heap_clean() and heap_xlog_clean(). Tom Lane 2003-02-23 20:32:12 +00:00
  • 88dc31e3f2 First cut at recycling space in btree indexes. Still some rough edges to fix, but it seems to basically work... Tom Lane 2003-02-23 06:17:13 +00:00
  • 1f3e24dee7 If a shutdown request comes in while we're still starting up, don't service it until after we execute SetThisStartUpID(). Else shutdown process will write the wrong SUI into the shutdown checkpoint, which seems likely to be trouble --- although I've not quite figured out how significant it really is. Tom Lane 2003-02-23 04:48:38 +00:00
  • 27854915b9 If a shutdown request comes in while we're still starting up, don't service it until after we execute SetThisStartUpID(). Else shutdown process will write the wrong SUI into the shutdown checkpoint, which seems likely to be trouble --- although I've not quite figured out how significant it really is. Tom Lane 2003-02-23 04:48:19 +00:00
  • 80d6a277c9 Simplify timezone-handling code per proposal to pghackers: get rid of setting timezone-related variables during transaction start. They were not used anyway in platforms that HAVE_TM_ZONE or HAVE_INT_TIMEZONE, which it appears is *all* the platforms we are currently supporting. For platforms that have neither, we now only support UTC or numeric- offset-from-UTC timezones. Tom Lane 2003-02-22 05:57:45 +00:00
  • 799bc58dc7 More infrastructure for btree compaction project. Tree-traversal code now knows what to do upon hitting a dead page (in theory anyway, it's untested...). Add a post-VACUUM-cleanup entry point for index AMs, to provide a place for dead-page scavenging to happen. Also, fix oversight that broke btpo_prev links in temporary indexes. initdb forced due to additions in pg_am. Tom Lane 2003-02-22 00:45:05 +00:00
  • 4fff132d1b Revert patch that broke \d commands, until it can be fixed. Tom Lane 2003-02-21 21:34:27 +00:00
  • a78e12f96a Repair nasty oversight in bt_split: if the index is temporary, we weren't updating the left-link from the split page's right sibling. This could result in backwards index scans missing some entries. Same bug exists in HEAD, will be patched later. Tom Lane 2003-02-21 18:24:54 +00:00
  • 03829995cd Forgot to commit Makefile change. Michael Meskes 2003-02-21 15:19:18 +00:00
  • 70508ba7ae Make btree index structure adjustments and WAL logging changes needed to support btree compaction, as per proposal of a few days ago. btree index pages no longer store parent links, instead they have a level indicator (counting up from zero for leaf pages). The FixBTree recovery logic is removed, and replaced by code that detects missing parent-level insertions during WAL replay. Also, generate appropriate WAL entries when updating btree metapage and when building a btree index from scratch. I believe btree indexes are now completely WAL-legal for the first time. initdb forced due to index and WAL changes. Tom Lane 2003-02-21 00:06:22 +00:00
  • 2bba78d605 Fix timestamptz_in so that parsing of 'now'::timestamptz gives right answer when SET TIMEZONE has been done since the start of the current transaction. Per bug report from Robert Haas. I plan some futher cleanup in HEAD, but this is a low-risk patch for the immediate issue in 7.3. Tom Lane 2003-02-20 05:25:25 +00:00
  • 4df0f1d26f Fix timestamptz_in so that parsing of 'now'::timestamptz gives right answer when SET TIMEZONE has been done since the start of the current transaction. Per bug report from Robert Haas. I plan some futher cleanup in HEAD, but this is a low-risk patch for the immediate issue in 7.3. Tom Lane 2003-02-20 05:24:55 +00:00
  • 69c049cef4 Back out LOCKTAG changes by Rod Taylor, pending code review. Sorry. Bruce Momjian 2003-02-19 23:41:15 +00:00
  • e2a618fe25 Fix for GUC client_encoding variable not being handled correctly. See following thread for more details. Tatsuo Ishii 2003-02-19 14:31:26 +00:00
  • d1bb0db8dd Back patch for GUC client_encoding variable not being handled correctly. However the patch for PostgresPollingStatusType() is not included to avoid 7.3 libpq vs. pre-7.3 backend compatibility problem. See following thread for more details. Tatsuo Ishii 2003-02-19 14:14:58 +00:00
  • d5740d7e26 Added DATABASE command as alias to CONNECT TO. Michael Meskes 2003-02-19 12:36:39 +00:00
  • cde8bbc413 This patch makes the following changes to the documentation: Bruce Momjian 2003-02-19 04:06:28 +00:00
  • 747c6152fd Autoconf run for readline/libedit patch. Bruce Momjian 2003-02-19 04:05:07 +00:00
  • adc3b34b9c Here's the patch I promised over on HACKERS - it alters the implementation of '\e' history tracking for systems that have a readline compatability library without replace_history_entry. I fall back to pushing the query onto the history stack after the \e, rather than replacing it. Bruce Momjian 2003-02-19 04:04:04 +00:00
  • d0f3a7e9c4 - Modifies LOCKTAG to include a 'classId'. Relation receive a classId of RelOid_pg_class, and transaction locks XactLockTableId. RelId is renamed to objId. Bruce Momjian 2003-02-19 04:02:54 +00:00
  • 81f6db4803 Allow PQcmdTuples to return row counts for MOVE and FETCH. Bruce Momjian 2003-02-19 03:59:02 +00:00
  • 1eb9fd49d1 Here's some changes I made last night to psql's common.c (as found in 7.3.2). It removes some code duplication and #ifdeffing, and some unstructured ugliness such as tacky breaks and an unneeded continue. Breaks up a large function into smaller functions and reduces required nesting levels, and kills a variable or two. Bruce Momjian 2003-02-19 03:54:39 +00:00
  • 71f35f5916 At present it is impossible to kill createuser except with kill -9 Bruce Momjian 2003-02-19 03:52:57 +00:00
  • 00cb9384a1 Please apply patches for contrib/ltree. Bruce Momjian 2003-02-19 03:50:49 +00:00
  • 71e1f531d3 Please apply patches for contrib/ltree. Bruce Momjian 2003-02-19 03:50:09 +00:00
  • a286f73210 The following patches eliminate the overflows in the j2date() and date2j() functions which limited the maximum date for a timestamp to AD 1465001. The new limit is AD 5874897. The files affected are: Bruce Momjian 2003-02-19 03:48:11 +00:00
  • 4efbbd7318 We just released new version of contrib/btree_gist (7.3 and current CVS) with support of int8, float4, float8 in addition to int4. Thanks Janko Richter for contribution. Bruce Momjian 2003-02-19 03:46:00 +00:00
  • 4996eea81c This patch includes more SGML markup fixes as well as a few minor additions to the docs. Bruce Momjian 2003-02-19 03:13:25 +00:00
  • aca86479fd This patch adds a note to the documentation describing why the performance of min() and max() is slow when applied to the entire table, and suggesting the simple workaround most experienced Pg users eventually learn about (SELECT xyz ... ORDER BY xyz LIMIT 1). Bruce Momjian 2003-02-19 03:12:22 +00:00
  • 9b13db687e Add SQL 200X standards URL. Bruce Momjian 2003-02-19 01:38:41 +00:00
  • d8f4eff89c Mark as done, fix grammar: Bruce Momjian 2003-02-19 01:36:32 +00:00
  • 3e2eceabc5 Update URL. Bruce Momjian 2003-02-18 17:23:08 +00:00
  • a9c28a6124 Hungarian FAQ is text, not HTML, so remove it. Bruce Momjian 2003-02-18 17:20:37 +00:00
  • f3fcb16ce6 New URL. Bruce Momjian 2003-02-18 16:38:05 +00:00
  • 1a458e9e64 New URL for FAQ. Bruce Momjian 2003-02-18 16:37:30 +00:00
  • f8247a7666 Add: Bruce Momjian 2003-02-18 05:15:51 +00:00
  • cdbe5f62f1 Update German FAQ, from Ian Barwick. Bruce Momjian 2003-02-18 05:08:12 +00:00
  • f3ad24efb8 *** empty log message *** Bruce Momjian 2003-02-18 05:07:42 +00:00
  • 9c1d2d66d6 Update changes from Ian Barwick. Bruce Momjian 2003-02-18 05:07:04 +00:00
  • 44ddef3be5 Add: Bruce Momjian 2003-02-18 03:47:39 +00:00
  • 9ee8e7a39e Update README. Bruce Momjian 2003-02-18 03:33:50 +00:00
  • c89000f346 Async_NotifyHandler must save and restore ImmediateInterruptOK. Fixes known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query. Tom Lane 2003-02-18 02:53:46 +00:00
  • f690acf104 Async_NotifyHandler must save and restore ImmediateInterruptOK. Fixes known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query. Tom Lane 2003-02-18 02:53:29 +00:00
  • bb402a0eca Add: Bruce Momjian 2003-02-18 02:49:30 +00:00
  • 32cc6cbe23 Rename 'holder' references to 'proclock' for PROCLOCK references, for consistency. Bruce Momjian 2003-02-18 02:13:24 +00:00
  • cf55ee5758 Add: Bruce Momjian 2003-02-17 20:47:29 +00:00
  • a8ed5dc069 Update marks: Bruce Momjian 2003-02-17 18:48:29 +00:00
  • fa4574e3a3 Remove IN/EXISTS TODO.detail item. Bruce Momjian 2003-02-17 18:48:14 +00:00