python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - alter

Function to dynamically change postgres password

I'm trying to create a function that dynamically changes the password for a client but I get an error "ERROR: syntax error at or near "=" ALTER USER postgres WITH PASSWORD = '$1';&quo...
test-img

Michael Efraimidis

postgresql

function

settings

alter

Votes: 0

Answers: 2

Latest Answer

Apart from the trivial syntax error of the superfluous =, you cannot use a parameter in an ALTER statement. You will have to use dynamic SQL: EXECUTE format( 'ALTER ROLE postgres PASSWORD %...
test-img

Laurenz Albe

Alter trigger from another trigger

I wish to have alter trigger under another trigger. CREATE TRIGGER izmeni_naziv_kupac AFTER UPDATE OF naziv ON Kupac FOR EACH ROW DECLARE novi_naziv varchar2(255); pibK INT; BEGIN EXECUTE ...
test-img

Radomir

oracle

triggers

alter

Votes: 0

Answers: 1

Latest Answer

This is not a practical way to manage trigger activation, and for the same reason, I'd advise against using 'autonmous' to work around it because its very rare to want to turn off a trigger for all us...
test-img

Connor McDonald

Does BigQuery has alter session like oracle(exp:ALTER SESSION SET NLS_DATE_FORMAT)

How to convert oracle alter session to BigQuery? example: ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD'; ALTER SESSION FORCE PARALLEL QUERY PARALLEL 4;
test-img

riley chen

oracle

google-bigquery

alter

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs