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

Re: NOT NULL

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: 200310292108.26864.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
David,

>    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

Responses

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-2014 The PostgreSQL Global Development Group