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

Commit Graph

  • 0d17ce92ac Fix breakage that had crept into setlocale() usage: once again we've been bit by the fact that the locale functions return pointers to modifiable variables. I added some comments that might help us avoid the mistake in future. Tom Lane 2002-10-18 20:44:02 +00:00
  • 6c06bc2644 Make 'dummy' declarations in header files be 'extern int no_such_variable' instead of 'extern int errno'; the latter is unsafe according to the ANSI C standard, as well as in practice on some platforms. Tom Lane 2002-10-18 20:33:57 +00:00
  • dad34ba567 Un-break createlang build. Tom Lane 2002-10-18 19:35:28 +00:00
  • 5214f09b27 Clean up for dblink autocommit OFF handling. Bruce Momjian 2002-10-18 19:11:27 +00:00
  • aa4c702eac Update /contrib for "autocommit TO 'on'". Bruce Momjian 2002-10-18 18:41:22 +00:00
  • fb9bc342ff Improve discussion of FOR UPDATE. Tom Lane 2002-10-18 18:26:22 +00:00
  • f99e525f0f Update for tables returning function, item 5.3, from Joe Conway. Bruce Momjian 2002-10-17 23:34:10 +00:00
  • b0146a2407 Fix in updateable result sets to handle binding null values correctly Patch submitted by Kris Jurka (applied with some modifications) Barry Lind 2002-10-17 19:17:08 +00:00
  • 3e4978b72b Fix free-slot search in PgSetResultId so it actually works. Tom Lane 2002-10-17 14:53:32 +00:00
  • e313eb8098 Improve formatting of error message. Tom Lane 2002-10-17 14:51:50 +00:00
  • c3e7b3cc96 Fixed support in jdbc for 7.3 server autocommit. With these changes the jdbc regression tests pass for both autocommit on and autocommit off Barry Lind 2002-10-17 05:33:52 +00:00
  • f789bd3de2 Add: Bruce Momjian 2002-10-17 03:58:22 +00:00
  • 841e4b2089 Put the disk information all in one chapter. Peter Eisentraut 2002-10-16 22:06:33 +00:00
  • cda776e613 Make pg_dump save for autocommit = off. Bruce Momjian 2002-10-16 05:46:54 +00:00
  • ec64390e91 Fix from Joe on timeout code. Bruce Momjian 2002-10-16 04:38:00 +00:00
  • 6b0e166644 Improve appearance of SET command. Bruce Momjian 2002-10-16 03:44:28 +00:00
  • 5d8c67462d Fix script to handle autocommit = 'off' by prepending autocommit 'on' to the start of the psql commandline. This is better than adding BEGIN/END because it handles multiple queries well, and allows the return code for psql to return the proper value. Bruce Momjian 2002-10-16 03:24:09 +00:00
  • facb720073 Fix connection_timeout to use time() and handle timeout == 1. Bruce Momjian 2002-10-16 02:55:30 +00:00
  • 8a96c50ec9 Remove: Bruce Momjian 2002-10-15 21:34:10 +00:00
  • 7426d4d937 Add: Bruce Momjian 2002-10-15 18:54:56 +00:00
  • f4a7c257dc Fix unintentional breakage of COPY TO/FROM stdin. Mea culpa. Tom Lane 2002-10-15 16:44:21 +00:00
  • 3a2ef59116 Fix Linux dynloader code for pre-HAVE_DLOPEN systems, which evidently are still in use out there. Per report from Brendan LeFebvre. Tom Lane 2002-10-15 16:04:17 +00:00
  • 951ec872c7 Fix psql to cope with autocommit off, at least during startup. Behavior of backslash commands (especially for large objects) may still require some thought. Tom Lane 2002-10-15 02:24:16 +00:00
  • e258a2b436 Fix libpq startup code to work correctly in autocommit off mode. In passing, fix breakage for case where PGCLIENTENCODING is set in environment. Tom Lane 2002-10-15 01:48:25 +00:00
  • 9ff695c944 Make SPI's execution of querystrings follow the rules agreed to for command status at the interactive level. SPI_processed, etc are set in the same way as the returned command status would have been set if the same querystring were issued interactively. Per gripe from Michael Paesold 25-Sep-02. Tom Lane 2002-10-14 23:49:20 +00:00
  • ba0edcf451 None. Bruce Momjian 2002-10-14 22:43:45 +00:00
  • d508b057ac Adjust handling of command status strings in the presence of rules, as per recent pghackers discussions. initdb forced due to change in fields of stored Query nodes. Tom Lane 2002-10-14 22:14:35 +00:00
  • ea3728ee5b Add missing entries for bit<->int4 and bit<->int8 conversions. Tom Lane 2002-10-14 22:12:49 +00:00
  • 50634c13e4 Translation updates Peter Eisentraut 2002-10-14 19:04:28 +00:00
  • 4a513ab07f Mention that resetting the timeout may be wrong on select retry. Bruce Momjian 2002-10-14 18:11:17 +00:00
  • 6d9d97e8ab Restore ptmp_timeout for cases where no timeout is passed. Bruce Momjian 2002-10-14 17:33:08 +00:00
  • 9eada51012 libpq connection_timeout doesn't do subsecond timing, so make the code clear on that point. Bruce Momjian 2002-10-14 17:15:11 +00:00
  • 8f2a289d78 Arrange to copy relcache's trigdesc structure at the start of any query that uses it. This ensures that triggers will be applied consistently throughout a query even if someone commits changes to the relation's pg_class.reltriggers field meanwhile. Per crash report from Laurette Cisneros. While at it, simplify memory management in relcache.c, which no longer needs the old hack to try to keep trigger info in the same place over a relcache entry rebuild. (Should try to fix rd_att and rewrite-rule access similarly, someday.) And make RelationBuildTriggers simpler and more robust by making it build the trigdesc in working memory and then CopyTriggerDesc() into cache memory. Tom Lane 2002-10-14 16:51:30 +00:00
  • 8fc1f413f4 - Link the entries in the table to the catalog heading - Wrap them in the <database class="table"> tags, since thats what they are (no markup rules for this, so it inherits from parent -- no style change) - Mention that pg_database, pg_shadow, and pg_group are global, and the rest are local to the specific DB. (I believe this is correct). Bruce Momjian 2002-10-14 04:29:23 +00:00
  • 4c59afaee6 This trivial patch fixes a bunch of spelling mistakes in the contrib/dbmirror/README.dbmirror doc file. Bruce Momjian 2002-10-14 04:27:25 +00:00
  • ac376a3eb9 As Niel so nicely pointed out this morning, the output of EXPLAIN ANALYZE is not quite clear when branches of the query are never executed. So this tiny patch fixes that. Bruce Momjian 2002-10-14 04:26:54 +00:00
  • 1f653ec31e I have attached two patches as per: Bruce Momjian 2002-10-14 04:20:52 +00:00
  • daaf999fcb Improvements to Ian Barwick patch. Bruce Momjian 2002-10-14 03:15:33 +00:00
  • 0896707ef6 FAQ updates from Ian Barwick. Bruce Momjian 2002-10-14 02:50:28 +00:00
  • ad4ce7aa5b Make SET really not start a transaction. Tom Lane 2002-10-13 16:55:05 +00:00
  • 5261bf9733 Make macaddr_in reject trailing garbage (except whitespace). Per gripe from Patrick Welche, 13-Oct-2002. Tom Lane 2002-10-13 15:39:17 +00:00
  • f94e5bde60 psql thought that backslash is an escape character inside double quotes. It isn't. Tom Lane 2002-10-12 23:09:34 +00:00
  • 5bb46e7cd0 Fix for bug #795: two clauses that seem redundant are not really, if one is pushed down into an outer join and the other is not. Tom Lane 2002-10-12 22:24:49 +00:00
  • 8031b066fa Update README for oid2name. Bruce Momjian 2002-10-12 19:15:09 +00:00
  • 3877847e88 Add: Bruce Momjian 2002-10-12 19:03:41 +00:00
  • bb63dacee3 Added: Bruce Momjian 2002-10-12 17:01:19 +00:00
  • 0cd5ce6b11 Compute version number for docs on the fly. Peter Eisentraut 2002-10-12 16:34:28 +00:00
  • 08028faa22 Handle indentation of verbatim environments in HTML output via CSS. Peter Eisentraut 2002-10-12 16:33:43 +00:00
  • af514dca9e Fix linking problem. Peter Eisentraut 2002-10-12 16:31:55 +00:00
  • 10f41b2b80 Replace &version; by appropriate version. Peter Eisentraut 2002-10-12 16:29:51 +00:00
  • c086590380 Assorted reference page updates Peter Eisentraut 2002-10-11 23:03:48 +00:00
  • 3379f7b9e0 Update FAQ. Bruce Momjian 2002-10-11 17:55:17 +00:00
  • e350d3d988 Update Russian FAQ. Bruce Momjian 2002-10-11 17:45:40 +00:00
  • 1aa4a37f6a Add replication, encryption, and cross database FAQ items. Bruce Momjian 2002-10-11 05:02:24 +00:00
  • 3258484d03 Add tv_sec change for connection timeout suggested by author. Bruce Momjian 2002-10-11 04:41:59 +00:00
  • 2177b6b635 Oops, back out newNode changes. We are not ready for that yet. Bruce Momjian 2002-10-11 04:16:44 +00:00
  • 6a7bb0afbc Prevent tv_sec from becoming negative in connection timeout code. Bruce Momjian 2002-10-11 04:12:14 +00:00
  • c2311337f0 Update: Bruce Momjian 2002-10-11 03:32:45 +00:00
  • 52f6918c28 Update IN/EXISTS item. Bruce Momjian 2002-10-10 03:15:19 +00:00
  • 5aa7849e1b set.patch updates an example in ref/set.sgml to have microsecond precision. Bruce Momjian 2002-10-09 16:27:48 +00:00
  • 8a7cfa3756 Lock on the rule relation wasn't removed after adding the comment. Bruce Momjian 2002-10-09 16:26:46 +00:00
  • 0215dc9b0f Well, this patch makes Makefile for contrib/rserv use the contrib/contrib-global.mk library and _generally_ behave like Makefiles for other contrib modules. Besides it fixes Perl's interpolation of $libdir variable, which should be passed to backend instead. This patch is done against PostgreSQL 7.3b2 Bruce Momjian 2002-10-09 16:23:55 +00:00
  • 33a6b67b51 > > > > and mb conversions (pg_ascii2mic and pg_mic2ascii not > > > > found in the postmaster and not included from elsewhere) > > > > shared libs on AIX need to be able to resolve all symbols at linkage time. > > Those two symbols are in backend/utils/SUBSYS.o but not in the postgres > > executable. > > They are defined in backend/utils/mb/conv.c and declared in > include/mb/pg_wchar.h. They're also linked into the > postmaster. I don't see anything unusual. Bruce Momjian 2002-10-09 16:21:54 +00:00
  • ba8e20a6dd > Alvaro Herrera <alvherre@atentus.com> writes: > > I'm looking at pg_dump/common.c:flagInhAttrs() and suspect that it can > > be more or less rewritten completely, and probably should to get rigth > > all the cases mentioned in the past attisinherited discussion. Is this > > desirable for 7.3? It can probably be hacked around and the rewrite > > kept for 7.4, but I think it will be much simpler after the rewrite. > > If it's a bug then it's fair game to fix in 7.3. But keep in mind that > pg_dump has to behave at least somewhat sanely when called against older > servers ... will your rewrite behave reasonably if the server does not > offer attinhcount values? Bruce Momjian 2002-10-09 16:20:25 +00:00
  • d015dcbe4e Have SET not start transaction when autocommit off, with doc updates. Bruce Momjian 2002-10-09 04:59:38 +00:00
  • eb949720ad Add: Bruce Momjian 2002-10-09 02:04:03 +00:00
  • baaf8d7186 Again improve MemSet comments. Bruce Momjian 2002-10-08 23:12:22 +00:00
  • 59da96b8ce Update MemSet comments. Bruce Momjian 2002-10-08 19:17:58 +00:00
  • 56ece37384 Move responsibility for setting QuerySnapshot for utility statements into postgres.c; make sure it happens for all cases that seem to need it. Perhaps it would be better to explicitly exclude just a few utility statement types from setting a snapshot? Tom Lane 2002-10-08 17:17:19 +00:00
  • 5fc32fbf87 fixed missing apostrophe Dave Cramer 2002-10-08 01:47:55 +00:00
  • 4e9b159484 Change order of operations during XLogFlush so that we try to include in our write/flush operation any WAL entries that got queued while we were waiting to get the WALWriteLock. This improves throughput when transactions are small enough that several can be committed per WAL write (ie, per disk revolution). Tom Lane 2002-10-07 17:04:30 +00:00
  • 9a2e9c6804 Avoid PQisBusy/PQconsumeInput busy loop in case of PQisBusy returning false. per Tom Lane's suggestion. See: Tatsuo Ishii 2002-10-07 05:10:02 +00:00
  • e4c2967edb Clarify comment. Bruce Momjian 2002-10-06 03:56:03 +00:00
  • fb5e61fd2d Fix markup error. Bruce Momjian 2002-10-05 23:43:42 +00:00
  • a32df55730 Add: Bruce Momjian 2002-10-05 19:04:00 +00:00
  • 0c88e38eda Add more documentation about CURRENT_TIMESTAMP. Bruce Momjian 2002-10-05 19:03:16 +00:00
  • 82df2dd732 Update: Bruce Momjian 2002-10-05 04:00:26 +00:00
  • 916d8164df Restrict CREATE OPERATOR CLASS to superusers, per discussion some weeks ago. Tom Lane 2002-10-04 22:19:29 +00:00
  • d2db166c75 Require superuser privilege to create a binary-compatible cast, per discussion some weeks ago. Also, add a check that two types to be binary-equivalenced match as to typlen, typbyval, and typalign; if they don't then it's surely a mistake to equivalence them. Tom Lane 2002-10-04 22:08:44 +00:00
  • 04c57d68ce Update wording for temp files: Bruce Momjian 2002-10-04 19:06:07 +00:00
  • b8dcb505ec Fix a couple of grammatical errors in error messages. Tom Lane 2002-10-04 17:34:01 +00:00
  • 54670bd504 Add: Bruce Momjian 2002-10-04 17:26:56 +00:00
  • 3b8ba163d0 Tweak a few of the most heavily used function call points to zero out just the significant fields of FunctionCallInfoData, rather than MemSet'ing the whole struct to zero. Unused positions in the arg[] array will thereby contain garbage rather than zeroes. This buys back some of the performance hit from increasing FUNC_MAX_ARGS. Also tweak tuplesort.c code for more speed by marking some routines 'inline'. All together these changes speed up simple sorts, like count(distinct int4column), by about 25% on a P4 running RH Linux 7.2. Tom Lane 2002-10-04 17:19:55 +00:00
  • 53c5edace8 Add: Bruce Momjian 2002-10-04 02:28:42 +00:00
  • aab47baf6c Hack to make it possible to load CREATE CONSTRAINT TRIGGER commands that are missing the FROM clause (due to a long-ago pg_dump bug). Patch by Stephan Szabo, minor tweaking by Tom Lane. Tom Lane 2002-10-03 21:06:23 +00:00
  • eb978845e4 Add auto-vacuum emails. Bruce Momjian 2002-10-03 19:33:50 +00:00
  • 2609ccc34b Add: Bruce Momjian 2002-10-03 19:32:43 +00:00
  • fb0b0a25dc Add: Bruce Momjian 2002-10-03 19:20:25 +00:00
  • 565c97bea5 In a bootstrap process or standalone backend, set MaxBackends = 1 to avoid unnecessary consumption of semaphores. Tom Lane 2002-10-03 19:19:09 +00:00
  • edf497dec9 Avoid palloc(0) when MaxBackends = 1. Tom Lane 2002-10-03 19:17:55 +00:00
  • 9886a46e76 Restore NOTICEs that were mistakenly removed from triggers regression test expected output. Tweak contrib/spi Makefile so that refint.so is by default built with appropriate NOTICE support for regression testing. Tom Lane 2002-10-03 18:40:02 +00:00
  • 793a4ba35e Add SSL documentation info to README.SSL Bruce Momjian 2002-10-03 17:26:14 +00:00
  • 0a85eea07e It's just a cosmetic change, fixes the help screen. Should be applied in /contrib/vacuumlo Bruce Momjian 2002-10-03 17:20:39 +00:00
  • dc4a49398f This patch fixes a few grammatical errors, removes some duplicate entries, and attributes some JDBC changes to the right people. Bruce Momjian 2002-10-03 17:17:42 +00:00
  • e654065f11 This is small README fix for contrib/intarray. Thank you. Bruce Momjian 2002-10-03 17:16:31 +00:00
  • a62873d279 The attached adds a bit to the contrib/tablefunc regression test for behavior of connectby() in the presence of infinite recursion. Please apply this one in addition to the one sent earlier. Bruce Momjian 2002-10-03 17:15:36 +00:00
  • 620dddf88a > The previous patch fixed an infinite recursion bug in > contrib/tablefunc/tablefunc.c:connectby. But, other unmanageable error > seems to occur even if a table has commonplace tree data(see below). > > I would think the patch, ancestor check, should be > > if (strstr(branch_delim || branchstr->data || branch_delim, > branch_delim || current_key || branch_delim)) > > This is my image, not a real code. However, if branchstr->data includes > branch_delim, my image will not be perfect. Bruce Momjian 2002-10-03 17:11:12 +00:00
  • a0bf2503ea The attached patch fixes a number of issues related to compiling the client utilities (libpq.dll and psql.exe) for win32 (missing defines, adjustments to includes, pedantic casting, non-existent functions) per: http://developer.postgresql.org/docs/postgres/install-win32.html. Bruce Momjian 2002-10-03 17:09:42 +00:00
  • d4eae72513 This patch removes two unused global variables from globals.c Bruce Momjian 2002-10-03 17:07:53 +00:00
  • 50869ef839 Add: Bruce Momjian 2002-10-03 16:39:02 +00:00