- 08 5月, 2004 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
in favor of using the REINDEX TABLE apparatus, which does the same thing simpler and faster. Also, make TRUNCATE not use cluster.c at all, but just assign a new relfilenode and REINDEX. This partially addresses Hartmut Raschick's complaint from last December that 7.4's TRUNCATE is an order of magnitude slower than prior releases. By getting rid of a lot of unnecessary catalog updates, these changes buy back about a factor of two (on my system). The remaining overhead seems associated with creating and deleting storage files, which we may not be able to do much about without abandoning transaction safety for TRUNCATE.
-
由 Neil Conway 提交于
printing the proper error message out of the common path.
-
由 Tom Lane 提交于
safely be marked immutable, since their results don't depend on the TimeZone GUC variable. Per recent discussion.
-
- 07 5月, 2004 13 次提交
-
-
由 Michael Meskes 提交于
- Fixed bug that reversed string length in typedefs. - Added portability file to pgtypeslib.
-
由 Tom Lane 提交于
versions of gcc. The code is correct AFAICS, but it requires slightly more analysis than usual to see that the variable can't be used uninitialized.
-
由 Teodor Sigaev 提交于
-
由 Tom Lane 提交于
by the SQL spec and by our parser. Thanks to Jonathan Scott for finding this longstanding error.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
have a more proper GUC based test. Also change error return code to ERRCODE_INVALID_PARAMETER_VALUE so it matches the old error return code.
-
由 Bruce Momjian 提交于
per-query stage stats.
-
由 Tom Lane 提交于
conversion of basic ASCII letters. Remove all uses of strcasecmp and strncasecmp in favor of new functions pg_strcasecmp and pg_strncasecmp; remove most but not all direct uses of toupper and tolower in favor of pg_toupper and pg_tolower. These functions use the same notions of case folding already developed for identifier case conversion. I left the straight locale-based folding in place for situations where we are just manipulating user data and not trying to match it to built-in strings --- for example, the SQL upper() function is still locale dependent. Perhaps this will prove not to be what's wanted, but at the moment we can initdb and pass regression tests in Turkish locale.
-
由 Bruce Momjian 提交于
> o -ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because
-
由 Bruce Momjian 提交于
recovering from an unexpected backend termination. The remaining patches are to allow whitespace in db/install directory names. Claudio Natoli
-
由 Bruce Momjian 提交于
used as salt for the MD5 password.
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
modify. Also fix a passel of problems with ALTER TABLE CLUSTER ON: failure to check that the index is safe to cluster on (or even belongs to the indicated rel, or even exists), and failure to broadcast a relcache flush event when changing an index's state.
-
- 06 5月, 2004 6 次提交
-
-
由 Tom Lane 提交于
Neil Conway.
-
由 Neil Conway 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
time_t; on some platforms they are not the same width. Per Manfred Koizar.
-
由 Tom Lane 提交于
composite types that use a domain.
-
由 Tom Lane 提交于
and unset PGCLIENTENCODING to prevent backend from dying if it's set to something incompatible with the -E option.
-
- 05 5月, 2004 4 次提交
-
-
由 Michael Meskes 提交于
- Synced parser again. - Synced lexer.
-
由 Bruce Momjian 提交于
o -ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT o -ALTER TABLE ADD COLUMN column DEFAULT should fill existing rows with DEFAULT value o -Allow ALTER TABLE to modify column lengths and change to binary compatible types Remove: o Allow columns to be reordered using ALTER ... POSITION i col1 [,col2]; have SELECT * and INSERT honor such ordering
-
由 Neil Conway 提交于
-
由 Tom Lane 提交于
* ALTER ... ADD COLUMN with defaults and NOT NULL constraints works per SQL spec. A default is implemented by rewriting the table with the new value stored in each row. * ALTER COLUMN TYPE. You can change a column's datatype to anything you want, so long as you can specify how to convert the old value. Rewrites the table. (Possible future improvement: optimize no-op conversions such as varchar(N) to varchar(N+1).) * Multiple ALTER actions in a single ALTER TABLE command. You can perform any number of column additions, type changes, and constraint additions with only one pass over the table contents. Basic documentation provided in ALTER TABLE ref page, but some more docs work is needed. Original patch from Rod Taylor, additional work from Tom Lane.
-
- 03 5月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
-
由 Bruce Momjian 提交于
-
- 02 5月, 2004 9 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> Please find a attached a small patch that adds accessor functions > for "aclitem" so that it is not an opaque datatype. > > I needed these functions to browse aclitems from user land. I can load > them when necessary, but it seems to me that these accessors for a > backend type belong to the backend, so I submit them. > > Fabien Coelho
-
由 Bruce Momjian 提交于
< o Add ALTER TABLE table SET WITHOUT CLUSTER > o Add ALTER TABLE table SET WITHOUT CLUSTER (Christopher)
-
由 Bruce Momjian 提交于
o Add ALTER TABLE table SET WITHOUT CLUSTER
-
由 Bruce Momjian 提交于
Andrew Dunstan
-
由 Bruce Momjian 提交于
* correct platform specific regression files are used under ming * pwd prints out a usable win32 pathname Claudio Natoli
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-