- 04 8月, 2002 1 次提交
-
-
由 Bruce Momjian 提交于
functions. If there are no objections, please apply. Joe Conway
-
- 03 8月, 2002 6 次提交
-
-
由 Tom Lane 提交于
in the relcache. It's rather silly that we have reference count leak checks in bufmgr and in catcache, but not in relcache which will normally have many fewer entries. Chris K-L would have caught at least one bug in his recent DROP patch if he'd had this.
-
由 Tom Lane 提交于
relation being modified. In most paths of control we'd already have such a lock, but if we were dropping the default due to a cascaded delete of some function it depended on, maybe not.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> o -Add ALTER TABLE DROP COLUMN feature
-
由 Bruce Momjian 提交于
> o -Add ALTER TABLE DROP COLUMN feature [drop]
-
由 Tom Lane 提交于
code review by Tom Lane. Remaining issues: functions that take or return tuple types are likely to break if one drops (or adds!) a column in the table defining the type. Need to think about what to do here. Along the way: some code review for recent COPY changes; mark system columns attnotnull = true where appropriate, per discussion a month ago.
-
- 01 8月, 2002 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Hiroshi Inoue 提交于
whose first non-space character is '('. 2) Handle Insert .. () VALUES ().
-
由 Tom Lane 提交于
attstattarget to indicate 'use the default'. The default is now a GUC variable default_statistics_target, and so may be changed on the fly. Along the way we gain the ability to have pg_dump dump the per-column statistics target when it's not the default. Patch by Neil Conway, with some kibitzing from Tom Lane.
-
- 31 7月, 2002 27 次提交
-
-
由 Bruce Momjian 提交于
> * -Remove LockMethodTable.prio field, not used (Bruce)
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * -Add getpid() function to backend
-
由 Tom Lane 提交于
this only works against 7.3 or later databases; the pushups required to do it without regprocedure/regtype/etc seem more trouble than they're worth, considering that existing users aren't expecting pg_dump support for this.
-
由 Bruce Momjian 提交于
< o ALTER TABLE ADD COLUMN column SET DEFAULT should fill existing > o ALTER TABLE ADD COLUMN column DEFAULT should fill existing
-
由 Bruce Momjian 提交于
< o ALTER TABLE ALTER COLUMN column SET DEFAULT should fill existing > o ALTER TABLE ADD COLUMN column SET DEFAULT should fill existing
-
由 Bruce Momjian 提交于
All of the internal tags are of the latter. The other thing I noticed is that most of the quick examples in the file use a para and synopsis. Is there a reason we're not using <example/> ? Rod Taylor
-
由 Bruce Momjian 提交于
> * Use CHECK constraints to improve optimizer decisions
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
OPERATOR CLASS commands.
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
OPERATOR CLASS commands. Further tweaking of documentation for same.
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
> o -Generate failure on short COPY lines rather than pad NULLs
-
由 Bruce Momjian 提交于
'tioga recipes', whatever those are -- Peter E. killed most of it a couple days ago, but this patch removes the rest. Most of it was #ifdef'ed out anyway. Neil Conway
-
由 Bruce Momjian 提交于
The attached patch completes the following TODO item: * Generate failure on short COPY lines rather than pad NULLs I also restructed a lot of the existing COPY code, did some code review on the column list patch sent in by Brent Verner a little while ago, and added some regression tests. I also added an explicit check (and resultant error) for extra data before the end-of-line. Neil Conway
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
a few other things: * Made all references to the pg_* tables absolute, by specifying the pg_catalog schema. * Added SCHEMA as a create/delete completion option. * Added SCHEMA completion as: SELECT nspname FROM pg_catalog.pg_namespace WHERE substr(nspname,1,%d)='%s' * Added completion of "INSERT INTO <table> (" with attribute names. * Added completion of "INSERT INTO <table> (attribs)" with VALUES or SELECT * Added limited locking completion: only for one table: "LOCK" and "LOCK TABLE" now both get a completion list of tables Complete with "IN" for LOCK [TABLE] <table> Complete LOCK [TABLE] <table> IN with a lock mode * Added a very simple WHERE finisher that uses the previous word as a table lookup for attributes. * Added quote support when parsing "previous words". In other words, hitting tab after INSERT INTO "foo bar baby" now does the right thing and recognizes "foo bar baby" as one word. Letting tab-complete quote things that should be quoted seems to be temporarily ifdef'ed out due to readline compatibility problems. Can anyone elaborate on this? Greg Sabino Mullane
-
由 Bruce Momjian 提交于
deleted that had another row inserted/updated to its old value during the same statement or other statements before the integrity check for noaction would incorrectly error. This could happen in deferred constraints or due to triggers or functions. It's effectively a reworking of the previous patch that did a not exists to instead do a separate check. Stephan Szabo
-
由 Tom Lane 提交于
we may as well use it in all our flex files. Make all the flex files have a consistent set of options.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
three functions which exercise the tablefunc API. show_all_settings() - returns the same information as SHOW ALL, but as a query result normal_rand(int numvals, float8 mean, float8 stddev, int seed) - returns a set of normally distributed float8 values - This routine implements Algorithm P (Polar method for normal deviates) from Knuth's _The_Art_of_Computer_Programming_, Volume 2, 3rd ed., pages 122-126. Knuth cites his source as "The polar method", G. E. P. Box, M. E. Muller, and G. Marsaglia, _Annals_Math,_Stat._ 29 (1958), 610-611. crosstabN(text sql) - returns a set of row_name plus N category value columns - crosstab2(), crosstab3(), and crosstab4() are defined for you, but you can create additional crosstab functions per directions in the README. Joe Conway
-
由 Bruce Momjian 提交于
changes mentioned above, and also adds a new function to the tablefunc API. The tablefunc API change adds the following function: * Oid foidGetTypeId(Oid foid) - Get a function's typeid given the * function Oid. Use this together with TypeGetTupleDesc() to get a * TupleDesc which is derived from the function's declared return type. In the next post I'll send the contrib/tablefunc patch, which illustrates the usage of this new function. Also attached is a doc patch for this change. The doc patch also adds a function that I failed to document previously. Joe Conway
-
由 Bruce Momjian 提交于
hard to reproduce) error conditions. Manfred Koizar
-
- 30 7月, 2002 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-