Re: int4 to varchar length (pgadmin3) issue - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: int4 to varchar length (pgadmin3) issue
Date
Msg-id 20060831201453.29115.qmail@web31805.mail.mud.yahoo.com
Whole thread Raw
In response to Re: int4 to varchar length (pgadmin3) issue  (<operationsengineer1@yahoo.com>)
List pgsql-novice
> this is an additional defined constraint, correct?

Yes, it will add a constraint to your table that specifically works on that particualar field.

> is
> this constraint added automagically by pgadmin when
> you  enter a length value or is this a different
> method to achieve a similar result?

I am not exactly sure what your question is, but the ALTER TABLE <...> is a Data Definition
statement. Once the statement comments, then any future attempts by any connection to
update/insert will blocked if the data doesn't meet the constraint criteria.

Regards,

Richard Broersma Jr.


pgsql-novice by date:

Previous
From: Ray Stell
Date:
Subject: admin technical training
Next
From: "Phillip Smith"
Date:
Subject: Re: moving content of a table to another table