Where

I am attempting to transfer the data in the fluid_id column of table process into column fluid_id of table pipe.

This should happen only when column contain of table process holds the value 'ip'.

Here is the command that I am having trouble with.
-------
create table process (fluid_id integer primary key, process varchar, contain varchar);

create table pipe ( fluid_id integer not null, contain varchar);

create or replace function base() returns trigger as $$

begin

insert into pipe (fluid_id) values (new.fluid_id);

select * into pipe from process where contain = 'ip';

return null;

end;

$$ language plpgsql;

create trigger trig1 after insert on process

for each row execute procedure base();

insert into process (fluid_id, process, contain)

values ('2', 'water', 'ip');

-------------------
On inserting data this error comes back -
-------
ERROR: relation "pipe" already exists
CONTEXT: SQL statement "SELECT * INTO pipe from process where contain = 'ip'"
PL/pgSQL function "base" line 4 at SQL statement
------
Of course the table pipe does already exist - it is a permanent table.

Is the program looking for some other target?? Perhaps a temporary table??

Or am I completely screwed up???

Bob