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

Commit Graph

  • 244d2d67a0 Added Informix "database" command. Michael Meskes 2003-02-17 14:06:40 +00:00
  • 72933a92c7 Back off previous patch to skip projection step in scan plan nodes, in the case where the node immediately above the scan is a Hash, Sort, or Material node. In these cases it's better to do the projection so that we don't store unneeded columns in the hash/sort/materialize table. Per discussion a few days ago with Anagh Lal. Tom Lane 2003-02-16 06:06:32 +00:00
  • 51972a9d5d COALESCE() and NULLIF() are now first-class expressions, not macros that turn into CASE expressions. They evaluate their arguments at most once. Patch by Kris Jurka, review and (very light) editorializing by me. Tom Lane 2003-02-16 02:30:39 +00:00
  • de25638d2f Update wording: < * Disallow DROP COLUMN on a column that is part of a multi-column index > * Require DROP COLUMN CASCADE for a column that is part of a multi-column index Bruce Momjian 2003-02-16 00:29:49 +00:00
  • 0d7abfe7cf Marginal tweaks to make sure that roundoff error won't cause us to make a bad choice between sorted and hashed aggregation. Tom Lane 2003-02-15 21:39:58 +00:00
  • 056467ec6b Teach planner how to propagate pathkeys from sub-SELECTs in FROM up to the outer query. (The implementation is a bit klugy, but it would take nontrivial restructuring to make it nicer, which this is probably not worth.) This avoids unnecessary sort steps in examples like SELECT foo,count(*) FROM (SELECT ... ORDER BY foo,bar) sub GROUP BY foo which means there is now a reasonable technique for controlling the order of inputs to custom aggregates, even in the grouping case. Tom Lane 2003-02-15 20:12:41 +00:00
  • 50c4190e37 Add: Bruce Momjian 2003-02-15 18:30:06 +00:00
  • ba16df979c Propogate pg_ctl -D to the postmaster as a -D flag for identification by ps for multiple postmasters, for Kevin Brown. Bruce Momjian 2003-02-14 22:18:25 +00:00
  • 79c049ddaa Fix SPI result logic for case where there are multiple statements of the same type in a rule. Per bug report from Pavel Hanak. Tom Lane 2003-02-14 21:12:54 +00:00
  • 2dde90ad8d Fix SPI result logic for case where there are multiple statements of the same type in a rule. Per bug report from Pavel Hanak. Tom Lane 2003-02-14 21:12:45 +00:00
  • 3f6333357f Make pg_dump/restore safer for autocommit=off in postgresql.conf. Bruce Momjian 2003-02-14 19:40:42 +00:00
  • 37664ee465 Add: Bruce Momjian 2003-02-14 17:02:45 +00:00
  • 1005c993a6 In Informix mode ecpg should still be able to parse preprocessor directives. Michael Meskes 2003-02-14 16:40:01 +00:00
  • e9551212d2 Add: Bruce Momjian 2003-02-14 14:41:40 +00:00
  • f0b8f5dbdb Allow PAM to work on MAC OS X, report from Aaron Hillegass. Bruce Momjian 2003-02-14 14:13:56 +00:00
  • 56650f3fda Update FAQ's in head and 7.3.X. Bruce Momjian 2003-02-14 14:05:52 +00:00
  • 0e010a54a3 Update FAQ's in head and 7.3.X. Bruce Momjian 2003-02-14 14:05:00 +00:00
  • 044dca9f7c Update to 7.3.2 as newest release. Bruce Momjian 2003-02-14 14:03:10 +00:00
  • a4a6c007bb *** empty log message *** Bruce Momjian 2003-02-14 13:59:14 +00:00
  • 2b26f1ca3f Update URL's. Bruce Momjian 2003-02-14 13:59:01 +00:00
  • 3a335375a9 - Synced parser and keyword file. - More work on Informix compatibility. Michael Meskes 2003-02-14 13:17:13 +00:00
  • aa874ee0d7 Add: Bruce Momjian 2003-02-14 13:11:44 +00:00
  • 5458bd2fa5 Update FAQ. Bruce Momjian 2003-02-14 04:07:46 +00:00
  • c5f8cbf9f5 Fix broken markup I just introduced. Bruce Momjian 2003-02-14 02:21:25 +00:00
  • 77cf4a133c Properly document location of pg_service.conf.sample. Bruce Momjian 2003-02-14 01:32:31 +00:00
  • e8a10dc7e9 Fix some of the breakage from the IPV6 patch. Tom Lane 2003-02-14 01:24:26 +00:00
  • 874e8cef99 Remove bogus manipulation of SIGPIPE; the backend already runs with SIGPIPE disabled, and does not need to waste two syscalls per I/O on it. Tom Lane 2003-02-14 00:18:41 +00:00
  • abe07ff174 Repair incorrect indexing for atttypmod, per Brad McLean. Tom Lane 2003-02-13 23:06:19 +00:00
  • 8eac198d5b Repair incorrect indexing for atttypmod, per Brad McLean. Tom Lane 2003-02-13 23:06:15 +00:00
  • 5dc8478d20 Result of lo_read() is int, not size_t. Per Oleg Drokin. Tom Lane 2003-02-13 22:56:59 +00:00
  • 57892e74db Result of lo_read() is int, not size_t. Per Oleg Drokin. Tom Lane 2003-02-13 22:56:52 +00:00
  • c6d801f3bf Parser was dropping foreign-key constraints on the floor if present in an ALTER TABLE ADD COLUMN command. Per bug #896. Tom Lane 2003-02-13 22:50:09 +00:00
  • c4ebf7b150 Parser was dropping foreign-key constraints on the floor if present in an ALTER TABLE ADD COLUMN command. Per bug #896. Tom Lane 2003-02-13 22:50:01 +00:00
  • 55570581f5 Repair rule permissions-checking bug reported by Tim Burgess 10-Feb-02: the table(s) modified by the original query would get checked for the type of write permission needed by a rule query. Tom Lane 2003-02-13 21:40:00 +00:00
  • f4a72f773c Repair rule permissions-checking bug reported by Tim Burgess 10-Feb-02: the table(s) modified by the original query would get checked for the type of write permission needed by a rule query. Tom Lane 2003-02-13 21:39:50 +00:00
  • 18e8f06c9d Arrange to give error when a SetOp member statement refers to a variable of the containing query (which really can only happen in a rule context). Per example from Brandon Craig Rhodes. Also, make the error message more specific for the similar case with sub-select in FROM. The revised coding should be easier to adapt to SQL99's LATERAL(), when we get around to supporting that. Tom Lane 2003-02-13 20:45:22 +00:00
  • 53c15ceda0 Just intermediate results for backup reasons. Michael Meskes 2003-02-13 20:37:28 +00:00
  • 5f5da0a6cb transformExpr() was missing some cases it ought to allow; per report from Greg Stark. Also, twiddle the FuncCall case to not scribble on the input structure, which was the proximate cause of the problem. Someday we ought to fix things so that transformExpr() isn't called on already-transformed trees ... Tom Lane 2003-02-13 18:29:07 +00:00
  • 8d33f80fc4 Suppress gcc warning. Tom Lane 2003-02-13 18:13:22 +00:00
  • 35710e0d76 Prevent timetz2tm() from scribbling on its input in HAVE_INT64_TIMESTAMP case. Tom Lane 2003-02-13 17:04:24 +00:00
  • 478c95a0dc Prevent timetz2tm() from scribbling on its input in HAVE_INT64_TIMESTAMP case. Tom Lane 2003-02-13 17:04:19 +00:00
  • 1a9b0613c1 - Applied error reporting patch by Matthew Vanecek - Started with an Informix compatibility option. Michael Meskes 2003-02-13 13:11:52 +00:00
  • e529e9fa44 [ Revert patch ] Bruce Momjian 2003-02-13 05:53:46 +00:00
  • 29e57ce303 Add local ident OpenBSD mention that was missing in one place. Bruce Momjian 2003-02-13 05:47:46 +00:00
  • 0064031f99 This patch fixes an error in the usage message for 'clusterdb', and makes a few editorial changes to the documentation. Bruce Momjian 2003-02-13 05:37:44 +00:00
  • 48ee6f4916 This trivial patch removes the usage of some old statistics code that no longer works -- IncrHeapAccessStat() didn't actually *do* anything anymore, so no reason to keep it around AFAICS. I also fixed a grammatical error in a comment. Bruce Momjian 2003-02-13 05:35:11 +00:00
  • cc3c67784a > > They work the same as table constraints with in-line declaration (no > > comma). > > OK. But the documentation implies there is a comma, so it should probably > get chenged then. Bruce Momjian 2003-02-13 05:32:58 +00:00
  • 0845b6f326 > > They work the same as table constraints with in-line declaration (no > > comma). > > OK. But the documentation implies there is a comma, so it should probably > get chenged then. Bruce Momjian 2003-02-13 05:32:42 +00:00
  • 9ccaaf676f The attached patches change earthdistance to use the new cube functions in one of the earth functions so that latitude and longitude to cartesian coordinates conversion will be more accurrate. (Previously a text string was built to provide as input which limited the accuracy to the number of digits printed.) Bruce Momjian 2003-02-13 05:31:06 +00:00
  • 80b3513d57 The attached patch provides cube with 4 functions for building cubes directly from float8 values. (As opposed to converting the values to strings and then parsing the strings.) The functions are: cube(float8) returns cube cube(float8,float8) returns cube cube(cube,float8) returns cube cube(cube,float8,float8) returns cube Bruce Momjian 2003-02-13 05:26:50 +00:00
  • f249daf9b7 Adds in NO MAXVALUE and NO MINVALUE options for create sequence per 200X spec, which will also make alter sequence a touch easier. Bruce Momjian 2003-02-13 05:25:24 +00:00
  • 6cb1f4fe44 The "random" regression test uses a function called oidrand(), which takes two parameters, an OID x and an integer y, and returns "true" with probability 1/y (the OID argument is ignored). This can be useful -- for example, it can be used to select a random sampling of the rows in a table (which is what the "random" regression test uses it for). Bruce Momjian 2003-02-13 05:24:04 +00:00
  • 8195f8f042 Code for WITHOUT OIDS. Bruce Momjian 2003-02-13 05:20:05 +00:00
  • 8add2e1bca This patch makes pg_get_constraintdef support UNIQUE, PRIMARY KEY and CHECK constraints. Bruce Momjian 2003-02-13 05:10:39 +00:00
  • d21de3b121 > ================================================================= > User interface proposal for multi-row function targetlist entries > ================================================================= > 1. Only one targetlist entry may return a set. > 2. Each targetlist item (other than the set returning one) is > repeated for each item in the returned set. > Bruce Momjian 2003-02-13 05:06:35 +00:00
  • 2bd63117c1 [ dumping schemas ] Bruce Momjian 2003-02-13 04:54:16 +00:00
  • 6d8b8a5e4d [ Have readline save edit history.] > > > I already posted a one-line patch to implement this, but it doesn't > > seem to hve come through to the list. Here it is inline, instead of as > > an attachment: > > We need this to work without readline as well. (Of course there won't be > any history, but it needs to compile.) Bruce Momjian 2003-02-13 04:08:16 +00:00
  • 68c67fc8a8 Applied patch to update translation file, submitted by Zhenbang Wei Barry Lind 2003-02-12 20:40:23 +00:00
  • c73a769076 Applied patch to update translation file, submitted by Zhenbang Wei Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/errors_zh_TW.properties Barry Lind 2003-02-12 20:39:53 +00:00
  • e4851e54ca Backport patch from Fernando Nasser and Harald Krake to fix an invalid datatype problem. Barry Lind 2003-02-12 17:14:49 +00:00
  • e2b58f7693 Done in 7.3.2, so removed: Bruce Momjian 2003-02-12 14:11:22 +00:00
  • 0550c7a63a Done: Bruce Momjian 2003-02-12 14:09:04 +00:00
  • 0dbb7aeac4 Patch to messages file from Holger Klawitter to add a missing message. Patch to makefile to clean up some of the output Barry Lind 2003-02-12 06:13:04 +00:00
  • fa0c09bffc Backport a patch from Kris Jurka to 7.3. Allows getTables() method to work against 7.1 servers. Barry Lind 2003-02-12 06:01:02 +00:00
  • d6b043eb63 Fix buffer clearing bug. Peter Eisentraut 2003-02-11 21:06:58 +00:00
  • 62c35b3098 Simplify evaluation of TCL_INCLUDE_SPEC. Peter Eisentraut 2003-02-11 21:05:35 +00:00
  • 02c614dc85 Use a varno not chosen at random for dummy variables in the top-level targetlist of a set-operation tree. I'm not sure that this solution will really stand the test of time --- perhaps we need to make a special RTE for such vars to refer to. But this quick hack fixes Brandon Craig Rhodes' complaint of 10-Feb-02 about EXCEPT in CREATE RULE, while not changing any behavior in the better-tested cases where leftmostRTI is one anyway. Tom Lane 2003-02-11 04:13:39 +00:00
  • 9069a5fc33 Use a varno not chosen at random for dummy variables in the top-level targetlist of a set-operation tree. I'm not sure that this solution will really stand the test of time --- perhaps we need to make a special RTE for such vars to refer to. But this quick hack fixes Brandon Craig Rhodes' complaint of 10-Feb-02 about EXCEPT in CREATE RULE, while not changing any behavior in the better-tested cases where leftmostRTI is one anyway. Tom Lane 2003-02-11 04:13:06 +00:00
  • 8a4fdce9f2 Fix thinko in new logic about pushing down non-nullability constraints: constraints appearing in outer-join qualification clauses are restricted as to when and where they can be pushed down. Add regression test to catch future errors in this area. Tom Lane 2003-02-10 17:08:50 +00:00
  • ec8f0e82ef Add code to show join rule (for outer and IN joins) in join type name. Tom Lane 2003-02-10 17:06:23 +00:00
  • c5ba16a83c Get rid of last few vestiges of parsetree dependency on grammar token codes, per discussion from last March. parse.h should now be included *only* by gram.y, scan.l, keywords.c, parser.c. This prevents surprising misbehavior after seemingly-trivial grammar adjustments. Tom Lane 2003-02-10 04:44:47 +00:00
  • b5956a2f22 Detect case where an outer join can be reduced to a plain inner join because there are WHERE clauses that will reject the null-extended rows. Per suggestion from Brandon Craig Rhodes, 19-Nov-02. Tom Lane 2003-02-09 23:57:19 +00:00
  • 43785a434e upped build# to 201 Barry Lind 2003-02-09 23:45:45 +00:00
  • d3038e6e2c up build # to 108 Barry Lind 2003-02-09 23:43:41 +00:00
  • 3448835967 Merge changes from head to 7.3 branch: better error message on character set conversion problems and patch from Kris Jurka for numeric scale Modified Files: Tag: REL7_3_STABLE jdbc/org/postgresql/errors.properties jdbc/org/postgresql/core/Encoding.java jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java Barry Lind 2003-02-09 23:41:46 +00:00
  • abcec0c125 Better error message on character set mismatches during conversion to unicode. Also applied patch from Lars Stenberg to make callable statements use the form select * from func() when running against a 7.3 server instead of select func() to allow for set returning functions to be called. Barry Lind 2003-02-09 23:14:55 +00:00
  • 39b7ec3309 Create a distinction between Lists of integers and Lists of OIDs, to get rid of the assumption that sizeof(Oid)==sizeof(int). This is one small step towards someday supporting 8-byte OIDs. For the moment, it doesn't do much except get rid of a lot of unsightly casts. Tom Lane 2003-02-09 06:56:28 +00:00
  • 3646ab58b4 Remove bogus comment (too freely copied & pasted). Tom Lane 2003-02-09 00:35:55 +00:00
  • 145014f811 Make further use of new bitmapset code: executor's chgParam, extParam, locParam lists can be converted to bitmapsets to speed updating. Also, replace 'locParam' with 'allParam', which contains all the paramIDs relevant to the node (i.e., the union of extParam and locParam); this saves a step during SetChangedParamList() without costing anything elsewhere. Tom Lane 2003-02-09 00:30:41 +00:00
  • c15a4c2aef Replace planner's representation of relation sets, per pghackers discussion. Instead of Lists of integers, we now store variable-length bitmap sets. This should be faster as well as less error-prone. Tom Lane 2003-02-08 20:20:55 +00:00
  • 893678eda7 applied Kris Jurka's patch for numeric Dave Cramer 2003-02-07 12:47:29 +00:00
  • 521d70f661 Revise mechanism for getting rid of temp tables at backend shutdown. Instead of grovelling through pg_class to find them, make use of the handy dandy dependency mechanism: just delete everything that depends on our temp schema. Unlike the pg_class scan, the dependency mechanism is smart enough to delete things in an order that doesn't fall foul of any dependency restrictions. Fixes problem reported by David Heggie: a temp table with a serial column may cause a backend FATAL exit at shutdown time, if it chances to try to delete the temp sequence first. Tom Lane 2003-02-07 01:33:39 +00:00
  • 3acf422316 Revise mechanism for getting rid of temp tables at backend shutdown. Instead of grovelling through pg_class to find them, make use of the handy dandy dependency mechanism: just delete everything that depends on our temp schema. Unlike the pg_class scan, the dependency mechanism is smart enough to delete things in an order that doesn't fall foul of any dependency restrictions. Fixes problem reported by David Heggie: a temp table with a serial column may cause a backend FATAL exit at shutdown time, if it chances to try to delete the temp sequence first. Tom Lane 2003-02-07 01:33:06 +00:00
  • c228ef1587 Avoid generating relid lists with duplicate entries. Fixes bugs reported by Stefanos Harhalakis 2/2/2003. Tom Lane 2003-02-07 00:02:43 +00:00
  • 00f1a41ab2 Make flatten_join_alias_vars() do the right thing when expanding an alias referenced from a subquery. Per example from Stefanos Harhalakis. Tom Lane 2003-02-06 22:21:11 +00:00
  • 77ede8900d Create a GUC variable REGEX_FLAVOR to control the type of regular expression accepted by the regex operators, per discussion yesterday. Tom Lane 2003-02-06 20:25:33 +00:00
  • 2425ab3ece Fix core dump when pltcl_elog is called with wrong number of parameters, per report from Ian Harding. Tom Lane 2003-02-06 17:02:22 +00:00
  • 465ed56531 Fix core dump when pltcl_elog is called with wrong number of parameters, per report from Ian Harding. Tom Lane 2003-02-06 17:02:11 +00:00
  • de42a5f53d Fix regexp slowness reported by Wade Klaver. Tatsuo Ishii 2003-02-06 00:00:24 +00:00
  • 47729caf2d Allow qualified type names in CREATE CAST, DROP CAST. Also allow the construction 'SETOF type[]' which for some reason was previously overlooked (you'd have to name the array type directly to make it work). Tom Lane 2003-02-05 20:16:55 +00:00
  • e24977f3a4 Allow qualified type names in CREATE CAST, DROP CAST. Also allow the construction 'SETOF type[]' which for some reason was previously overlooked (you'd have to name the array type directly to make it work). Tom Lane 2003-02-05 20:16:42 +00:00
  • 7bcc6d98fb Replace regular expression package with Henry Spencer's latest version (extracted from Tcl 8.4.1 release, as Henry still hasn't got round to making it a separate library). This solves a performance problem for multibyte, as well as upgrading our regexp support to match recent Tcl and nearly match recent Perl. Tom Lane 2003-02-05 17:41:33 +00:00
  • 32c3db0f86 patch from Oliver Jowett to implement some of the jdbc3 methods Dave Cramer 2003-02-05 11:12:39 +00:00
  • 865429e00f Update Hungarian FAQ, from Laszlo Hornyak Bruce Momjian 2003-02-04 12:32:41 +00:00
  • bf4bf092e5 Revert doc change so we mention moving past the last row of a cursor. Bruce Momjian 2003-02-04 11:23:58 +00:00
  • 62ca0fce8f Fix for rollback SQLException from Kris Jurka Dave Cramer 2003-02-04 11:16:00 +00:00
  • 985e551b48 Applied Kris Jurkas patch to fix rollback and SQLException Dave Cramer 2003-02-04 11:01:52 +00:00
  • d23fd9572b applied patch from Oliver Jowett Dave Cramer 2003-02-04 10:44:37 +00:00
  • 28ce9f0fed Two patches from Kris Jurka. One fixes a problem with incorrect type for double and the other fixes a NPE in Statement.toString() under some circumstances. The second patch was originally submitted by Oliver Jowett and updated by Kris Barry Lind 2003-02-04 10:09:32 +00:00
  • 16a30346c8 Patch from Nic Ferrier to add support for result sets being cursor based so that rows can be fetched incrementally. This is enabled by using setFetchSize() Barry Lind 2003-02-04 09:20:12 +00:00