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

Commit Graph

  • 674818dce8 This patch corrects a minor mis-statement in the CREATE DOMAIN docs, pointed out by Chris KL on -hackers a little while ago -- NOT NULL != CHECK xxx IS NOT NULL. Bruce Momjian 2002-09-20 03:39:15 +00:00
  • da395b56cd Tweak heap.c to refuse attempts to create table columns of standalone composite types. Add a couple more lsyscache.c routines to support this, and make use of them in some other places that were doing lookups the hard way. Tom Lane 2002-09-19 23:40:56 +00:00
  • 4a0c3a6142 Department of second thoughts: suppressing implicit casts everywhere in ruleutils display is not such a great idea. For arguments of functions and operators I think we'd better keep the historical behavior of showing such casts explicitly, to ensure that the function/operator is reparsed the same way when the rule is reloaded. This also makes the output of EXPLAIN less obscurantist about exactly what's happening. Tom Lane 2002-09-19 22:48:34 +00:00
  • b26dfb9522 Extend pg_cast castimplicit column to a three-way value; this allows us to be flexible about assignment casts without introducing ambiguity in operator/function resolution. Introduce a well-defined promotion hierarchy for numeric datatypes (int2->int4->int8->numeric->float4->float8). Change make_const to initially label numeric literals as int4, int8, or numeric (never float8 anymore). Explicitly mark Func and RelabelType nodes to indicate whether they came from a function call, explicit cast, or implicit cast; use this to do reverse-listing more accurately and without so many heuristics. Explicit casts to char, varchar, bit, varbit will truncate or pad without raising an error (the pre-7.2 behavior), while assigning to a column without any explicit cast will still raise an error for wrong-length data like 7.3. This more nearly follows the SQL spec than 7.2 behavior (we should be reporting a 'completion condition' in the explicit-cast cases, but we have no mechanism for that, so just do silent truncation). Fix some problems with enforcement of typmod for array elements; it didn't work at all in 'UPDATE ... SET array[n] = foo', for example. Provide a generalized array_length_coerce() function to replace the specialized per-array-type functions that used to be needed (and were missing for NUMERIC as well as all the datetime types). Add missing conversions int8<->float4, text<->numeric, oid<->int8. initdb forced. Tom Lane 2002-09-18 21:35:25 +00:00
  • cc70ba2e4d Add mention of /contrib/adddepend to HISTORY. Bruce Momjian 2002-09-18 20:43:03 +00:00
  • 9152bebfe4 Add 'adddepend' script to handle pre-7.3 object dependencies. Bruce Momjian 2002-09-18 20:38:59 +00:00
  • da123b7c58 Update installation instructions and put mostly everything in one place. Also, some editing in PL/Perl and PL/Python chapters. Peter Eisentraut 2002-09-18 20:09:32 +00:00
  • 0db8c41523 Remove pgeasy and odbc. Peter Eisentraut 2002-09-18 20:07:15 +00:00
  • b844465185 Rename help file upgrade_7.3 to upgrade_tips_7.3. Bruce Momjian 2002-09-18 15:24:08 +00:00
  • 6bea242750 Add GRANT EXECUTE ON FUNCTION Tatsuo Ishii 2002-09-18 06:38:29 +00:00
  • 80c185eaac Add mention of Tom's client change summary email to the history file. Bruce Momjian 2002-09-18 05:17:04 +00:00
  • f1eac87eda Add: Bruce Momjian 2002-09-18 04:22:51 +00:00
  • 4b23f05c4f Fix bug in encoding conversion map. Tatsuo Ishii 2002-09-18 02:10:10 +00:00
  • 4c0bdd1ba8 Update Japanese README so that it reflects the changes made to the conversion function interface. Tatsuo Ishii 2002-09-18 01:21:28 +00:00
  • 1c4478a5ba Add: Bruce Momjian 2002-09-17 22:23:02 +00:00
  • 445732a5ff Point out that CREATE INDEX uses sorts and hence sort_mem GUC parameter. Bruce Momjian 2002-09-17 21:41:47 +00:00
  • aef9dbdb37 Fix pgaccess URL, from Justin. Bruce Momjian 2002-09-17 21:15:04 +00:00
  • ff9973a8f1 Remove src/test/regress/sql: plpgsql-nsp-testing.sql per Joe Conway. Bruce Momjian 2002-09-17 04:27:41 +00:00
  • c53bb2759f Un-break duplicate_oids script. Tom Lane 2002-09-17 01:28:36 +00:00
  • a2ba9a76b8 Remove retest Makefile entry because it does not compile. Bruce Momjian 2002-09-16 16:02:43 +00:00
  • 8f6b96de9a Add mention of removed -enable-multibyte/locale in HISTORY. Bruce Momjian 2002-09-16 15:08:53 +00:00
  • a4bb484c66 Add to link() thread. Bruce Momjian 2002-09-16 02:50:20 +00:00
  • 0e484f19c9 Add link() info to TODO.detail. Bruce Momjian 2002-09-16 02:47:05 +00:00
  • 53e95eee84 Fix for rare race-condition-like failure: if a backend receives SIGUSR2 (notify/SI-overrun interrupt) while it is in process of doing proc_exit, it is possible for Async_NotifyHandler() to try to start a transaction when one is already running. This leads to Asserts() or worse. I think it may only be possible to occur when frontend synchronization is lost (ie, the elog(FATAL) in SocketBackend() fires), but that is a standard occurrence after error during COPY. In any case, I have seen this failure occur during regression tests, so it is definitely possible. Tom Lane 2002-09-16 01:24:41 +00:00
  • 5ea9322872 Cast functions can be immutable or stable. Peter Eisentraut 2002-09-15 13:04:16 +00:00
  • db4f3c0334 Update obsolete comment. Tom Lane 2002-09-14 22:14:49 +00:00
  • cd7a3b6c0d Simplify handling of second database for dblink tests. Tom Lane 2002-09-14 22:00:59 +00:00
  • b66ba36be9 Clean up mess from duplicate patches. Tom Lane 2002-09-14 21:32:38 +00:00
  • d724c314da The attached adds GRANTs to PUBLIC for dblink functions, removes the non-standard regression test, and adds standard installcheck regression test support. Tom Lane 2002-09-14 20:28:54 +00:00
  • 1b69b122bb Some PL/PgSQL documentation improvements from Neil Conway. Tom Lane 2002-09-14 20:11:16 +00:00
  • c91b8bc537 Cosmetic fixes from Neil Conway. Tom Lane 2002-09-14 19:59:20 +00:00
  • c0edc53a36 The attached adds GRANTs to PUBLIC for contrib/fuzzystringmatch. Tom Lane 2002-09-14 19:56:01 +00:00
  • bd04184b11 Attached is a patch to fix some recently raised issues that exist in contrib/tablefunc. Specifically it replaces the use of VIEWs (for needed composite type creation) with use of CREATE TYPE. It also performs GRANT EXECUTE ON FUNCTION foo() TO PUBLIC for all of the created functions. There was also a cosmetic change to two regression files. Tom Lane 2002-09-14 19:53:59 +00:00
  • f7978c6f1d Avoid overflow for large elapsed times in \timing output. Per Kenji Sugita. Tom Lane 2002-09-14 19:46:01 +00:00
  • d3ebc1ae4a Fix portability bug in get_normal_pair (RAND_MAX != MAX_RANDOM_VALUE). Also try to improve readability and performance. Tom Lane 2002-09-14 19:32:54 +00:00
  • 49c86099f3 Shrink the pg_hba.conf and pg_ident.conf default files and move most of the inline documentation to the main docs. Peter Eisentraut 2002-09-14 18:35:46 +00:00
  • d73f8137d2 Translation updates Peter Eisentraut 2002-09-14 13:46:24 +00:00
  • 7d6a055a7f Added regression test for using server side prepared statements in jdbc and fixed a bug found by the regression test Barry Lind 2002-09-14 03:52:56 +00:00
  • 3357577247 Change Assert(len > 0) to Assert(len >= 0) Change PG_RETURN_INT32(0) to PG_RETURN_VOID() Tatsuo Ishii 2002-09-13 06:41:18 +00:00
  • 6d77f6e5fb Add more information about schemas. Combines some previously existing material into the new location. Peter Eisentraut 2002-09-12 22:05:36 +00:00
  • feb202193d Fix likely cause of rare ALTER TABLE ADD FOREIGN KEY failures --- don't assume relname field of a relcache entry will stay valid across lots of operations. Tom Lane 2002-09-12 21:16:42 +00:00
  • 2b0319869a Avoid misleading error message when SET/RESET target variable name doesn't match any known variable. Tom Lane 2002-09-12 14:03:45 +00:00
  • 7184a428a2 The small context diff below corrects what seems to be an oversight in fmgr.h - it's discouraged to access fcinfo directly but there is no macro to get the number of arguments passed to the function. Checking the number of arguments is often useful when you have a function which can be called like: Bruce Momjian 2002-09-12 00:26:42 +00:00
  • e57ab04565 This is a comprehensive set of diffs (versus current CVS) that replaces those attached to the same message with the Earth Distance patches. Recent changes include changing the subscript in one place I forgot in the previous bugfix patch. A couple of added regression tests, which should help catch this mistake if it reappears. I also put in a limit of 100 dimensions in cube_large and cube_in to prevent making it easy to create very large cubes. Changing one define in cubedata.h will raise the limit if some needs more dimensions. Bruce Momjian 2002-09-12 00:26:00 +00:00
  • eb5bf51372 > intarray and ltree both seem to be mapping their own declarations onto > arrays using largely-similar code. But while intarray fails its > regression test, I find ltree still passes. So I'm confused about what > that code is really doing and don't want to touch it. Bruce Momjian 2002-09-12 00:24:46 +00:00
  • b3f52320f6 > Sean Chittenden <sean@chittenden.org> writes: > >>::sigh:: Is it me or does it look like all >>of pl/pgsql is schema un-aware (ie, all of the declarations). -sc > > > Yeah. The group of routines parse_word, parse_dblword, etc that are > called by the lexer certainly all need work. There are some > definitional issues to think about, too --- plpgsql presently relies on > the number of names to give it some idea of what to look for, and those > rules are probably all toast now. Please come up with a sketch of what > you think the behavior should be before you start hacking code. Bruce Momjian 2002-09-12 00:24:10 +00:00
  • 81186865fe Joe Conway wrote: > Hannu Krosing wrote: > >> It seems that my last mail on this did not get through to the list >> ;( >> >> Please consider renaming the new builtin function >> split(text,text,int) >> >> to something else, perhaps >> >> split_part(text,text,int) >> >> (like date_part) >> >> The reason for this request is that 3 most popular scripting >> languages (perl, python, php) all have also a function with similar >> signature, but returning an array instead of single element and the >> (optional) third argument is limit (maximum number of splits to >> perform) >> >> I think that it would be good to have similar function in (some >> future release of) postgres, but if we now let in a function with >> same name and arguments but returning a single string instead an >> array of them, then we will need to invent a new and not so easy to >> recognise name for the "real" split function. >> > > This is a good point, and I'm not opposed to changing the name, but > it is too bad your original email didn't get through before beta1 was > rolled. The change would now require an initdb, which I know we were > trying to avoid once beta started (although we could change it > without *requiring* an initdb I suppose). > > I guess if we do end up needing an initdb for other reasons, we > should make this change too. Any other opinions? Is split_part an > acceptable name? > > Also, if we add a todo to produce a "real" split function that > returns an array, similar to those languages, I'll take it for 7.4. Bruce Momjian 2002-09-12 00:21:25 +00:00
  • e04069fbae No change. Bruce Momjian 2002-09-12 00:20:04 +00:00
  • f490dbe594 > Now I'm testing connectby() in the /contrib/tablefunc in 7.3b1, which would > be a useful function for many users. However, I found the fact that > if connectby_tree has the following data, connectby() tries to search the end > of roots without knowing that the relations are infinite(-5-9-10-11-9-10-11-) . > I hope connectby() supports a check routine to find infinite relations. > > > CREATE TABLE connectby_tree(keyid int, parent_keyid int); > INSERT INTO connectby_tree VALUES(1,NULL); > INSERT INTO connectby_tree VALUES(2,1); > INSERT INTO connectby_tree VALUES(3,1); > INSERT INTO connectby_tree VALUES(4,2); > INSERT INTO connectby_tree VALUES(5,2); > INSERT INTO connectby_tree VALUES(6,4); > INSERT INTO connectby_tree VALUES(7,3); > INSERT INTO connectby_tree VALUES(8,6); > INSERT INTO connectby_tree VALUES(9,5); > > INSERT INTO connectby_tree VALUES(10,9); > INSERT INTO connectby_tree VALUES(11,10); > INSERT INTO connectby_tree VALUES(9,11); <-- infinite > Bruce Momjian 2002-09-12 00:19:44 +00:00
  • b2711a0aee > BTW, clusterdb is not schema-aware and will surely fail in any database > where more than one schema is in use, because it doesn't trouble to > schema-qualify table names. Bruce Momjian 2002-09-12 00:18:14 +00:00
  • 5dd74c0f21 The attached small patch fixes the cause of the regression test failure for contrib/intarray. Bruce Momjian 2002-09-12 00:15:33 +00:00
  • 6fff9a7475 The attached removes the current non-standard file "contrib/tablefunc/tablefunc-test.sql", and adds a standard regression test suite to contrib/tablefunc. Bruce Momjian 2002-09-12 00:14:40 +00:00
  • 6309033b16 Add sprompt.obj to Win32 makefiles. Bruce Momjian 2002-09-11 17:36:13 +00:00
  • 68ba17d406 Add comment about sharing of sprompt.c file. Bruce Momjian 2002-09-11 17:32:37 +00:00
  • 6fdc44be71 Tweak querytree-dependency-extraction code so that columns of tables that are explicitly JOINed are not considered dependencies unless they are actually used in the query: mere presence in the joinaliasvars list of a JOIN RTE doesn't count as being used. The patch touches a number of files because I needed to generalize the API of query_tree_walker to support an additional flag bit, but the changes are otherwise quite small. Tom Lane 2002-09-11 14:48:55 +00:00
  • d28ec4f083 Synced yet again. Michael Meskes 2002-09-11 08:50:29 +00:00
  • d634a5903f Patches submitted by Kris Jurka (jurka@ejurka.com) for the following bugs: - Properly drop tables in jdbc regression tests with cascade for 7.3 - problem with Statement.execute() and executeUpdate() not clearing binds - problem with ResultSet not correctly handling default encoding - changes to correctly support show transaction isolation level in 7.3 - changed DatabaseMetaDataTest to handle differences in FK names in 7.3 - better fix for dynamically checking server NAME data length (With the fixes above the jdbc regression tests pass on jdbc2 and jdbc3 against both a 7.2 and 7.3 server) Patchs submitted by David Wall (d.wall@computer.org): - problem with getBlob when largeobject oid is null - improvements to BlobOutputStream Patch submitted by Haris Peco (snpe@snpe.co.yu): - problem with callable statement not supporting prepared statement methods Barry Lind 2002-09-11 05:38:45 +00:00
  • 8aa966e4b8 Add mention of config.log for configure failure debugging. Bruce Momjian 2002-09-11 04:27:48 +00:00
  • 6a5733a1ea Fix atan() description. Bruce Momjian 2002-09-11 02:56:46 +00:00
  • 87e76d0d4a Fix portability problem (size_t != int). Tom Lane 2002-09-10 18:25:13 +00:00
  • 94d8a798fa Powerup defaults for LC_foo GUC variables should match what main.c does. Tom Lane 2002-09-10 16:09:02 +00:00
  • 6555177f24 Use different sed separator for configure arguments. Peter Eisentraut 2002-09-09 18:35:04 +00:00
  • fe80b5ed8a Remove more references to pgaccess as a build target in docs. Bruce Momjian 2002-09-08 02:33:08 +00:00
  • 62da2fa0e1 Fixed DatabaseMetaData to correctly handle NAME size of 64 Fixed Statement to correctly DEALLOCATE any prepared statements Barry Lind 2002-09-08 00:15:29 +00:00
  • 24507acc0b Changes to documentation and the regression tests for the default NAMEDATALEN of 64. Bruce Momjian 2002-09-07 18:39:05 +00:00
  • 86e8a43f9b Done as far as possible: Bruce Momjian 2002-09-07 18:37:15 +00:00
  • fba5c7b944 Remove pgaccess from docs; not shipping it anymore. Bruce Momjian 2002-09-07 16:49:50 +00:00
  • 40853dd445 Allow pg_dumpall to work with previous releases again. Don't pass the -c option down to pg_dump, where it's useless, and clarify the meaning of -c in the documentation. Peter Eisentraut 2002-09-07 16:14:33 +00:00
  • 123baf8310 Fix help output. Peter Eisentraut 2002-09-07 16:12:27 +00:00
  • 38e444aae6 Make sure the pg_dump tar archiver can handle members larger than 2 GB, but does not create members larger than allowed by the tar format. Also, fix the generation of the tar header to conform to POSIX. Peter Eisentraut 2002-09-06 21:58:36 +00:00
  • 172f9a49e0 Adjust the tarball splitting scheme to the new reality. Peter Eisentraut 2002-09-06 21:57:11 +00:00
  • f37c1c486a Run pgjindent for Java folks. Bruce Momjian 2002-09-06 21:23:06 +00:00
  • b4295d052e Fix another typo. Bruce Momjian 2002-09-06 20:26:00 +00:00
  • 022eb280af Fix typo. Bruce Momjian 2002-09-06 20:08:06 +00:00
  • c813d03ff9 Update for new IP. Bruce Momjian 2002-09-06 18:46:23 +00:00
  • f3b211841e Add JAVA_HOME test for Ant. Bruce Momjian 2002-09-06 14:31:16 +00:00
  • 847f8b39d7 Fix printf() quote handling and improper exit(), per Tom. Bruce Momjian 2002-09-06 02:33:47 +00:00
  • 9a9825f96a Remove heap_mark4update from AlterTableCreateToastTable. This has never been the correct procedure for locking a relation, and the recently-found ALTER TABLE bug with adding a constraint and a toast table in the same command shows why it's a bad idea. Tom Lane 2002-09-06 00:01:53 +00:00
  • 6fe27ca2fb Fix some operator-precedence problems. New constructs IS DISTINCT FRM and IS [NOT] OF were not being parsed consistently with other IS forms. Also, make the world a little safer for functions named LEFT, RIGHT, etc. Tom Lane 2002-09-05 22:52:48 +00:00
  • e06f4c65b4 Fix compile error. Bruce Momjian 2002-09-05 22:24:23 +00:00
  • cd06c70d9a Missed mention of PGPASSWORDFILE. Bruce Momjian 2002-09-05 22:09:42 +00:00
  • 6e9b41b3f2 Update HISTORY for PGPASSWORDFILE change. Bruce Momjian 2002-09-05 22:08:55 +00:00
  • 5fc10c3d17 Remove PGPASSWORDFILE and default to always trying $HOME/.pgpass. Bruce Momjian 2002-09-05 22:05:50 +00:00
  • f4aecac468 Update: Bruce Momjian 2002-09-05 22:03:02 +00:00
  • 04604fd1a4 Fill in section on table modification. Peter Eisentraut 2002-09-05 21:32:23 +00:00
  • 497baca6b5 Fix compile warning. Tom Lane 2002-09-05 21:19:13 +00:00
  • 8d7904f526 Fix bit-rotted reference to GetUserName() ... it's GetUserNameFromId() now. Tom Lane 2002-09-05 21:13:03 +00:00
  • bed4f65499 Fix breakage introduced by careless snprintf patching. Tom Lane 2002-09-05 21:09:54 +00:00
  • fb473bc6fa Fix unsafe macro definitions (which were producing incorrect code, leading to compile warnings). Tom Lane 2002-09-05 21:08:26 +00:00
  • da2e0ddeb4 Remove compile warnings, ensure consistent build environment for largefile usage. Tom Lane 2002-09-05 21:01:16 +00:00
  • f2a242f988 Fix compile warning. Tom Lane 2002-09-05 20:57:00 +00:00
  • fcbe62ee51 findoidjoins and tsearch are not broken anymore. Tom Lane 2002-09-05 20:53:45 +00:00
  • 5d1c8a3b07 Fix compile errors. Tom Lane 2002-09-05 20:51:39 +00:00
  • b73d8d22f7 Improve opr_sanity regression test to check oprltcmpop and opgtcmpop mergejoin links. Tom Lane 2002-09-05 20:23:19 +00:00
  • f4003816f5 Update oidjoins regression test for 7.3 catalogs. Tom Lane 2002-09-05 19:58:14 +00:00
  • d7e654ff79 findoidjoins is updated for schemas, does not use libpgeasy. From Joe Conway. Tom Lane 2002-09-05 19:57:32 +00:00
  • 5b69f695ac Seems like a good idea for template1 to contain ANALYZE stats for the system tables. Tom Lane 2002-09-05 19:56:57 +00:00
  • 012288d565 Commenting out doesn't work, so move the broken modules out of the list. Peter Eisentraut 2002-09-05 18:40:33 +00:00
  • b9d5620a14 autoconf Peter Eisentraut 2002-09-05 18:39:11 +00:00
  • 337da0678a Assorted fixes for Cygwin: Peter Eisentraut 2002-09-05 18:28:46 +00:00