Also ich versuche gerade zwei Trigger in meine Docker Init Script einzubinden. Ich habe das Init Script bereits ohne den Part getestet und dort bekomme ich keine Fehler...Nur wenn ich es wieder einbaue.
Die Fehlermeldung ist:
Bash:
CREATE FUNCTION creation_datetime() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.creation_date = CURRENT_TIMESTAMP;
RETURN NEW;
END $$;
CREATE FUNCTION sales_datetime() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.sales_datetime = CURRENT_TIMESTAMP;
RETURN NEW;
END $$;
CREATE TRIGGER customer_creation_date
BEFORE INSERT ON customer
FOR EACH ROW EXECUTE PROCEDURE creation_datetime();
CREATE TRIGGER sales_sale_datetime
BEFORE INSERT ON sales
FOR EACH ROW EXECUTE PROCEDURE sales_datetime();
Die Fehlermeldung ist:
Code:
db_1 | 2021-08-10 16:53:17.525 UTC [200] ERROR: syntax error at or near "1" at character 125
db_1 | 2021-08-10 16:53:17.525 UTC [200] STATEMENT: CREATE FUNCTION creation_datetime() RETURNS trigger
db_1 | LANGUAGE plpgsql
db_1 | AS 1
db_1 | BEGIN
db_1 | NEW.creation_date = CURRENT_TIMESTAMP;
db_1 | ERROR: syntax error at or near "1"
db_1 | LINE 3: AS 1
db_1 | ^
db_1 |
db_1 | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1 |