title: I have a trouble about a SQL instruction on PostgreSQL
body: <p>I have the follow instruction on PostgreSQL:</p>
  
  <pre><code>CREATE TABLE ACTOR(
      ACT_CUIL            NUMERIC(8,0) NOT NULL,
      ACT_NOMBRE      CHARACTER VARYING(25) NOT NULL,
      ACT_APELLIDOPAT     CHARACTER VARYING(25) NOT NULL,
      ACT_APELLIDOMAT     CHARACTER VARYING(25) NOT NULL,
      ACT_NOMARTCO            CHARACTER VARYING(25) NULL,
      ACT_ROL         CHARACTER VARYING(25) NOT NULL,
      PRIMARY KEY             (ACT_CUIL),
      FOREIGN KEY            (ID_ELEN)  REFERENCES ELENCO(ID_ELEN)
  
  );
  </code></pre>
  
  <p>The Primary Key from ACTOR is created; but the pgAdmin compiler says me: </p>
  
  <pre><code>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "actor_pkey" for table "actor"
  ERROR:  column "id_elen" referenced in foreign key constraint does not exist
  
  
  ********** Error **********
  
  ERROR: column "id_elen" referenced in foreign key constraint does not exist
  SQL state: 42703
  </code></pre>
  
  <p>About this I don't know what is the problem. I use the official documentation at <a href="http://www.postgresql.org/docs/8.1/static/ddl-constraints.html" rel="nofollow">http://www.postgresql.org/docs/8.1/static/ddl-constraints.html</a></p>
  
  <p>Thanks 
  Regards</p>