From 6b23ba1093d298a41463a24f091c6f86be406449 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 29 Jun 2011 09:26:14 +0300 Subject: [PATCH] Unify spelling of "canceled", "canceling", "cancellation" We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard. --- doc/src/sgml/high-availability.sgml | 12 +++---- doc/src/sgml/indexam.sgml | 2 +- doc/src/sgml/libpq.sgml | 2 +- doc/src/sgml/monitoring.sgml | 14 ++++---- doc/src/sgml/protocol.sgml | 2 +- doc/src/sgml/ref/set_transaction.sgml | 2 +- doc/src/sgml/release-7.4.sgml | 2 +- doc/src/sgml/release-8.0.sgml | 2 +- doc/src/sgml/release-8.1.sgml | 4 +-- doc/src/sgml/release-8.2.sgml | 2 +- doc/src/sgml/release-8.3.sgml | 2 +- doc/src/sgml/release-8.4.sgml | 2 +- doc/src/sgml/release-9.1.sgml | 2 +- src/backend/access/transam/xlog.c | 12 +++---- src/backend/commands/vacuum.c | 4 +-- src/backend/postmaster/autovacuum.c | 4 +-- src/backend/postmaster/bgwriter.c | 2 +- src/backend/storage/buffer/bufmgr.c | 2 +- src/backend/storage/lmgr/README-SSI | 6 ++-- src/backend/storage/lmgr/deadlock.c | 2 +- src/backend/storage/lmgr/predicate.c | 22 ++++++------ src/backend/storage/lmgr/proc.c | 2 +- src/backend/tcop/postgres.c | 2 +- src/backend/utils/cache/relcache.c | 2 +- src/bin/psql/common.c | 2 +- src/bin/scripts/common.c | 2 +- src/port/path.c | 2 +- src/test/regress/expected/prepared_xacts.out | 2 +- src/test/regress/expected/subselect.out | 36 ++++++++++---------- src/test/regress/sql/subselect.sql | 10 +++--- 30 files changed, 82 insertions(+), 82 deletions(-) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index 80665a5cb2..0d3baa04bc 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1585,7 +1585,7 @@ if (!triggered) There are also additional types of conflict that can occur with Hot Standby. These conflicts are hard conflicts in the sense that queries - might need to be cancelled and, in some cases, sessions disconnected to resolve them. + might need to be canceled and, in some cases, sessions disconnected to resolve them. The user is provided with several ways to handle these conflicts. Conflict cases include: @@ -1682,7 +1682,7 @@ if (!triggered) Once the delay specified by max_standby_archive_delay or max_standby_streaming_delay has been exceeded, conflicting - queries will be cancelled. This usually results just in a cancellation + queries will be canceled. This usually results just in a cancellation error, although in the case of replaying a DROP DATABASE the entire conflicting session will be terminated. Also, if the conflict is over a lock held by an idle transaction, the conflicting session is @@ -1690,10 +1690,10 @@ if (!triggered) - Cancelled queries may be retried immediately (after beginning a new + Canceled queries may be retried immediately (after beginning a new transaction, of course). Since query cancellation depends on the nature of the WAL records being replayed, a query that was - cancelled may well succeed if it is executed again. + canceled may well succeed if it is executed again. @@ -1751,7 +1751,7 @@ if (!triggered) Another option is to increase on the primary server, so that dead rows will not be cleaned up as quickly as they normally would be. This will allow more time for queries to - execute before they are cancelled on the standby, without having to set + execute before they are canceled on the standby, without having to set a high max_standby_streaming_delay. However it is difficult to guarantee any specific execution-time window with this approach, since vacuum_defer_cleanup_age is measured in @@ -1981,7 +1981,7 @@ LOG: database system is ready to accept read only connections DROP TABLESPACE can only succeed if the tablespace is empty. Some standby users may be actively using the tablespace via their temp_tablespaces parameter. If there are temporary files in the - tablespace, all active queries are cancelled to ensure that temporary + tablespace, all active queries are canceled to ensure that temporary files are removed, so the tablespace can be removed and WAL replay can continue. diff --git a/doc/src/sgml/indexam.sgml b/doc/src/sgml/indexam.sgml index c7e997793d..bb94258385 100644 --- a/doc/src/sgml/indexam.sgml +++ b/doc/src/sgml/indexam.sgml @@ -712,7 +712,7 @@ amrestrpos (IndexScanDesc scan); read-write conflict with the insert of any tuple into that index by a concurrent serializable transaction. If certain patterns of read-write conflicts are detected among a set of concurrent serializable - transactions, one of those transactions may be cancelled to protect data + transactions, one of those transactions may be canceled to protect data integrity. When the flag is set, it indicates that the index access method implements finer-grained predicate locking, which will tend to reduce the frequency of such transaction cancellations. diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 3a57295bd3..fd8b534356 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -4088,7 +4088,7 @@ int PQflush(PGconn *conn); - Cancelling Queries in Progress + Canceling Queries in Progress canceling diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 553c16873f..8da8f85e70 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -282,7 +282,7 @@ postgres: user database host @@ -290,7 +290,7 @@ postgres: user database host pg_stat_database_conflictspg_stat_database_conflicts One row per database, showing database OID, database name and - the number of queries that have been cancelled in this database due to + the number of queries that have been canceled in this database due to dropped tablespaces, lock timeouts, old snapshots, pinned buffers and deadlocks. Will only contain information on standby servers, since conflicts do not occur on master servers. @@ -639,7 +639,7 @@ postgres: user database host pg_stat_get_db_conflict_tablespace(oid) bigint - Number of queries cancelled because of recovery conflict with dropped tablespaces in database + Number of queries canceled because of recovery conflict with dropped tablespaces in database @@ -647,7 +647,7 @@ postgres: user database host pg_stat_get_db_conflict_lock(oid) bigint - Number of queries cancelled because of recovery conflict with locks in database + Number of queries canceled because of recovery conflict with locks in database @@ -655,7 +655,7 @@ postgres: user database host pg_stat_get_db_conflict_snapshot(oid) bigint - Number of queries cancelled because of recovery conflict with old snapshots in database + Number of queries canceled because of recovery conflict with old snapshots in database @@ -663,7 +663,7 @@ postgres: user database host pg_stat_get_db_conflict_bufferpin(oid) bigint - Number of queries cancelled because of recovery conflict with pinned buffers in database + Number of queries canceled because of recovery conflict with pinned buffers in database @@ -671,7 +671,7 @@ postgres: user database host pg_stat_get_db_conflict_startup_deadlock(oid) bigint - Number of queries cancelled because of recovery conflict with deadlocks in database + Number of queries canceled because of recovery conflict with deadlocks in database diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index d3de330916..508991bcc2 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -1142,7 +1142,7 @@ - Cancelling Requests in Progress + Canceling Requests in Progress During the processing of a query, the frontend might request diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index f864bbf6a6..e28a7e1cde 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -143,7 +143,7 @@ SET SESSION CHARACTERISTICS AS TRANSACTION transa transaction, the transaction may block when first acquiring its snapshot, after which it is able to run without the normal overhead of a SERIALIZABLE transaction and without any risk of - contributing to or being cancelled by a serialization failure. This mode + contributing to or being canceled by a serialization failure. This mode is well suited for long-running reports or backups. diff --git a/doc/src/sgml/release-7.4.sgml b/doc/src/sgml/release-7.4.sgml index ee8184b16c..f13957b026 100644 --- a/doc/src/sgml/release-7.4.sgml +++ b/doc/src/sgml/release-7.4.sgml @@ -465,7 +465,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. diff --git a/doc/src/sgml/release-8.0.sgml b/doc/src/sgml/release-8.0.sgml index 469a76d893..5d6d60e607 100644 --- a/doc/src/sgml/release-8.0.sgml +++ b/doc/src/sgml/release-8.0.sgml @@ -609,7 +609,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. diff --git a/doc/src/sgml/release-8.1.sgml b/doc/src/sgml/release-8.1.sgml index 4e1a0c5dd0..5f74abf45e 100644 --- a/doc/src/sgml/release-8.1.sgml +++ b/doc/src/sgml/release-8.1.sgml @@ -849,7 +849,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. @@ -4203,7 +4203,7 @@ psql -t -f fixseq.sql db1 | psql -e db1 While the statement_timeout configuration parameter allows a query taking more than a certain amount of - time to be cancelled, the NOWAIT option allows a + time to be canceled, the NOWAIT option allows a query to be canceled as soon as a SELECT ... FOR UPDATE/SHARE command cannot immediately acquire a row lock. diff --git a/doc/src/sgml/release-8.2.sgml b/doc/src/sgml/release-8.2.sgml index 0a9ee5031a..2ab644fa3f 100644 --- a/doc/src/sgml/release-8.2.sgml +++ b/doc/src/sgml/release-8.2.sgml @@ -1334,7 +1334,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. diff --git a/doc/src/sgml/release-8.3.sgml b/doc/src/sgml/release-8.3.sgml index bccc141a54..7db9d6bcb0 100644 --- a/doc/src/sgml/release-8.3.sgml +++ b/doc/src/sgml/release-8.3.sgml @@ -1566,7 +1566,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml index e4fddd44e6..27e4e2902d 100644 --- a/doc/src/sgml/release-8.4.sgml +++ b/doc/src/sgml/release-8.4.sgml @@ -2062,7 +2062,7 @@ - This fix prevents a PANIC if a VACUUM FULL is cancelled + This fix prevents a PANIC if a VACUUM FULL is canceled after it's already committed its tuple movements, as well as transient errors if a plain VACUUM is interrupted after having truncated the table. diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml index 2d6c8edf9b..9dfca1c786 100644 --- a/doc/src/sgml/release-9.1.sgml +++ b/doc/src/sgml/release-9.1.sgml @@ -779,7 +779,7 @@ - This helps avoid cancelling long-running queries on the standby. + This helps avoid canceling long-running queries on the standby. diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c index aa0b0291ee..eca7a4038d 100644 --- a/src/backend/access/transam/xlog.c +++ b/src/backend/access/transam/xlog.c @@ -8375,13 +8375,13 @@ xlog_redo(XLogRecPtr lsn, XLogRecord *record) /* * If we see a shutdown checkpoint while waiting for an end-of-backup - * record, the backup was cancelled and the end-of-backup record will + * record, the backup was canceled and the end-of-backup record will * never arrive. */ if (InArchiveRecovery && !XLogRecPtrIsInvalid(ControlFile->backupStartPoint)) ereport(ERROR, - (errmsg("online backup was cancelled, recovery cannot continue"))); + (errmsg("online backup was canceled, recovery cannot continue"))); /* * If we see a shutdown checkpoint, we know that nothing was running @@ -9337,7 +9337,7 @@ do_pg_stop_backup(char *labelfile, bool waitforarchive) (errmsg("pg_stop_backup still waiting for all required WAL segments to be archived (%d seconds elapsed)", waits), errhint("Check that your archive_command is executing properly. " - "pg_stop_backup can be cancelled safely, " + "pg_stop_backup can be canceled safely, " "but the database backup will not be usable without all the WAL segments."))); } } @@ -9819,13 +9819,13 @@ CancelBackup(void) if (stat(BACKUP_LABEL_FILE, &stat_buf) < 0) return; - /* remove leftover file from previously cancelled backup if it exists */ + /* remove leftover file from previously canceled backup if it exists */ unlink(BACKUP_LABEL_OLD); if (rename(BACKUP_LABEL_FILE, BACKUP_LABEL_OLD) == 0) { ereport(LOG, - (errmsg("online backup mode cancelled"), + (errmsg("online backup mode canceled"), errdetail("\"%s\" was renamed to \"%s\".", BACKUP_LABEL_FILE, BACKUP_LABEL_OLD))); } @@ -9833,7 +9833,7 @@ CancelBackup(void) { ereport(WARNING, (errcode_for_file_access(), - errmsg("online backup mode was not cancelled"), + errmsg("online backup mode was not canceled"), errdetail("Could not rename \"%s\" to \"%s\": %m.", BACKUP_LABEL_FILE, BACKUP_LABEL_OLD))); } diff --git a/src/backend/commands/vacuum.c b/src/backend/commands/vacuum.c index 5cbf3a04f8..9303967863 100644 --- a/src/backend/commands/vacuum.c +++ b/src/backend/commands/vacuum.c @@ -78,7 +78,7 @@ static bool vacuum_rel(Oid relid, VacuumStmt *vacstmt, bool do_toast, * tables separately. * * for_wraparound is used by autovacuum to let us know when it's forcing - * a vacuum for wraparound, which should not be auto-cancelled. + * a vacuum for wraparound, which should not be auto-canceled. * * bstrategy is normally given as NULL, but in autovacuum it can be passed * in to use the same buffer strategy object across multiple vacuum() calls. @@ -867,7 +867,7 @@ vacuum_rel(Oid relid, VacuumStmt *vacstmt, bool do_toast, bool for_wraparound) * here by violating transaction semantics.) * * We also set the VACUUM_FOR_WRAPAROUND flag, which is passed down by - * autovacuum; it's used to avoid cancelling a vacuum that was invoked + * autovacuum; it's used to avoid canceling a vacuum that was invoked * in an emergency. * * Note: these flags remain set until CommitTransaction or diff --git a/src/backend/postmaster/autovacuum.c b/src/backend/postmaster/autovacuum.c index fcc912f8e3..ca4e03590d 100644 --- a/src/backend/postmaster/autovacuum.c +++ b/src/backend/postmaster/autovacuum.c @@ -714,7 +714,7 @@ AutoVacLauncherMain(int argc, char *argv[]) worker->wi_links.next = (SHM_QUEUE *) AutoVacuumShmem->av_freeWorkers; AutoVacuumShmem->av_freeWorkers = worker; AutoVacuumShmem->av_startingWorker = NULL; - elog(WARNING, "worker took too long to start; cancelled"); + elog(WARNING, "worker took too long to start; canceled"); } } else @@ -1461,7 +1461,7 @@ AutoVacWorkerMain(int argc, char *argv[]) pqsignal(SIGHUP, SIG_IGN); /* - * SIGINT is used to signal cancelling the current table's vacuum; SIGTERM + * SIGINT is used to signal canceling the current table's vacuum; SIGTERM * means abort and exit cleanly, and SIGQUIT means abandon ship. */ pqsignal(SIGINT, StatementCancelHandler); diff --git a/src/backend/postmaster/bgwriter.c b/src/backend/postmaster/bgwriter.c index 1f4ac93d8d..5643ec821a 100644 --- a/src/backend/postmaster/bgwriter.c +++ b/src/backend/postmaster/bgwriter.c @@ -1182,7 +1182,7 @@ CompactBgwriterRequestQueue() * intervening FORGET_RELATION_FSYNC or FORGET_DATABASE_FSYNC request, so * we do it this way. It would be possible to be even smarter if we made * the code below understand the specific semantics of such requests (it - * could blow away preceding entries that would end up being cancelled + * could blow away preceding entries that would end up being canceled * anyhow), but it's not clear that the extra complexity would buy us * anything. */ diff --git a/src/backend/storage/buffer/bufmgr.c b/src/backend/storage/buffer/bufmgr.c index 5eb6186343..5420dbe61a 100644 --- a/src/backend/storage/buffer/bufmgr.c +++ b/src/backend/storage/buffer/bufmgr.c @@ -2465,7 +2465,7 @@ LockBufferForCleanup(Buffer buffer) /* * Check called from RecoveryConflictInterrupt handler when Startup - * process requests cancelation of all pin holders that are blocking it. + * process requests cancellation of all pin holders that are blocking it. */ bool HoldingBufferPinThatDelaysRecovery(void) diff --git a/src/backend/storage/lmgr/README-SSI b/src/backend/storage/lmgr/README-SSI index 246938f1ee..a9dc01f237 100644 --- a/src/backend/storage/lmgr/README-SSI +++ b/src/backend/storage/lmgr/README-SSI @@ -239,9 +239,9 @@ serialization anomalies will fail with SQLSTATE 40001, which has a standard meaning of "serialization failure". * This SSI implementation makes an effort to choose the -transaction to be cancelled such that an immediate retry of the +transaction to be canceled such that an immediate retry of the transaction will not fail due to conflicts with exactly the same -transactions. Pursuant to this goal, no transaction is cancelled +transactions. Pursuant to this goal, no transaction is canceled until one of the other transactions in the set of conflicts which could generate an anomaly has successfully committed. This is conceptually similar to how write conflicts are handled. To fully @@ -567,7 +567,7 @@ on conflicts with the same transactions. information about older committed transactions to put an upper bound on RAM used. Beyond that limit, information spills to disk. Performance can degrade in a pessimal situation, but it should be -tolerable, and transactions won't need to be cancelled or blocked +tolerable, and transactions won't need to be canceled or blocked from starting. diff --git a/src/backend/storage/lmgr/deadlock.c b/src/backend/storage/lmgr/deadlock.c index 980042b6af..837f0296c6 100644 --- a/src/backend/storage/lmgr/deadlock.c +++ b/src/backend/storage/lmgr/deadlock.c @@ -535,7 +535,7 @@ FindLockCycleRecurse(PGPROC *checkProc, * Note we read vacuumFlags without any locking. This is * OK only for checking the PROC_IS_AUTOVACUUM flag, * because that flag is set at process start and never - * reset; there is logic elsewhere to avoid cancelling an + * reset; there is logic elsewhere to avoid canceling an * autovacuum that is working for preventing Xid * wraparound problems (which needs to read a different * vacuumFlag bit), but we don't do that here to avoid diff --git a/src/backend/storage/lmgr/predicate.c b/src/backend/storage/lmgr/predicate.c index 8bb740ef6d..ce92dfcf17 100644 --- a/src/backend/storage/lmgr/predicate.c +++ b/src/backend/storage/lmgr/predicate.c @@ -3752,7 +3752,7 @@ CheckForSerializableConflictOut(bool visible, Relation relation, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on identification as a pivot, during conflict out checking."), + errdetail("Canceled on identification as a pivot, during conflict out checking."), errhint("The transaction might succeed if retried."))); } @@ -3841,7 +3841,7 @@ CheckForSerializableConflictOut(bool visible, Relation relation, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on conflict out to old pivot %u.", xid), + errdetail("Canceled on conflict out to old pivot %u.", xid), errhint("The transaction might succeed if retried."))); if (SxactHasSummaryConflictIn(MySerializableXact) @@ -3849,7 +3849,7 @@ CheckForSerializableConflictOut(bool visible, Relation relation, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on identification as a pivot, with conflict out to old committed transaction %u.", xid), + errdetail("Canceled on identification as a pivot, with conflict out to old committed transaction %u.", xid), errhint("The transaction might succeed if retried."))); MySerializableXact->flags |= SXACT_FLAG_SUMMARY_CONFLICT_OUT; @@ -3872,7 +3872,7 @@ CheckForSerializableConflictOut(bool visible, Relation relation, * We have a conflict out to a transaction which has a conflict out to a * summarized transaction. That summarized transaction must have * committed first, and we can't tell when it committed in relation to our - * snapshot acquisition, so something needs to be cancelled. + * snapshot acquisition, so something needs to be canceled. */ if (SxactHasSummaryConflictOut(sxact)) { @@ -3888,7 +3888,7 @@ CheckForSerializableConflictOut(bool visible, Relation relation, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on conflict out to old pivot."), + errdetail("Canceled on conflict out to old pivot."), errhint("The transaction might succeed if retried."))); } } @@ -4127,7 +4127,7 @@ CheckForSerializableConflictIn(Relation relation, HeapTuple tuple, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on identification as a pivot, during conflict in checking."), + errdetail("Canceled on identification as a pivot, during conflict in checking."), errhint("The transaction might succeed if retried."))); /* @@ -4459,7 +4459,7 @@ OnConflict_CheckForSerializationFailure(const SERIALIZABLEXACT *reader, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on identification as a pivot, during write."), + errdetail("Canceled on identification as a pivot, during write."), errhint("The transaction might succeed if retried."))); } else if (SxactIsPrepared(writer)) @@ -4471,7 +4471,7 @@ OnConflict_CheckForSerializationFailure(const SERIALIZABLEXACT *reader, ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on conflict out to pivot %u, during read.", writer->topXid), + errdetail("Canceled on conflict out to pivot %u, during read.", writer->topXid), errhint("The transaction might succeed if retried."))); } writer->flags |= SXACT_FLAG_DOOMED; @@ -4492,7 +4492,7 @@ OnConflict_CheckForSerializationFailure(const SERIALIZABLEXACT *reader, * marked for death, because rolling back another transaction might mean * that we flail without ever making progress. This transaction is * committing writes, so letting it commit ensures progress. If we - * cancelled the far conflict, it might immediately fail again on retry. + * canceled the far conflict, it might immediately fail again on retry. */ void PreCommit_CheckForSerializationFailure(void) @@ -4513,7 +4513,7 @@ PreCommit_CheckForSerializationFailure(void) ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on identification as a pivot, during commit attempt."), + errdetail("Canceled on identification as a pivot, during commit attempt."), errhint("The transaction might succeed if retried."))); } @@ -4551,7 +4551,7 @@ PreCommit_CheckForSerializationFailure(void) ereport(ERROR, (errcode(ERRCODE_T_R_SERIALIZATION_FAILURE), errmsg("could not serialize access due to read/write dependencies among transactions"), - errdetail("Cancelled on commit attempt with conflict in from prepared pivot."), + errdetail("Canceled on commit attempt with conflict in from prepared pivot."), errhint("The transaction might succeed if retried."))); } nearConflict->sxactOut->flags |= SXACT_FLAG_DOOMED; diff --git a/src/backend/storage/lmgr/proc.c b/src/backend/storage/lmgr/proc.c index 8c399ec168..44399d822c 100644 --- a/src/backend/storage/lmgr/proc.c +++ b/src/backend/storage/lmgr/proc.c @@ -1333,7 +1333,7 @@ CheckDeadLock(void) * the lock. * * If blocked by autovacuum, this wakeup will enable ProcSleep to send - * the cancelling signal to the autovacuum worker. + * the canceling signal to the autovacuum worker. */ PGSemaphoreUnlock(&MyProc->sem); } diff --git a/src/backend/tcop/postgres.c b/src/backend/tcop/postgres.c index a07661f02a..80d07f8f2d 100644 --- a/src/backend/tcop/postgres.c +++ b/src/backend/tcop/postgres.c @@ -179,7 +179,7 @@ static int UseNewLine = 1; /* Use newlines query delimiters (the default) */ static int UseNewLine = 0; /* Use EOF as query delimiters */ #endif /* TCOP_DONTUSENEWLINE */ -/* whether or not, and why, we were cancelled by conflict with recovery */ +/* whether or not, and why, we were canceled by conflict with recovery */ static bool RecoveryConflictPending = false; static bool RecoveryConflictRetryable = true; static ProcSignalReason RecoveryConflictReason; diff --git a/src/backend/utils/cache/relcache.c b/src/backend/utils/cache/relcache.c index d7e94ffc12..1a400a0a57 100644 --- a/src/backend/utils/cache/relcache.c +++ b/src/backend/utils/cache/relcache.c @@ -1897,7 +1897,7 @@ RelationClearRelation(Relation relation, bool rebuild) * on next access. Meanwhile it's not any less valid than it was * before, so any code that might expect to continue accessing it * isn't hurt by the rebuild failure. (Consider for example a - * subtransaction that ALTERs a table and then gets cancelled partway + * subtransaction that ALTERs a table and then gets canceled partway * through the cache entry rebuild. The outer transaction should * still see the not-modified cache entry as valid.) The worst * consequence of an error is leaking the necessarily-unreferenced new diff --git a/src/bin/psql/common.c b/src/bin/psql/common.c index b57da05345..256c1c2c2a 100644 --- a/src/bin/psql/common.c +++ b/src/bin/psql/common.c @@ -194,7 +194,7 @@ NoticeProcessor(void *arg, const char *message) * so. We use write() to report to stderr because it's better to use simple * facilities in a signal handler. * - * On win32, the signal cancelling happens on a separate thread, because + * On win32, the signal canceling happens on a separate thread, because * that's how SetConsoleCtrlHandler works. The PQcancel function is safe * for this (unlike PQrequestCancel). However, a CRITICAL_SECTION is required * to protect the PGcancel structure against being changed while the signal diff --git a/src/bin/scripts/common.c b/src/bin/scripts/common.c index c882123dd1..e85adfaf11 100644 --- a/src/bin/scripts/common.c +++ b/src/bin/scripts/common.c @@ -378,7 +378,7 @@ ResetCancelConn(void) #ifndef WIN32 /* - * Handle interrupt signals by cancelling the current command, + * Handle interrupt signals by canceling the current command, * if it's being executed through executeMaintenanceCommand(), * and thus has a cancelConn set. */ diff --git a/src/port/path.c b/src/port/path.c index 0d40a0bb9c..6991bc7247 100644 --- a/src/port/path.c +++ b/src/port/path.c @@ -304,7 +304,7 @@ canonicalize_path(char *path) } else if (pending_strips > 0 && *spath != '\0') { - /* trim a regular directory name cancelled by ".." */ + /* trim a regular directory name canceled by ".." */ trim_directory(path); pending_strips--; /* foo/.. should become ".", not empty */ diff --git a/src/test/regress/expected/prepared_xacts.out b/src/test/regress/expected/prepared_xacts.out index 328cd7426e..e094476cb4 100644 --- a/src/test/regress/expected/prepared_xacts.out +++ b/src/test/regress/expected/prepared_xacts.out @@ -135,7 +135,7 @@ INSERT INTO pxtest1 VALUES ('fff'); -- This should fail, because the two transactions have a write-skew anomaly PREPARE TRANSACTION 'foo5'; ERROR: could not serialize access due to read/write dependencies among transactions -DETAIL: Cancelled on commit attempt with conflict in from prepared pivot. +DETAIL: Canceled on commit attempt with conflict in from prepared pivot. HINT: The transaction might succeed if retried. SELECT gid FROM pg_prepared_xacts; gid diff --git a/src/test/regress/expected/subselect.out b/src/test/regress/expected/subselect.out index 8f180b9b19..e638f0a60c 100644 --- a/src/test/regress/expected/subselect.out +++ b/src/test/regress/expected/subselect.out @@ -266,7 +266,7 @@ SELECT * FROM foo WHERE id IN CREATE TABLE orderstest ( approver_ref integer, po_ref integer, - ordercancelled boolean + ordercanceled boolean ); INSERT INTO orderstest VALUES (1, 1, false); INSERT INTO orderstest VALUES (66, 5, false); @@ -285,8 +285,8 @@ SELECT *, WHEN ord.approver_ref=1 THEN '---' ELSE 'Approved' END) AS "Approved", (SELECT CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (SELECT CASE WHEN ord.po_ref=1 @@ -300,8 +300,8 @@ SELECT *, END) END) AS "Status", (CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (CASE WHEN ord.po_ref=1 @@ -316,19 +316,19 @@ END) AS "Status", END) AS "Status_OK" FROM orderstest ord; SELECT * FROM orders_view; - approver_ref | po_ref | ordercancelled | Approved | Status | Status_OK ---------------+--------+----------------+----------+-----------+----------- - 1 | 1 | f | --- | --- | --- - 66 | 5 | f | Approved | PO | PO - 66 | 6 | f | Approved | PO | PO - 66 | 7 | f | Approved | PO | PO - 66 | 1 | t | Approved | Cancelled | Cancelled - 66 | 8 | f | Approved | PO | PO - 66 | 1 | f | Approved | Approved | Approved - 77 | 1 | f | Approved | Approved | Approved - 1 | 1 | f | --- | --- | --- - 66 | 1 | f | Approved | Approved | Approved - 1 | 1 | f | --- | --- | --- + approver_ref | po_ref | ordercanceled | Approved | Status | Status_OK +--------------+--------+---------------+----------+----------+----------- + 1 | 1 | f | --- | --- | --- + 66 | 5 | f | Approved | PO | PO + 66 | 6 | f | Approved | PO | PO + 66 | 7 | f | Approved | PO | PO + 66 | 1 | t | Approved | Canceled | Canceled + 66 | 8 | f | Approved | PO | PO + 66 | 1 | f | Approved | Approved | Approved + 77 | 1 | f | Approved | Approved | Approved + 1 | 1 | f | --- | --- | --- + 66 | 1 | f | Approved | Approved | Approved + 1 | 1 | f | --- | --- | --- (11 rows) DROP TABLE orderstest cascade; diff --git a/src/test/regress/sql/subselect.sql b/src/test/regress/sql/subselect.sql index 0d117c878f..3cecbc1d41 100644 --- a/src/test/regress/sql/subselect.sql +++ b/src/test/regress/sql/subselect.sql @@ -136,7 +136,7 @@ SELECT * FROM foo WHERE id IN CREATE TABLE orderstest ( approver_ref integer, po_ref integer, - ordercancelled boolean + ordercanceled boolean ); INSERT INTO orderstest VALUES (1, 1, false); @@ -157,8 +157,8 @@ SELECT *, WHEN ord.approver_ref=1 THEN '---' ELSE 'Approved' END) AS "Approved", (SELECT CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (SELECT CASE WHEN ord.po_ref=1 @@ -172,8 +172,8 @@ SELECT *, END) END) AS "Status", (CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (CASE WHEN ord.po_ref=1 -- 2.40.0