- 10 6月, 2001 1 次提交
-
-
由 Peter Eisentraut 提交于
for GRANT/REVOKE is now just that, not "CHANGE". On the way, migrate some of the aclitem internal representation away from the parser and build a real parse tree instead. Also add some 'const' qualifiers.
-
- 06 6月, 2001 1 次提交
-
-
由 Tom Lane 提交于
copy PUBLIC access rights into each newly created ACL entry. Instead treat each ACL entry as independent flags. Also clean up some ugliness in acl.h API.
-
- 01 6月, 2001 1 次提交
-
-
由 Tom Lane 提交于
report on old-style functions invoked by RI triggers. We had a number of other places that were being sloppy about which memory context FmgrInfo subsidiary data will be allocated in. Turns out none of them actually cause a problem in 7.1, but this is for arcane reasons such as the fact that old-style triggers aren't supported anyway. To avoid getting burnt later, I've restructured the trigger support so that we don't keep trigger FmgrInfo structs in relcache memory. Some other related cleanups too: it's not really necessary to call fmgr_info at all while setting up the index support info in relcache entries, because those ScanKeyEntry structs are never used to invoke the functions. This should speed up relcache initialization a tiny bit.
-
- 31 5月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 30 5月, 2001 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
basically want your guys feedback. I have sprinkled some of my q's thru the text delimited with the @@ symbol. It seems to work perfectly. [ Removed @@ comments because patch was reviewed. ] At the moment it does CHECK constraints only, with inheritance. However, due to the problem mentioned before with the mismatching between inherited constraints it may be wise to disable the inheritance feature for a while. it is written in an extensible fashion to support future dropping of other types of constraint, and is well documented. Please send me your comments, check my use of locking, updating of indices, use of ERROR and NOTICE, etc. and I will rework the patch based on feedback until everyone is happy with it... Christopher Kings
-
- 27 5月, 2001 1 次提交
-
-
由 Peter Eisentraut 提交于
privileges. INSERT and COPY FROM now require INSERT (only). Add privileges regression test.
-
- 21 5月, 2001 1 次提交
-
-
由 Tom Lane 提交于
create_index_paths are not immediately discarded, but are available for subsequent planner work. This allows avoiding redundant syscache lookups in several places. Change interface to operator selectivity estimation procedures to allow faster and more flexible estimation. Initdb forced due to change of pg_proc entries for selectivity functions!
-
- 19 5月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 17 5月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 15 5月, 2001 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Re-add pg_index.indisclustered in a minimalist way. Also fix BSDi dynamic linker change. #include must be before #ifdef test.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
forced.
-
- 10 5月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
constraint names. > > A reasonable interpretation of DROP CONSTRAINT "foo" is to drop *all* > > constraints named "foo" on the target table. > > Then it should probably be a good thing to avoid the automatic > generation of > duplicate names? I might take a look at that, actually... > Christopher Kings-Lynne
-
- 07 5月, 2001 1 次提交
-
-
由 Tom Lane 提交于
a separate statement (though it can still be invoked as part of VACUUM, too). pg_statistic redesigned to be more flexible about what statistics are stored. ANALYZE now collects a list of several of the most common values, not just one, plus a histogram (not just the min and max values). Random sampling is used to make the process reasonably fast even on very large tables. The number of values and histogram bins collected is now user-settable via an ALTER TABLE command. There is more still to do; the new stats are not being used everywhere they could be in the planner. But the remaining changes for this project should be localized, and the behavior is already better than before. A not-very-related change is that sorting now makes use of btree comparison routines if it can find one, rather than invoking '<' twice.
-
- 02 4月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 22 3月, 2001 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 23 2月, 2001 2 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Hiroshi Inoue 提交于
-
- 15 2月, 2001 1 次提交
-
-
由 Tom Lane 提交于
clause with an alias is a <subquery> and therefore hides table references appearing within it, according to the spec. This is the same as the preliminary patch I posted to pgsql-patches yesterday, plus some really grotty code in ruleutils.c to reverse-list a query tree with the correct alias name depending on context. I'd rather not have done that, but unless we want to force another initdb for 7.1, there's no other way for now.
-
- 13 2月, 2001 1 次提交
-
-
由 Tom Lane 提交于
two transactions create the same table name concurrently, the one that fails will complain about unique index pg_class_relname_index, rather than about pg_type_typname_index which'll confuse most people. Free side benefit: pg_class.reltype is correctly linked to the pg_type entry now. It's been zero in all but the preloaded pg_class entries since who knows when.
-
- 29 1月, 2001 1 次提交
-
-
由 Tom Lane 提交于
allocated by plan nodes are not leaked at end of query. This doesn't really matter for normal queries, but it sure does for queries invoked repetitively inside SQL functions. Clean up some other grotty code associated with tupdescs, and fix a few other memory leaks exposed by tests with simple SQL functions.
-
- 25 1月, 2001 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 24 1月, 2001 2 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Tom Lane 提交于
than forcing 'plain'. This probably does not matter right now, but I think it needs to be consistent with the regular (not-functional) index case, where attstorage is copied from the underlying table. Clean up some other dead and infelicitous code too.
-
- 23 1月, 2001 1 次提交
-
-
由 Tom Lane 提交于
bothering to check the return value --- which meant that in case the update or delete failed because of a concurrent update, you'd not find out about it, except by observing later that the transaction produced the wrong outcome. There are now subroutines simple_heap_update and simple_heap_delete that should be used anyplace that you're not prepared to do the full nine yards of coping with concurrent updates. In practice, that seems to mean absolutely everywhere but the executor, because *noplace* else was checking.
-
- 18 1月, 2001 2 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Hiroshi Inoue 提交于
the tuple is already uodated. (If LockClassinfoForUpdate() is thought to be useful).
-
- 17 1月, 2001 1 次提交
-
-
由 Tom Lane 提交于
-
- 02 1月, 2001 1 次提交
-
-
由 Tom Lane 提交于
tuples for a relation. Needed to prevent Assert failure in CLUSTER.
-
- 28 12月, 2000 1 次提交
-
-
由 Tom Lane 提交于
1. Distinguish cases where a Datum representing a tuple datatype is an OID from cases where it is a pointer to TupleTableSlot, and make sure we use the right typlen in each case. 2. Make fetchatt() and related code support 8-byte by-value datatypes on machines where Datum is 8 bytes. Centralize knowledge of the available by-value datatype sizes in two macros in tupmacs.h, so that this will be easier if we ever have to do it again.
-
- 23 12月, 2000 2 次提交
-
-
由 Tom Lane 提交于
table that inherits from a temp table. Make sure the right things happen if one creates a temp table, creates another temp that inherits from it, then renames the first one. (Previously, system would end up trying to delete the temp tables in the wrong order.)
-
由 Tom Lane 提交于
table has a child table.
-
- 14 12月, 2000 1 次提交
-
-
由 Hiroshi Inoue 提交于
-
- 10 12月, 2000 1 次提交
-
-
由 Tom Lane 提交于
-
- 08 12月, 2000 2 次提交
-
-
由 Hiroshi Inoue 提交于
-
由 Tom Lane 提交于
-