- 24 6月, 2001 3 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
message in that case.
-
由 Bruce Momjian 提交于
> > secure_ctx changes too. it will be PGC_BACKEND after '-p'. > > Oh, okay, I missed that part. Could we see the total state of the > patch --- ie, a diff against current CVS, not a bunch of deltas? > I've gotten confused about what's in and what's out. Ok, here it is. Cleared the ctx comment too - after -p it will be PGC_BACKEND in any case. Marko Kreen
-
- 23 6月, 2001 9 次提交
-
-
由 Bruce Momjian 提交于
Oracle database to PostgreSQL. It currently dump the database schema (tables, views, sequences, indexes, grants), with primary, unique and foreign keys into PostgreSQL syntax without editing the SQL code generated. You can dump only a particular schema from the Oracle database. Functions, procedures and triggers with SQL or PLSQL code generated must be reviewed to match the PostgreSQL syntax. Some usefull recommandation on porting Oracle to PostgreSQL can be found at http://techdocs.postgresql.org/ under the "Converting from other Databases to PostgreSQL" Oracle part. I just notice one thing more is that the trunc() function in Oracle is the same for number or date so be carefull when porting to PostgreSQL to use trunc() for number and date_trunc() for date. I will add more precision in type NUMBER conversion based on length to match as closest as possible all rich PostgreSQL numerics type. But it seems not to be urgent as it seems that Oracle DBAs only create number with length 22 (default) Space seems not to be their problem... Gilles DAROLD
-
由 Bruce Momjian 提交于
sequence.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
Alex Pilosov
-
由 Jan Wieck 提交于
Jan
-
由 Jan Wieck 提交于
it's hard to keep such massive changes in sync with the tree so I need to get it in and work from there now). Jan
-
由 Tom Lane 提交于
to large tables. Recommend ANALYZE or VACUUM ANALYZE after populating a table.
-
由 Peter Eisentraut 提交于
oid values.
-
- 22 6月, 2001 6 次提交
-
-
由 Hiroshi Inoue 提交于
other than tablename_pkey.
-
由 Tom Lane 提交于
return without waiting if we can't get the lock immediately). Not used yet, but will be needed for concurrent VACUUM.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
ordering of startup operations in one or two places.
-
- 21 6月, 2001 6 次提交
-
-
由 Peter Eisentraut 提交于
(see http://mail.gnu.org/pipermail/libtool/2000-July/001824.html). But apparently it should still be present with -Bsymbolic.
-
由 Peter Eisentraut 提交于
from Johnny C. Lam <lamj@stat.cmu.edu> via D'Arcy
-
由 Peter Eisentraut 提交于
to be missing in some header files (on OpenBSD 2.8?).
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
a new postmaster child process. This should eliminate problems with authentication blocking (e.g., ident, SSL init) and also reduce problems with the accept queue filling up under heavy load. The option to send elog output to a different file per backend (postgres -o) has been disabled for now because the initialization would have to happen in a different order and it's not clear we want to keep this anyway.
-
- 20 6月, 2001 9 次提交
-
-
由 D'Arcy J.M. Cain 提交于
-
由 D'Arcy J.M. Cain 提交于
make sure that we are using the right #defines in pgmodule.c but the OIDs are never actually expected to change.
-
由 Hiroshi Inoue 提交于
by multiple SQLError calls.
-
由 Bruce Momjian 提交于
broken, and its impossible to make a shared library when compiling with both CCDLFLAGS and LDDLFAGS, you have to pick one or the other. Alex Pilosov
-
由 Bruce Momjian 提交于
around. I tested this patch under Cygwin and Linux. Note that I only changed dblink's Makefile in the most minimal way to fix the link problem under Cygwin (i.e., use the link rule from Makefile.shlib instead). dblink's Makefile should probably be further patched to be consistent with the other PostgreSQL Makefiles. Jason Tishler
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
tests to return the correct results per SQL9x when given NULL inputs. Reimplement these tests as well as IS [NOT] NULL to have their own expression node types, instead of depending on special functions. From Joe Conway, with a little help from Tom Lane.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
SI messages now include the relevant database OID, so that operations in one database do not cause useless cache flushes in backends attached to other databases. Declare SI messages properly using a union, to eliminate the former assumption that Oid is the same size as int or Index. Rewrite the nearly-unreadable code in inval.c, and document it better. Arrange for catcache flushes at end of command/transaction to happen before relcache flushes do --- this avoids loading a new tuple into the catcache while setting up new relcache entry, only to have it be flushed again immediately.
-
- 19 6月, 2001 7 次提交
-
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
Quick hack -- need to decide which header should include the other.
-
由 Hiroshi Inoue 提交于
-
由 Hiroshi Inoue 提交于
1) ERRORs cause an SQL_ERROR and the SQLSTATE='S1000'. 2) NOTICEs cause an SQL_SUCCESS_WITH_INFO and the succeeding SQLError() returns the NOTICE message.
-
由 Bruce Momjian 提交于
Here is Tomified version of my 2 pending patches. Dropped the set_.._real change as it is not needed. Desc would be: * use GUC for settings from cmdline Marko Kreen
-
由 Bruce Momjian 提交于
modifiable repositories, I have a clean untrusted plperl patch to offer you :) Highlights: * There's one perl interpreter used for both trusted and untrusted procedures. I do think its unnecessary to keep two perl interpreters around. If someone can break out from trusted "Safe" perl mode, well, they can do what they want already. If someone disagrees, I can change this. * Opcode is not statically loaded anymore. Instead, we load Dynaloader, which then can grab Opcode (and anything else you can 'use') on its own. * Checked to work on FreeBSD 4.3 + perl 5.5.3 , OpenBSD 2.8 + perl5.6.1, RedHat 6.2 + perl 5.5.3 * Uses ExtUtils::Embed to find what options are necessary to link with perl shared libraries * createlang is also updated, it can create untrusted perl using 'plperlu' * Example script (assuming you have Mail::Sendmail installed): create function foo() returns text as ' use Mail::Sendmail; %mail = ( To => q(you@yourname.com), From => q(me@here.com), Message => "This is a very short message" ); sendmail(%mail) or die $Mail::Sendmail::error; return "OK. Log says:\n", $Mail::Sendmail::log; ' language 'plperlu'; Alex Pilosov
-
由 Bruce Momjian 提交于
Cygwin with the possible exception of mSQL-interface. Since I don't have mSQL installed, I skipped this tool. Except for dealing with a missing getopt.h (oid2name) and HUGE (seg), the bulk of the patch uses the standard PostgreSQL approach to deal with Windows DLL issues. I tested the build aspect of this patch under Cygwin and Linux without any ill affects. Note that I did not actually attempt to test the code for functionality. The procedure to apply the patch is as follows: $ # save the attachment as /tmp/contrib.patch $ # change directory to the top of the PostgreSQL source tree $ patch -p0 </tmp/contrib.patch Jason
-