hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-14 18:37:03 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • dbe49b8c66 Update TODO list. Bruce Momjian 2001-06-13 20:17:05 +00:00
  • df3f152ed7 Don't assume free(NULL) is OK. Yes, I know ANSI C says it is. Tom Lane 2001-06-13 19:52:33 +00:00
  • c74dc1281f Update some obsolete examples. Tom Lane 2001-06-13 19:31:56 +00:00
  • bbb7b6f699 Remove some dead code, simplify calling convention. Tom Lane 2001-06-13 18:56:30 +00:00
  • cee82fab71 - Synced preproc.y with gram.y. - Applied bug fix by John Summerfield. Michael Meskes 2001-06-13 12:38:58 +00:00
  • 807a262657 Back-patch fix for attempt to pfree a value that's not palloc'd (it's a field of a tuple). I see Jan has already fixed this in current sources, but 7.1.* is pretty badly broken here. Tom Lane 2001-06-13 01:02:59 +00:00
  • 2938eec7fe Extend GUC concepts of parse_hook and assign_hook to all four supported datatypes, not only strings. parse_hook is useless for bool, I suppose, but it seems possibly useful for int and double to apply variable-specific constraints that are more complex than simple range limits. assign_hook is definitely useful for all datatypes --- we need it right now for bool to support date cache reset when changing Australian timezone rule setting. Also, clean up some residual problems with the reset all/show all patch, including memory leaks and mistaken reset of PostPortNumber. It seems best that RESET ALL not touch variables that don't have SUSET or USERSET context. Tom Lane 2001-06-12 22:54:06 +00:00
  • 89765fa555 Fix compile error caused by patch application. Bruce Momjian 2001-06-12 21:51:27 +00:00
  • deab4a4692 Repair problem with multi-action rules in combination with any nontrivial manipulation of rtable/jointree by planner. Rewriter was generating actions that shared rtable/jointree substructure, which caused havoc when planner got to the later actions that it'd already mucked up. Tom Lane 2001-06-12 18:54:53 +00:00
  • 2a06b3bdfd Repair problem with multi-action rules in combination with any nontrivial manipulation of rtable/jointree by planner. Rewriter was generating actions that shared rtable/jointree substructure, which caused havoc when planner got to the later actions that it'd already mucked up. Tom Lane 2001-06-12 18:54:22 +00:00
  • c1db506ab7 Add Updatable view mention. Bruce Momjian 2001-06-12 18:15:59 +00:00
  • a0316a19e3 Update TODO list. Bruce Momjian 2001-06-12 18:15:50 +00:00
  • 76e9ad1f55 Back out has_table_privilege patch. Bruce Momjian 2001-06-12 16:34:27 +00:00
  • 3c3ff4288d Update TODO list. Bruce Momjian 2001-06-12 16:18:11 +00:00
  • 58c909bb8d OK -- here's take #5. Bruce Momjian 2001-06-12 15:58:34 +00:00
  • 13a52c1f03 I installed postgres 7.1 with --enable-odbc. I then installed tclodbc (http://sourceforge.net/projects/tclodbc) and libiodbc-2.50.3 (http://www.iodbc.org/dist/libiodbc-2.50.3.tar.gz). I could not get either to work... postgres would not find the global odbcinst.ini file. I traced this to src/interfaces/odbc/gpps.c -- here are the many things I think are wrong: Bruce Momjian 2001-06-12 15:14:47 +00:00
  • 55abc36e15 Update TODO list. Bruce Momjian 2001-06-12 14:50:24 +00:00
  • 1d584f97b9 Clean up various to-do items associated with system indexes: pg_database now has unique indexes on oid and on datname. pg_shadow now has unique indexes on usename and on usesysid. pg_am now has unique index on oid. pg_opclass now has unique index on oid. pg_amproc now has unique index on amid+amopclaid+amprocnum. Remove pg_rewrite's unnecessary index on oid, delete unused RULEOID syscache. Remove index on pg_listener and associated syscache for performance reasons (caching rows that are certain to change before you need 'em again is rather pointless). Change pg_attrdef's nonunique index on adrelid into a unique index on adrelid+adnum. Tom Lane 2001-06-12 05:55:50 +00:00
  • d2c8358188 autoconf Bruce Momjian 2001-06-11 22:17:14 +00:00
  • 92f450652c The attached patch enables PostgreSQL CVS to build cleanly under Cygwin when built against readline 4.2. Specifically, it handles the deprecation of Bruce Momjian 2001-06-11 22:12:48 +00:00
  • 8af0ea9dc1 Got two patches that were found by folks on the Castor list, that we'd like to submit. These were done for the jdbc2 driver. The first one is for support of the Types.BIT in the PreparedStatement class. The following lines need to be inserted in the switch statment, at around line 530: Bruce Momjian 2001-06-11 22:12:00 +00:00
  • 05150e2df3 Add French psql translation. (My rendition of French anyway...) Fix typo in message. Peter Eisentraut 2001-06-11 18:23:33 +00:00
  • 94cb2201bf Update FAQ. Bruce Momjian 2001-06-11 16:27:52 +00:00
  • 88e948216c Nest macros with slightly less enthusiasm, for performance and to avoid having non-gcc compilers spit up. Tom Lane 2001-06-11 05:00:56 +00:00
  • 2a6f7ac456 Move temporary files into 'pg_tempfiles' subdirectory of each database directory (which can be made a symlink to put temp files on another disk). Add code to delete leftover temp files during postmaster startup. Bruce, with some kibitzing from Tom. Tom Lane 2001-06-11 04:12:29 +00:00
  • 6f2182fe18 contrib/intarray updates from Oleg Bartunov: it's reimplemented to use function interface version 1 and special treating of degenerated signatures. Tom Lane 2001-06-11 02:31:25 +00:00
  • 88ba401879 Update EXPLAIN discussion and examples to match current sources. Tom Lane 2001-06-11 00:52:09 +00:00
  • 01a819abe3 Make planner compute the number of hash buckets the same way that nodeHash.c will compute it (by sharing code). Tom Lane 2001-06-11 00:17:08 +00:00
  • ccda1a672c Mark inet,cidr,macaddr '=' operators as mergejoinable. Tom Lane 2001-06-10 22:32:35 +00:00
  • 5021fcb5e4 Add inheritance. Bruce Momjian 2001-06-10 03:48:16 +00:00
  • 23c25ab36e Update TODO list. Bruce Momjian 2001-06-10 03:48:05 +00:00
  • 091b262008 Update or remove mentions of versions where appropriate. Bruce Momjian 2001-06-10 03:46:31 +00:00
  • a8fe109ac1 Fix thinko in hash cost estimation: average frequency should be computed from total number of distinct values in whole relation, not # distinct values we expect to have after restriction clauses are applied. Tom Lane 2001-06-10 02:59:35 +00:00
  • 26c94c5d9c Update TODO list. Bruce Momjian 2001-06-10 02:58:51 +00:00
  • ab36eeaaa2 Add to TODO.detail. Bruce Momjian 2001-06-10 02:57:33 +00:00
  • 933adb3e37 Update TODO list. Bruce Momjian 2001-06-10 01:25:01 +00:00
  • 7ceed2a9b5 Allow GRANT/REVOKE to/from more than one user per invocation. Command tag for GRANT/REVOKE is now just that, not "CHANGE". Peter Eisentraut 2001-06-09 23:21:55 +00:00
  • 202548d6cc Teach convert_to_scalar about datatypes timetz, inet, cidr, macaddr. Tom Lane 2001-06-09 22:16:18 +00:00
  • e8637ec9de Add #define for OID of type macaddr. Tom Lane 2001-06-09 21:41:42 +00:00
  • bdadc9bf1c Remove RelationGetBufferWithBuffer(), which is horribly confused about appropriate pin-count manipulation, and instead use ReleaseAndReadBuffer. Make use of the fact that the passed-in buffer (if there is one) must be pinned to avoid grabbing the bufmgr spinlock when we are able to return this same buffer. Eliminate unnecessary 'previous tuple' and 'next tuple' fields of HeapScanDesc and IndexScanDesc, thereby removing a whole lot of bookkeeping from heap_getnext() and related routines. Tom Lane 2001-06-09 18:16:59 +00:00
  • 3247989130 Update FAQ. Bruce Momjian 2001-06-09 14:40:41 +00:00
  • 7c106621de Fix a few missed NOIND usages. Tom Lane 2001-06-09 02:19:07 +00:00
  • 0acd843c05 Finish German translation, edit (original) messages a bit. Peter Eisentraut 2001-06-08 23:53:48 +00:00
  • 959dc927d3 Preliminary code cleanup in elog(). Split out some code into utility functions, remove indent support, make sure all strings are marked translatable. Peter Eisentraut 2001-06-08 21:16:49 +00:00
  • 24775c5cd5 Document and work around ANT bug that prevents directory deletion. Bruce Momjian 2001-06-07 20:24:54 +00:00
  • 695f2395c2 Add to TODO.detail. Bruce Momjian 2001-06-07 20:06:16 +00:00
  • a5875d7c86 Update TODO list. Bruce Momjian 2001-06-07 20:05:56 +00:00
  • 4ee76ad884 reset all: command line and .conf options change defaults on RESET ALL those are restored. Bruce Momjian 2001-06-07 04:50:57 +00:00
  • d927ed20c2 I have ported another Python Postgres interface to Windows (PgSQL). It seems that not many people actually use libpq on Win32; I have found another bug. Some functions that are defined in libpq-fe.h aren't exported in the DLL version of the library. I have added them to src/interfaces/libpq/libpqdll.def. The new complete file is attached. Bruce Momjian 2001-06-07 00:10:18 +00:00
  • ba17165f55 This adds unary plus capability. No grammar changes, per Tom's request. Bruce Momjian 2001-06-07 00:09:32 +00:00
  • a6697b3614 get_seq_name should truncate name to NAMEDATALEN, so that this works: create sequence a1234567890123456789012345678901234567890; select nextval('a1234567890123456789012345678901234567890'); Tom Lane 2001-06-06 22:03:48 +00:00
  • b67fc0079c Be a little smarter about deciding how many most-common values to save. Tom Lane 2001-06-06 21:29:17 +00:00
  • bf9e01d950 Add large object finalization cleanup to the proper java file. Bruce Momjian 2001-06-06 21:16:09 +00:00
  • 4dca29dd3c Remove large object finalize code. Compile error. Bruce Momjian 2001-06-06 21:04:20 +00:00
  • 398b41a23f pgindent fix for asterisk indented too much in return type, for Tom. Bruce Momjian 2001-06-06 20:51:31 +00:00
  • ce62c8b10e Patch from Ian Lance Taylor fixing multiple cursor arguments and buffer zero termination. Jan Wieck 2001-06-06 18:54:41 +00:00
  • ef20c6991d Back-patch change to not keep WAL segments just for UNDO information. Tom Lane 2001-06-06 17:18:56 +00:00
  • 1173344e74 Adjust WAL code so that checkpoints truncate the xlog at the previous checkpoint's redo pointer, not its undo pointer, per discussion in pghackers a few days ago. No point in hanging onto undo information until we have the ability to do something with it --- and this solves a rather large problem with log space for long-running transactions. Also, change all calls of write() to detect the case where write returned a count less than requested, but failed to set errno. Presume that this situation indicates ENOSPC, and give the appropriate error message, rather than a random message associated with the previous value of errno. Tom Lane 2001-06-06 17:07:46 +00:00
  • ce370eec35 Update TODO list. Bruce Momjian 2001-06-06 04:53:50 +00:00
  • fb97d2b6bf Correct permissions-checking bugs associated with ancient decision to copy PUBLIC access rights into each newly created ACL entry. Instead treat each ACL entry as independent flags. Also clean up some ugliness in acl.h API. Tom Lane 2001-06-05 19:34:56 +00:00
  • cdd230d628 Improve planning of OR indexscan plans: for quals like WHERE (a = 1 or a = 2) and b = 42 and an index on (a,b), include the clause b = 42 in the indexquals generated for each arm of the OR clause. Essentially this is an index- driven conversion from CNF to DNF. Implementation is a bit klugy, but better than not exploiting the extra quals at all ... Tom Lane 2001-06-05 17:13:52 +00:00
  • 7c579fa12d Further work on making use of new statistics in planner. Adjust APIs of costsize.c routines to pass Query root, so that costsize can figure more things out by itself and not be so dependent on its callers to tell it everything it needs to know. Use selectivity of hash or merge clause to estimate number of tuples processed internally in these joins (this is more useful than it would've been before, since eqjoinsel is somewhat more accurate than before). Tom Lane 2001-06-05 05:26:05 +00:00
  • 28d2420eef This patch adds support for %TYPE in CREATE FUNCTION argument and return types. This version has an elog() to remind the user the type resolution is not dynamic. Bruce Momjian 2001-06-04 23:27:23 +00:00
  • 0a93285d88 Update with new email on ftp location of Karel patch. Bruce Momjian 2001-06-04 20:52:51 +00:00
  • 603fa2d5d7 Add Ross's email to schema. Bruce Momjian 2001-06-04 20:29:08 +00:00
  • 4dd5feb6df Add schema mention. Bruce Momjian 2001-06-04 20:28:21 +00:00
  • 5075a98996 Update TODO list. Bruce Momjian 2001-06-04 20:27:52 +00:00
  • cadf7ee34e Add domain to TODO.detail Bruce Momjian 2001-06-04 20:13:01 +00:00
  • 8b74f70d68 Update TODO list. Bruce Momjian 2001-06-04 20:12:22 +00:00
  • b69370441e protected void finalize() { close(); } Bruce Momjian 2001-06-04 20:10:41 +00:00
  • eeaa497e7b Give error message, rather than coredump, for utility statements in conditional rules (rules with WHERE clauses). We cannot support these since there's noplace to hang a condition on a utility statement. We caught the other case (attempt to attach a condition at rewrite time) awhile ago, but this one escaped notice until now. Tom Lane 2001-06-04 16:17:30 +00:00
  • 12c1552066 Mark many strings in backend not covered by elog for translation. Also, make strings in xlog.c look more like English and less like binary noise. Peter Eisentraut 2001-06-03 14:53:56 +00:00
  • 277a47ad0f Accept and output '-Infinity' as well as 'Infinity', per long-ago suggestion from Ross Reedstrom. Still needs work to make those symbols convert to actual IEEE infinities (on machines where such things exist). Tom Lane 2001-06-02 20:18:30 +00:00
  • 1df27f9a59 Update TODO list. Bruce Momjian 2001-06-02 19:11:42 +00:00
  • 5433b48380 Tweak sorting so that nulls appear at the front of a descending sort (vs. at the end of a normal sort). This ensures that explicit sorts yield the same ordering as a btree index scan. To be really sure that that equivalence holds, we use the btree entries in pg_amop to decide whether we are looking at a '<' or '>' operator. For a sort operator that has no btree association, we put the nulls at the front if the operator is named '>' ... pretty grotty, but it does the right thing in simple ASC and DESC cases, and at least there's no possibility of getting a different answer depending on the plan type chosen. Tom Lane 2001-06-02 19:01:53 +00:00
  • e542036461 Native Language Support (NLS) Peter Eisentraut 2001-06-02 18:25:18 +00:00
  • 58193c5f37 Paranoia about unordered comparisons in IEEE float math. If we are given values that compare as unordered, make sure we reply that they are equal, which is better than giving an arbitrary answer --- at least it doesn't depend on which one is passed as which arg. Tom Lane 2001-06-02 17:12:12 +00:00
  • fc7c16fd16 dllist.c is included in the frontend libpq interface via symlink. There is no elog() available. Used fprintf(stderr, ...) and exit instead. Jan Wieck 2001-06-02 15:16:55 +00:00
  • c9445f0882 The following patch for JDBC fixes an issue with jdbc running on a non-multibyte database loosing 8bit characters. This patch will cause the jdbc driver to ignore the encoding reported by the database when multibyte isn't enabled and use the JVM default in that case. Bruce Momjian 2001-06-01 20:57:58 +00:00
  • c6b1ef8fe7 Check for malloc failure. Tom Lane 2001-06-01 20:29:43 +00:00
  • ddd96e1f21 Guard against malloc failure. Also, don't examine segP->lastBackend until we hold the spinlock. Tom Lane 2001-06-01 20:07:16 +00:00
  • d8adce8983 Check for malloc failure. Tom Lane 2001-06-01 19:54:58 +00:00
  • 25ee08e14a If spi.c wants to use malloc, it better test for malloc failure. Tom Lane 2001-06-01 19:43:55 +00:00
  • 7748e9e7e5 pltcl, plperl, and plpython all suffer the same bug previously fixed in plpgsql: they fail for datatypes that have old-style I/O functions due to caching FmgrInfo structs with wrong fn_mcxt lifetime. Tom Lane 2001-06-01 18:17:44 +00:00
  • 7c0c9b3cce New improved version of bpcharin() may have got the truncation case right, but it failed to get the padding case right. Tom Lane 2001-06-01 17:49:17 +00:00
  • 597ca67e5e Fix for: Bruce Momjian 2001-06-01 16:09:55 +00:00
  • a51ec450ff Remove fastpath.c's lame attempt at caching function lookup info across calls. This has never actually cached anything, because postgres.c does each fastpath call as a separate transaction command, and so fastpath.c would always decide that its cache was outdated. If it had worked, it would now be failing for calls of oldstyle functions due to dangling pointers in the FmgrInfo struct. Rip it out for simplicity and bug- proofing. Tom Lane 2001-06-01 15:45:42 +00:00
  • cfd184371e - Synced preproc.y with gram.y. - Synced pgc.l with scan.l. - Synced keyword.c. - Set ecpg version to 2.9.0. - Set library version to 3.3.0. Michael Meskes 2001-06-01 06:23:19 +00:00
  • 0b370ea7c8 Clean up some minor problems exposed by further thought about Panon's bug report on old-style functions invoked by RI triggers. We had a number of other places that were being sloppy about which memory context FmgrInfo subsidiary data will be allocated in. Turns out none of them actually cause a problem in 7.1, but this is for arcane reasons such as the fact that old-style triggers aren't supported anyway. To avoid getting burnt later, I've restructured the trigger support so that we don't keep trigger FmgrInfo structs in relcache memory. Some other related cleanups too: it's not really necessary to call fmgr_info at all while setting up the index support info in relcache entries, because those ScanKeyEntry structs are never used to invoke the functions. This should speed up relcache initialization a tiny bit. Tom Lane 2001-06-01 02:41:36 +00:00
  • a1d9d096f0 Update release 1.09 date Bruce Momjian 2001-06-01 00:24:21 +00:00
  • 92e0535dbb Forgot SGML section section id tag for 7.1. Bruce Momjian 2001-05-31 21:50:47 +00:00
  • e5b412bd79 Forgot SGML section section id tag for 7.1. Bruce Momjian 2001-05-31 21:49:15 +00:00
  • 5bcf9233e4 Ooops, forgot to commit Makefile along with other changes. Tom Lane 2001-05-31 19:25:27 +00:00
  • 16f85390f2 Support for emulating RTREE indexing in GiST. Contributed by Oleg Bartunov and Teodor Sigaev. Tom Lane 2001-05-31 18:27:18 +00:00
  • 3043810d97 Updates to make GIST work with multi-key indexes (from Oleg Bartunov and Teodor Sigaev). Declare key values as Datum where appropriate, rather than char* (Tom Lane). Tom Lane 2001-05-31 18:16:55 +00:00
  • 6ab6f872c1 RI triggers would fail for datatypes using old-style equal function, because cached fmgr info contained reference to a shorter-lived data structure. Also guard against possibility that fmgr_info could fail, leaving an incomplete entry present in the hash table. Tom Lane 2001-05-31 17:33:03 +00:00
  • e1107fc285 RI triggers would fail for datatypes using old-style equal function, because cached fmgr info contained reference to a shorter-lived data structure. Also guard against possibility that fmgr_info could fail, leaving an incomplete entry present in the hash table. Tom Lane 2001-05-31 17:32:33 +00:00
  • c9a001a11e Allow IS and FOR in Pl/PgSQL cursors, per Oracle and ANSI. Jan-approved. Bruce Momjian 2001-05-31 17:15:40 +00:00
  • 0cee65b51f Update TODO list. Bruce Momjian 2001-05-31 14:49:24 +00:00
  • 227a584655 Update FAQ. Bruce Momjian 2001-05-30 23:00:41 +00:00