When grilled further on (Sun, 06 Nov 2005 18:52:40 -0500),
Andrew Dunstan <[EMAIL PROTECTED]> confessed:
>
> Which version is first in your path, 8.0 or 8.1? If 8.0, do you get a
> different result from the 8.1 binaries?
>
8.0 was first. I've specified the correct full path now for the executables.
Also, I've actually installed the shared libraries for the types and triggers
that I use on that DB. I always seem to forget that :-(
But, the table/index that it dies on is not using either the trigger or non
native types, unless PG isn't getting the chance to emit that it's working on
the next one before it goes out to lunch? The second reload died also. If the
third dies (now that the type is in place), I'll do the re-compile and core.
tassiv=# \d zero_pair
Table "public.zero_pair"
Column | Type | Modifiers
--------------+---------+-----------
pair_id | integer | not null
group_id | integer |
zero_v | real | default 0
zero_v_sigma | real | default 0
zero_i | real | default 0
zero_i_sigma | real | default 0
Indexes:
"zero_pair_pkey" PRIMARY KEY, btree (pair_id)
"zero_pair_group_id" btree (group_id)
Foreign-key constraints:
"zero_pair_group_id_fkey" FOREIGN KEY (group_id) REFERENCES
color_groups(group_id) ON DELETE CASCADE
"zero_pair_pair_id_fkey" FOREIGN KEY (pair_id) REFERENCES pairs(pair_id) ON
DELETE CASCADE
tassiv=# \d zero_pair_pkey
Index "public.zero_pair_pkey"
Column | Type
---------+---------
pair_id | integer
primary key, btree, for table "public.zero_pair"
Cheers,
Rob
--
19:49:33 up 35 days, 12:24, 8 users, load average: 2.93, 2.51, 2.30
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
