Skip site navigation (1) Skip section navigation (2)


From: Josh Berkus <josh(at)agliodbs(dot)com>
To: David Wheeler <david(at)kineticode(dot)com>, sfpug(at)postgresql(dot)org
Subject: Re: NOT NULL
Date: 2003-10-30 05:08:26
Message-ID: (view raw or whole thread)
Lists: sfpug

>    UPDATE pg_attribute
>    SET    attnotnull = 't'
>    WHERE  attname = 'primary_oc__id'
>            AND attrelid in (
>              SELECT pg_class.oid
>              FROM   pg_class
>              WHERE  relkind='r'
>                     AND relname='element__site'
>            )

Looks good to me, provided that you aren't using SCHEMA in your design, which 
I belive you're not.

BTW, what's with the double underscores in the object names?

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • NOT NULL at 2003-10-30 01:20:52 from David Wheeler


sfpug by date

Next:From: David WheelerDate: 2003-10-30 15:51:18
Subject: Re: NOT NULL
Previous:From: David FetterDate: 2003-10-30 03:55:02
Subject: Re: NOT NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group