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"
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
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
dro
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 disreg
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 /usr/
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.
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
disks.
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
