- 04 1月, 2001 1 次提交
-
-
由 Tom Lane 提交于
(and most other places where it needed to output a string literal, too, except for data INSERT statements). Per bug report from Easter, 12/1/00.
-
- 04 12月, 2000 1 次提交
-
-
由 Tom Lane 提交于
values, whether the local char type is signed or not. This is necessary for portability. Per discussion on pghackers around 9/16/00.
-
- 28 11月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
key exist). awn@bcs.zp.ua
-
- 25 11月, 2000 1 次提交
-
-
由 Peter Eisentraut 提交于
-
- 15 11月, 2000 1 次提交
-
-
由 Tom Lane 提交于
cloned, rather than always cloning template1. Modify initdb to generate two identical databases rather than one, template0 and template1. Connections to template0 are disallowed, so that it will always remain in its virgin as-initdb'd state. pg_dumpall now dumps databases with restore commands that say CREATE DATABASE foo WITH TEMPLATE = template0. This allows proper behavior when there is user-added data in template1. initdb forced!
-
- 14 11月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
leading slash to behave as a unix socket path.
-
- 13 11月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
hosting product, on both shared and dedicated machines. We currently offer Oracle and MySQL, and it would be a nice middle-ground. However, as shipped, PostgreSQL lacks the following features we need that MySQL has: 1. The ability to listen only on a particular IP address. Each hosting customer has their own IP address, on which all of their servers (http, ftp, real media, etc.) run. 2. The ability to place the Unix-domain socket in a mode 700 directory. This allows us to automatically create an empty database, with an empty DBA password, for new or upgrading customers without having to interactively set a DBA password and communicate it to (or from) the customer. This in turn cuts down our install and upgrade times. 3. The ability to connect to the Unix-domain socket from within a change-rooted environment. We run CGI programs chrooted to the user's home directory, which is another reason why we need to be able to specify where the Unix-domain socket is, instead of /tmp. 4. The ability to, if run as root, open a pid file in /var/run as root, and then setuid to the desired user. (mysqld -u can almost do this; I had to patch it, too). The patch below fixes problem 1-3. I plan to address #4, also, but haven't done so yet. These diffs are big enough that they should give the PG development team something to think about in the meantime :-) Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get out what I have, which works (for the problems it tackles), now. With these changes, we can set up and run PostgreSQL with scripts the same way we can with apache or proftpd or mysql. In summary, this patch makes the following enhancements: 1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT, and command line options -k --unix-socket to the relevant programs. 2. Adds a -h option to postmaster to set the hostname or IP address to listen on instead of the default INADDR_ANY. 3. Extends some library interfaces to support the above. 4. Fixes a few memory leaks in PQconnectdb(). The default behavior is unchanged from stock 7.0.2; if you don't use any of these new features, they don't change the operation. David J. MacKenzie
-
- 31 10月, 2000 1 次提交
-
-
由 Philip Warner 提交于
Prevent dumping of languages from template1.
-
- 24 10月, 2000 2 次提交
-
-
由 Philip Warner 提交于
Fix for endian bug in TAR output Nicer error messages in pg_dump
-
由 Tom Lane 提交于
kibitzing from Tom Lane. Large objects are now all stored in a single system relation "pg_largeobject" --- no more xinv or xinx files, no more relkind 'l'. This should offer substantial performance improvement for large numbers of LOs, since there won't be directory bloat anymore. It'll also fix problems like running out of locktable space when you access thousands of LOs in one transaction. Also clean up cruft in read/write routines. LOs with "holes" in them (never-written byte ranges) now work just like Unix files with holes do: a hole reads as zeroes but doesn't occupy storage space. INITDB forced!
-
- 23 10月, 2000 2 次提交
-
-
由 Philip Warner 提交于
-
由 Philip Warner 提交于
-
- 22 10月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
> Regression tests opr_sanity and sanity_check are now failing. Um, Bruce, I've said several times that I didn't think Perchine's large object changes should be applied until someone had actually reviewed them.
-
- 21 10月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
I tested it restoring my database with > 100000 BLOBS, and dumping it out. But unfortunatly I can not restore it back due to problems in pg_dump. -- Sincerely Yours, Denis Perchine
-
- 13 10月, 2000 1 次提交
-
-
由 Philip Warner 提交于
-
- 10 10月, 2000 1 次提交
-
-
由 Philip Warner 提交于
- Support for 'isstrict' procedure attribute. - Disable --blobs and --table (replaced prior to attempting to fix sequence dump problems)
-
- 18 9月, 2000 3 次提交
-
-
由 Philip Warner 提交于
-
由 Philip Warner 提交于
-
由 Tom Lane 提交于
-
- 15 9月, 2000 1 次提交
-
-
由 Philip Warner 提交于
- Use symbols for tests on relkind (ie. use RELKIND_VIEW, not 'v') - Fix bug in support for -b option (== --blobs). - Dump views as views (using 'create view'). - Remove 'isViewRule' since we check the relkind when getting tables. - Now uses temp table 'pgdump_oid' rather than 'pg_dump_oid' (errors otherwise). - Added extra param for specifying handling of OID=0 and which typename to output. - Fixed bug in SQL scanner when SQL contained braces. (in rules) - Use format_type function wherever possible
-
- 12 9月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
Here's the multibyte aware version of my patch to fix the truncation of the rulename autogenerated during a CREATE VIEW. I've modified all the places in the backend that want to construct the rulename to use the MakeRetrieveViewRuleName(), where I put the #ifdef MULTIBYTE, so that's the only place that knows how to construct a view rulename. Except pg_dump, where I replicated the code, since it's a standalone binary. The only effect the enduser will see is that views with names len(name) > NAMEDATALEN-4 will fail to be created, if the derived rulename clases with an existing rule: i.e. the user is trying to create two views with long names whose first difference is past NAMEDATALEN-4 (but before NAMEDATALEN: that'll error out after the viewname truncation.) In no case will the user get left with a table without a view rule, as the current code does. Ross Reedstrom
-
- 07 8月, 2000 1 次提交
-
-
由 Philip Warner 提交于
-
- 01 8月, 2000 1 次提交
-
-
由 Philip Warner 提交于
- Added code to dump 'Create Schema' statement (pg_dump) - Don't bother to disable/enable triggers if we don't have a superuser (pg_restore) - Cleaned up code for reconnecting to database. - Force a reconnect as superuser before enabling/disabling triggers. - Added & Removed --throttle (pg_dump) - Fixed minor bug in language dumping code: expbuffres were not being reset. - Fixed version number initialization in _allocAH (pg_backup_archiver.c) - Added second connection when restoring BLOBs to allow temp. table to survive (db reconnection causes temp tables to be lost).
-
- 24 7月, 2000 1 次提交
-
-
由 Philip Warner 提交于
- connect as appropriate user in pg_restore with db connection - dump owner of rule in pg_dump
-
- 21 7月, 2000 1 次提交
-
-
由 Philip Warner 提交于
- Support for direct DB connection in pg_restore - Fixes in support for --insert flag - pg_dump now outputs in modified OID order - various other bug fixes
-
- 17 7月, 2000 1 次提交
-
-
由 Tom Lane 提交于
There's now only one transition value and transition function. NULL handling in aggregates is a lot cleaner. Also, use Numeric accumulators instead of integer accumulators for sum/avg on integer datatypes --- this avoids overflow at the cost of being a little slower. Implement VARIANCE() and STDDEV() aggregates in the standard backend. Also, enable new LIKE selectivity estimators by default. Unrelated change, but as long as I had to force initdb anyway...
-
- 11 7月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
moment. A patch for CVS is attached, and I have amended my BLOB dumping version appropriately. Philip Warner
-
- 07 7月, 2000 1 次提交
-
-
由 Jan Wieck 提交于
- The problems Jan reported - incompatibility with configure (now uses HAVE_LIBZ instead of HAVE_ZLIB) - a problem in auto-detecting archive file format on piped archives Philip Warner
-
- 05 7月, 2000 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 04 7月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 02 7月, 2000 1 次提交
-
-
由 Peter Eisentraut 提交于
and config.h. Adjusted all referring code. Scrapped pg_version and changed initdb accordingly. Integrated src/utils/version.c into src/backend/utils/init/miscinit.c. Changed all callers. Set version number to `7.1devel'. (Non-numeric version suffixes now allowed.)
-
- 15 6月, 2000 1 次提交
-
-
由 Peter Eisentraut 提交于
we'll get there one day. Use `cat' to create aclocal.m4, not `aclocal'. Some people don't have automake installed. Only run the autoconf rule in the top-level GNUmakefile if the invoker specified `make configure', don't run it automatically because of CVS timestamp skew.
-
- 10 6月, 2000 1 次提交
-
-
由 Tom Lane 提交于
fflush(stderr)'s for good luck.
-
- 09 6月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
pg_dump -o -u some_db >dump_file works.
-
- 02 6月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
"rb" and "wb".
-
- 29 5月, 2000 1 次提交
-
-
由 Tom Lane 提交于
pg_language entries.
-
- 14 4月, 2000 1 次提交
-
-
由 Tom Lane 提交于
-
- 13 4月, 2000 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 04 4月, 2000 1 次提交
-
-
由 Tom Lane 提交于
If not, abort by default. Abort can be prevented by using -i or --ignore-version switch.
-