Re: Storing number '001' ?

Charles,

> I get an error:
>
> chlamy_est=> CREATE TABLE clone_fasta(
> chlamy_est(> clone_fasta_id SERIAL PRIMARY KEY,
> chlamy_est(> clone_id INTEGER NOT NULL REFERENCES clone(clone_id) ON
> DELETE CASCADE,
> chlamy_est(> seq TEXT NOT NULL,
> chlamy_est(> length INTEGER NOT NULL
> chlamy_est(> );
> NOTICE:  CREATE TABLE will create implicit sequence
> 'clone_fasta_clone_fasta_id_seq' for SERIAL column
> 'clone_fasta.clone_fasta_id'
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
> 'clone_fasta_pkey' for table 'clone_fasta'
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
> check(s)
> ERROR:  Relation 'clone_fasta_clone_fasta_id_seq' already exists
>
>
> Something funny going on w/column names?

Nope.  You just dropped a previous instance of the clone_fasta table and
Postgres does not automatically drop the sequence. You need to manually
drop the sequence:
DROP SEQUENCE clone_fasta_clone_fasta_id_seq;
... before re-creating the table.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco