Robert Fitzpatrick <[EMAIL PROTECTED]> writes:
> I have changed the default sequence on a primary key integer (created as
> SERIAL) field in a table, but it will not let me drop the old sequence
> and continues to tell me that the sequence is required by the table. Can
> someone tell me what is req
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Fri, Jun 20, 2003 at 11:14:25AM -0600, scott.marlowe wrote:
>> Actually, template0 is the "oh dear god, what have I done to template1"
>> recovery database that the initdb script (now program) creates when run.
> I think template0 is also used to co
On Thu, 19 Jun 2003, Erik Price wrote:
> Hi,
>
> I have a database with a few tables in it (this is just a "learning"
> database). Originally I set these tables up with sequences on them
> which increment the primary key of the table when a new record is
> inserted. I would like to drop thes
Tom Lane wrote:
Erik Price <[EMAIL PROTECTED]> writes:
So, is the solution to drop the column first, then drop the sequence,
then re-create the column by using ALTER TABLE ?
Perhaps what you are really looking to do is just to reset the sequence
counters with setval() ?
Believe it or not, I r
Erik Price <[EMAIL PROTECTED]> writes:
> So, is the solution to drop the column first, then drop the sequence,
> then re-create the column by using ALTER TABLE ?
Perhaps what you are really looking to do is just to reset the sequence
counters with setval() ?
regards, tom
