aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Update marks:Bruce Momjian2003-02-17
| | | | | | | | | | | < o Allow CLUSTER to cluster all tables (Alvaro Herrera) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) 243c243 < * Allow pg_dump to dump a specific schema (Neil Conway) > * -Allow pg_dump to dump a specific schema (Neil Conway) 398c398 < * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)
* Remove IN/EXISTS TODO.detail item.Bruce Momjian2003-02-17
|
* Mark as done:Bruce Momjian2003-02-17
| | | | | | | | | | | | > o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) > * -Allow pg_dump to dump a specific schema (Neil Conway) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * Rod is Rod Taylor <pg@rbt.ca)>
* Update:Bruce Momjian2003-02-17
| | | | | < * -Make a transaction-safe TRUNCATE > * -Make a transaction-safe TRUNCATE (Rod)
* Done:Bruce Momjian2003-02-17
| | | | > * -Make a transaction-safe TRUNCATE
* Added Informix "database" command.Michael Meskes2003-02-17
|
* Back off previous patch to skip projection step in scan plan nodes,Tom Lane2003-02-16
| | | | | | | 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.
* COALESCE() and NULLIF() are now first-class expressions, not macrosTom Lane2003-02-16
| | | | | that turn into CASE expressions. They evaluate their arguments at most once. Patch by Kris Jurka, review and (very light) editorializing by me.
* Update wording:Bruce Momjian2003-02-16
| | | | | < * 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
* Marginal tweaks to make sure that roundoff error won't cause us to makeTom Lane2003-02-15
| | | | a bad choice between sorted and hashed aggregation.
* Teach planner how to propagate pathkeys from sub-SELECTs in FROM up toTom Lane2003-02-15
| | | | | | | | | 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.
* Add:Bruce Momjian2003-02-15
| | | | > * Disallow DROP COLUMN on a column that is part of a multi-column index
* Propogate pg_ctl -D to the postmaster as a -D flag for identification byBruce Momjian2003-02-14
| | | | ps for multiple postmasters, for Kevin Brown.
* Fix SPI result logic for case where there are multiple statements of theTom Lane2003-02-14
| | | | same type in a rule. Per bug report from Pavel Hanak.
* Make pg_dump/restore safer for autocommit=off in postgresql.conf.Bruce Momjian2003-02-14
|
* Add:Bruce Momjian2003-02-14
| | | | > * Allow incremental backups
* In Informix mode ecpg should still be able to parse preprocessor directives.Michael Meskes2003-02-14
|
* Add:Bruce Momjian2003-02-14
| | | | > * Add schema option to createlang
* Allow PAM to work on MAC OS X, report from Aaron Hillegass.Bruce Momjian2003-02-14
| | | | Change was actually made in a previous commit.
* Update FAQ's in head and 7.3.X.Bruce Momjian2003-02-14
|
* Update to 7.3.2 as newest release.Bruce Momjian2003-02-14
|
* *** empty log message ***Bruce Momjian2003-02-14
|
* Update URL's.Bruce Momjian2003-02-14
|
* - Synced parser and keyword file.Michael Meskes2003-02-14
| | | | - More work on Informix compatibility.
* Add:Bruce Momjian2003-02-14
| | | | > * Cache last known per-tuple offsets to speed long tuple access
* Update FAQ.Bruce Momjian2003-02-14
|
* Fix broken markup I just introduced.Bruce Momjian2003-02-14
|
* Properly document location of pg_service.conf.sample.Bruce Momjian2003-02-14
|
* Fix some of the breakage from the IPV6 patch.Tom Lane2003-02-14
|
* Remove bogus manipulation of SIGPIPE; the backend already runs withTom Lane2003-02-14
| | | | SIGPIPE disabled, and does not need to waste two syscalls per I/O on it.
* Repair incorrect indexing for atttypmod, per Brad McLean.Tom Lane2003-02-13
|
* Result of lo_read() is int, not size_t. Per Oleg Drokin.Tom Lane2003-02-13
|
* Parser was dropping foreign-key constraints on the floor if present inTom Lane2003-02-13
| | | | an ALTER TABLE ADD COLUMN command. Per bug #896.
* Repair rule permissions-checking bug reported by Tim Burgess 10-Feb-02:Tom Lane2003-02-13
| | | | | the table(s) modified by the original query would get checked for the type of write permission needed by a rule query.
* Arrange to give error when a SetOp member statement refers to a variableTom Lane2003-02-13
| | | | | | | | 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.
* Just intermediate results for backup reasons.Michael Meskes2003-02-13
|
* transformExpr() was missing some cases it ought to allow; per reportTom Lane2003-02-13
| | | | | | | 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 ...
* Suppress gcc warning.Tom Lane2003-02-13
|
* Prevent timetz2tm() from scribbling on its input in HAVE_INT64_TIMESTAMP case.Tom Lane2003-02-13
|
* - Applied error reporting patch by Matthew VanecekMichael Meskes2003-02-13
| | | | - Started with an Informix compatibility option.
* [ Revert patch ]Bruce Momjian2003-02-13
| | | | | | | | | | | | | | | | | > ================================================================= > 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. > Having gotten no objections (actually, no response at all), I can only assume no one had heartburn with this change. The attached patch covers the first of the two proposals, i.e. restricting the target list to only one set returning function. Joe Conway
* Add local ident OpenBSD mention that was missing in one place.Bruce Momjian2003-02-13
|
* This patch fixes an error in the usage message for 'clusterdb', andBruce Momjian2003-02-13
| | | | | | | makes a few editorial changes to the documentation. Neil Conway
* This trivial patch removes the usage of some old statistics code that noBruce Momjian2003-02-13
| | | | | | | | | 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. Neil Conway
* > > They work the same as table constraints with in-line declaration (noBruce Momjian2003-02-13
| | | | | | | | | | | | | > > comma). > > OK. But the documentation implies there is a comma, so it should probably > get chenged then. Yes, it should. (attached) [ Backpatched to 7.3.X too.] Rod Taylor
* The attached patches change earthdistance to use the new cube functionsBruce Momjian2003-02-13
| | | | | | | | | | | | | | | 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.) The new functions were included in a recent patch to contrib/cube that has not as yet been accepted as of yet. I also added check constraints to the domain 'earth' since they are now working in 7.4. Bruno Wolff III
* The attached patch provides cube with 4 functions for building cubesBruce Momjian2003-02-13
| | | | | | | | | | | | | 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 Bruno Wolff III
* Adds in NO MAXVALUE and NO MINVALUE options for create sequence per 200XBruce Momjian2003-02-13
| | | | | | | | | spec, which will also make alter sequence a touch easier. sequence.c init_params() will check for settings which have been defined twice, and complain. Rod Taylor
* The "random" regression test uses a function called oidrand(), whichBruce Momjian2003-02-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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). This patch removes that function, because it was old and messy. The old function had the following problems: - it was undocumented - it was poorly named - it was designed to workaround an optimizer bug that no longer exists (the OID argument is to ensure that the optimizer won't optimize away calls to the function; AFAIK marking the function as 'volatile' suffices nowadays) - it used a different random-number generation technique than the other PSRNG-related functions in the backend do (it called random() like they do, but it had its own logic for setting a set and deciding when to reseed the RNG). Ok, this patch removes oidrand(), oidsrand(), and userfntest(), and improves the SGML docs a little bit (un-commenting the setseed() documentation). Neil Conway
* Code for WITHOUT OIDS.Bruce Momjian2003-02-13
| | | | | | | | | On Wed, 2003-01-08 at 21:59, Christopher Kings-Lynne wrote: > I agree. I want to remove OIDs from heaps of our tables when we go to 7.3. > I'd rather not have to do it in the dump due to down time. Rod Taylor <rbt@rbt.ca>
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 12:12:07 +0000