pnfsDump2MigratePnfs2Chimera: companion2chimera.sql

---
--- migrate companion info into t_locationinfo table
---
--- v0.1
---


CREATE OR REPLACE FUNCTION "public"."companion2chimera" ()  RETURNS void AS $$
DECLARE
    ichain  RECORD;
 BEGIN
     FOR ichain IN SELECT * FROM cacheinfo LOOP
         BEGIN
                INSERT INTO t_locationinfo VALUES ( ichain.pnfsid, 1, ichain.pool, 10, NOW(), NOW(), 1);
             EXCEPTION WHEN foreign_key_violation THEN
          RAISE NOTICE 'not in chimera %', ichain.pnfsid;
               --- INSERT INTO t_locationinfo_trash VALUES ( ichain.pnfsid, 1, ichain.pool, 10, NOW(), NOW(), 0);
        END;
     END LOOP;
END;
$$
LANGUAGE 'plpgsql';