hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-21 22:07:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • aaf11b931f Back out to_char fixes until regression tests are fixed. Bruce Momjian 2003-03-22 02:12:24 +00:00
  • 05f916e6ad Adjust subquery qual pushdown rules to be more forgiving: if a qual refers to a non-DISTINCT output column of a DISTINCT ON subquery, or if it refers to a function-returning-set, we cannot push it down. But the old implementation refused to push down *any* quals if the subquery had any such 'dangerous' outputs. Now we just look at the output columns actually referenced by each qual expression. More code than before, but probably no slower since we don't make unnecessary checks. Tom Lane 2003-03-22 01:49:38 +00:00
  • e43094b124 Fix compile warning. Tom Lane 2003-03-21 23:18:52 +00:00
  • e02f818311 Add hostmask() function: Bruce Momjian 2003-03-21 21:54:29 +00:00
  • 1a7f4ed525 Make "win" a separate port from "cygwin". This means you can now configure under native Windows (MinGW that is), but you won't get very far compiling yet. The dynaloader files are from Jan Wieck's patch set. Peter Eisentraut 2003-03-21 17:18:34 +00:00
  • 93331d8318 Remove mention of transactions for insensitive cursors. Bruce Momjian 2003-03-21 17:11:46 +00:00
  • 063da9dce6 Fix ALTER TABLE / CLUSTER ON breakage. Bruce Momjian 2003-03-21 15:43:02 +00:00
  • b8f7d3d0b6 Do not free prepares statements at the end of a transaction. Michael Meskes 2003-03-21 15:31:04 +00:00
  • 524e9d62a7 Changes to the parser to accept new datatypes. Michael Meskes 2003-03-21 14:17:47 +00:00
  • 9a9719e482 Allow error query to start transaction in autocommit off mode. Bruce Momjian 2003-03-21 04:33:15 +00:00
  • 3bb7e1ef11 Fix sequence casting. Bruce Momjian 2003-03-21 03:55:21 +00:00
  • c7d17a551a Done: Bruce Momjian 2003-03-21 03:47:38 +00:00
  • 7542f10325 Improve psql comment coding. Bruce Momjian 2003-03-21 03:28:29 +00:00
  • d72f6c7503 Reimplement NUMERIC datatype using base-10000 arithmetic; also improve some of the algorithms for higher functions. I see about a factor of ten speedup on the 'numeric' regression test, but it's unlikely that that test is representative of real-world applications. initdb forced due to change of on-disk representation for NUMERIC. Tom Lane 2003-03-21 01:58:05 +00:00
  • 5ae424529b Fix multiline C comments in psql. Bruce Momjian 2003-03-20 22:08:50 +00:00
  • e5f5e73fcb Update for new serial functionality. Bruce Momjian 2003-03-20 21:00:49 +00:00
  • b2e09fcd5e This is not the only place in the system catalogs where NULL is effectively used to mean a default value that could also be spelled out explicitly. (ACLs behave that way, and useconfig/datconfig do too IIRC.) Bruce Momjian 2003-03-20 20:05:32 +00:00
  • 0fe77d7283 The documentation for SELECT is incorrect in a sense: the syntax for a join is defined as: Bruce Momjian 2003-03-20 19:00:01 +00:00
  • e0d043b94d please apply attached patch to current CVS. btree_gist now supports int2 ! Thanks Janko Richter for contribution. Bruce Momjian 2003-03-20 18:59:18 +00:00
  • 3be6367b9f This patch creates a function named pg_get_triggerdef that takes the oid of a trigger as its parameter. It is basically copied from the pg_dump code. Bruce Momjian 2003-03-20 18:58:02 +00:00
  • 8819213534 Now that the CLUSTER ALL machinery is in place, the clusterdb script can be simplified (I'd thought that it can even be removed). This patch does that. Bruce Momjian 2003-03-20 18:53:18 +00:00
  • 432b9b0f75 Add ALTER TABLE <tablename> CLUSTER ON <indexname> Bruce Momjian 2003-03-20 18:52:48 +00:00
  • db5d7ccac9 It would also be handy if users could see their own pg_stat_activity queries while the rest remain blank. Bruce Momjian 2003-03-20 18:51:16 +00:00
  • bd18c50ba8 I have updated my pg_autovacuum program (formerly pg_avd, the name changed as per discussion on the patches list). Bruce Momjian 2003-03-20 18:14:46 +00:00
  • 41d17389f1 Fix typo in SGML tags. Bruce Momjian 2003-03-20 17:37:46 +00:00
  • da1534d952 Re-add type conversion examples. Bruce Momjian 2003-03-20 16:17:32 +00:00
  • 2e6f97560a Started adding date and timestamp. Michael Meskes 2003-03-20 15:56:50 +00:00
  • 26a6378e84 Remove extern for cancelConn, from Karel Zak Bruce Momjian 2003-03-20 15:44:17 +00:00
  • 4422fe6017 Remove compile warning. Bruce Momjian 2003-03-20 15:39:53 +00:00
  • cf4cee1b17 At present, dates are put into a dump in the format specified by the default datestyle. This is not portable between installations. Bruce Momjian 2003-03-20 07:05:21 +00:00
  • 5f65225fa3 Todo items: Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values Bruce Momjian 2003-03-20 07:02:11 +00:00
  • 46bce088c1 Done: Bruce Momjian 2003-03-20 07:00:57 +00:00
  • 64d0b8b05f Attached is an update to contrib/tablefunc. It implements a new hashed version of crosstab. This fixes a major deficiency in real-world use of the original version. Easiest to undestand with an illustration: Bruce Momjian 2003-03-20 06:46:30 +00:00
  • add932ee91 I'm continuing to work on cleaning up code in psql. As things appear now, my changes seem to work. Some possible minor bugs got squished on the way but I can't be sure without more feedback from people who really put the code to the test. Bruce Momjian 2003-03-20 06:43:35 +00:00
  • 1b3d4cefe8 It has been tested only against CVS backend, however. Some checking of the changes to the SQL to retrieve attributes for older versions of Postgres is probably wise. Also, please make sure that I have mapped the storage types to the correct storage names, as this is relatively poorly documented. Bruce Momjian 2003-03-20 06:26:30 +00:00
  • 44aba28020 PGRES_POLLING_ACTIVE is unused, keep for backward compatibility. Bruce Momjian 2003-03-20 06:23:30 +00:00
  • d7f10705b4 Attached is a patch that limits the range tested by horology to what is capable using integer-datatime timestamps. It does attempt to exercise the maximum allowable timestamp range. Also is a small error check when converting a timestamp from external to internal format that prevents out of range timestamps from being entered. Bruce Momjian 2003-03-20 06:03:00 +00:00
  • be1c6e7529 Here's some changes I made last night to psql's common.c (as found in 7.3.2). It removes some code duplication and #ifdeffing, and some unstructured ugliness such as tacky breaks and an unneeded continue. Breaks up a large function into smaller functions and reduces required nesting levels, and kills a variable or two. Bruce Momjian 2003-03-20 06:00:12 +00:00
  • 94701fb24b Peter found bug in the to_char() routine for PL/MI options. This patch fix it -- but this patch doesn't contains tests or docs fixes. I will send it later. Bruce Momjian 2003-03-20 05:19:26 +00:00
  • 8000fdd462 > > - Move SEQ_MAXVALUE, SEQ_MINVALUE definitions to sequence.h > > > > - Add check in pg_dump to see if the value returned is the max /min > > values and replace with NO MAXVALUE, NO MINVALUE. > > > > - Change START and INCREMENT to use START WITH and INCREMENT BY syntax. > > This makes it a touch easier to port to other databases with sequences > > (Oracle). PostgreSQL supports both syntaxes already. > > + char bufm[100], > + bufx[100]; > > This seems to be an arbitary size. Why not set it to the actual maximum > length? > > Also: > > + snprintf(bufm, 100, INT64_FORMAT, SEQ_MINVALUE); > + snprintf(bufx, 100, INT64_FORMAT, SEQ_MAXVALUE); > > sizeof(bufm), sizeof(bufx) is probably the more > maintenance-friendly/standard way to do it. Bruce Momjian 2003-03-20 05:18:15 +00:00
  • a00431b8d8 "Information_schema" changes Bruce Momjian 2003-03-20 05:06:55 +00:00
  • 54ca7a7b13 (Now featuring documentation: fixed some typos, expanded the Envrironment and Files section, explained exactly what -w does) Bruce Momjian 2003-03-20 05:00:14 +00:00
  • 3c28f9c144 This trivial cleans up a little bit of the code in src/test/regress/regress.c (e.g. removing K & R style parameter declarations, improving sprintf() usage, etc.) Bruce Momjian 2003-03-20 04:52:35 +00:00
  • 15ce2d2e4a > I can see a couple possible downsides: (a) the library might have some > weird behavior across fork boundaries; (b) the additional memory space > that has to be duplicated into child processes will cost something per > child launch, even if the child never uses it. But these are only > arguments that it might not *always* be a prudent thing to do, not that > we shouldn't give the DBA the tool to do it if he wants. So fire away. Bruce Momjian 2003-03-20 04:51:44 +00:00
  • e733510d5d > Mph. It fails for me too when I use --enable-integer-datetimes. Looks > like that patch still needs some work... Bruce Momjian 2003-03-20 04:49:18 +00:00
  • 7d1d7200a0 Minor doc patch: create function Bruce Momjian 2003-03-20 04:41:13 +00:00
  • ee303739d3 Just some fixups to a couple contrib directories I was trying out. Bruce Momjian 2003-03-20 04:39:27 +00:00
  • e8b9aeea41 The attatched patch fixes a memory error with contrib/dbmirror/pending.c when running it with older(Pre 7.3.x) versions of Postgresql. Bruce Momjian 2003-03-20 03:58:48 +00:00
  • 900fa3d0f5 The attatched patch fixes a memory error with contrib/dbmirror/pending.c when running it with older(Pre 7.3.x) versions of Postgresql. Bruce Momjian 2003-03-20 03:58:13 +00:00
  • 31ce4557b3 Item done: Bruce Momjian 2003-03-20 03:40:33 +00:00
  • a18331004a Add start time to pg_stat_activity Bruce Momjian 2003-03-20 03:34:57 +00:00
  • ddd50a0bab This patch fixes a very small memory leak in psql, spotted with valgrind. Bruce Momjian 2003-03-19 22:49:43 +00:00
  • 1ef7ba20e7 Remove typecasting section that isn't needed anymore. Bruce Momjian 2003-03-19 21:20:52 +00:00
  • 8cb041aada Set up the privileges on the default schemas in initdb with real GRANT commands, to arrive at a valid and dumpable state. Peter Eisentraut 2003-03-19 16:08:59 +00:00
  • 28efaf3ccd Avoid mysterious warning about possibly uninitialized variable. Peter Eisentraut 2003-03-19 16:05:41 +00:00
  • e02ace4418 Backport patch to work around a server bug. Server incorrectly handles the following: select 1; commit; set autocommit true; If this is submitted in one call to the server (the select 1 doesn't start a new transaction like it should), however if the select 1 is sent as a separate call then it works correctly. Barry Lind 2003-03-19 04:09:09 +00:00
  • 44a6959f4a Applied patch to work around server bug. Barry Lind 2003-03-19 04:06:20 +00:00
  • c085c771d3 Fix typo: Bruce Momjian 2003-03-19 03:53:21 +00:00
  • 9e0ab7126d Reimplement create and drop scripts in C, to reduce repetitive connections, increase robustness, add NLS, and prepare for Windows port. (vacuumdb and clusterdb will follow later.) Peter Eisentraut 2003-03-18 22:19:47 +00:00
  • cf1cf89649 Make the printing code somewhat more independent by not relying on functions and global variables from the rest of psql. Also clean up some data type mismatches created by the last pager patch. Peter Eisentraut 2003-03-18 22:15:44 +00:00
  • 9384dc6e59 Improve error message. Peter Eisentraut 2003-03-18 22:11:48 +00:00
  • a14424a9d2 Fix off-by-one error in the maxlen parameter handling. Peter Eisentraut 2003-03-18 22:09:37 +00:00
  • 6cf8ce13db Compiling anything that uses InvalidOid under g++ yields a warning about the expression using an "old-style cast." Therefore, would it be okay to patch postgres_ext.h as follows: Bruce Momjian 2003-03-18 17:21:07 +00:00
  • 526de7ffd1 Remove duplicate ANALYZE recommendation in pg_dump. Bruce Momjian 2003-03-18 17:05:01 +00:00
  • 6fad73ed45 Some bugfixes for numerical library. Michael Meskes 2003-03-18 10:46:39 +00:00
  • a6f00f3939 Applied updated translation patch Barry Lind 2003-03-18 05:26:50 +00:00
  • d10ed0263e Applied translation fixes Barry Lind 2003-03-18 05:24:36 +00:00
  • 6fdd71c133 Add to mmap discussion. Bruce Momjian 2003-03-18 01:36:01 +00:00
  • 29c18bca50 Add mention of ANALYZE after object restore. Bruce Momjian 2003-03-18 00:02:11 +00:00
  • ccfa6f1c1e Add mention of new sets returning functions capability. Bruce Momjian 2003-03-17 19:53:08 +00:00
  • 77312655a9 Update links, from Ian Barwick Bruce Momjian 2003-03-17 19:47:28 +00:00
  • b776fc198b Add: Bruce Momjian 2003-03-17 18:50:06 +00:00
  • 93b408ef86 Reorder crypt.h include for SunOS compile problem. Bruce Momjian 2003-03-17 17:58:57 +00:00
  • aac4484345 Increase max known database size. Bruce Momjian 2003-03-17 16:33:12 +00:00
  • bb3730893b Forgot some files... Michael Meskes 2003-03-16 10:49:51 +00:00
  • a4f25b6a9c Started working on a seperate pgtypes library. First test work. PLEASE test compilation on iother systems. Michael Meskes 2003-03-16 10:42:54 +00:00
  • 48dfa0d057 Arrange to print the relevant key values when reporting a foreign-key violation. Also, factor out some duplicate code in the RI triggers. Patch by Dmitry Tkach, reviewed by Stephan Szabo and Tom Lane. Tom Lane 2003-03-15 21:19:40 +00:00
  • 35911088ff A typo in src/backend/libpq/hba.c breaks local ident authentication in the SO_PEERCRED case. elif is misspelled as elsif for the test. A patch is attached. Bruce Momjian 2003-03-15 16:18:25 +00:00
  • 1a0172fbbd pg_dumpall failed on groups having no members. Per report from Nick Eskelinen. Tom Lane 2003-03-14 22:45:56 +00:00
  • 2a44306396 pg_dumpall failed on groups having no members. Per report from Nick Eskelinen. Tom Lane 2003-03-14 22:45:49 +00:00
  • c90354bad0 Remove unneeded dash blocks around function start comments. Bruce Momjian 2003-03-14 22:40:31 +00:00
  • dc95c9f3ab Update name of GUC var: Bruce Momjian 2003-03-14 20:19:59 +00:00
  • 96fecb54dc Add: Bruce Momjian 2003-03-14 19:27:49 +00:00
  • 1ad6337fd5 Backport fix for parsing \n in updateable result sets to 7.3 branch Barry Lind 2003-03-14 05:38:36 +00:00
  • 9f66350b0e Fixed parsing to handle \n for updateable result sets. Bug reported by Rich Cullingford. Barry Lind 2003-03-14 05:36:58 +00:00
  • dabb2fbc0d Repair incorrect prorettype entry for timestamptz_izone. Can't force initdb in the 7.3 branch, but we can at least make it right for people who install 7.3.3 from scratch. Tom Lane 2003-03-14 04:44:05 +00:00
  • a6bf340975 Repair incorrect prorettype entry for timestamptz_izone. Can't force initdb in the 7.3 branch, but we can at least make it right for people who install 7.3.3 from scratch. Tom Lane 2003-03-14 04:43:52 +00:00
  • 8f390674de Backport batch update error message improvements to 7.3 branch Barry Lind 2003-03-14 01:23:08 +00:00
  • 77ce53580b Improved error message and added some log messages in batch update functionality Barry Lind 2003-03-14 01:21:47 +00:00
  • 7931bfa764 Make eval_const_expressions simplify FieldSelect from a whole-row Var into an ordinary one-field Var. Per example from Chris Mungall. Tom Lane 2003-03-14 00:55:17 +00:00
  • cebedc36ed Prevent infinite loop in ln_var() due to roundoff error. Per report from Dave Marin. Tom Lane 2003-03-14 00:15:41 +00:00
  • 2a1ef30b57 Prevent infinite loop in ln_var() due to roundoff error. Per report from Dave Marin. Tom Lane 2003-03-14 00:15:32 +00:00
  • 40faf433b0 Async_NotifyHandler must save and restore ImmediateInterruptOK. Fixes known problem with failure to respond to 'pg_ctl stop -m fast', and probable problems if SIGINT or SIGTERM arrives while processing a SIGUSR2 interrupt that arrived while waiting for a new client query. Tom Lane 2003-03-13 23:44:07 +00:00
  • d144f96bf0 GROUP BY got confused if there were multiple equal() GROUP BY items. This bug has been latent since 7.0 or maybe even further back, but it was only exposed when parse_clause.c stopped suppressing duplicate items (see its rev 1.96 of 18-Aug-02). Tom Lane 2003-03-13 16:58:49 +00:00
  • 6c4996fa6b GROUP BY got confused if there were multiple equal() GROUP BY items. This bug has been latent since 7.0 or maybe even further back, but it was only exposed when parse_clause.c stopped suppressing duplicate items (see its rev 1.96 of 18-Aug-02). Tom Lane 2003-03-13 16:58:35 +00:00
  • 706a32cdf6 Big editing for consistent content and presentation. Peter Eisentraut 2003-03-13 01:30:29 +00:00
  • 31e69ccb21 Add explicit tests for division by zero to all user-accessible integer division and modulo functions, to avoid problems on OS X (which fails to trap 0 divide at all) and Windows (which traps it in some bizarre nonstandard fashion). Standardize on 'division by zero' as the one true spelling of this error message. Add regression tests as suggested by Neil Conway. Tom Lane 2003-03-11 21:01:33 +00:00
  • 6261c75014 Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n options for FETCH and MOVE. Tom Lane 2003-03-11 19:40:24 +00:00
  • e4704001ea This patch fixes a bunch of spelling mistakes in comments throughout the PostgreSQL source code. Tom Lane 2003-03-10 22:28:22 +00:00
  • 081fa240a1 Update German FAQ Bruce Momjian 2003-03-10 16:06:41 +00:00