NOT NULL v PgSQL 7.2?

[Honza Pazdziora]

On Mon, Jun 23, 2003 at 10:11:41AM +0200, Karel Zak wrote:
> On Fri, Jun 20, 2003 at 11:00:23PM +0200, Zdenek Prchal wrote:
> > V PgSQL 7.2 nejde pridat do tabulky sloupec s NOT NULL constraint?
> 
>  Co je to "pridat"? ALTER table?
> 
>  7.2 tu nemam, ale podle dokumentace by to ani jit nemelo, protoze
>  tam ALTER [ COLUMN ] column { SET | DROP } NOT NULL neni.

Mozna mel OP na mysli pridani noveho sloupce, tedy

	ALTER TABLE [ ONLY ] table [ * ]
	     ADD [ COLUMN ] column type [ column_constraint [ ... ] ]

Tipoval bych, ze problem muze nastat, pokud se snazi pridat NOT NULL
sloupec do tabulky, kde uz jsou nejake zaznamy. Samozrejme by ale
pomohlo, pokud bychom mohli videt presny prikaz a presnou chybu.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, auth. WWW servers, XML/XSL, ...
		Only self-confident people can be simple.