delete rows of a table NAME DELETE - delete rows of a table SYNOPSIS [ WITH [ RECURSIVE ] with_q...conditionally insert, update, or delete rows of a table NAME MERGE - conditionally insert, update, or delete rows of a table SYNO......n_name ( arguments ) where event can be one of: INSERT UPDATE [ OF column_name [, ... ] ] DELETE TRUNCATE DESCRIPTION CREATE TRIGGER creates a new trigger. CREATE OR REPLACE TRI…...pen (2) O_CREAT , mkdir (2), link (2), symlink (2), bind (2) on a UNIX domain socket). IN_DELETE (+) File/directory deleted from watched directory. IN_DELETE_SELF Watched file/d…...terface flags is a privileged operation. SIOCGIFADDR SIOCSIFADDR SIOCDIFADDR Get, set, or delete the address of the device using ifr_addr , or ifr6_addr with ifr6_prefixlen . Se…...N table_name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ] [ TO { role_name | PUBLIC | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, …...mmand | ( command ; command ... ) } where event can be one of: SELECT | INSERT | UPDATE | DELETE DESCRIPTION CREATE RULE defines a new rule applying to a specified table or view…...value is a comma-separated list of operations. The allowed operations are insert, update, delete, and truncate. The default is to publish all actions, and so the default value f…...100644 bcd1234... 0123456... M file0 create :000000 100644 0000000... 1234567... A file4 delete :100644 000000 1234567... 0000000... D file5 unmerged :000000 000000 0000000... 0…...nd expr is not an element of A , then the element is created with value null . void array_delete(ARRAY A, CELL *cp) removes an element A [ expr from the array A . cp points at t…...( storage_parameter [= value ] [, ... ] ) | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] [ TABLESPACE tablespace_name ] AS query [ WITH [ NO ] DATA ] DESC…...ew_name The new name for the publication. EXAMPLES Change the publication to publish only deletes and updates: ALTER PUBLICATION noinsert SET (publish = 'update, delete'); Add s…...ly a limited set of events was supported. In particular, there was no support for create, delete, and move events. The support for those events was added in Linux 5.1. (See inot…...E quickly removes all rows from a set of tables. It has the same effect as an unqualified DELETE on each table, but since it does not actually scan the tables it is faster. Furt…...( storage_parameter [= value ] [, ... ] ) | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] [ TABLESPACE tablespace_name ] CREATE [ [ GLOBAL | LOCAL ] { TEMP…...t have the right privilege for the specified lockmode . If the user has MAINTAIN, UPDATE, DELETE, or TRUNCATE privileges on the table, any lockmode is permitted. If the user has….... It is possible to construct these old form repositories manually. When deinitialized or deleted (see below), the submodule’s Git directory is automatically moved to $GIT_DIR/m…...e Views Simple views are automatically updatable: the system will allow INSERT , UPDATE , DELETE , and MERGE statements to be used on the view in the same way as on a regular ta…...uclockid () is present. --- - _POSIX_FILE_LOCKING - _SC_FILE_LOCKING This option has been deleted. Not in final XPG6. FSC - _POSIX_FSYNC - _SC_FSYNC The function fsync () is pre…...annot be changed after the first query or data-modification statement ( SELECT , INSERT , DELETE , UPDATE , MERGE , FETCH , or COPY ) of a transaction has been executed. See Cha…