postgres script troubles syntax error: unexpected end of file

Question

I am missing something below. I keep getting unexpected end of file. What is it?

function lock_inactive_accounts {
    echo "Locking inactive accounts or accounts that haven't logged in during the past 35 days."
    echo " "
    echo "The following accounts have been locked: "
    su - postgres -c "psql database" << EOF
      UPDATE users SET has_locked_account = true WHERE DATE_PART('days', now() - last_successful_login) > 35;
      SELECT name from users where has_locked_account = 't';
        EOF
}

lock_inactive_accounts

For your own convenience you can consider running problematic snippets like this through shellcheck to get instant feedback on many common problems (including this one) — that other guy
– that other guy, Commented Dec 19, 2013 at 22:57

Alexander L. Belikoff · Accepted Answer · 2013-12-19 21:15:49Z

2

I believe the terminating EOF should be at the beginning of the line for here document to work:

su - postgres -c "psql database" <<EOF
  UPDATE users SET has_locked_account = true WHERE DATE_PART('days', now() - last_successful_login) > 35;
  SELECT name from users where has_locked_account = 't';
EOF

answered Dec 19, 2013 at 21:15

Alexander L. Belikoff

5,7331 gold badge27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jason Over a year ago

I tried that, but doesn't seem to make a difference within a function.

Denis de Bernardy Over a year ago

I'm pretty certain this is correct regardless. Maybe << EOF. Or the tab-friendly syntax, which I vaguely recollect being <<-EOF or something to that order.

Alexander L. Belikoff Over a year ago

I just checked by copying your (not mine) code above, putting it into a script (no sharp-bang), making sure EOF is starting at column 1, and running (in Linux) and it does work: Locking inactive accounts or accounts that haven't logged in during the past 35 days. The following accounts have been locked: su: must be run from a terminal

Collectives™ on Stack Overflow

postgres script troubles syntax error: unexpected end of file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related