summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2002-06-07Fix for factorial(0::int2) returning 1, from sugita@sra.co.jp.Bruce Momjian
2002-06-07The attached patch fixes a problem with InstallXLogFileSegment()'s useBruce Momjian
of link() under Cygwin: http://archives.postgresql.org/pgsql-cygwin/2002-04/msg00072.php Note that it appears that BeOS and Netware also have the above or similar problem. I have only verified that PostgreSQL builds under Cygwin with this patch. Since I cannot reproduce the problem, I cannot verify that the proposed patch solves it. Nevertheless, both Barry Pederson and David P. Caldwell attest that this patch solves the problem. See the following for details: http://archives.postgresql.org/pgsql-cygwin/2002-05/msg00043.php http://archives.postgresql.org/pgsql-cygwin/2002-05/msg00040.php Jason Tishler
2002-06-07Remove int16 from libpgeasy examples. Improve error reporting.Bruce Momjian
2002-06-07fixed bug reported by cc.ais40@wanadoo.fr where getObject was returning an ↵Barry Lind
Integer for a smallint datatype instead of a Short
2002-06-07Fix interface example errors causes by backend changes.Bruce Momjian
Permaine Cheung
2002-06-06change table name to lower case in getColumnsDave Cramer
2002-06-06Add missing win_setup.h.Hiroshi Inoue
2002-06-06Add *Int8 As* option.Hiroshi Inoue
2002-06-05fixed getImported/ExportedKeys to be simpler, and return the correct number ↵Dave Cramer
of keys
2002-06-03Document that SM_* variables should be longer.Bruce Momjian
2002-06-03fixed bug reported by Noel Rappin (nrappin@sockeye.com) java Array type ↵Barry Lind
handled Timestamps incorrectly
2002-06-03Small patch to correct the default arraysize associatedBruce Momjian
with the Cursor object's fetchmany() method. The API and inline documentation state that the default is 1. It currently defaults to 5. Patrick Macdonald
2002-06-03Mention SM_USER should be the same size as the others.Bruce Momjian
2002-06-02Add PQescapeString and PQescapeBytea for Win32.Bruce Momjian
2002-06-02Allow pod2man 5.005p3 to work with our current sources.Bruce Momjian
2002-06-01Fix timestamp to date conversion for the case where timestamp uses a doubleThomas G. Lockhart
precision storage format. Previously applied the same math as used for the 64-bit integer storage format case, which was wrong. Problem introduced recently when the 64-bit storage format was implemented.
2002-05-30small fix to testExportedKeysDave Cramer
2002-05-30added imported/exported key testDatabaseMetaDataTest.javaDave Cramer
2002-05-29Another place that needs schema qualification.Tom Lane
2002-05-29Fix some more not-schema-aware queries in pg_dump. Also fix some placesTom Lane
that would do the wrong thing with BLOB OIDs exceeding 2G.
2002-05-28Rearrange LOG_CONNECTIONS code so that two log messages are made:Tom Lane
one immediately upon forking to handle a new connection, and one after the authentication cycle is finished. Per today's pggeneral discussion.
2002-05-28Rework pg_dump namespace search criteria so that dumping of user objectsTom Lane
having names conflicting with system objects will work --- the search path is now user-schema, pg_catalog rather than implicitly the other way around. Note this requires being careful to explicitly qualify references to system names whenever pg_catalog is not first in the search path. Also, add support for dumping ACLs of schemas.
2002-05-28Queries used by ruleutils were not schema-proof.Tom Lane
2002-05-28In default nextval('foo') expression for a SERIAL column, use doubleTom Lane
quotes only when necessary.
2002-05-28Change PL/Perl and Pg interface build to use configured compiler andPeter Eisentraut
Makefile.shlib system, not MakeMaker.
2002-05-28Repair error with not adjusting active scans properly after gistSplit.Tom Lane
Patch from Teodor Sigaev.
2002-05-27Distinguish between MaxHeapAttributeNumber and MaxTupleAttributeNumber,Tom Lane
where the latter is made slightly larger to allow for in-memory tuples containing resjunk attributes. Responds to today's complaint that one cannot UPDATE a table containing the allegedly-legal maximum number of columns. Also, apply Manfred Koizar's recent patch to avoid extra alignment padding when there is a null bitmap. This saves bytes in some cases while not creating any backward-compatibility problem AFAICS.
2002-05-25Remove AMI_OVERRIDE tests from tqual.c routines; they aren't necessaryTom Lane
and just slow down normal operations (only fractionally, but a cycle saved is a cycle earned). Improve documentation of AMI_OVERRIDE behavior.
2002-05-25AlterDatabaseSet() forgot to update the indexes on pg_database.Tom Lane
2002-05-24Fix coding error in UTF conversion.Tom Lane
2002-05-24Add 'volatile' to suppress gcc warning. Not sure why this warningTom Lane
wasn't seen before, maybe the Tcl compiler flags were less strict.
2002-05-24Wups, managed to break ANALYZE with one aspect of that heap_fetch change.Tom Lane
2002-05-24Mark index entries "killed" when they are no longer visible to anyTom Lane
transaction, so as to avoid returning them out of the index AM. Saves repeated heap_fetch operations on frequently-updated rows. Also detect queries on unique keys (equality to all columns of a unique index), and don't bother continuing scan once we have found first match. Killing is implemented in the btree and hash AMs, but not yet in rtree or gist, because there isn't an equally convenient place to do it in those AMs (the outer amgetnext routine can't do it without re-pinning the index page). Did some small cleanup on APIs of HeapTupleSatisfies, heap_fetch, and index_insert to make this a little easier.
2002-05-24Change PL/Tcl build to use configured compiler and Makefile.shlibPeter Eisentraut
system, not Tcl-provided one. Make sure export file, if any, is cleaned. Tcl configuration is now read directly in configure and recorded in Makefile.global. This eliminates some duplicate efforts and allows for easier hand-editing of the results, if necessary.
2002-05-22Add $(LDFLAGS) to Windows make rule for postgres executable. NeededTom Lane
to do profiling on Cygwin, per report from Dave Page.
2002-05-22Modify sequence state storage to eliminate dangling-pointer problemTom Lane
exemplified by bug #671. Moving the storage to relcache turned out to be a bad idea because relcache might decide to discard the info. Instead, open and close the relcache entry on each sequence operation, and use a record of the current XID to discover whether we already hold AccessShareLock on the sequence.
2002-05-22Minor kibitzing.Tom Lane
2002-05-22Add optional "validator" function to languages that can validate thePeter Eisentraut
function body (and other properties) as a function in the language is created. This generalizes ad hoc code that already existed for the built-in languages. The validation now happens after the pg_proc tuple of the new function is created, so it is possible to define recursive SQL functions. Add some regression test cases that cover bogus function definition attempts.
2002-05-22Make RelationForgetRelation error out if the relcache entry has nonzeroTom Lane
reference count. This avoids leaving dangling pointers around, as in recent bug report against sequences (bug# 671).
2002-05-22Un-break table creation.Tom Lane
2002-05-22AllowHiroshi Inoue
CREATE VIEW as SELECT CTID, .... SELECT currtid( a view, ..).
2002-05-221) Support Keyset Driven driver cursors.Hiroshi Inoue
2) Supprt ARD precision/scale and SQL_C_NUEMRIC. 3) Minimal implementation of SQLGetDiagField(). 4) SQLRowCount() reports the result of SQLSetPos and SQLBulkOperation. 5) int8 -> SQL_NUMERIC for Microsoft Jet. 6) Support isolation level change. 7) ODBC3.0 SQLSTATE code. 8) Append mode log files.
2002-05-21Since COPY fires triggers, it seems like a good idea for it to useTom Lane
a frozen (copied) snapshot too. Move execMain's snapshot copying code out into a subroutine in case we find other places that need it.
2002-05-21Remove SetQuerySnapshot() from FETCH processing. No longer necessaryTom Lane
or appropriate, since the snapshot that will be used by the cursor was frozen when ExecutorStart was run for it.
2002-05-21Remove global variable scanCommandId in favor of storing a command IDTom Lane
in snapshots, per my proposal of a few days ago. Also, tweak heapam.c routines (heap_insert, heap_update, heap_delete, heap_mark4update) to be passed the command ID to use, instead of doing GetCurrentCommandID. For catalog updates they'll still get passed current command ID, but for updates generated from the main executor they'll get passed the command ID saved in the snapshot the query is using. This should fix some corner cases associated with functions and triggers that advance current command ID while an outer query is still in progress.
2002-05-21Spell long option with -c not --, for compatibility's sake.Tom Lane
2002-05-21Repair OPEN cursor(args), which I broke on 11/29/01 with a change toTom Lane
be smarter about parentheses in read_sql_construct(). Sigh.
2002-05-20Restructure indexscan API (index_beginscan, index_getnext) perTom Lane
yesterday's proposal to pghackers. Also remove unnecessary parameters to heap_beginscan, heap_rescan. I modified pg_proc.h to reflect the new numbers of parameters for the AM interface routines, but did not force an initdb because nothing actually looks at those fields.
2002-05-20 - Fixed some parser bugs.Michael Meskes
- Removed some simple rules to work arounf bison limit for now. - Update c_keywords.c to reflect changes in keywords.c.
2002-05-19 - Fixed reduce/reduce conflict in parser.Michael Meskes
- Synced preproc.y with gram.y. - Synced pgc.l with scan.l. - Synced keywords.c.