Commit Graph

  • a03f9adb98 Remove mention of wal_files in a SHOW example. Bruce Momjian 2002-09-01 01:59:48 +00:00
  • d64e6392fb Remove code that suggested increasing wal_files. Bruce Momjian 2002-09-01 01:58:42 +00:00
  • ee8fcc57f6 Done: Bruce Momjian 2002-09-01 01:32:21 +00:00
  • 3c49c4b152 Mark the float8 -> int8 cast as implicit. This resolves the problem pointed out by Barry Lind: UPDATE bigintcol = 10000000000 fails because the constant is initially taken as float8. We really need a better way, but it's not gonna happen for 7.3. Tom Lane 2002-09-01 00:58:07 +00:00
  • 845a6c3acc Code review for domain-constraints patch. Use a new ConstraintTest node type for runtime constraint checks, instead of misusing the parse-time Constraint node for the purpose. Fix some damage introduced into type coercion logic; in particular ensure that a coerced expression tree will read out the correct result type when inspected (patch had broken some RelabelType cases). Enforce domain NOT NULL constraints against columns that are omitted from an INSERT. Tom Lane 2002-08-31 22:10:48 +00:00
  • 1440acd703 Wups, didn't mean to commit that just yet. Tom Lane 2002-08-31 19:10:08 +00:00
  • 0da6cf54ec The UNDEFOID later causes an assertion failure in heap_formtuple when you try to use the tupdesc to build a tuple. Tom Lane 2002-08-31 19:09:27 +00:00
  • 1bab464eb4 Code review for pg_locks feature. Make shmemoffset of PROCLOCK structs available (else there's no way to interpret the list links). Change pg_locks view to show transaction ID locks separately from ordinary relation locks. Avoid showing N duplicate rows when the same lock is held multiple times (seems unlikely that users care about exact hold count). Improve documentation. Tom Lane 2002-08-31 17:14:28 +00:00
  • 642fd38e42 *** empty log message *** Bruce Momjian 2002-08-31 01:36:33 +00:00
  • 7bacf2befa Add expected tuple descriptor to ReturnSetInfo information for table functions, per suggestion from John Gray and Joe Conway. Also, fix plpgsql RETURN NEXT to verify that returned values match the expected tupdesc. Tom Lane 2002-08-30 23:59:46 +00:00
  • 9c279355fb Updates to reflect availability of autocommit option. Tom Lane 2002-08-30 22:45:25 +00:00
  • 26993b2918 AUTOCOMMIT mode is now an available backend GUC variable; setting it to false provides more SQL-spec-compliant behavior than we had before. I am not sure that setting it false is actually a good idea yet; there is a lot of client-side code that will probably be broken by turning autocommit off. But it's a start. Tom Lane 2002-08-30 22:18:07 +00:00
  • 549928d99b Fix for breakage of C-coded SRFs, from Joe Conway. Tom Lane 2002-08-30 19:56:49 +00:00
  • e2d156fa6e Add attisinherited column to pg_attribute; use it to guard against column additions, deletions, and renames that would let a child table get out of sync with its parent. Patch by Alvaro Herrera, with some kibitzing by Tom Lane. Tom Lane 2002-08-30 19:23:20 +00:00
  • 96fd7192e7 Back out unintented tab change. Bruce Momjian 2002-08-30 18:15:23 +00:00
  • 72b60ac997 Remove pgaccess from Makefile. Bruce Momjian 2002-08-30 18:14:21 +00:00
  • ce26e71945 Run autoconf. Bruce Momjian 2002-08-30 17:16:42 +00:00
  • 47c51db5f3 Update documentation for --with-perl. Bruce Momjian 2002-08-30 17:14:30 +00:00
  • 2c65658c04 Improve wording after wal_files removal. Bruce Momjian 2002-08-30 16:53:34 +00:00
  • 63653f7ffa Complete TODO item: Bruce Momjian 2002-08-30 16:50:50 +00:00
  • fefb57ce74 Remove pgaccess from CVS. It has its own home now. Bruce Momjian 2002-08-30 16:48:44 +00:00
  • 4890ec9eac Re-enable perl configure tests for psql help file generation. Bruce Momjian 2002-08-30 16:23:21 +00:00
  • f7e089b3fa Back out password packet length check. Bruce Momjian 2002-08-30 16:00:41 +00:00
  • 9a0b4d7f84 perl5 interface moved to gborg Marc G. Fournier 2002-08-30 13:06:22 +00:00
  • c411f51dfb libpgeasy moved to gborg ... Marc G. Fournier 2002-08-30 13:03:11 +00:00
  • df40e28850 Fix off-by-one allocation error in PasswordFromFile(), per Gordon Runkle. Tom Lane 2002-08-30 05:28:50 +00:00
  • cafebdd4d8 Add comment on old sytax for SELECT FOR UPDATE/LIMIT and COPY. Bruce Momjian 2002-08-30 03:18:23 +00:00
  • a4dbbb52c9 Revert _LARGEFILE64_SOURCE addition; good try but doesn't work, at least not on HPUX 10.20, and there's no reason to think it is needed on later versions. Tom Lane 2002-08-30 02:01:34 +00:00
  • d803de50d4 intagg subdirectory was missing. Tom Lane 2002-08-30 01:44:00 +00:00
  • fac3dd56b3 Group-manipulating code neglected to fill in array element type, which is now required. Tom Lane 2002-08-30 01:01:02 +00:00
  • e107f3a7e3 PL/pgSQL functions can return sets. Neil Conway's patch, modified so that the functionality is available to anyone via ReturnSetInfo, rather than hard-wiring it to PL/pgSQL. Tom Lane 2002-08-30 00:28:41 +00:00
  • 82ccb420d5 Fix a bug introduced in 7.2. Hiroshi Inoue 2002-08-29 23:39:05 +00:00
  • 40f2eec503 > > > > If you want to put in security restrictions that are actually useful, > > > > where is the code to verify that PGPASSWORDFILE points at a > > > > non-world-readable file? That needs to be there now, not later, or > > > > we'll have people moaning about backward compatibility when we finally > > > > do plug that hole. Bruce Momjian 2002-08-29 23:06:32 +00:00
  • 9858a3a43f Sir Mordred The Traitor <mordred@s-mail.com> writes: > Upon invoking a polygon(integer, circle) function a > src/backend/utils/adt/geo_ops.c:circle_poly() function will gets > called, which suffers from a buffer overflow. > > 2) A src/backend/adt/utils/geo_ops.c:path_encode() fails to detect a > buffer overrun condition. It is called in multiple places, the most > interesting are path_out() and poly_out() functions. Bruce Momjian 2002-08-29 23:05:44 +00:00
  • dbc4d615ca Add cube changes file. Bruce Momjian 2002-08-29 23:05:03 +00:00
  • 32784cddf1 The changes I have made are described in CHANGES. This was based on diffs to 7.3-devel and may not be applicable to 7.2. I have included a change covered by a previous bugfix patch I submitted (the problem with -.1 not being accepted by cube_in). It does not include a fix for the potential buffer overrun issue I reported for cube_yyerror in cubeparse.y. Bruce Momjian 2002-08-29 23:03:58 +00:00
  • 6d27cfdd89 Make pg_resetxlog options parsing more standard and prepare messages for translation. Peter Eisentraut 2002-08-29 22:19:03 +00:00
  • 41a8562739 Create "po" subdirectory before writing there. Peter Eisentraut 2002-08-29 22:13:01 +00:00
  • d525ab81c3 Workaround for broken large file support on HP-UX Peter Eisentraut 2002-08-29 22:09:22 +00:00
  • f81ce4a0f6 Prevent problem with extra-long password packets from allocating lots of memory. Bruce Momjian 2002-08-29 21:50:36 +00:00
  • 626eca697c This patch reserves the last superuser_reserved_connections slots for connections by the superuser only. Bruce Momjian 2002-08-29 21:02:12 +00:00
  • 1761990e38 please apply small patch for README.tsearch. Bruce Momjian 2002-08-29 19:55:26 +00:00
  • 31fbdad6e5 The unit for statement_timeout is s/1000, not s/1000000 Bruce Momjian 2002-08-29 19:53:58 +00:00
  • a4f6add21b Back out patch, that was alpha, which I think still needs just -O. Bruce Momjian 2002-08-29 19:35:47 +00:00
  • 19deb4fc41 Change FreeBSD to use -O2, important for MemSet. Bruce Momjian 2002-08-29 19:35:07 +00:00
  • e4186762ff Adjust nodeFunctionscan.c to reset transient memory context between calls to the table function, thus preventing memory leakage accumulation across calls. This means that SRFs need to be careful to distinguish permanent and local storage; adjust code and documentation accordingly. Patch by Joe Conway, very minor tweaks by Tom Lane. Tom Lane 2002-08-29 17:14:33 +00:00
  • 0201dac1c3 Push down outer qualification clauses into UNION and INTERSECT subqueries. Per pghackers discussion from back around 1-August. Tom Lane 2002-08-29 16:03:49 +00:00
  • d2236800ee Cause REINDEX to regard TOAST tables as regular relations, not system tables that need special defenses. I believe this is okay even for TOAST tables that belong to system tables. Tom Lane 2002-08-29 15:56:20 +00:00
  • 5f97dc3e7c chkpass_rout returns text so change PG_RETURN_CSTRING to PG_RETURN_TEXT_P. This is currently a cosmetic difference but I make the change now in case the macros diverge one day. D'Arcy J.M. Cain 2002-08-29 12:18:20 +00:00
  • 0308d66a6a Remove MULTIBYTE Tatsuo Ishii 2002-08-29 08:03:22 +00:00
  • ed7baeaf4d Remove #ifdef MULTIBYTE per hackers list discussion. Tatsuo Ishii 2002-08-29 07:22:30 +00:00
  • 8e80dbb849 Rephrase 'Cannot insert into a view' and related messages, per pghackers discussion around 31-Jul-02. Tom Lane 2002-08-29 06:05:27 +00:00
  • bf59ccc7d8 A few more fixes for the <replaceable>able> fiasco. Tom Lane 2002-08-29 05:17:55 +00:00
  • 16402ac6e3 update mbregress expected files Tatsuo Ishii 2002-08-29 04:43:55 +00:00
  • dc4e983ff6 Produce a somewhat-useful error message, namely ERROR: Cannot display a value of type RECORD rather than a random integer when someone tries to SELECT a tuple value. Per pghackers discussion around 26-May-02. Tom Lane 2002-08-29 04:38:04 +00:00
  • 99fd5cbd41 FOUND patch was a bit over-enthusiastic: SQL commands that are not INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway. Also, try to make documentation a little clearer. Tom Lane 2002-08-29 04:12:03 +00:00
  • 5241a6259f Remove support for version-0 FE/BE protocol, per pghackers discussion. This breaks support for 6.2 or older client libraries. Tom Lane 2002-08-29 03:22:01 +00:00
  • 8a24a55c81 Fix ruleutils to dump column definition lists for anonymous record types defined in the FROM clause. From Joe Conway, with some tweaks. Tom Lane 2002-08-29 01:19:41 +00:00
  • 64505ed58b Code review for standalone composite types, query-specified composite types, SRFs. Not happy with memory management yet, but I'll commit these other changes. Tom Lane 2002-08-29 00:17:06 +00:00
  • 7483749d82 Improve description of tablefunc. Tom Lane 2002-08-28 22:05:46 +00:00
  • 12f80d7c69 Initial Spanish translation from Karim Mribti <karim@inlosa.com> Peter Eisentraut 2002-08-28 21:01:14 +00:00
  • 3aaffad26f Updates from Dennis Bjorklund Peter Eisentraut 2002-08-28 20:58:45 +00:00
  • d54caa6b34 Break up the long usage messages in pg_dump and pg_restore and unify the wording, to make life easier for translators. Peter Eisentraut 2002-08-28 20:57:22 +00:00
  • 03d39ce080 Remove TIOGA files from CVS current; they remain in repositiry. Bruce Momjian 2002-08-28 20:55:23 +00:00
  • fbb1966cf3 This trivial patches fixes the error message returned by CREATE INDEX when it finds an existing relation with the same name as the to-be-created index. Bruce Momjian 2002-08-28 20:46:47 +00:00
  • 81dfa2ce43 backend where a statically sized buffer is written to. Most of these should be pretty safe in practice, but it's probably better to be safe than sorry. Bruce Momjian 2002-08-28 20:46:24 +00:00
  • f5fea0808f This is a quick patch to fix a crash in pgquery_dictresult() introduced recently. I just ran into it while running a set of python test scripts, and I'm not sure who the normal maintainer is for interfaces/python. Bruce Momjian 2002-08-28 20:18:58 +00:00
  • b60acaf568 The following small patch provides a couple of minor updates (against CVS HEAD): Bruce Momjian 2002-08-28 20:18:29 +00:00
  • 1923816c37 Add mention of foreign key dependency and SERIAL in 7.2 data restores. Bruce Momjian 2002-08-28 20:17:44 +00:00
  • 2364928814 Dump ALTER DATABASE/USER ... SET ... Peter Eisentraut 2002-08-28 18:25:05 +00:00
  • 4469f1aec7 Remove: Bruce Momjian 2002-08-28 16:45:11 +00:00
  • 83501ef4ca Update info about relkind and pg_type entries for composite-types patch. Tom Lane 2002-08-28 15:02:55 +00:00
  • 6077db92c2 Allow FOR UPDATE to appear after LIMIT/OFFSET to match MySQL syntax and as a more logical ordering. Bruce Momjian 2002-08-28 14:35:37 +00:00
  • 8e4357d8ad Fix compile warning. Tom Lane 2002-08-27 21:50:23 +00:00
  • f032bccbdd Flush output streams before calling pg_dump subprocess. Peter Eisentraut 2002-08-27 21:33:41 +00:00
  • 056dee3bad Add: Bruce Momjian 2002-08-27 21:16:13 +00:00
  • 9afa305835 Disable use of -c and -a together in pg_dump; they don't make sense together. Bruce Momjian 2002-08-27 21:04:58 +00:00
  • 65a34e93c6 Bring comments back in sync with code. Tom Lane 2002-08-27 20:54:47 +00:00
  • 73b94657b0 Throw error on pg_atoi(''), regression adjustments. Bruce Momjian 2002-08-27 20:29:11 +00:00
  • 7292131c66 Enable locale, so case conversion (identifier processing) and number formatting (\timing) works correctly. Change "Total time" to "Time" since there is nothing that "total" refers to. Remove non-multibyte code. Peter Eisentraut 2002-08-27 20:16:49 +00:00
  • 7af5ea736f Reimplement pg_dumpall in C. Currently no change in functionality, except that it's more robust, reconnects less often, and is NLS'ed. Peter Eisentraut 2002-08-27 18:57:26 +00:00
  • 6deb649cd3 Add '+' mention in \? help. More clean of \? to do. Bruce Momjian 2002-08-27 18:28:29 +00:00
  • ec11403023 Make change for pg_locks table. Bruce Momjian 2002-08-27 18:06:00 +00:00
  • a1c218cae4 The attached patch implements the password packet length sanity check (using an elog(LOG) ), as well as includes a few more comment fixes. Bruce Momjian 2002-08-27 16:21:51 +00:00
  • dbf261f588 Add: Bruce Momjian 2002-08-27 16:19:46 +00:00
  • cf0be7fe5e Add error code emails. Bruce Momjian 2002-08-27 15:31:32 +00:00
  • fd3c4b2eaf Add most of Neil Conway's cleanups. Bruce Momjian 2002-08-27 15:15:23 +00:00
  • 840deabfe0 More connection timeout cleanups. Bruce Momjian 2002-08-27 15:02:50 +00:00
  • 4e723e6717 Cleanup of libpq connection timeout code. Bruce Momjian 2002-08-27 14:49:52 +00:00
  • 78a693c430 Add: Bruce Momjian 2002-08-27 14:17:14 +00:00
  • 0582ad91ac Add fsm sizes. Bruce Momjian 2002-08-27 14:06:05 +00:00
  • 28e82066a1 PREPARE/EXECUTE statements. Patch by Neil Conway, some kibitzing from Tom Lane. Tom Lane 2002-08-27 04:55:12 +00:00
  • bc8f725a4a Done: Bruce Momjian 2002-08-27 04:30:24 +00:00
  • a4965520f6 Add to mmap discussion. Bruce Momjian 2002-08-27 04:09:01 +00:00
  • a77d34f0b8 This patch updates the lock listing code to use Joe Conway's new anonymous return type SRF code. It gets rid of the superflous 'pg_locks_result' that Bruce/Tom had commented on. Otherwise, no changes in functionality. Bruce Momjian 2002-08-27 04:00:28 +00:00
  • bda45958a8 This is a 2 line patch to src/interfaces/perl5/GNUMakefile that fixes the 'override CPPFLAGS' to include the source directory during compile, and makes the install target look in the proper place for the man page. Bruce Momjian 2002-08-27 03:57:11 +00:00
  • dd912c6977 This patches replaces a few more usages of strcpy() and sprintf() when copying into a fixed-size buffer (in this case, a buffer of NAMEDATALEN bytes). AFAICT nothing to worry about here, but worth fixing anyway... Bruce Momjian 2002-08-27 03:56:35 +00:00
  • e0a77f56e3 Cleanup of SGML Bruce Momjian 2002-08-27 03:55:17 +00:00
  • c0ad595386 I attach a little patch to make CLUSTER set and reset the indisclustered bit on the indexes. Bruce Momjian 2002-08-27 03:38:28 +00:00
  • b7e272429c Add to skip list in check_guc Bruce Momjian 2002-08-27 03:06:16 +00:00