CREATE TABLE "nextUrl"
(
  id int4 NOT NULL DEFAULT nextval('"nextUrl_id_seq"'::regclass),
  url varchar( 256 ),
  idurlstyle int4,
  free bool NOT NULL DEFAULT true,
  idurldataxml int4,
  CONSTRAINT xmldata_pkey PRIMARY KEY (id),
  CONSTRAINT "nextUrl_idurldataxml_fkey" FOREIGN KEY (idurldataxml)
      REFERENCES "nextUrlDataXML" (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE,
  CONSTRAINT "nextUrl_idurlstyle_fkey" FOREIGN KEY (idurlstyle)
      REFERENCES "nextUrlStyle" (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
) 
WITHOUT OIDS;

delete from "nextUrl" where "nextUrl".id = <значение id>;

CREATE TABLE test
(
  id serial NOT NULL,
  idtest2 int4,
  CONSTRAINT test_pkey PRIMARY KEY (id),
  CONSTRAINT test_idtest2_fkey FOREIGN KEY (idtest2)
      REFERENCES test2 (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE CASCADE
) 
WITHOUT OIDS;
ALTER TABLE test OWNER TO postgres;
-- ***********************************
CREATE TABLE test2
(
  id serial NOT NULL,
  name char( 80 ),
  CONSTRAINT test2_pkey PRIMARY KEY (id)
) 
WITHOUT OIDS;
ALTER TABLE test2 OWNER TO postgres;

--- запросы
insert into test2 (name) values ('имя'); 
insert into test (idtest2) values ( 1 );
delete from test where id =  1 ;
select * from test2;
id |            name                                
----+------------------------
   1  | имя                                                                       
( 1  row)