On Thu, 2003-06-05 at 11:11, Rod Taylor wrote:
On Wed, 2003-06-04 at 22:28, Christopher Kings-Lynne wrote:
Which ones are missing, and should we really be looking at creating
a
pg_definition_schema instead?
Missing:
Database, schema, table, domain, cast, conversion, function...
As an interface writer, do you prefer dealing with functions like
pg_get_constraintdef() or a view like the information schema provides?
I would think it is easier to get the information from the information
schema. That's most like what we're doing now getting the information
from
On Wed, 2003-06-04 at 22:28, Christopher Kings-Lynne wrote:
Which ones are missing, and should we really be looking at creating a
pg_definition_schema instead?
Missing:
Database, schema, table, domain, cast, conversion, function...
Maybe a definition schema might be
Which ones are missing, and should we really be looking at creating a
pg_definition_schema instead?
Missing:
Database, schema, table, domain, cast, conversion, function...
Maybe a definition schema might be better.dunno...it would need to use
the pg_get_*def functions anyway methinks.
As you can see below, after a rename the check constraint still refers
to 'col' and not 'newname' as pg_constraint.consrc is not updated.
Of course, this functions fine (conbin is still valid) but when it comes
time to do a pg_dump, the database is dumped using the old column name.
It seems this
Rod Taylor [EMAIL PROTECTED] writes:
As you can see below, after a rename the check constraint still refers
to 'col' and not 'newname' as pg_constraint.consrc is not updated.
The same issue has always existed with regard to pg_attrdef.adsrc.
pg_dump ought to be using the binary column not the
Rod Taylor [EMAIL PROTECTED] writes:
I do not think we need to remove the column.
Is it ok that the consrc column is not synch'd with conbin? What does
it provide if it doesn't match?
Documentation of the original form of the constraint, perhaps?
At very least we should be discouraging
On Mon, 2003-06-02 at 14:00, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
As you can see below, after a rename the check constraint still refers
to 'col' and not 'newname' as pg_constraint.consrc is not updated.
The same issue has always existed with regard to pg_attrdef.adsrc.