amacneil / amacneil/dbmate

`pq: syntax error at or near "."` error received when calling functions with schema in front.

Aperta
#722 6 commenti 0 reazioni 0 assegnatari Vedi su GitHub
bug needs more info
Lingua principale
Go
Stelle
7.4k
Fork
379
Merge medio
6m
PR unite (30g)
1

Descrizione

**Description**

`pq: syntax error at or near "."` appearing on a migration script where schema is specified before a function.

Same migration works when deployed via 2.28.0.

- Version: 2.29.0
- Database: postgres
- Operating System: linux (Github CI)

**Steps To Reproduce**

All 3 versions of this failed to migrate on v2.29.0 invoked via the command line:

```
-- migrate:up
SELECT audit.attach_trigger('public.table_name', 'security_id');

-- migrate:down
DROP TRIGGER table_name_audit_insert ON public.table_name;
DROP TRIGGER table_name_audit_update ON public.table_name;
DROP TRIGGER table_name_audit_delete ON public.table_name;
DROP TRIGGER table_name_audit_truncate ON public.table_name;
```

```
-- migrate:up
SELECT "audit"."attach_trigger"('public.table_name', 'security_id');

-- migrate:down
DROP TRIGGER table_name_audit_insert ON public.table_name;
DROP TRIGGER table_name_audit_update ON public.table_name;
DROP TRIGGER table_name_audit_delete ON public.table_name;
DROP TRIGGER table_name_audit_truncate ON public.table_name;
```

```
-- migrate:up
SELECT * FROM "audit"."attach_trigger"('public.table_name', 'security_id');

-- migrate:down
DROP TRIGGER table_name_audit_insert ON public.table_name;
DROP TRIGGER table_name_audit_update ON public.table_name;
DROP TRIGGER table_name_audit_delete ON public.table_name;
DROP TRIGGER table_name_audit_truncate ON public.table_name;
```

First version succeeded when running with dbmate v2.28.0 (executed via yarn). Other versions weren't tested.

All 3 versions suceeded when running directly on DBeaver connected to the database.

**Expected Behavior**
There should not be a warning of syntax error. The syntax is valid and accepted by PG, seemingly only being rejected by lib/pq.

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.