- 24 3月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
< o Add support for day-time syntax, INTERVAL '1 2:03:04' > o Add support for day-time syntax, INTERVAL '1 2:03:04' 192c192,194 < o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds' > o Interpret syntax that isn't uniquely ANSI or PG, like '1:30' or > '1' as ANSI syntax, e.g. interpret '1:30' MINUTE TO SECOND as > '1 minute 30 seconds'
-
由 Bruce Momjian 提交于
< * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND < * Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH < * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision < < Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL < MONTH), and this should return '12 months' < < * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds' > * Add ANSI INTERVAL handling > o Add support for day-time syntax, INTERVAL '1 2:03:04' > DAY TO SECOND > o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH > o Process mixed ANSI/PG syntax, and round value to requested > precision or generate an error > o Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS > INTERVAL MONTH), and this should return '12 months' > o Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds' > o Support precision, CREATE TABLE foo (a INTERVAL MONTH(3))
-
由 Tom Lane 提交于
from WAL. A couple other grammatical improvements too.
-
由 Bruce Momjian 提交于
< * Add support for ANSI date INTERVAL syntax, INTERVAL '9-3' YEAR TO MONTH > * Add support for ANSI date INTERVAL syntax, INTERVAL '20-6' YEAR TO MONTH
-
由 Bruce Momjian 提交于
< * Add support for ANSI date INTERVAL syntax, INTERVAL '1-2' YEAR TO MONTH > * Add support for ANSI date INTERVAL syntax, INTERVAL '9-3' YEAR TO MONTH
-
- 23 3月, 2005 14 次提交
-
-
由 Neil Conway 提交于
ExclusiveLock rather than AccessExclusiveLock. This will allow concurrent SELECT queries to proceed on the table. Per discussion with Andrew at SuperNews.
-
由 Bruce Momjian 提交于
> o Add MOVE to PL/pgSQL
-
由 Bruce Momjian 提交于
> o Update pg_dump and psql to use the new COPY libpq API (Christopher)
-
由 Bruce Momjian 提交于
> > * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds'
-
由 Bruce Momjian 提交于
> * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO SECOND > * Add support for ANSI date INTERVAL syntax, INTERVAL '1-2' YEAR TO MONTH > * Process mixed ANSI/PG INTERVAL syntax, and round value to requested precision 184a188,189 > Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL > MONTH), and this should return '12 months'
-
由 Bruce Momjian 提交于
< * Allow a warm standby system to also allow read-only queries
-
由 Bruce Momjian 提交于
> * Allow WAL replay of CREATE TABLESPACE to work when the directory > structure on the recovery computer is different from the original
-
由 Bruce Momjian 提交于
> o Update pg_dump and psql to use the new COPY libpq API
-
由 Bruce Momjian 提交于
< o Update to use the newer COPY syntax
-
由 Bruce Momjian 提交于
> o Update to use the newer COPY syntax
-
由 Bruce Momjian 提交于
> > * Support table partitioning that allows a single table to be stored > in subtables that are partitioned based on the primary key or a WHERE > clause
-
由 Bruce Momjian 提交于
< < o Prevent conflicting SET options from being set < < This requires a checking function to be called after the server < configuration file is read.
-
由 Tom Lane 提交于
explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context??
-
由 Tom Lane 提交于
critical places in execQual. By Atsushi Ogawa; some minor cleanup by moi.
-
- 22 3月, 2005 2 次提交
-
-
由 Tom Lane 提交于
PageIndexTupleDelete() with a single pass of compactification --- logic mostly lifted from PageRepairFragmentation. I noticed while profiling that a VACUUM that's cleaning up a whole lot of deleted tuples would spend as much as a third of its CPU time in PageIndexTupleDelete; not too surprising considering the loop method was roughly O(N^2) in the number of tuples involved.
-
由 Tom Lane 提交于
up-to-speed logic; in particular this will cause it to quote names that match keywords. Remove unnecessary multibyte cruft from quote_literal (all backend-internal encodings are 8-bit-safe).
-
- 21 3月, 2005 10 次提交
-
-
由 Neil Conway 提交于
* test error handling * add tests for des, 3des, cast5 * add some tests to blowfish, rijndael * Makefile: ability to specify different tests for different crypto libraries, so we can skip des, 3des and cast5 for builtin. Marko Kreen
-
由 Neil Conway 提交于
Reserve px_get_random_bytes() for strong randomness, add new function px_get_pseudo_random_bytes() for weak randomness and use it in gen_salt(). On openssl case, use RAND_pseudo_bytes() for px_get_pseudo_random_bytes(). Final result is that is user has not configured random souce but kept the 'silly' one, gen_salt() keeps working, but pgp_encrypt() will throw error. Marko Kreen
-
由 Neil Conway 提交于
* openssl.c: Add 3des and AES support * README.pgcrypto: list only supported ciphers for openssl OpenSSL has pre-processor symbol OPENSSL_NO_AES, which isn't that helpful for detecting if it _does_ exist. Thus the hack with AES_ENCRYPT. Marko Kreen
-
由 Neil Conway 提交于
* Use error codes instead of -1 * px_strerror for new error codes * calling convention change for px_gen_salt - return error code * use px_strerror in pgcrypto.c Marko Kreen
-
由 Neil Conway 提交于
It was a bad style to begin with, and now several loops can be clearer. * pgcrypto.c: Fix function comments * crypt-gensalt.c, crypt-blowfish.c: stop messing with errno * openssl.c: use px_free instead pfree * px.h: make redefining px_alloc/px_realloc/px_free easier Marko Kreen
-
由 Neil Conway 提交于
libmcrypt seems to dead, maintainer address bounces, and cast-128 fails on 2 of the 3 test vectors from RFC2144. So I see no reason to keep around stuff I don't trust anymore. Support for several crypto libraries is probably only confusing to users, although it was good for initial developing - it helped to find hidden assumptions and forced me to create regression tests for all functionality. Marko Kreen
-
由 Tom Lane 提交于
convention for isnull flags. Also, remove the useless InsertIndexResult return struct from index AM aminsert calls --- there is no reason for the caller to know where in the index the tuple was inserted, and we were wasting a palloc cycle per insert to deliver this uninteresting value (plus nontrivial complexity in some AMs). I forced initdb because of the change in the signature of the aminsert routines, even though nothing really looks at those pg_proc entries...
-
由 Neil Conway 提交于
rather than an integer, and fix the associated fallout. From Alvaro Herrera.
-
由 Tom Lane 提交于
EXPLAIN ANALYZE instrumentation. Magnus Hagander
-
由 Tom Lane 提交于
to write out data that we are about to tell the filesystem to drop. smgr_internal_unlink already had a DropRelFileNodeBuffers call to get rid of dead buffers without a write after it's no longer possible to roll back the deleting transaction. Adding a similar call in smgrtruncate simplifies callers and makes the overall division of labor clearer. This patch removes the former behavior that VACUUM would write all dirty buffers of a relation unconditionally.
-
- 20 3月, 2005 8 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
snprintf is called before the memory system is started. We have to just malloc/free. There are no elogs in the code so we should be fine.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
the server-side port library. Somehow I missed that change when I added memory allocation to snprintf.c.
-
由 Bruce Momjian 提交于
> * -Allow the size of the buffer cache used by temporary objects to be
-
由 Tom Lane 提交于
of the local buffer arena for temporary table access.
-
由 Tom Lane 提交于
find already-allocated local buffers. This is the last obstacle in the way of setting NLocBuffer to something reasonably large.
-
- 19 3月, 2005 1 次提交
-
-
由 Tom Lane 提交于
it's supposed to when --file option is used.
-