aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Improve error message for case where DROP TABLE is rejected becauseTom Lane2000-12-22
| | | | table has a child table.
* Add 'ONLY' to queries generated by RI triggers, so as to preserve pre-7.1Tom Lane2000-12-22
| | | | | semantics of RI operations. Eventually we ought to look at making RI work properly across inheritance trees, but not for 7.1 ...
* Change default output formatting for CIDR to be unabbreviated, perTom Lane2000-12-22
| | | | | | recommendation from Paul Vixie. Add a new abbrev() function to produce abbreviated format as text. No forced initdb, but new function is not available unless you do an initdb or add the pg_proc row manually.
* - Fixed bug in a connect statement using varchars.Michael Meskes2000-12-22
| | | | - Synced parser.
* Fix PQsetdbLogin() backward compatibility problem.Tatsuo Ishii2000-12-22
| | | | | | | | | | | | If pghost == "" and pgport == "" then PQsetdbLogin() fails with a error message: Is the postmaster running locally and accepting connections on Unix socket '/tmp/.s.PGSQL.0'? I see many applications such as PHP fails due to this behavior. Now if pgport == "", then it is assumed to be a DEF_PGPORT_STR. This is the same behavior as the version prior 7.1.
* Clean up CREATE TYPE/OPERATOR/AGGREGATE productions, so that parserTom Lane2000-12-22
| | | | will not accept types named with operator names or vice versa.
* In looking at the 7.1beta1 code for JDBC, I noticed that support wasBruce Momjian2000-12-22
| | | | | | | | | | | | | | | added to support character set encodings. However I noticed that the encoding that is used isn't obtained from the DB. Since Java uses unicode UCS2 internally the character set encoding is used to translate strings from/to the DB encoding. So it seems logical that the code would get the encoding from the DB instead of the current method of requiring the user pass it as a parameter. Attached is a patch that gets the DB encoding from the DB in the same manner as is done in libpq/fe-connect.c. The patch is created off of the latest CVS sources (Connection.java version 1.10). Barry Lind
* Revise lock manager to support "session level" locks as well as "transactionTom Lane2000-12-22
| | | | | | | | | | | | | | | | level" locks. A session lock is not released at transaction commit (but it is released on transaction abort, to ensure recovery after an elog(ERROR)). In VACUUM, use a session lock to protect the master table while vacuuming a TOAST table, so that the TOAST table can be done in an independent transaction. I also took this opportunity to do some cleanup and renaming in the lock code. The previously noted bug in ProcLockWakeup, that it couldn't wake up any waiters beyond the first non-wakeable waiter, is now fixed. Also found a previously unknown bug of the same kind (failure to scan all members of a lock queue in some cases) in DeadLockCheck. This might have led to failure to detect a deadlock condition, resulting in indefinite waits, but it's difficult to characterize the conditions required to trigger a failure.
* Repair round(numeric) function. An initdb would be required to get thePeter Eisentraut2000-12-21
| | | | fixed version, otherwise you'll continue to encounter breakage.
* Fix longstanding bug with VIEW using BETWEEN: OffsetVarNodes would getTom Lane2000-12-21
| | | | | | applied to the duplicated subtree twice. Probably someday we should fix the parser not to generate multiple links to the same subtree, but for now a quick copyObject() is the path of least resistance.
* Remove multi.c and single.c, which have been dead code forTom Lane2000-12-20
| | | | over two years.
* Prevent freshly-started backend from ignoring SIGUSR1, per race conditionTom Lane2000-12-20
| | | | | | | observed by Inoue. Also, don't call ProcRemove() from postmaster if we have detected a backend crash --- too risky if shared memory is corrupted. It's not needed anyway, considering we are going to reinitialize shared memory and semaphores as soon as the last child is dead.
* Finished build.xml and updated Driver.java.in and buildDriver to match how ↵Peter Mount2000-12-20
| | | | Makefile and ANT operate.
* Rename --accounts-only to --globals-only, polish documentation.Peter Eisentraut2000-12-19
|
* Polish PL/Perl documentation. The README file got shrunk to being aPeter Eisentraut2000-12-19
| | | | pointer into the real documentation.
* Remove inclusions of <malloc.h>.Peter Eisentraut2000-12-19
|
* Finally created ant build.xml filePeter Mount2000-12-19
|
* >> Here is a patch for the beos port (All regression tests are OK).Bruce Momjian2000-12-18
| | | | | | | | | | | | | | | | | | | | | | >> xlog.c : special case for beos to avoid 'link' which does not work yet >> beos/sem.c : implementation of new sem_ctl call (GETPID) and a new >sem_op >> flag (IPCNOWAIT) >> dynloader/beos.c : add a verification of symbol validity (seem that the >> loader sometime return OK with an invalid symbol) >> postmaster.c : add beos forking support for the new checkpoint process >> postgres.c : remove beos special case for getrusage >> beos.h : Correction of a bas definition of AF_UNIX, misc defnitions >> >> >> thanks >> >> >> cyril Cyril VELTER
* Ensure that 'errno' is saved and restored by all signal handlers thatTom Lane2000-12-18
| | | | | | might change it. Experimentation shows that the signal handler call mechanism does not save/restore errno for you, at least not on Linux or HPUX, so this is definitely a real risk.
* Updates for 7.1 branding.Bruce Momjian2000-12-18
|
* - Synced gram.y and preproc.y.Michael Meskes2000-12-18
| | | | | - Synced keyword.c. - Added several small patches from Christof.
* Make sure make_rels_by_clause_joins doesn't return multiple referencesTom Lane2000-12-18
| | | | | to same joinrel. Although make_rels_by_joins doesn't mind, GEQO has an Assert that doesn't like this.
* Tweak regressplans.sh to use any already-set PGOPTIONS.Tom Lane2000-12-18
|
* Repair mishandling of PRIMARY KEY declaration that references anTom Lane2000-12-18
| | | | inherited column, per bug report from Elphick 12/15/00.
* Clean up backend-exit-time cleanup behavior. Use on_shmem_exit callbacksTom Lane2000-12-18
| | | | | | to ensure that we have released buffer refcounts and so forth, rather than putting ad-hoc operations before (some of the calls to) proc_exit. Add commentary to discourage future hackers from repeating that mistake.
* Tweak select_common_type() to deal with possibility of multiple preferredTom Lane2000-12-17
| | | | | types in a category --- it was taking the last preferred type among the inputs, rather than the first one as intended.
* Fix linker options for ODBC driver. See comment inPeter Eisentraut2000-12-16
| | | | src/interfaces/odbc/GNUmakefile.
* Fix rules to re-generate config.h. The examples in the Autoconf manual arePeter Eisentraut2000-12-16
| | | | | flawed because the timestamp file is already updated when Makefile.global is remade, and the rule for config.h never gets run.
* Remove current->old mapping.Bruce Momjian2000-12-15
|
* Change ET_WARN to ET_NOTICE to match internal codes, leave message asBruce Momjian2000-12-15
| | | | WARNING. Fix German FAQ mention about warning.
* Make algorithm for resolving UNKNOWN function/operator inputs beTom Lane2000-12-15
| | | | insensitive to the order of arguments. Per pghackers discussion 12/10/00.
* here is a patch fixing today's bug report:Bruce Momjian2000-12-15
| | | | | | | | | | | | | | | | | | | | > Date: Thu, 14 Dec 2000 12:44:47 +0100 (CET) > From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu> > To: pgsql-bugs@postgresql.org > Subject: [BUGS] to_char() causes backend to close connection > > Hi, this query gives different strange results: > > select to_char(now()::abstime,'YYMMDDHH24MI'); > > I get e.g. a "backend closed the channel unexpectedly..." error with > successful or failed resetting attempt (indeterministic) Again thanks Kovacs, you found really designing bug, that appear if anyone write bad format template to "number" version of to_char() (as you with 'DD'). Karel
* there is one problem with Zoltan patches commited into the tree:Bruce Momjian2000-12-15
| | | | | | | if we set autocommit off and issued COMMIT (or ROLLBACK) on a connection new transaction is not started Max Khon
* List .o file explicitly as dependency, to work around a gmake bugPeter Eisentraut2000-12-15
| | | | (intermediate .o file gets deleted and rebuild on next make invocation).
* Remove obsolete comment.Tom Lane2000-12-15
|
* Print the error message before attempting to reset the connection after aPeter Eisentraut2000-12-15
| | | | backend crash.
* Remove a few remaining vestiges of elog(WARN).Tom Lane2000-12-15
|
* BugfixJan Wieck2000-12-14
| | | | | | | | Trying to connect to template0 left a global referenced buffer because the scan of pg_database wasn't ended properly before elog(FATAL). Jan
* Planner speedup hacking. Avoid saving useless pathkeys, so that pathTom Lane2000-12-14
| | | | | | | | | | | | comparison does not consider paths different when they differ only in uninteresting aspects of sort order. (We had a special case of this consideration for indexscans already, but generalize it to apply to ordered join paths too.) Be stricter about what is a canonical pathkey to allow faster pathkey comparison. Cache canonical pathkeys and dispersion stats for left and right sides of a RestrictInfo's clause, to avoid repeated computation. Total speedup will depend on number of tables in a query, but I see about 4x speedup of planning phase for a sample seven-table query.
* Make sure to not handle deactivated system indexesHiroshi Inoue2000-12-14
|
* Change StoreCatalogInheritance() to work from a list of parent relationTom Lane2000-12-14
| | | | | | OIDs rather than names. Aside from being simpler and faster, this way doesn't blow up in the face of 'create temp table foo () inherits (foo)'. Which is a rather odd thing to do, but it seems some people want to.
* Fix thinko for case of outer join where inner table is empty: shouldTom Lane2000-12-13
| | | | output first outer tuple before advancing...
* Cache eval cost of qualification expressions in RestrictInfo nodes toTom Lane2000-12-12
| | | | | | | avoid repeated evaluations in cost_qual_eval(). This turns out to save a useful fraction of planning time. No change to external representation of RestrictInfo --- although that node type doesn't appear in stored rules anyway.
* Remove elog for online log files.Vadim B. Mikheev2000-12-11
|
* Make all ODBCVER = 2.50Bruce Momjian2000-12-11
|
* Allow resultmap file to be missing, for use in contrib self-tests.Tom Lane2000-12-11
|
* Fix ODBC compile, prevent ODBCVER warning, though the version numbers goBruce Momjian2000-12-11
| | | | not match.
* elog(LOG)-->elog(DEBUG) for skipped logs.Vadim B. Mikheev2000-12-11
|
* Add Darwin-specific geometry test file.Tom Lane2000-12-11
|
* Tweak Darwin patch to get right include order.Tom Lane2000-12-11
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 23:35:29 +0000