-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> The problem I am encountering is with having a primary key labeled as
> serial. Do I have to drop the sequence also to be able to recreate the
> table? Omitting the sequence drop did not seem to allow the creation of the
> table with a serial, but
- Original Message -
From: "Brook Milligan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 29, 2000 12:28 PM
Subject: Re: [GENERAL] SQL scripts - sequences
> My solution in a similar situation is to have a bunch of scripts to
The problem I am encountering is with having a primary key labeled as
serial. Do I have to drop the sequence also to be able to recreate the
table? Omitting the sequence drop did not seem to allow the creation of the
table with a serial, but when I added a drop sequence, the table cr
I'm building a database and making my table creates in a text file so that,
if I want to recreate my database, I can just rerun the scripts.
At the top of the script are the statements to drop the tables. Next is the
area which creates the tables.
The problem I am encountering is with having a
