From: | Ivan <Ivan-Sun1(at)mail(dot)ru> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Bug in CHECK constraints statement reverse engineering. |
Date: | 2005-05-20 09:00:58 |
Message-ID: | 1067494659.20050520130058@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello Dave,
DP> Hi,
DP> pgAdmin does do this correctly. In order to run at a reasonable speed,
DP> pgAdmin caches details of objects read from the database, rather than
DP> running queries every time you select one. If you rename an object such
DP> as a function, it doesn't always know that that action may cause a
DP> property of another object to be changed, thus pgAdmin may continue to
DP> show the old definition.
DP> To force a reload, right-click a node in the treeview and select the
DP> 'Refresh' option.
You were right on a half - pgAdmin do this correctly for tables check
constraints, but for domain definition 'Refresh' and even closing
pgAdmin and restarting postmaster doesn't help :) -
I see:
CREATE DOMAIN "TestDomain"
AS int4
CONSTRAINT TestDomain_check CHECK "Check_IntegerGreaterZero"(VALUE);
though function were renamed.
By the way it will be great to add quoting of domain's constraint name
in the definition pane (right bottom).
Thank you for support.
--
Best regards,
Ivan mailto:Ivan-Sun1(at)mail(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-05-20 09:31:05 | Re: Bug in CHECK constraints statement reverse engineering. |
Previous Message | Dave Page | 2005-05-20 08:30:34 | Re: Bug in CHECK constraints statement reverse engineering. |