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

Commit Graph

  • d05b4bd7c6 Permission checking wasn't quite right for insert/update/delete rules, either :-(. Tom Lane 2001-05-03 21:16:48 +00:00
  • c434ae3539 pg_dump can dump 7.0 databases. Bruce Momjian 2001-05-03 20:39:52 +00:00
  • 3f8e21c34a apply a little patch: Bruce Momjian 2001-05-03 19:20:24 +00:00
  • 2792374cff Ensure that btree sort ordering functions and boolean comparison operators give consistent results for all datatypes. Types float4, float8, and numeric were broken for NaN values; abstime, timestamp, and interval were broken for INVALID values; timetz was just plain broken (some possible pairs of values were neither < nor = nor >). Also clean up text, bpchar, varchar, and bit/varbit to eliminate duplicate code and thereby reduce the probability of similar inconsistencies arising in the future. Tom Lane 2001-05-03 19:00:37 +00:00
  • 77fe28f33e Describe handling of multiply-inherited fields correctly. Tom Lane 2001-05-03 17:50:55 +00:00
  • f2122d092f Permissions were not checked correctly when one view invokes another. Per bug report from Lieven Van Acker, 5/2/01. Tom Lane 2001-05-03 17:47:49 +00:00
  • d31b9f3101 Update shared memory docs. Bruce Momjian 2001-05-03 17:28:13 +00:00
  • 645553eaf6 Improve list. Bruce Momjian 2001-05-03 17:20:14 +00:00
  • 7efc878104 Final stamp for 7.1.1. All done. Bruce Momjian 2001-05-03 17:17:41 +00:00
  • 3bc0ab783b Updates for 7.1.1. Not done yet. Bruce Momjian 2001-05-03 16:47:58 +00:00
  • c0f5b4c82c autoconf Bruce Momjian 2001-05-03 16:43:26 +00:00
  • 13e9cea634 Some updates for 7.1.1. Bruce Momjian 2001-05-03 16:26:21 +00:00
  • 8571e6c6e5 Correct pg_description entry for type macaddr. Tom Lane 2001-05-03 16:18:02 +00:00
  • f13cb7e524 Fixes to make ecpg work on Cygwin, from Jason Tishler <Jason.Tishler@dothill.com>. Tom Lane 2001-05-03 16:07:52 +00:00
  • b95ff0c542 Initial checkin of a contributed type that handles passwords efficiently. D'Arcy J.M. Cain 2001-05-03 12:32:13 +00:00
  • 4ad073cf4c In the outputs section the NOTICE reads: aggregate 'agg' for 'type' does not exist. Bruce Momjian 2001-05-02 20:35:21 +00:00
  • 8e393fc501 Added mention of SHMALL and removed BSD/OS-specific table. Bruce Momjian 2001-05-02 17:04:53 +00:00
  • 4929d85e50 description of the command line option echo should read: Bruce Momjian 2001-05-02 14:46:33 +00:00
  • d67a618e19 Previous commit mistakenly converted all newlines to DOS style (CR/LF). Convert back to Unix style --- it seems some versions of nmake insist on this. Tom Lane 2001-05-02 14:23:40 +00:00
  • 57faa28740 Add note explaining why inserts take longer as tables grow. Also suggest the way to handle this. D'Arcy J.M. Cain 2001-05-02 11:21:57 +00:00
  • 66feaa80dc Change "|zzlzzzz" argument specification to "|zzizzzz" so that the code works properly on 64 bit systems. D'Arcy J.M. Cain 2001-05-02 11:17:24 +00:00
  • adee1da002 Bump version to 7.1.1. Now run over to hub to rebuild documentation before release... Peter Eisentraut 2001-05-01 10:50:26 +00:00
  • 4f268b01cd More markup fixes Peter Eisentraut 2001-05-01 10:48:57 +00:00
  • d45c0794df Fix slightly confused description of debug options. Tom Lane 2001-05-01 03:00:28 +00:00
  • ac2b9aee1c Synced gram.y and preproc.y. Tom Lane 2001-05-01 02:33:55 +00:00
  • d63571a7f4 Allow a string argument to the EXTRACT() function. This is an extension to the SQL9x standard, but is consistant with usage of the underlying date_part() function used to implement it. Example: EXTRACT('YEAR',...) No impact on regression tests. Thomas G. Lockhart 2001-05-01 01:36:10 +00:00
  • 892d46e7d0 1) fix bugs reported by Andrea Aime. 2) fix a bug reported by Jan Wieck. psqlodbc is 7.01.0005 now. Hiroshi Inoue 2001-05-01 00:47:06 +00:00
  • 48bdf021b6 Update FAQ_HPUX now that we have reports of out-of-the-box build on HPUX 11. Tom Lane 2001-04-30 23:55:26 +00:00
  • c8b5598a11 Document pltcl's return_null command. Tom Lane 2001-04-30 22:22:34 +00:00
  • 955c8771f8 Repair freshly-broken markup. Tom Lane 2001-04-30 22:21:22 +00:00
  • 8bb3c8fe54 exec_move_row() should be more forgiving of tuples with a different number of columns than it was expecting, for reasons that are now documented in the code... Tom Lane 2001-04-30 20:05:40 +00:00
  • e2004dfc69 Suppress pull-up of subqueries that are in the nullable side of an outer join. This is needed to avoid improper evaluation of expressions that should be nulled out, as in Victor Wagner's bug report of 4/27/01. Pretty ugly solution, but no time to do anything better for 7.1.1. Tom Lane 2001-04-30 19:24:47 +00:00
  • 60ba30d13a Break up PQexec() result functions into subsections to be clearer. Both libpq and libpq++ reorganized. Bruce Momjian 2001-04-30 17:38:00 +00:00
  • cfc4d6c510 Update TODO list. Bruce Momjian 2001-04-30 15:57:01 +00:00
  • 9a878b4ec7 Add mention of libpgtcl's options to manual, libpq++ markup fixes. Bruce Momjian 2001-04-30 04:26:01 +00:00
  • 189a752ef9 Update TODO list. Bruce Momjian 2001-04-30 02:35:40 +00:00
  • c527366b60 Add missing Unicode support for Cyrillic encodings. Patches contributed by Victor Wagner. Tatsuo Ishii 2001-04-29 07:27:38 +00:00
  • 82511e3375 In create_function there is a remark concerning SQL/PSM not being ratified as yet. This is certainly no longer true, it wasn't even true in Q2/1998 when I did a little research for Date's book. SQL/PSM had been published on 1996-12-15 as ISO/IEC 9075:4. So you might want to update that section. Bruce Momjian 2001-04-28 13:59:07 +00:00
  • 651acdaa6e A small patch for a small option (for rel. 7.1). Bruce Momjian 2001-04-27 01:31:56 +00:00
  • 8926d8b28d Update FAQ. Bruce Momjian 2001-04-27 00:55:49 +00:00
  • 1531ed897b Update FAQ. Bruce Momjian 2001-04-27 00:22:59 +00:00
  • ea0d2dab06 Update FAQ. Bruce Momjian 2001-04-27 00:21:44 +00:00
  • 2adff4b20e Remove bogus Assert from AbsoluteTimeIsBefore(). (If you don't think it's bogus, try building a btree index on the regress tests' abstime_tbl.) Tom Lane 2001-04-26 21:52:17 +00:00
  • a43f20cb0a Tweak nestloop costing to weight restart cost of inner path more heavily. Without this, it was making some pretty silly decisions about whether an expensive sub-SELECT should be the inner or outer side of a join... Tom Lane 2001-04-25 22:04:37 +00:00
  • cbeda8401a Update TODO list. Bruce Momjian 2001-04-25 17:49:29 +00:00
  • 8dc42a3aa2 - Fixed CONSTRAINT TRIGGER dump to record tgconstrelid properly - pgsql v7.0 compatbility Philip Warner 2001-04-25 07:03:20 +00:00
  • 38b0f2fb3b typological errors Peter Eisentraut 2001-04-24 20:05:02 +00:00
  • e89bf1258b Undo pgindent brain damage, so that node type numbers can once again be counted off by lines ... Tom Lane 2001-04-24 00:08:38 +00:00
  • 5c48b253af Behave sanely when database name is omitted from command line. Tom Lane 2001-04-23 23:36:33 +00:00
  • fae92fba43 Send 'cd' output to /dev/null. Peter Eisentraut 2001-04-23 20:27:55 +00:00
  • 19c97b8579 Defend against ancient versions of zlib by checking that zlib.h defines z_streamp. Tom Lane 2001-04-23 15:14:58 +00:00
  • a933bceacf compatible_oper needs to do ReleaseSysCache in one path to avoid complaints about 'Cache reference leak'. Per report from Don Baccus. Tom Lane 2001-04-23 04:32:30 +00:00
  • e355992ff9 1) Decrease the size of needlessly large buffers. For example, it resolved the stack over flow errors reported by Johann Zuschlag. 2) Support {oj syntax for 71. servers. Hiroshi Inoue 2001-04-23 01:41:06 +00:00
  • cc6bdb3e48 A patch to fix the following bugs. 1) [ODBC] Psqlodbc and Centura: here it is a patch posted by Matteo Cavalleli 2) [ODBC] pgsqODBC binding parameters II posted by Ludek Finstrle 3) Invalid Page Fault in PSQLODBC.DLL personal mail from Johann Zuschlag Hiroshi Inoue 2001-04-23 01:00:49 +00:00
  • 0e29d760f4 Don't bomb out on indexes on system attributes other than 'oid'. (Not sure such an index is actually useful, but just because it's useless doesn't mean pg_dump should coredump.) Tom Lane 2001-04-22 21:34:13 +00:00
  • 8407bb3c72 Remove useless setuid() call, instead add a check that real and effective userids are the same. Per today's pghackers discussion. Tom Lane 2001-04-21 18:29:29 +00:00
  • 9ae6819038 Make sure that the postmaster options (from postmaster.opts[.default] or -o option) are properly dequoted. Also, always pass an explicit -D option to postmaster, don't rely on it being set in postmaster.opts. Peter Eisentraut 2001-04-21 11:23:58 +00:00
  • e6767a3205 Final markup for 7.1 hardcopy release. Mostly typo and table-fitting adjustments. Note that many tables are being abused with *really* long description columns. Should probably shrink those columns to be more concise, and move some of the info to follow-on reference notes. Thomas G. Lockhart 2001-04-20 15:52:33 +00:00
  • 072174f941 Add option --refentry to change \keepn (keep with next paragraph) to \keep (keep current paragraph together). This fixes most troubles with reference pages marked up with <refentry> tags. Use on reference.rtf, generated by "make reference.rtf". Thomas G. Lockhart 2001-04-20 15:50:25 +00:00
  • 90f4d0faf1 Remove libsfio check. Peter Eisentraut 2001-04-19 20:27:47 +00:00
  • 031e1afa23 Pass -D option to pg_ctl because export PGDATA won't be preserved across 'su -l'. Peter Eisentraut 2001-04-19 19:17:44 +00:00
  • 47324d7689 Add extern int optreset declaration, per bug report from <info@decc.nl>. Peter Eisentraut 2001-04-19 19:09:23 +00:00
  • 7ff8d11065 Fix "off by VARHDRSZ" bug in (Cyrillic) recode support. Peter Eisentraut 2001-04-19 19:01:23 +00:00
  • 73470b27ce Update TODO list. Bruce Momjian 2001-04-19 15:22:29 +00:00
  • 2dbdba86db Kluge solution for Alex Pilosov's report of problems with whole-tuple function arguments in join queries: copy the tuples into TransactionCommandContext so they don't get recycled too soon. This is horrid, but not any worse than 7.0 or before, which also leaked such tuples until end of query. A proper fix will require allowing tuple datums to be physically stored inside larger tuple datums, which opens up a bunch of issues that can't realistically be solved for 7.1.1. Tom Lane 2001-04-19 04:29:02 +00:00
  • b9be04e63d Add a crash gurard to pg_encoding_mblen in case of an invalid encoding given. Tatsuo Ishii 2001-04-19 02:34:35 +00:00
  • 23436bd530 Further tweaking of error messages for cases involving attributes & functions of join or subselect aliases. It'd be awfully nice if this code knew for sure whether it was dealing with 'x.f' or 'f(x)' syntax; maybe we can fix that in a future cycle. Tom Lane 2001-04-18 22:25:31 +00:00
  • 645ebc0403 Repair misbehavior of \! with immediately following argument that contains spaces (e.g., '\!ls -l'). Also correct a comment. Peter Eisentraut 2001-04-18 20:53:08 +00:00
  • d5096af2c4 Make the world safe for passing whole rows of views to functions. This already worked fine for whole rows of tables, but not so well for views... Tom Lane 2001-04-18 20:42:56 +00:00
  • e4c06b2125 Update TODO list. Bruce Momjian 2001-04-18 17:52:12 +00:00
  • 40136f4465 Make rule lister do the right thing with Vars representing whole tuples. Tom Lane 2001-04-18 17:04:24 +00:00
  • 4a5905184f Update TODO list. Bruce Momjian 2001-04-17 14:17:47 +00:00
  • 9609a875bb The renewal of README thanks to Dave Page. Hiroshi Inoue 2001-04-17 07:30:53 +00:00
  • c273e8b13c Add some defenses to guard against case where a rule refers to a table or view that's been dropped and then recreated with the same name (but, perhaps, different columns). Eventually we'd like to support this but for now all we can do is fail cleanly, rather than possibly coredumping if we proceed using the obsolete rule. Tom Lane 2001-04-17 00:32:58 +00:00
  • cdcaec5c53 Avoid reversing user-given order of WHERE clauses while attaching clauses to specific base or join RelOptInfo nodes during planning. This preserves the more-intuitive behavior of 7.0.* --- if you write an expensive clause (such as a sub-select) last, it should get evaluated last. Someday we ought to try to have some intelligence about the order of evaluation of WHERE clauses, but for now we should not override what the user wrote. Tom Lane 2001-04-16 19:44:10 +00:00
  • 722f7efdd9 Correction for mathematical properties in Unicode converison maps. Patches contributed by Eiji Tokuya (e-tokuya@sankyo-unyu.co.jp) Tatsuo Ishii 2001-04-16 06:10:19 +00:00
  • d32422f796 Update Japanese FAQ's. Bruce Momjian 2001-04-16 04:20:36 +00:00
  • 10cdcf1c7b Add new item. Bruce Momjian 2001-04-16 04:11:54 +00:00
  • fbee97664e getdatabaseencoding() and PG_encoding_to_char() were being sloppy about converting char* strings to type 'name'. Imagine my surprise when 7.1 release coredumped upon start when compiled --enable-multibyte ... Tom Lane 2001-04-16 02:42:01 +00:00
  • 6ccb2af725 Remove error report from pq_endmessage when pq_putmessage fails. The only possible failure is in pq_flush, which will log a (better!) report anyway --- so pq_endmessage is just cluttering the log with a redundant entry. This matters when a client crashes partway through a large query, since we will emit many broken-pipe reports before finishing the query and exiting. Tom Lane 2001-04-16 01:46:57 +00:00
  • c8e05affe4 Update TODO list. Bruce Momjian 2001-04-16 01:36:50 +00:00
  • 382a429d84 Add LDFLAGS_SL to AIX shlib building command, per report from Rocco Altier <roccoa@routescape.com>. Tom Lane 2001-04-15 03:25:07 +00:00
  • ffbeafb19a Constant expressions that appear in ORDER BY, GROUP BY, DISTINCT ON lists should be reverse-compiled into targetlist index numbers, because that's the only interpretation the parser allows for a constant in these clauses. (Ergo, the only way they could have gotten into the list in the first place is to have come from the targetlist; so this should always work.) Per problem report from Peter E. Tom Lane 2001-04-15 03:14:18 +00:00
  • 7f2de4937a Update TODO list. Bruce Momjian 2001-04-15 01:56:08 +00:00
  • f9094c44c0 Prevent generation of invalid plans for RIGHT or FULL joins with multiple join clauses. The mergejoin executor wants all the join clauses to appear as merge quals, not as extra joinquals, for these kinds of joins. But the planner would consider plans in which partially-sorted input paths were used, leading to only some of the join clauses becoming merge quals. This is fine for inner/left joins, not fine for right/full joins. Tom Lane 2001-04-15 00:48:17 +00:00
  • 15a6cd0091 If the password prompt goes to stderr, then the trailing newline should also go there. Peter Eisentraut 2001-04-15 00:43:37 +00:00
  • eb1b164317 Work with Readline 4.2. Peter Eisentraut 2001-04-14 22:55:02 +00:00
  • 25efda227d Add debug_query_string global variable for pgmonitor and debugging use. Bruce Momjian 2001-04-14 19:11:45 +00:00
  • 232d8fa3c4 - Get view OID based on rule OID not base table OID - Fix crash due to null string pointer in some tar files with some libs Philip Warner 2001-04-14 13:11:03 +00:00
  • 83c94a886c Another try at making numeric MODULO operator produce the right answer. Although it was now using the right equation, it was making bogus choices of the precision to compute intermediate results to. I'm not sure this is really right even yet, but it's better than before ... Tom Lane 2001-04-14 02:10:57 +00:00
  • ca224d2ba4 Suppress compiler warnings in Vax and NS32K assembly code: 'register foo' is not a complete declaration. Tom Lane 2001-04-13 23:32:57 +00:00
  • 741604dd84 tag the source tree as REL7_1, renaming the old tag REL7_1_BETA like it should have been done REL7_1 Marc G. Fournier 2001-04-13 21:21:33 +00:00
  • ef922b2556 Remove as-of from HISTORY file. Bruce Momjian 2001-04-13 18:38:32 +00:00
  • d3d35e9b25 I just noticed the beta comment. That's not actually true any more so I removed it. D'Arcy J.M. Cain 2001-04-12 09:49:37 +00:00
  • e47d6d440e Update FAQ. Bruce Momjian 2001-04-09 19:28:01 +00:00
  • f34fa8ba89 Update FAQ. Bruce Momjian 2001-04-08 22:57:38 +00:00
  • ecd8ddd004 upgrade tags to rc4 (note lower case for packagers) Marc G. Fournier 2001-04-08 18:10:42 +00:00
  • fc21f3c926 Rearrange distribution split as discussed on -hackers. Peter Eisentraut 2001-04-08 17:28:10 +00:00
  • cdbf1762dc Update to reflect OpenSSL 0.9.6a release. Peter Eisentraut 2001-04-08 16:36:13 +00:00
  • 8ca722b678 Update TODO list. Bruce Momjian 2001-04-07 02:30:58 +00:00