- 31 7月, 2002 6 次提交
-
-
由 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 18 次提交
-
-
由 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 提交于
-
由 Tom Lane 提交于
copied more places than I first thought it would. This fixes a bug: a couple of these places were neglecting to enforce USAGE access on explicitly-referenced schemas.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
documentation (xindex.sgml should be rewritten), need to teach pg_dump about it, need to update contrib modules that currently build pg_opclass entries by hand. Original patch by Bill Studenmund, grammar adjustments and general update for 7.3 by Tom Lane.
-
由 Bruce Momjian 提交于
< o ALTER TABLE ADD COLUMN column SET DEFAULT should fill existing > o ALTER TABLE ALTER COLUMN column SET DEFAULT should fill existing
-
由 Tom Lane 提交于
cache entry.
-
- 29 7月, 2002 1 次提交
-
-
由 Tatsuo Ishii 提交于
-
- 28 7月, 2002 3 次提交
-
-
由 Peter Eisentraut 提交于
Add information about environment variables.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
Some makefile simplifications.
-
- 26 7月, 2002 4 次提交
-
-
由 Hiroshi Inoue 提交于
reported by Sergey Smirnov.
-
由 Barry Lind 提交于
Modified Files: jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSetMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSetMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSetMetaData.java Removed Files: jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/ResultSetMetaData.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/ResultSetMetaData.java
-
由 Barry Lind 提交于
Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/DatabaseMetaData.java jdbc/org/postgresql/jdbc1/Jdbc1Connection.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/DatabaseMetaData.java jdbc/org/postgresql/jdbc2/Jdbc2Connection.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java Added Files: jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java Removed Files: jdbc/org/postgresql/jdbc1/CallableStatement.java jdbc/org/postgresql/jdbc2/CallableStatement.java jdbc/org/postgresql/jdbc2/UpdateableResultSet.java
-
由 Peter Eisentraut 提交于
-
- 25 7月, 2002 6 次提交
-
-
由 Tatsuo Ishii 提交于
Add regression test
-
由 Barry Lind 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.)
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> * -Add Intimate Shared Memory(ISM) for Solaris
-
- 24 7月, 2002 2 次提交
-
-
由 Tatsuo Ishii 提交于
English README will come soon...
-
由 Tatsuo Ishii 提交于
-