Re: default values

On 6/27/06, Jonathan Vanasco <rosedb-GYD5gbT+W3w@xxxxxxxxxxxxxxxx> wrote:
> i noticed just now...
>
> if postgres is this:
>
>         create table stuff ( id integer not null primary key , name varchar
> (40), active boolean default true );

This seems like something the DB should handle. What happens when you modify
your column to not accept null? Will it force the default to be applied?

Clayton
-- 

Clayton Scott
clayton.scott-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642