sampledb=# \d
                 List of relations
     Schema      |     Name      | Type  |  Owner
-----------------+---------------+-------+----------
 instrumentation | looptimelines | table | teaminst
(1 row)

sampledb=# select * from looptimelines;
 startdate  |  enddate   | startproject_code | endproject_code | area | process | loop_nbr | suffix | service_desc
------------+------------+-------------------+-----------------+------+---------+----------+--------+--------------
 2008-01-02 | 9999-12-31 | 02U20420          |                 |   84 | P       |        1 |        | Second Loop
 2008-01-01 | 2008-01-12 | 02U20410          | 02U20420        |   84 | P       |        1 |        | First Loop
(2 rows)

sampledb=# set search_path to instrumentation;
SET
sampledb=# \d
                 List of relations
     Schema      |     Name      | Type  |  Owner
-----------------+---------------+-------+----------
 instrumentation | looptimelines | table | teaminst
(1 row)

sampledb=# select * from looptimelines;
 startdate  |  enddate   | startproject_code | endproject_code | area | process | loop_nbr | suffix | service_desc
------------+------------+-------------------+-----------------+------+---------+----------+--------+--------------
 2008-01-02 | 9999-12-31 | 02U20420          |                 |   84 | P       |        1 |        | Second Loop
 2008-01-01 | 2008-01-12 | 02U20410          | 02U20420        |   84 | P       |        1 |        | First Loop
(2 rows)
                                                             ^
sampledb=# UPDATE Looptimelines SET enddate = enddate + INTERVAL '5 DAYS' WHERE endproject_code = '02U20420';
NOTICE:  After performing the UPDATE operation, the OLD record is
        visible before the commit.
UPDATE 1
sampledb=# BEGIN; UPDATE Looptimelines SET enddate = enddate + INTERVAL '5 DAYS' WHERE endproject_code = '02U20420'; COMMIT;
BEGIN
UPDATE 1
NOTICE:  After performing the UPDATE operation, the NEW record is
        visible before the commit.
COMMIT
sampledb=#