ALTER INDEX <index_name>
ON <schema.object>
SET (OPTIMIZE_FOR_SEQUENTIAL_KEY = ON);

WITH cte AS (
	SELECT
           f.id,     -- Adding the PK/UQ of the table you want to update
	    f.a,      -- you don't need this line now
	    b.a AS new_a,
	    '?' AS something_else
	FROM foo f
	JOIN bar b ON b.id = f.id
)
UPDATE foo
SET    a = a || something_else
FROM cte
WHERE cte.id = foo.id ;

-- broke
update sc as foo set
    "name" = concat(acc.name, '_', right(cast(sc.key as text), -2))
from accounts as acc
join sc as sc on sc.account_id = acc.id;
-- woke
update sc as sc
set "name" = concat(acc."name", '_', right(cast(sc.key as text), -2))
from accounts as acc
where acc.id = sc.account_id;

➜  py git:(dev) ✗ psql -c 'select 1/1;'
 ?column?
----------
        1
(1 row)

➜  py git:(dev) ✗ echo $?
0
➜  py git:(dev) ✗ psql -c 'select 1/0;' -v ON_ERROR_STOP=1
ERROR:  division by zero
➜  py git:(dev) ✗ echo $?
1
➜  py git:(dev) ✗

postgres@ironforge:~$ psql -f 'onerrorstop.sql'
psql:onerrorstop.sql:2: ERROR:  relation "gurumeditationerror" does not exist
LINE 1: select * from gurumeditationerror;
                  ^
postgres@ironforge:~$ echo $?
3
postgres@ironforge:~$

postgres@ironforge:~$ echo "\set ON_ERROR_STOP on
> select * from smellyfarts;" | psql
ERROR:  relation "smellyfarts" does not exist
LINE 1: select * from smellyfarts;
                  ^
postgres@ironforge:~$ echo $?
3
postgres@ironforge:~$

[postgres@vagrant ~]$ echo 'select 1/0;' > foo.sql
[postgres@vagrant ~]$ psql -v ON_ERROR_STOP=1 -f foo.sql
psql:foo.sql:1: ERROR:  division by zero
[postgres@vagrant ~]$ echo $?
3
[postgres@vagrant ~]$

if (pset.on_error_stop)
goto loop_exit;

on error moan_on_slack

on error ask_on_stackoverflow

ALTER TABLE [dbo].[tblScheduleGroupConfigurationSchedules]  WITH CHECK ADD  CONSTRAINT [FK_tblScheduleGroupConfigurationSchedules_tblScheduleFrequencies] FOREIGN KEY([ScheduleFrequency])
REFERENCES [dbo].[tblScheduleFrequencies] ([ScheduleFrequency])
GO

ALTER TABLE [dbo].[tblScheduleGroupConfigurationSchedules] CHECK CONSTRAINT [FK_tblScheduleGroupConfigurationSchedules_tblScheduleFrequencies]
GO

ALTER TABLE [dbo].[tblScheduleGroupConfigurationSchedules]  WITH CHECK ADD  CONSTRAINT [CK_tblScheduleGroupConfigurationSchedulesScheduleFrequency] CHECK  (([ScheduleFrequency]=(2) OR [ScheduleFr…