- 08 7月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
> * -Prevent dropping user that still owns objects, or auto-drop the objects
-
由 Tom Lane 提交于
have adequate mechanisms for tracking the contents of databases and tablespaces). This solves the longstanding problem that you can drop a user who still owns objects and/or has access permissions. Alvaro Herrera, with some kibitzing from Tom Lane.
-
由 Bruce Momjian 提交于
< writer. > writer. It might cause problems for applying WAL on recovery > into a partially-written page, but later the full page will be > replaced from WAL.
-
- 07 7月, 2005 12 次提交
-
-
由 Bruce Momjian 提交于
> > o -Add ability to turn off full page writes > o When off, write CRC to WAL and check file system blocks > on recovery > o Write full pages during file system write and not when > the page is modified in the buffer cache > > This allows most full page writes to happen in the background > writer.
-
由 Bruce Momjian 提交于
Andrew Dunstan
-
由 Bruce Momjian 提交于
Mark Kirkwood
-
由 Bruce Momjian 提交于
plperl - the attached small patch remedies that omission, and adds a small regression test for error and warning output - the new regression input and expected output are in separate attached files. Andrew Dunstan
-
由 Bruce Momjian 提交于
plperl - the attached small patch remedies that omission. Andrew Dunstan
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
problems: --------------------------------------------------------------------------- Support cross compilation by compiling "zic" with a native compiler. This relies on the output of zic being platform independent, but that is currently the case.
-
由 Bruce Momjian 提交于
possible compression. Mark Kirkwood
-
由 Tom Lane 提交于
before, but they were out of sync again. Per Kris Jurka.
-
由 Tom Lane 提交于
could not be reached before, but now that there is a plpgsql validator function, it can be. Check is needed to prevent core dump reported by Satoshi Nagayasu. Besides, this gives a more specific and useful error message for a fairly common novice error.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
- 06 7月, 2005 11 次提交
-
-
由 Bruce Momjian 提交于
Michael Paesold
-
由 Bruce Momjian 提交于
> * -Add function to return compressed length of TOAST data values
-
由 Bruce Momjian 提交于
find myself typing a command and then wanting to get the syntax for it. So I do a ctrl-a and add a \h: but psql does not recognize the command, because I have stuff attached to it (e.g. "alter table foobar"), so I have to scroll over and delete everything except the name of the command itself. This patch gives \h three chances to match: if nothing matches the complete string (current behavior), it tries to match the first two words (e.g. "ALTER TABLE"). If that fails, it tries to match the first word (e.g. "DELETE"). Greg Sabino Mullane
-
由 Tom Lane 提交于
to make. We ship the table file in the tarball and so this dependency just opens file timestamp skew problems without doing anything useful. (Not that it should hurt, either ... except for cross-compile builds.)
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
is used in the toplevel configure. Per Marko Kreen.
-
由 Bruce Momjian 提交于
< * Turn off full page writes if fsync is disabled < < If fsync is off, there is no purpose in writing full pages to WAL <
-
由 Bruce Momjian 提交于
< 881a881,882 > o Improve xid wraparound detection by recording per-table rather > than per-database
-
由 Bruce Momjian 提交于
--------------------------------------------------------------------------- This patch allows the PL/Python module to do (SRF) functions. The patch was taken from the CVS version. I have modified the plpython.c file and have added a test sql script for testing the functionality. It was actually the script that was in the 8.0.3 version but have since been removed. In order to signal the end of a set, the called python function must simply return plpy.EndOfSet and the set would be returned. Gerrit van Dyk
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
build of zic.
-
- 05 7月, 2005 7 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
wrong. __AMD64__ is not defined, __amd64__ is. Christof Petig
-
由 Bruce Momjian 提交于
The patch was taken from the CVS version. I have modified the plpython.c file and have added a test sql script for testing the functionality. It was actually the script that was in the 8.0.3 version but have since been removed. In order to signal the end of a set, the called python function must simply return plpy.EndOfSet and the set would be returned. Gerrit van Dyk
-
由 Bruce Momjian 提交于
The content of the patch is as follows: (1)Create shortcut when subtext was not found. (2)Stop using LEFT and RIGHT macro. In LEFT and RIGHT macro, TEXTPOS is executed by the same content as execution immediately before. The execution frequency of TEXTPOS can be reduced by using text_substring instead of LEFT and RIGHT macro. (3)Add appendStringInfoText, and use it instead of appendStringInfoString. There is an overhead of PG_TEXT_GET_STR when appendStringInfoString is executed by text type. This can be reduced by appendStringInfoText. (4)Reduce execution of TEXTDUP. The effect of the patch that I measured is as follows: - The Data for test was created by 'pgbench -i'. - Test SQL: select replace(aid, '9', 'A') from accounts; - Test results: Linux(CPU: Pentium III, Compiler option: -O2) original: 1.515s patched: 1.250s Atsushi Ogawa
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 04 7月, 2005 7 次提交
-
-
由 Bruce Momjian 提交于
SELECT date_trunc('week', '2002-12-31'::date); Backpatch to 8.0.X. Per report from Nick Johnson.
-
由 Bruce Momjian 提交于
> * Allow GIST indexes to create certain complex index types, like digital > trees (see Aoki) > 783a787 >
-
由 Tom Lane 提交于
chdir into PGDATA and subsequently use relative paths instead of absolute paths to access all files under PGDATA. This seems to give a small performance improvement, and it should make the system more robust against naive DBAs doing things like moving a database directory that has a live postmaster in it. Per recent discussion.
-
由 Bruce Momjian 提交于
--------------------------------------------------------------------------- > A quick look shows that when you use --with-libraries=/foo/bar the > generated link line for libraries says > > -L/foo/bar -lpq > > and it should probably be the other way around (as it is for the > executables). > > So I suspect we need some makefile tuning. You were correct. This patch fixes it. Jim C. Nasby
-
由 Bruce Momjian 提交于
< Currently, to protect against partial disk page writes, we write the > Currently, to protect against partial disk page writes, we write 877c877 < * Turn off after-change writes if fsync is disabled > * Turn off full page writes if fsync is disabled
-
由 Neil Conway 提交于
changes.
-
由 Bruce Momjian 提交于
auto-detection of AES. Now openssl.c just checks OpenSSL version. Whoever compiles newer OpenSSL without AES is on his own. Marko Kreen
-