I’m working on a PowerShell script to link Discourse groups with AD security groups and my PSQL query gets this error when I try to insert
Also attempting via API and I thinking I might be doing it wrong
I get a 403 Forbidden when I this
GRANT USAGE, SELECT ON SEQUENCE group_users_id_seq TO mydbuser;
On the PHP:
api_key=key is your api key really “key”.
No I scrubbed it out
postgres=# GRANT USAGE, SELECT ON SEQUENCE group_users_id_seq TO user; ERROR: relation "group_users_id_seq" does not exist
I got it to work if I looked up the last ID and manually incremented to the next ID.
Since this is in a script, I can just add the lookup before I execute the INSERT command