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

Commit Graph

  • e490ee80e6 inet_recv() wasn't IPv6-ready. Tom Lane 2003-08-01 23:22:52 +00:00
  • ec1501395e Update, add Greg: Bruce Momjian 2003-08-01 22:18:15 +00:00
  • fb78fd0e12 Add: Bruce Momjian 2003-08-01 21:44:05 +00:00
  • 57c08791d1 Code review for sslmode patch: eliminate memory leak, avoid giving a completely useless error message in 'allow' case, don't retry connection at the sendauth stage (by then the server will either let us in or not, no point in wasting cycles on another try in the other SSL state). Tom Lane 2003-08-01 21:27:27 +00:00
  • 13ac54d1ca Since HPUX now exists for Itanium, we should decouple the assumption that OS=hpux is the same as CPU=hppa. First steps at doing this. With these patches, we still work on hppa with either gcc or HP's cc. We might work on hpux/itanium with gcc, but I can't test it. Definitely will not work on hpux/itanium with non-gcc compiler, for lack of spinlock code. Tom Lane 2003-08-01 19:12:52 +00:00
  • 75619cff56 Get the include ordering right for TCL includes vs whatever is coming from --with-includes. Tom Lane 2003-08-01 19:01:49 +00:00
  • 25b10fc1e6 Missed two places to replace union member. Michael Meskes 2003-08-01 18:19:03 +00:00
  • 6520c666c1 Fix a few of the more blatantly unportable constructs in this file. Tom Lane 2003-08-01 18:10:43 +00:00
  • 3a1ed8761f Fix inconsistent static-vs-not-static declarations. Tom Lane 2003-08-01 18:03:57 +00:00
  • 38a412ec39 Fix compile warning. Tom Lane 2003-08-01 16:46:06 +00:00
  • ec506c12cd Russian translation updates by Serguei Mokhov Peter Eisentraut 2003-08-01 16:19:14 +00:00
  • 7843a44839 Use only two-part shared library version numbers, for better portability and consistency. Peter Eisentraut 2003-08-01 16:18:04 +00:00
  • 95261c44d2 While having a parallel-make-safe genbki.sh is good, it's better not to uselessly invoke it in parallel in the first place. Peter Eisentraut 2003-08-01 16:12:32 +00:00
  • 4f7df90db0 Make ecpg SQLSTATE-aware. Map existing SQLCODE assignments to SQLSTATEs, rather than parsing the message. Add some documentation about embedded SQL. Peter Eisentraut 2003-08-01 13:53:36 +00:00
  • 1ffc5b05a3 Update comments. Bruce Momjian 2003-08-01 13:48:58 +00:00
  • 5fbb42eb3f Update comments. Bruce Momjian 2003-08-01 13:48:25 +00:00
  • 0584370728 Added missing TO keyword. Michael Meskes 2003-08-01 11:25:55 +00:00
  • 7a9c074cba - Added some Informix error codes in Informix mode. - Added just another pgtypeslib function. Michael Meskes 2003-08-01 08:21:04 +00:00
  • 83f62e9d29 cvs log used -b for head, not -rHEAD. Bruce Momjian 2003-08-01 05:52:44 +00:00
  • 4da1e06f64 python needs to be removed from here Marc G. Fournier 2003-08-01 04:28:13 +00:00
  • 4895635da4 clean python out of Makefile Marc G. Fournier 2003-08-01 04:24:57 +00:00
  • 13a0e910cd remove python module, as its moved to http://www.pygresql.org Marc G. Fournier 2003-08-01 04:19:06 +00:00
  • 2c018f9b10 Fix for Alpha portability. Tom Lane 2003-08-01 03:55:05 +00:00
  • 55103553ad --enable-thread-safeness -> --enable-thread-safety Bruce Momjian 2003-08-01 03:10:04 +00:00
  • 6ed071bca5 Update contrib regression tests for recent error message editing. Tom Lane 2003-08-01 02:38:09 +00:00
  • 1e120a8e5d Add missing #include. Tom Lane 2003-08-01 02:25:31 +00:00
  • 3896f48d7e Fix some minor portability issues, per Chris K-L. Tom Lane 2003-08-01 02:21:17 +00:00
  • 30f665d745 Fix my own mistake in GUC variable annotation. Tom Lane 2003-08-01 01:23:11 +00:00
  • eb06e6d182 Improve description of restoring pg_dumpall backups, per gripe from Havard Eidnes. Tom Lane 2003-08-01 01:01:52 +00:00
  • c4cf7fb814 Adjust 'permission denied' messages to be more useful and consistent. Tom Lane 2003-08-01 00:15:26 +00:00
  • a063d4b3ec Very minor editing. Tom Lane 2003-07-31 22:17:11 +00:00
  • 1297126881 Fix mistaken error code assignments, per Peter's note 7/28/03. Tom Lane 2003-07-31 21:34:18 +00:00
  • d7d7d7fa99 When using a temp installation, unset PGUSER and other variables we might have inherited from the environment that would possibly cause psql to fail to connect to the temp installation properly. Per trouble report from Markus Bertheau 7/1/03. Tom Lane 2003-07-31 19:20:41 +00:00
  • 8b1ea2f58b Cause library-preload feature to report error if specified initialization function is not found. Also, make all the PL libraries have initialization functions with standard names. Patch from Joe Conway. Tom Lane 2003-07-31 18:36:46 +00:00
  • 8488f25425 Upgrade parsing code for ACLs to be less hokey and more cognizant of the actual logical structure and quoting rules being used. Fixes bug reported by Chris K-L on 7/8/03. Tom Lane 2003-07-31 17:21:57 +00:00
  • 1c6eba447c Modify: Bruce Momjian 2003-07-31 15:07:17 +00:00
  • 644bf7d02c Modify: Bruce Momjian 2003-07-31 04:49:38 +00:00
  • 36f3a3c486 contraints -> constraints Bruce Momjian 2003-07-31 04:48:15 +00:00
  • 6b8f6a65e2 Update Turkish FAQ, Devrim GUNDUZ Bruce Momjian 2003-07-31 04:41:56 +00:00
  • f766b376f1 Add fflush of stdout when outputing query. Bruce Momjian 2003-07-31 04:23:40 +00:00
  • 82bade79dc dbf2pg - Insert xBase-style .dbf-files into a PostgreSQL-table There is an option "-s oldname=newname", which changes the old field name of the dbf-file to the newname in PostgeSQL. If the length of the new name is 0, the field is skiped. If you want to skip the first field of the dbf-file, you get the wildest error-messages from the backend. dbf2pg load the dbf-file via "COPY tablename FROM STDIN". If you skip the first field, it is an \t to much in STDIN. Bruce Momjian 2003-07-31 02:12:43 +00:00
  • 52347b6637 Add pretty-printing variants of pg_get_viewdef and related functions. Patch from Andreas Pflug. Tom Lane 2003-07-30 22:56:24 +00:00
  • 12911ea2e1 Add:; > * Allow server log information to be output as INSERT statements Bruce Momjian 2003-07-30 20:23:32 +00:00
  • 4b1c6695f1 Fix numeric_smaller, numeric_larger, float4smaller, float4larger, float8smaller, float8larger (and thereby the MIN/MAX aggregates on these datatypes) to agree with the datatypes' comparison operations as regards NaN handling. In all these datatypes, NaN is arbitrarily considered larger than any normal value ... but MIN/MAX had not gotten the word. Per recent discussion on pgsql-sql. Tom Lane 2003-07-30 19:48:41 +00:00
  • 0159f7f272 Modify: > * Allow log lines to include session-level information, like database and user Bruce Momjian 2003-07-30 19:16:18 +00:00
  • 9ca5c754fb Cause ARRAY[] construct to return a NULL array, rather than raising an error, if any input element is NULL. This is not what we ultimately want, but until arrays can have NULL elements, it will have to do. Patch from Joe Conway. Tom Lane 2003-07-30 19:02:18 +00:00
  • 082df47b2e Add: Bruce Momjian 2003-07-30 18:52:06 +00:00
  • 5c7d04d24b When shutting down the regression test postmaster after 'make check', wait for the postmaster to actually exit. Otherwise running repeated 'make check's tends to misbehave, because we try to remove and recreate the data directory while the old PM is still alive. Tom Lane 2003-07-30 17:08:47 +00:00
  • 5925377401 Fix longstanding error in _bt_search(): should moveright at top of loop not bottom. Otherwise we fail to moveright when the root page was split while we were "in flight" to it. This is not a significant problem when the root is above the leaf level, but if the root was also a leaf (ie, a single-page index just got split) we may return the wrong leaf page to the caller, resulting in failure to find a key that is in fact present. Bug has existed at least since 7.1, probably forever. Tom Lane 2003-07-29 22:18:53 +00:00
  • a4ffca6bdf Fix longstanding error in _bt_search(): should moveright at top of loop not bottom. Otherwise we fail to moveright when the root page was split while we were "in flight" to it. This is not a significant problem when the root is above the leaf level, but if the root was also a leaf (ie, a single-page index just got split) we may return the wrong leaf page to the caller, resulting in failure to find a key that is in fact present. Bug has existed at least since 7.1, probably forever. Tom Lane 2003-07-29 22:18:48 +00:00
  • 892a51c367 Fix longstanding error in _bt_search(): should moveright at top of loop not bottom. Otherwise we fail to moveright when the root page was split while we were "in flight" to it. This is not a significant problem when the root is above the leaf level, but if the root was also a leaf (ie, a single-page index just got split) we may return the wrong leaf page to the caller, resulting in failure to find a key that is in fact present. Bug has existed at least since 7.1, probably forever. Tom Lane 2003-07-29 22:18:38 +00:00
  • 5e3c09a114 Coerce unknown-literal-constant default values to the column type during CREATE TABLE (or ALTER TABLE SET DEFAULT), rather than postponing it to the time that the default is inserted into an INSERT command by the rewriter. This reverses an old decision that was intended to make the world safe for writing f1 timestamp default 'now' but in fact merely made the failure modes subtle rather than obvious. Per recent trouble report and followup discussion. Tom Lane 2003-07-29 17:21:27 +00:00
  • f353f8e83b There is no reason to cast valuntil to timestamp, and a very good reason not to: it fails for an 'invalid' abstime. Per bug report of today's date. Tom Lane 2003-07-29 14:17:37 +00:00
  • a5e804df71 Use a process-specific temp file name, per Andreas Haumer. Tom Lane 2003-07-29 14:12:50 +00:00
  • 9c2a7c2269 Apply (a somewhat revised version of) Greg Mullane's patch to eliminate heuristic determination of day vs month in date/time input. Add the ability to specify that input is interpreted as yy-mm-dd order (which formerly worked, but only for yy greater than 31). DateStyle's input component now has the preferred spellings DMY, MDY, or YMD; the older keywords European and US are now aliases for the first two of these. Per recent discussions on pgsql-general. Tom Lane 2003-07-29 00:03:19 +00:00
  • 2baf4efe09 Code review for recent GUC changes --- try to make it less obvious that these things were added at different times by different people ;-). Includes Aizaz Ahmed's patch to remove duplicate array in help_config.c. Tom Lane 2003-07-28 19:31:32 +00:00
  • aad71b40ca Add error stack traceback support for SQL-language functions. Tom Lane 2003-07-28 18:33:18 +00:00
  • 1c241545e3 There was enough code drift since this patch, that a couple of bugs materialized. Bruce Momjian 2003-07-28 16:22:16 +00:00
  • 00941bf9ba Localizability improvement. Tom Lane 2003-07-28 06:27:06 +00:00
  • b7489ac445 elog() is no longer a gettext trigger --- all remaining uses are considered internal errors. Tom Lane 2003-07-28 00:25:21 +00:00
  • 02d79e765b Rename psql's VERBOSE variable to VERBOSITY, per suggestion from Bruce. Tom Lane 2003-07-28 00:14:43 +00:00
  • 81b5c8a136 A visit from the message-style police ... Tom Lane 2003-07-28 00:09:16 +00:00
  • b556e8200e elog mop-up: bring some straggling fprintf(stderr)'s into the elog world. Tom Lane 2003-07-27 21:49:55 +00:00
  • 606debf268 Updatge to skip composite types. Bruce Momjian 2003-07-27 20:12:06 +00:00
  • 440953e6cd Tom, happier with the attached patch? Bruce Momjian 2003-07-27 19:39:13 +00:00
  • 51e46d14f8 Adjust oid2name to skip certain row types, per Tom. Bruce Momjian 2003-07-27 19:30:24 +00:00
  • e7f3645171 Fix some localizability issues with existing errcontext() calls. Tom Lane 2003-07-27 18:38:26 +00:00
  • 2d7a6a9ef2 Move ERRCODE_XXX macros into their own header file. Tom Lane 2003-07-27 18:37:52 +00:00
  • aec57ea868 elog mop-up. Tom Lane 2003-07-27 18:07:19 +00:00
  • e8db9b26d0 elog mop-up. Tom Lane 2003-07-27 17:10:07 +00:00
  • aeea73d4ec Remove unportable // comments. Tom Lane 2003-07-27 16:32:34 +00:00
  • b29c557e0f Cleanup of timetravel compile warnings. Bruce Momjian 2003-07-27 04:59:29 +00:00
  • b6a1d25b0a Error message editing in utils/adt. Again thanks to Joe Conway for doing the bulk of the heavy lifting ... Tom Lane 2003-07-27 04:53:12 +00:00
  • 524cfad23f Here is 4 file in tgz: the new timetravel.c, new timetravel.README (cut from spi/README and modified), modified timetravel.sql.in and modified timetravel.example. Bruce Momjian 2003-07-27 04:51:45 +00:00
  • 38fb906f93 > Joe Conway <mail@joeconway.com> writes: >>ISTM that "source" is worth knowing. > > Hm, possibly. Any other opinions? Bruce Momjian 2003-07-27 04:35:54 +00:00
  • a265b7f70a > Am Son, 2003-06-22 um 02.09 schrieb Joe Conway: >>Sounds like all that's needed for your case. But to be complete, in >>addition to changing tablefunc.c we'd have to: >>1) come up with a new function call signature that makes sense and does >>not cause backward compatibility problems for other people >>2) make needed changes to tablefunc.sql.in >>3) adjust the README.tablefunc appropriately >>4) adjust the regression test for new functionality >>5) be sure we don't break any of the old cases >> >>If you want to submit a complete patch, it would be gratefully accepted >>-- for review at least ;-) > > Here's the patch, at least for steps 1-3 Bruce Momjian 2003-07-27 03:51:59 +00:00
  • 9ae6905520 This is a totally trivial patch for something that was a very minor nit that annoyed me the other day while I was documenting my current project. It makes pg_dump use the same layout for types as for tables, by putting "\n\t" before the first field and "\n" before the final ");" Bruce Momjian 2003-07-27 03:47:22 +00:00
  • 9df48371c2 here are the patches for psql on Win32: Bruce Momjian 2003-07-27 03:32:26 +00:00
  • e7fe89d57d This makes the initcap function compatible with Oracle 9i, it has been tested on both redhat 8 and FreebSD. -- Mike Nolan Bruce Momjian 2003-07-27 03:16:20 +00:00
  • 1e5a16cc9c The deferred trigger queue pushing to disk patch pointed out that the regression tests for foreign keys didn't seem to test a deferred constraint that was not satisified by a later statement and was not made immediate by set constraints, so here's a simple added test with a single invalid insert and a commit. Bruce Momjian 2003-07-27 03:13:17 +00:00
  • 1be17f1f26 >>You can alias $0, similar to the argument variables. And, I confirmed >>that you cannot change the value, similar to the argument variables: > > Perhaps you shouldn't mark it isconst; then it would actually have some > usefulness (you could use it directly as a temporary variable to hold > the intended result). I can't see much value in aliasing it if it's > const, either. Bruce Momjian 2003-07-26 23:58:23 +00:00
  • 9df03060e9 Fix for Linux startup script. Bruce Momjian 2003-07-26 20:42:55 +00:00
  • abc7f73273 Have SSL text print only when SSL mode is enabled. Bruce Momjian 2003-07-26 15:22:22 +00:00
  • 74ca686796 I corecting date_trunc('quarter',...) and friends because orig version doing '2003-07-30' -> '2003-04-01', '2003-11-30' ->'2003-07-01' Bruce Momjian 2003-07-26 15:17:36 +00:00
  • 397831e103 At long last I put together a patch to support 4 client SSL negotiation modes (and replace the requiressl boolean). The four options were first spelled out by Magnus Hagander <mha@sollentuna.net> on 2000-08-23 in email to pgsql-hackers, archived here: Bruce Momjian 2003-07-26 13:50:02 +00:00
  • 5f2499d5af Update to match error editing. Tom Lane 2003-07-26 00:02:02 +00:00
  • 3b04893ffc Error message editing in src/pl. The plpython module could use another look ... I'm not real certain which errors are strictly internal and which are likely to be provoked by users. Tom Lane 2003-07-25 23:37:31 +00:00
  • 400fedc8f1 Done: Bruce Momjian 2003-07-25 22:08:36 +00:00
  • 02c3231937 Add mention of new SSL capabilities. Bruce Momjian 2003-07-25 22:07:44 +00:00
  • ad73f6b86f Update copyrights to 2003. Bruce Momjian 2003-07-25 21:48:45 +00:00
  • 57748fc25d > Having read the list, and noticed the message about table inheritance I > thought that I would see if I could come up with a simple solution, and > have my first delve into the code for PostgreSQL. > > Attached is a diff against 7.3.3 source, of changes to describe.c for > psql. This should print out a list of parent tables in a similar style > to that of the index listing. I have done some testing on my side and it > all seems fine, can some other people have a quick look? What do people > think? Useful? Bruce Momjian 2003-07-25 21:42:26 +00:00
  • b92d055b56 Recent patch to dump nondefault attstorage settings broke pg_dump for dropped columns. Fix by using LEFT JOIN rather than straight join between pg_attribute and pg_type. Also, use pg_type.oid as input to format_type, so that we don't get a failure on deleted types of deleted columns (this may be a change we ought to backpatch to 7.3....). Tom Lane 2003-07-25 21:02:52 +00:00
  • 689eb53e47 Error message editing in backend/utils (except /adt). Tom Lane 2003-07-25 20:18:01 +00:00
  • 9fecf302f7 Seems my check constraint change did break stuff. Bruce Momjian 2003-07-25 19:37:21 +00:00
  • 187e865174 > Rod Taylor <rbt@rbt.ca> writes: > > It seems that readline() on my system (FreeBSD 4.8) isn't declared to > > take the prompt as a const. Thus, remove const from gets_interactive() > > to remove the warning. > > I think it would be a lot cleaner to just put a cast to char * into the > readline call (with a note about why). Bruce Momjian 2003-07-25 19:27:06 +00:00
  • 6a0d6d0060 Added explicit casts for date/interval/timestamp. Michael Meskes 2003-07-25 16:10:26 +00:00
  • f1a27b120d Begin improving markup of (past) release notes. Peter Eisentraut 2003-07-25 09:00:17 +00:00
  • 4c4a667f4d Applied Peter's patch to use yyless instead of my string_unput function. Michael Meskes 2003-07-25 05:42:27 +00:00
  • b2312c4eae No need for Static.Entries, use -rHEAD. Bruce Momjian 2003-07-25 02:11:17 +00:00
  • 8355901a0e Add example of cvs log pulls _just_ from HEAD. Bruce Momjian 2003-07-25 01:40:02 +00:00