Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: > On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote: >> Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: >>> Is this still safe to do ? >> >> What kind of constraint? > The only ones left are foreign key constraints. I had a few not nulls > too, but those are not actually there anyway (see my other post). IIRC, the name of an FK constraint also appears in the arguments for its triggers. If you didn't update those too, the behavior might be a bit inconsistent, depending on which PG version you're using. In particular I'm not sure which name pg_dump will believe. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/