summaryrefslogtreecommitdiff
path: root/src/include
AgeCommit message (Collapse)Author
2002-02-18Privileges on functions and procedural languagesPeter Eisentraut
2002-02-14Ensure that a cursor is scanned under the same scanCommandId it wasTom Lane
originally created with, so that the set of visible tuples does not change as a result of other activity. This essentially makes PG cursors INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02.
2002-01-29Make S/390 TAS spell __inline__ the same way as the other eight GCCTom Lane
inline routines do.
2002-01-22libpq++/pgconnection.h must not include postgres_fe.h, else it fails toTom Lane
compile in client apps that use the standard installed header set. To allow removing that include, move DLLIMPORT definitions out of c.h and into the appropriate port-specific header files.
2002-01-16TOAST needs to do at least minimal time-qual checking in order not toTom Lane
mess up after an aborted VACUUM FULL, per today's pghackers discussion. Add a suitable HeapTupleSatisfiesToast routine. Remove useless special- case test in HeapTupleSatisfiesVisibility macro for xmax = BootstrapTransactionId; perhaps that was needed at one time, but it's a waste of cycles now, not to mention actively wrong for SnapshotAny. Along the way, add some much-needed comments to tqual.c, and simplify toast_fetch_datum, which no longer needs to assume it may see chunks out-of-order.
2002-01-15Add more sanity-checking to PageAddItem and PageIndexTupleDelete,Tom Lane
to prevent spreading of corruption when page header pointers are bad. Merge PageZero into PageInit, since it was never used separately, and remove separate memset calls used at most other PageInit call points. Remove IndexPageCleanup, which wasn't used at all.
2002-01-12Bump catversion to ensure people apply recent timestamp and sequenceTom Lane
fixes.
2002-01-12Repair bugs in declarations of routines to add timestamptz and interval.Thomas G. Lockhart
Thanks to Bruce for spotting it and Tom Lane for diagnosing it. Since horology test output is changing anyway, add some date/time input tests to horology.sql. Some of these should move to the tests for the individual data types, and we perhaps should add an entire new test for "timezone" to allow manipulating the current time zone without risking damage to the results of other tests.
2002-01-01Do not accept interrupts in RESUME_INTERRUPTS() and END_CRIT_SECTION()Tom Lane
macros, but only at explicit CHECK_FOR_INTERRUPTS() calls. Not clear whether overenthusiastic acceptance of interrupts accounts for any real bugs, but it definitely seems risky and unnecessary.
2002-01-01Rename TIME token to ISOTIME to eliminate conflict with gram.y parserThomas G. Lockhart
token. Seems to be isolated to datetime.c and datetime.h.
2001-12-29Rework the date/time parsing to tighten up some cases and to enable otherThomas G. Lockhart
cases which should have worked but did not. Now supports julian day (J2452271), ISO time labels (T040506) and various combinations of spaces and run-togethers of dates, times, and time zones. All regression tests pass, and I have more tests to add after the 7.2 release (don't want to require changes to the ancillary horology result files until after then).
2001-12-11Make sure that inlined S_UNLOCK is marked as an update of a 'volatile'Tom Lane
object. This should prevent the compiler from reordering loads and stores into or out of a critical section.
2001-12-10Suppress subquery pullup and pushdown when the subquery has anyTom Lane
set-returning functions in its target list. This ensures that we won't rewrite the query in a way that places set-returning functions into quals (WHERE clauses). Cf. bug reports from Joe Conway.
2001-12-04Replace pq_getbytes(&ch, 1) calls with pq_getbyte(), which is easierTom Lane
to use and significantly faster. This tweak saves 25% (!) of the runtime of COPY IN in a test with 8000-character lines. I wouldn't normally commit a performance improvement this late in the cycle, but 25% got my attention...
2001-12-03Add configure-time check whether sig_atomic_t is defined; if not,Tom Lane
provide a default definition equating it to 'int'. Should trigger only on machines with pre-ANSI-C header files, eg SunOS 4.1.x.
2001-12-02More correct way to check for existence of types, which allows to specifyPeter Eisentraut
which include files to consider. Should fix BeOS problems with int8 types.
2001-11-22Remove compile errors of psql.exe and libpq.dll underHiroshi Inoue
Multibyte mode.
2001-11-21Spell 'precedes', 'preceding' correctly in various places.Tom Lane
2001-11-16IsSystemRelationName() treats TOAST relations as system relations.Tom Lane
This seems the right thing for most usages, but I notice two places where it is the wrong thing. One is that the default permissions on TOAST rels should be no-access, not world-readable; the other is that PrepareForTupleInvalidation doesn't really need to spend time looking at tuples of TOAST relations.
2001-11-16Remove 'triggered data change violation' error check, per recentTom Lane
discussions in pghackers.
2001-11-15Well the absolute correct solution would involve all of:Bruce Momjian
int8, int16, int32, int64 and separately uint8, uint16, uint32, uint64 The previous patch grouped: int8, int16 and int32 uint8, uint16 and uint32 int64 and uint64 <-- this grouping is wrong on AIX 4.3.3 and below If you prefer to make 4 groups out of this you could apply this patch. Andreas
2001-11-15Fix for AIX compile and unsigned/signed typedefs.Bruce Momjian
Peter E, Tatsuo, Andreas
2001-11-12Remove duplicate extern declaration.Tom Lane
2001-11-12Remove a bunch more no-longer-used stuff in libpq-be.h.Tom Lane
2001-11-12The PacketReceive/PacketSend routines aren't used anymore.Tom Lane
2001-11-12Add comments of duplicate definitions in interfaces/odbc/md5.h.Bruce Momjian
2001-11-12Make ALTER TABLE RENAME update foreign-key trigger arguments correctly.Tom Lane
Brent Verner, with review and kibitzing from Tom Lane.
2001-11-10Clean up usage-statistics display code (ShowUsage and friends). StatFpTom Lane
is gone, usage messages now go through elog(DEBUG).
2001-11-08Fix indenting for 'extern "C"' cases.Bruce Momjian
2001-11-06Use PostgreSQL's standard declaration for a 32-bit integer to defineThomas G. Lockhart
the cash data type.
2001-11-06The extra semaphore that proc.c now allocates for checkpoint processesTom Lane
should be accounted for in the PROC_SEM_MAP_ENTRIES() macro. Otherwise the ports that rely on this macro to size data structures are broken. Mea culpa.
2001-11-05Fix coredump in plpgsql when trying to return a rowtype result.Tom Lane
Need to return a TupleTableSlot, not just a bare tuple.
2001-11-05New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian
initdb/regression tests pass.
2001-11-05CREATE TABLE foo (x,y,z) AS SELECT ... can't apply target column namesTom Lane
to the target list in gram.y; it must wait till after expansion of the target list in analyze.c. Per bug report 4-Nov: lx=# CREATE TABLE abc (a char, b char, c char); CREATE lx=# CREATE TABLE xyz (x, y, z) AS SELECT * FROM abc; ERROR: CREATE TABLE/AS SELECT has mismatched column count
2001-11-04Merge three existing ways of signaling postmaster from child processes,Tom Lane
so that only one signal number is used not three. Flags in shared memory tell the reason(s) for the current signal. This method is extensible to handle more signal reasons without chewing up even more signal numbers, but the immediate reason is to keep pg_pwd reloads separate from SIGHUP processing in the postmaster. Also clean up some problems in the postmaster with delayed response to checkpoint status changes --- basically, it wouldn't schedule a checkpoint if it wasn't getting connection requests on a regular basis.
2001-11-02Fix pg_pwd caching mechanism, which was broken by changes to forkTom Lane
postmaster children before client auth step. Postmaster now rereads pg_pwd on receipt of SIGHUP, the same way that pg_hba.conf is handled. No cycles need be expended to validate password cache validity during connection startup.
2001-11-02Fix problem reported by Alex Korn: if a relation has been dropped andTom Lane
recreated since the start of our transaction, our first reference to it errored out because we'd try to reuse our old relcache entry for it. Do this by accepting SI inval messages just before relcache search in heap_openr, so that dead relcache entries will be flushed before we search. Also, break heap_open/openr into two pairs of routines, relation_open(r) and heap_open(r). The relation_open routines make no tests on relkind and so can be used to open anything that has a pg_class entry. The heap_open routines are wrappers that add a relkind test to preserve their established behavior. Use the relation_open routines in several places that had various kluge solutions for opening rels that might be either heap or index rels. Also, remove the old 'heap stats' code that's been superseded by Jan's stats collector, and clean up some inconsistencies in error reporting between the different types of ALTER TABLE.
2001-10-30Fix problems with subselects used in GROUP BY expressions, per gripeTom Lane
from Philip Warner. Side effect of change is that GROUP BY expressions will not be re-evaluated at multiple plan levels anymore, whereas this sometimes happened with old code.
2001-10-28Another pgindent run. Fixes enum indenting, and improves #endifBruce Momjian
spacing. Also adds space for one-line comments.
2001-10-25Add int2-to-int8 and int8-to-int2 conversion routines. Needed to avoidTom Lane
breaking existing pg_dump scripts, which try to assign the result of count(*) to an int2 variable. catversion bumped.
2001-10-25pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian
tests pass.
2001-10-24Include locale.h before undefining gettext() to avoid compilation errorsPeter Eisentraut
on Solaris. per report from Lee Kindness, 2001-10-23
2001-10-23Document range restriction on bit values used in INTERVAL typmod.Tom Lane
2001-10-23Fix foreign keys on system columns.Tom Lane
2001-10-22Consolidate tables of known system attributes into one table.Tom Lane
2001-10-21Fix getopt-vs-init_ps_display problem by copying original argv[] info,Tom Lane
per suggestion from Peter. Simplify several APIs by transmitting the original argv location directly from main.c to ps_status.c, instead of passing it down through several levels of subroutines.
2001-10-20Revert change to autodetect '__getopt_initialized' variable ... turnsTom Lane
out glibc doesn't actually export this variable, so we need a different solution.
2001-10-19Proper fix for glibc getopt() botch. Surprising we did not see thisTom Lane
before.
2001-10-19Rename macro arg to avoid useless compiler warning when building plperl.Tom Lane
2001-10-18Add STATUS_EOF value needed for auth.c. Remove a bunch of unusedTom Lane
STATUS_xxx macros to reduce clutter.