ERT INTO t_routers VALUES (index, $1, $2);
RETURN 1;
END;'
LANGUAGE 'plpgsql';
What am I doing wrong?
Cheers!
Wim.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello,
I want to drop all functions from my data base. Is their an easy way to do
this? Or did somebody wrote a function, or a sql script that deletes all
functions?
Thanks a lot for your help.
Best regards,
Wim
---(end of broadcast
I suppose you could make
> a case for either accepting or rejecting the UNIQUE constraint in that
> situation --- but SQL92 chose the "accept" decision, and I think that
> for the majority of practical applications they made the right choice.
>
> If you don't like that behavior, possibly your column should be defined
> as NOT NULL.
>
Regards
Wim
Carolyn Lu Wong wrote:
>
> I have a field in a table that has been defined 'not null'. Is it
> possible to remove this constraint? I don't see this option under 'alter
> table'.
update pg_attribute set attnotnull = 'f' where oid = oidofnotnullcolumn;
vacuum analyze;
Regards
Wim
