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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco