I wanted to change a foreign key to be deferrable (db version 7.2.1).
During table creation I didn't specify a constraint name for the foreign
key.
\d shows a trigger RI_ConstraintTrigger_17195, however when I'm trying
to alter table mytable drop constraint RI_ConstraintTrigger_17195
restrict I'm
since name of constrauint is in mixed cased
u must double quote it in command. below will work.
psql alter table mytable drop constraint RI_ConstraintTrigger_17195 restrict ;
I wanted to change a foreign key to be deferrable (db version 7.2.1). During table
creation I
didn't specify a
Oops disregard my prev reply,
RI_ConstraintTrigger_17195 is a trigger not contraint so u must in 7.2.1 do
DROP TRIGGER RI_ConstraintTrigger_17195 on mytable ;
in 7.3 foreign key constraints on tables have name.
so you need not drop underlying triggers like in 721 but can use command to
drop
Thanks Mallah,
I didn't realize the name of the trigger is in mixed case. However, I had to drop
another 2 triggers
on the referenced table. So it looks for me, a foreign key uses 3 triggers at all.
Looking into
pg_trigger, I found them all.
Thanks
Egon
[EMAIL PROTECTED] wrote:
Oops
Mr. Elphick:
OK. Here is what I got.
hesco@biko:~$ ls -al /usr/bin/psql
lrwxrwxrwx1 root root 10 Oct 10 16:24 /usr/bin/psql -
pg_wrapper
hesco@biko:~$ ls -al /usr/bin/pg_w*
-rwxr-xr-x1 root root 6584 Sep 11 04:30 /usr/bin/pg_wrapper
hesco@biko:~$ ls -al
On Sun, 2002-11-24 at 16:18, Hugh Esco wrote:
So it appears that instead of copying the symbolic link, it copied instead
pg_wrapper, renaming it in the new directory as psql.
hesco@biko:~$ /usr/lib/postgresql/bin/psql -U hesco template1
hangs, and spins the hard drive interminably.
So I
At 10:47 14.11.2002 -0500, A.M. wrote the following message:
What you're looking for is SQLRelay.
one can not use sql relay as fake postgresql server?
Thanks in advance.
Tomaz
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Mallah,
I agree with Chris. The fastest is to have an in
memory database.
Raid 0 (striping) will speed up both reading and
writing since you have more available disk I/O
bandwidth.
SCSI320 in theory is twice as fast as SCSI160. But the
bottleneck will be the throughput of the individual
Oliver Elphick asked:
What have you got in /var/lib/dpkg/diversions?
Here is my preliminary answer, plus a question of my own:
biko:/var/lib/dpkg# ls -al | grep diversions
-rw-r--r--1 root root 361825 Nov 21 18:48 diversions
-rw-r--r--1 root root 361931 Nov 21 18:48