From: | Erison Gmail <nosire(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | ERROR: bogus varno: 2 |
Date: | 2019-04-01 23:41:50 |
Message-ID: | e88707be-1237-f508-e239-0b1929356de4@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Good night friends
This is my first message, thank you in advance.
I have some databases that I migrated from postgresql 9.5 to 10, and in
some tables when trying to view SQL I get the following error: "ERROR:
bogus varno: 2"
After some queries I came to the conclusion that the error appears when
I have in the table a trigger that has AFTER UPDATE condition.
Example:
"AFTER UPDATE OF notan1 ON public.nota FOR EACH ROW WHEN ((old.notan1 IS
DISTINCT FROM new.notan1))"
I already ran backup of the database, and I removed the trigger, and
circled the CREATE of it again and the sql normal wheel, the triggers
are working.
Thank you.
--
ATT.
Erison Roberto Belon
Técnólogo em processamento de dados
Bacharel em desenvolvimento de software para web
email: nosire(at)gmail(dot)com
skype: nosireerb
ICQ: 609535756
Fone: 55(17)99714-9152 (vivo)(Whatsapp)
55(17)98211-0279 (Tim)
From | Date | Subject | |
---|---|---|---|
Next Message | Murtuza Zabuawala | 2019-04-02 03:31:36 | Re: ERROR: bogus varno: 2 |
Previous Message | mickey | 2019-04-01 18:23:01 | pgadmin4 Edit and "Save" data |