- 26 Aug, 2002 21 commits
-
-
Bruce Momjian authored
> * Add CORRESPONDING BY to UNION/INTERSECT/EXCEPT
-
Bruce Momjian authored
-
Bruce Momjian authored
< o Add plsh server-side shell language (Peter E)
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow DELETE to handle table aliases for self-joins [delete]
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow triggers to be disabled [trigger]
-
Tom Lane authored
that ANALYZE would not gather any stats for a CHAR(255) column. I still think a width threshold is appropriate for the reasons mentioned in the code, but we can loosen it at least.
-
Tom Lane authored
array header, and to compute sizing and alignment of array elements the same way normal tuple access operations do --- viz, using the tupmacs.h macros att_addlength and att_align. This makes the world safe for arrays of cstrings or intervals, and should make it much easier to write array-type-polymorphic functions; as examples see the cleanups of array_out and contrib/array_iterator. By Joe Conway and Tom Lane.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Return proper effected tuple count from complex commands [return]
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * -Disallow TRUNCATE on tables that are involved in referential constraints
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 25 Aug, 2002 6 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Make error messages more consistent [error]
-
Tom Lane authored
width types and varlena types, since with the introduction of CSTRING as a more-or-less-real type, these concepts aren't identical. I've tried to use varlena consistently to denote datatypes with typlen = -1, ie, they have a length word and are potentially TOASTable; while the term variable width covers both varlena and cstring (and, perhaps, someday other types with other rules for computing the actual width). No code changes in this commit except for renaming a couple macros.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 24 Aug, 2002 2 commits
-
-
Tom Lane authored
value '-2' is used to indicate a variable-width type whose width is computed as strlen(datum)+1. Everything that looks at typlen is updated except for array support, which Joe Conway is working on; at the moment it wouldn't work to try to create an array of cstring.
-
Bruce Momjian authored
> * -SELECT cash_out(2) crashes because of opaque
-
- 23 Aug, 2002 11 commits
-
-
Barry Lind authored
the server. Previously we allocated a new String object for the entire final query we were sending to the database. If you had a big query, or especially if you had large bind values you ended up with essentially two copies in memory. This change will reuse the existing objects and therefore should take 1/2 the memory it does today for a given query. This restructuring will also allow in the future the ability to stream bytea data to the server instead of the current approach of pulling it all into memory. I also fixed a test that was failing on a 7.2 database. Also renamed some internal variables and some minor cleanup. Modified Files: jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java
-
Tom Lane authored
the declarations of some index access method support functions. Support SQL functions returning VOID.
-
Tatsuo Ishii authored
-
Bruce Momjian authored
instance in which the docs mention that 'NAMEDATALEN == 32". Neil Conway
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow xlog directory location to be specified during initdb, perhaps > using symlinks
-
Bruce Momjian authored
Teodor Sigaev
-
Bruce Momjian authored
settings of NAMEDATALEN. I looked through the docs for other references to NAMEDATALEN, but this is the only one I could find. Neil Conway
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Add GUC parameter to print queries that generate errors
-
Tom Lane authored
-