O$ SQL error setting NOT NULL

[Brian O'Sullivan]

Hi Michael,
Not sure if this holds true in Postgress, but some other database I've 
used don't allow columns to be changed to NOT NULL once the table has 
been created (existing data may contain NULLs already). Could you 
generate SQL DDL for a CREATE TABLE instead?

On 11/20/2011 10:02 PM, Michael Rowan wrote:
> ...ALTER TABLE vehicle ADD CONSTRAINT maker_id SET NOT NULL
>
> Thats seems to be in accordance with the PostgreSQL documentation except for the missing semi-colon, which was not needed in the other statements that create the tables and the PKs.
>
> Anyone see the error in this?