X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A711B9DCC9D for ; Tue, 29 Nov 2005 12:47:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05848-04 for ; Tue, 29 Nov 2005 12:47:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail44.e.nsc.no (mail44.e.nsc.no [193.213.115.44]) by postgresql.org (Postfix) with ESMTP id DFBD19DCC8E for ; Tue, 29 Nov 2005 12:47:50 -0400 (AST) Received: from [192.168.0.57] (062016183238.customer.alfanett.no [62.16.183.238]) (authenticated bits=0) by mail44.nsc.no (8.13.5/8.13.5) with ESMTP id jATGlomI009081 for ; Tue, 29 Nov 2005 17:47:50 +0100 (CET) From: "Leif B. Kristensen" To: pgsql-sql@postgresql.org Subject: Re: Strange bug Date: Tue, 29 Nov 2005 17:47:49 +0100 User-Agent: KMail/1.8.1 References: <200511291531.30441.leif@solumslekt.org> <200511291552.53024.leif@solumslekt.org> <200511291701.26148.leif@solumslekt.org> In-Reply-To: <200511291701.26148.leif@solumslekt.org> X-Face: %iea8o"[SI'kMDS.`hz7lU=?\^lC9J-]CVjo; f{4-C:$?uVUEjyN~uYFn%*aH_c3d09U>=?utf-8?q?x=0A=09TXtaoj=7EMV=2E8PgG7hik9=3BcCT2N6+u?=@Y{wH\p3*_f~FH9k,Wi74e[_l%.7b^'zJ)8S'^G<(=?utf-8?q?=3D=0A=09zw8=5CPMC3=27=7BKl9=2EzL*ks!b6wA?=,c~'F`k&Vq|ELDGa|4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/278 X-Sequence-Number: 23529 On Tuesday 29 November 2005 17:01, Leif B. Kristensen wrote: >Is there an easy and non-disruptive way to do this? For the record, I just did the following: pgslekt=> create table rel_cits ( pgslekt(> relation_fk integer references relations (relation_id), pgslekt(> source_fk integer references sources (source_id), pgslekt(> PRIMARY KEY (relation_fk, source_fk) pgslekt(> ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rel_cits_pkey" for table "rel_cits" CREATE TABLE pgslekt=> insert into rel_cits (select relation_fk, source_fk from relation_citations); INSERT 0 19837 pgslekt=> create table event_cits ( pgslekt(> event_fk integer references events (event_id), pgslekt(> source_fk integer references sources (source_id), pgslekt(> PRIMARY KEY (event_fk, source_fk) pgslekt(> ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "event_cits_pkey" for table "event_cits" CREATE TABLE pgslekt=> insert into event_cits (select event_fk, source_fk from event_citations); INSERT 0 29139 pgslekt=> drop table event_citations cascade; NOTICE: drop cascades to rule _RETURN on view event_notes NOTICE: drop cascades to view event_notes DROP TABLE pgslekt=> drop table relation_citations cascade; NOTICE: drop cascades to rule _RETURN on view relation_notes NOTICE: drop cascades to view relation_notes DROP TABLE pgslekt=> drop table citations; DROP TABLE pgslekt=> alter table rel_cits rename to relation_citations; ALTER TABLE pgslekt=> alter table event_cits rename to event_citations; ALTER TABLE pgslekt=> \i views_and_functions.sql Seems simple enough :-) -- Leif Biberg Kristensen | Registered Linux User #338009 http://solumslekt.org/ | Cruising with Gentoo/KDE