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

Commit Graph

  • 2990b8a4a6 Add missing PQclear(). Tatsuo Ishii 2004-06-14 11:00:12 +00:00
  • dd83b34d38 Updated wording: Bruce Momjian 2004-06-13 23:42:59 +00:00
  • 75c8e51b08 Re-add: Bruce Momjian 2004-06-13 23:39:30 +00:00
  • 950d047ec5 Give inet/cidr datatypes their own hash function that ignores the inet vs cidr type bit, the same as network_eq does. This is needed for hash joins and hash aggregation to work correctly on these types. Per bug report from Michael Fuhr, 2004-04-13. Also, improve hash function for int8 as suggested by Greg Stark. Tom Lane 2004-06-13 21:57:28 +00:00
  • 0e338bba42 Remove README.CVS when making a distribution. Peter Eisentraut 2004-06-13 21:51:36 +00:00
  • 2416c758a6 Remove README.CVS when making a distribution. REL7_4_3 Peter Eisentraut 2004-06-13 21:50:04 +00:00
  • c0dff99dbc Translation update Peter Eisentraut 2004-06-13 21:41:33 +00:00
  • b458e15279 Translation update Peter Eisentraut 2004-06-13 21:41:20 +00:00
  • ba0f9ff3ba Code review for recently-added network functions. Get it to work when log_hostname is enabled, clean up documentation. Tom Lane 2004-06-13 19:56:52 +00:00
  • 27ab2e5d41 Correct erroneous table title, per Halley Pacheco de Oliveira. Tom Lane 2004-06-13 17:51:16 +00:00
  • 88961fc45d Correct erroneous table title, per Halley Pacheco de Oliveira. Tom Lane 2004-06-13 17:51:08 +00:00
  • da736b79e7 Suppress compile warnings on machines where the INT64CONST() decoration is actually needed. Backport of Oliver Elphick's recent patch. Tom Lane 2004-06-13 17:17:49 +00:00
  • 2e11ef8be8 Now needs to include <ctype.h>. Tom Lane 2004-06-12 20:31:48 +00:00
  • 83db69bebc Now needs to include <ctype.h>. Tom Lane 2004-06-12 20:31:43 +00:00
  • d7f5817a9b Some editorializing on 7.4.3 release notes. Tom Lane 2004-06-12 19:30:36 +00:00
  • 4832c53e10 Some editorializing on 7.4.3 release notes. Tom Lane 2004-06-12 19:30:29 +00:00
  • aa5fe4ae76 Improve release wording. Bruce Momjian 2004-06-12 04:22:15 +00:00
  • 8d7ed778c4 Markup fix. Bruce Momjian 2004-06-12 04:08:39 +00:00
  • b24e361d11 Markup fix. Bruce Momjian 2004-06-12 04:08:02 +00:00
  • 0649d10a3b Fix markup Bruce Momjian 2004-06-12 04:03:45 +00:00
  • 342e3b06f8 Fix markup Bruce Momjian 2004-06-12 04:02:53 +00:00
  • c796e97abd Update release notes for 7.4.3. Bruce Momjian 2004-06-12 03:56:25 +00:00
  • a1c4b9efe4 Update release notes for 7.4.3. Bruce Momjian 2004-06-12 03:54:51 +00:00
  • ba57e33d7f Stamp 7.4.3. Still need release notes. Bruce Momjian 2004-06-11 18:17:54 +00:00
  • 257a8feb60 ECPG preprocessor for PostgreSQL 7.4.1, 7.4.2 doubles const, volatile, static, and register keywords before variables, declared as VARCHAR. Bruce Momjian 2004-06-11 17:32:55 +00:00
  • eebad1a74f ECPG preprocessor for PostgreSQL 7.4.1, 7.4.2 doubles const, volatile, static, and register keywords before variables, declared as VARCHAR. Bruce Momjian 2004-06-11 17:32:39 +00:00
  • bbf0ebadaf StrategyDirtyBufferList wasn't being careful to honor max_buffers limit. Bug is only latent given that sole caller is passing NBuffers, but it could bite someone in the rear someday. Tom Lane 2004-06-11 17:20:39 +00:00
  • 2597056cc3 Use sizeof() rather than strlen() in array size. Bruce Momjian 2004-06-11 17:09:13 +00:00
  • e6cba71503 Add some code to Assert that when we release pin on a buffer, we are not holding the buffer's cntx_lock or io_in_progress_lock. A recent report from Litao Wu makes me wonder whether it is ever possible for us to drop a buffer and forget to release its cntx_lock. The Assert does not fire in the regression tests, but that proves little ... Tom Lane 2004-06-11 16:43:24 +00:00
  • 8d64b56206 Cleanup use of Win32 START by using "" for title. No need for temp batch files anymore. Bruce Momjian 2004-06-11 16:36:31 +00:00
  • 800910fe97 Add URL about Win32 quoting behavior. Bruce Momjian 2004-06-11 16:10:09 +00:00
  • eae2a7204f Another fix for Win32 START. Bruce Momjian 2004-06-11 04:17:21 +00:00
  • 1261fe18ff The attached tiny patch removes spurious carriage returns that might be copied by the script that generates psql's help. (You can get the spurious CRs if you use a CVS client on Windows that does line end translation.) Elsewhere, the patch should be totally benign. Bruce Momjian 2004-06-11 03:56:46 +00:00
  • 3a8cdf33aa >> It certainly doesn't. There still was a bug with the locale stuff, >> though - the GUC variable was not set in the child >processes. So "show >> lc_collate" would *always* return "C", for example. attached >patch fixes >> this. > >Hm. Why were these vars not propagated by the regular >mechanism for GUC >variables (write_nondefault_variables or whatever it's called)? If the >problem is that it's not accepting PGC_INTERNAL values, then we need to >fix it there not here, because otherwise we'll have to pass all the >PGC_INTERNAL variables through the backend_variables file, which seems >like a recipe for more of the same sort of bug. Bruce Momjian 2004-06-11 03:54:54 +00:00
  • a28d04e6ee This patch updates pgpipe() on win32 to log exactly which part of the call fails when it does. (As it is now, there is no way to figure out the point of error). Shouldn't be a problem since it's most defintily not a performance-critical path (only called on pgstat startup ATM). Bruce Momjian 2004-06-11 03:48:35 +00:00
  • 7643bed58e When using extended-query protocol, postpone planning of unnamed statements until Bind is received, so that actual parameter values are visible to the planner. Make use of the parameter values for estimation purposes (but don't fold them into the actual plan). This buys back most of the potential loss of plan quality that ensues from using out-of-line parameters instead of putting literal values right into the query text. Tom Lane 2004-06-11 01:09:22 +00:00
  • 5fe8c7d6e5 More restructuring to use Win32 START with paths needing quotes. Bruce Momjian 2004-06-11 00:57:25 +00:00
  • b43b461396 Translation updates Peter Eisentraut 2004-06-10 22:43:28 +00:00
  • 6cc4175b25 Attached is a patch that takes care of the PATHSEP issue. I made a more extensive change then what was suggested. I found the file path.c that contained a lot of "Unix/Windows" agnostic functions so I added a function there instead and removed the PATHSEP declaration in exec.c altogether. All to keep things from scattering all over the code. Bruce Momjian 2004-06-10 22:26:24 +00:00
  • d4117de50a More quoting cleanups for Win32's pg_ctl. Bruce Momjian 2004-06-10 22:20:53 +00:00
  • 3485cc3a7c Adjust cost_nonsequential_access() to have more reasonable behavior when random_page_cost has a small value. Per Manfred Koizar, though I didn't use his equation exactly. Tom Lane 2004-06-10 21:02:00 +00:00
  • 387b38bec4 Done: Bruce Momjian 2004-06-10 19:04:49 +00:00
  • 36af1dd299 Make ALTER TABLE ADD SERIAL work reasonably in inheritance cases, too. Tom Lane 2004-06-10 18:34:45 +00:00
  • 6121aed8a5 Fix oversight in recent ALTER TABLE improvements. We now support ALTER TABLE tab ADD COLUMN col SERIAL, but we forgot to install the dependency between the column and the sequence, so the sequence would not go away if you dropped the table later. Tom Lane 2004-06-10 18:25:02 +00:00
  • c9d327b866 Use /B to start so a new window isn't created, per Andrew Dunstan. Bruce Momjian 2004-06-10 18:02:36 +00:00
  • 45616f5bbb Clean up generation of default names for constraints, indexes, and serial sequences, as per recent discussion. All these names are now of the form table_column_type, with digits added if needed to make them unique. Default constraint names are chosen to be unique across their whole schema, not just within the parent object, so as to be more SQL-spec-compatible and make the information schema views more useful. Tom Lane 2004-06-10 17:56:03 +00:00
  • 75db5a665f Add START background code for another code path, per Andrew Dunstan. Bruce Momjian 2004-06-10 17:45:09 +00:00
  • 3a854af433 Use START for pg_ctl background runs on Win32, from Magnus. Bruce Momjian 2004-06-10 17:26:14 +00:00
  • bf61bdc124 Translation updates Peter Eisentraut 2004-06-10 17:23:12 +00:00
  • 90ecc9ffda Translation update Peter Eisentraut 2004-06-10 17:19:47 +00:00
  • 6de9abc359 Translation update Peter Eisentraut 2004-06-10 17:18:14 +00:00
  • 1159c484b2 New translation Peter Eisentraut 2004-06-10 17:10:24 +00:00
  • 10a3d19ad4 Handle multiple double-quoted strings using Win32's system() call. Document limitations. Bruce Momjian 2004-06-10 16:35:18 +00:00
  • 93db6f6ae2 Reword: Bruce Momjian 2004-06-10 11:56:27 +00:00
  • 13c30084f6 Add: Bruce Momjian 2004-06-10 04:33:51 +00:00
  • 741681b7b2 Modify: Bruce Momjian 2004-06-10 04:06:21 +00:00
  • 252849eb10 Add Brazilian version of FAQ. Bruce Momjian 2004-06-10 03:46:45 +00:00
  • c7099997ac Add Brazilian version of FAQ. Bruce Momjian 2004-06-10 03:46:11 +00:00
  • babd02af5a Add: Bruce Momjian 2004-06-10 03:45:30 +00:00
  • 6d1347b36f Add pg_ctl native language files for Russian. Bruce Momjian 2004-06-10 02:59:22 +00:00
  • 659660c116 Add regression tests for CSV COPY format. Bruce Momjian 2004-06-09 23:39:24 +00:00
  • 337f802460 Fix slightly-wrong syntax error messages from bootstrap parser, as per report from Tom Cook. Tom Lane 2004-06-09 19:49:56 +00:00
  • 7e64dbc6b5 Support assignment to subfields of composite columns in UPDATE and INSERT. As a side effect, cause subscripts in INSERT targetlists to do something more or less sensible; previously we evaluated such subscripts and then effectively ignored them. Another side effect is that UPDATE-ing an element or slice of an array value that is NULL now produces a non-null result, namely an array containing just the assigned-to positions. Tom Lane 2004-06-09 19:08:20 +00:00
  • 3a0df651da Use single quotes around pg_dump call from pg_dumpall. Bruce Momjian 2004-06-09 17:37:28 +00:00
  • dc6c8c2d06 Use single quotes for pg_ctl system call. Bruce Momjian 2004-06-09 17:36:07 +00:00
  • 7ac67fd189 Add time.h to pg_dumpall. Bruce Momjian 2004-06-09 17:05:14 +00:00
  • 36b8654cb0 Use mkstemp instead of mktemp in thread test, per Jan. Bruce Momjian 2004-06-09 15:16:17 +00:00
  • a1ccbb9019 Previous code cleanup was for bufpage.c, not bufmgr.c. Bruce Momjian 2004-06-09 13:11:34 +00:00
  • 69616f96ec Add: Bruce Momjian 2004-06-09 03:15:51 +00:00
  • 112403ba71 Add missing check for too-few-inputs when replacing a zero-dimensional array. Tom Lane 2004-06-08 20:28:29 +00:00
  • 32af13f03d Add missing check for too-few-inputs when replacing a zero-dimensional array. Tom Lane 2004-06-08 20:28:21 +00:00
  • 619b560c84 tag this as 7.4.3 and copyright date 2004 PostgreSQL Daemon 2004-06-08 15:36:35 +00:00
  • 327d86ca99 Fix mingw link check by using double-brackets. Bruce Momjian 2004-06-08 14:06:35 +00:00
  • ce04221a1e Stylistic changes in bufmgr.c Bruce Momjian 2004-06-08 14:00:35 +00:00
  • 5e926cbb6b vacuum.c refactoring Bruce Momjian 2004-06-08 13:59:36 +00:00
  • cd8b0fc5f1 Change PGETC to PGSYSCONFDIR and PGLOCALE to PGLOCALEDIR, per Peter. Bruce Momjian 2004-06-08 13:49:23 +00:00
  • b2a17038d7 Have strerror_r return "Unknown error". Bruce Momjian 2004-06-08 01:45:50 +00:00
  • a63d2168e9 Fix strerror_r by checking return type from configure. Bruce Momjian 2004-06-07 22:39:45 +00:00
  • 9136613803 Add start/stop times for pg_dump/pg_dumpall when verbose output is used. Bruce Momjian 2004-06-07 20:35:57 +00:00
  • 144dc30554 Remove asymetrical word processing in query and text Teodor Sigaev 2004-06-07 16:49:25 +00:00
  • db688bc1c3 Remove asymetrical word processing in query and text Teodor Sigaev 2004-06-07 16:48:49 +00:00
  • e25a6e185b Remove asymetrical word processing in query and text Teodor Sigaev 2004-06-07 16:48:18 +00:00
  • 613c684a60 Update date. Bruce Momjian 2004-06-07 15:11:23 +00:00
  • 982d005d62 Some preliminary documentation for composite-type stuff. Tom Lane 2004-06-07 04:04:47 +00:00
  • 7845bfc095 Dept of second thoughts: don't use the new wide-character upper/lower code if we are running in a single-byte encoding. No point in the extra overhead in that case. Tom Lane 2004-06-06 22:17:01 +00:00
  • b8312c5fe7 Add some regression tests for composite-type operations. Tom Lane 2004-06-06 21:20:46 +00:00
  • bb3da43e3b Allow use of table rowtypes directly as column types of other tables. Instead of prohibiting that, put code into ALTER TABLE to reject ALTERs that would affect other tables' columns. Eventually we will probably want to extend ALTER TABLE to actually do something useful here, but in the meantime it seems wrong to forbid the feature completely just because ALTER isn't fully baked. Tom Lane 2004-06-06 20:30:07 +00:00
  • 19e3bdd6c7 Minor catalog cleanups for composite-type stuff. Adjust signatures shown in pg_proc for record_in, record_out, etc to reflect that these routines now make use of the second OID parameter. Remove the ancient SET entry in pg_type, which is now highly unlikely to ever become used again. Adjust type_sanity regression test to match. Tom Lane 2004-06-06 19:07:02 +00:00
  • 62c3e61e50 Add binary I/O support for composite types. Tom Lane 2004-06-06 18:06:25 +00:00
  • f24c5098fd Remove finger from dike: composite types are now allowed as table columns. Still a few things to do, like binary I/O and regression tests and docs, but might as well let people play with the toy. Tom Lane 2004-06-06 04:52:55 +00:00
  • a3704d3dec Preliminary support for composite type I/O; just text for now, no binary yet. Tom Lane 2004-06-06 04:50:28 +00:00
  • c541bb86e9 Infrastructure for I/O of composite types: arrange for the I/O routines of a composite type to get that type's OID as their second parameter, in place of typelem which is useless. The actual changes are mostly centralized in getTypeInputInfo and siblings, but I had to fix a few places that were fetching pg_type.typelem for themselves instead of using the lsyscache.c routines. Also, I renamed all the related variables from 'typelem' to 'typioparam' to discourage people from assuming that they necessarily contain array element types. Tom Lane 2004-06-06 00:41:28 +00:00
  • c3a153afed Tweak palloc/repalloc to allow zero bytes to be requested, as per recent proposal. Eliminate several dozen now-unnecessary hacks to avoid palloc(0). (It's likely there are more that I didn't find.) Tom Lane 2004-06-05 19:48:09 +00:00
  • 1532e3a8aa Adjust PageGetMaxOffsetNumber to ensure sane behavior on uninitialized pages, even when the macro's result is stored into an unsigned variable. Tom Lane 2004-06-05 17:42:50 +00:00
  • 24a1e20f14 Adjust PageGetMaxOffsetNumber to ensure sane behavior on uninitialized pages, even when the macro's result is stored into an unsigned variable. Tom Lane 2004-06-05 17:42:46 +00:00
  • 641c5b565b Slight code cleanup for printf's. Bruce Momjian 2004-06-05 04:27:48 +00:00
  • ae93e5fd6e Make the world very nearly safe for composite-type columns in tables. 1. Solve the problem of not having TOAST references hiding inside composite values by establishing the rule that toasting only goes one level deep: a tuple can contain toasted fields, but a composite-type datum that is to be inserted into a tuple cannot. Enforcing this in heap_formtuple is relatively cheap and it avoids a large increase in the cost of running the tuptoaster during final storage of a row. 2. Fix some interesting problems in expansion of inherited queries that reference whole-row variables. We never really did this correctly before, but it's now relatively painless to solve by expanding the parent's whole-row Var into a RowExpr() selecting the proper columns from the child. If you dike out the preventive check in CheckAttributeType(), composite-type columns now seem to actually work. However, we surely cannot ship them like this --- without I/O for composite types, you can't get pg_dump to dump tables containing them. So a little more work still to do. Tom Lane 2004-06-05 01:55:05 +00:00
  • 8f2ea8b7b5 Resurrect heap_deformtuple(), this time implemented as a singly nested loop over the fields instead of a loop around heap_getattr. This is considerably faster (O(N) instead of O(N^2)) when there are nulls or varlena fields, since those prevent use of attcacheoff. Replace loops over heap_getattr with heap_deformtuple in situations where all or most of the fields have to be fetched, such as printtup and tuptoaster. Profiling done more than a year ago shows that this should be a nice win for situations involving many-column tables. Tom Lane 2004-06-04 20:35:21 +00:00
  • af44cac6ef The attached patch will create a dummy pg_config_paths.h. Additionally, ENABLE_THREAD_SAFETY is supported by the makefile (but not by the sources, which need some rework) Bruce Momjian 2004-06-04 13:30:04 +00:00
  • 768916d753 This is a small fix in FAQ. It just clean up some old comments and change an old -not-working piece of code. Bruce Momjian 2004-06-04 04:09:40 +00:00