On Thursday 08 January 2004 13:59, beyaRecords - The home Urban music wrote:
> I am running postgresql 7.4.1 on OS X 10.3 and am having to manually
> start-up postgresql using /usr/local/pgsql/bin/postmaster -i -D
> /usr/local/pgsql/data.
>
> Is there a script available which will enable me to auto
id_a) references
A(id);
alter table AB add constraint fk_AB_B_exists foreign key(id_b) references
B(id);
HTH
Johannes Lochmann
--
Disclaimer - These opiini^H^H damn! ^H^H ^Q ^[ .. :w :q :wq :wq! ^d X^?
exit X Q ^C ^c ^? :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT
^[zz ^[ZZ ^
On Wednesday 20 November 2002 10:48, Henshall, Stuart - Design & Print wrote:
> Michiel Lange wrote:
> Trigger functions can only return type OPAQUE which isn't seen by the
> client program.
I just saw that in 7.3 the return type for triggers has changed to TRIGGER.
HTH
On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:
Hi,
(which list should this go to? I guess it is OT on both...)
> Can anybody take me reference on Database design tool with PostgreSQL
> support.
Dia and dia2sql (or something similar...) Google knows more :-)
HTH
Johannes Lo
not find any syntax for ALTER TABLE ADD
> CONSTRAINT to put a NOT NULL constraint on a column. Can someone help
> me here?
An additional thought to what [EMAIL PROTECTED] said:
BEGIN;
ALTER TABLE msg_owner ADD CONSTRAINT chk_msg_owner_usr_opt_flds_null
CHECK(user_optional_fields IS NO
