On Mon, Aug 01, 2005 at 04:02:14PM +0200, Renzo Kottmann wrote:
> > Do other tables have foreign key references to t_node? If so, are
> > there indexes on those tables' foreign key columns? How many records
> > are in t_node and any tables that reference it? Do you keep the
> > tables vacuumed a
"Renzo Kottmann" <[EMAIL PROTECTED]> writes:
> "t_annotation_ann_startnode_id_fkey" FOREIGN KEY (ann_startnode_id)
> REFERENCES t_node(node_global_id) MATCH FULL
> "t_annotation_ann_endnode_id_fkey" FOREIGN KEY (ann_endnode_id)
> REFERENCES t_node(node_global_id) MATCH FULL
You need indexe
> On Mon, Aug 01, 2005 at 01:57:32PM +0200, Renzo Kottmann wrote:
>> If I try a
>>
>> delete
>> from t_node
>> where node_doc_id = XX;
>>
>> from inside a plpgsql function
>> ...
>> The deletion does not finish after several minutes and the CPU is
>> running at 100% all the time unless
On Mon, Aug 01, 2005 at 01:57:32PM +0200, Renzo Kottmann wrote:
> If I try a
>
> delete
> from t_node
> where node_doc_id = XX;
>
> from inside a plpgsql function
> ...
> The deletion does not finish after several minutes and the CPU is
> running at 100% all the time unless I stop po
Post the result of
\d t_node t_documentOn 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:
Gnanavel S wrote:> post the description of the t_node and t_document tables for more> information>> On 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:>
>>Hello,I have a strange delete behaviour in my
Gnanavel S wrote:
> post the description of the t_node and t_document tables for more
> information
>
> On 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:
>
>>Hello,
>>
>>I have a strange delete behaviour in my postgres 8.0.3 database:
>>
>>If I try a
>>
>>delete
>>from t_node
>>where node_doc
post the description of the t_node and t_document tables for more informationOn 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]
> wrote:Hello,I have a strange delete behaviour in my postgres 8.0.3 database:
If I try adelete from t_node where node_doc_id = XX;from inside a plpgsql functionon th
Hello,
I have a strange delete behaviour in my postgres 8.0.3 database:
If I try a
delete
from t_node
where node_doc_id = XX;
from inside a plpgsql function
on this table:
CREATE TABLE t_node (
node_global_id int4 DEFAULT nextval('seq_node') NOT NULL ,
node_doc_id
