- 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 13 次提交
-
-
由 Bruce Momjian 提交于
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-
由 Dave Cramer 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
contains descriptions of every single system table. Update 'complex' tutorial example too.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Allow logging of query durations
-
由 Bruce Momjian 提交于
-
由 Hiroshi Inoue 提交于
-
由 Bruce Momjian 提交于
-