On Thu, Jun 02, 2005 at 16:57:14 -0400,
Douglas McNaught <[EMAIL PROTECTED]> wrote:
>
> A serial column is basically just syntactic sugar for the above, so
> you're not losing anything.
In recent versions of postgres, I do think you lose something. I don't
believe the dependency will get tracke
"Marcelo" <[EMAIL PROTECTED]> writes:
> Hello,
> Using Postgres 7.4, I am trying to perform an "alter table temptable add
> column "myCol" serial"
>
> It gives the following msg
> ERROR: adding columns with defaults is not implemented
>
> You cannot add a column that is serial in a table whic
al Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Marcelo" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 02, 2005 4:43 PM
Subject: Re: [GENERAL] adding columns with defaults is not implemented
On Thu, 2005-06-02 at 15:29, Marcelo wrote:
Hello,
Using Post
CTED]>
> Cc:
> Sent: Thursday, June 02, 2005 4:43 PM
> Subject: Re: [GENERAL] adding columns with defaults is not implemented
>
>
> > On Thu, 2005-06-02 at 15:29, Marcelo wrote:
> > > Hello,
> > > Using Postgres 7.4, I am trying to perform an "alter table
?
Thanks again for your help.
Marcelo
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Marcelo" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 02, 2005 4:43 PM
Subject: Re: [GENERAL] adding columns with defaults is not implemented
> O
On Thu, 2005-06-02 at 15:29, Marcelo wrote:
> Hello,
> Using Postgres 7.4, I am trying to perform an "alter table
> temptable add column "myCol" serial"
>
> It gives the following msg
> ERROR: adding columns with defaults is not implemented
>
> You cannot add a column that is serial in a table
Hello,
Using Postgres 7.4, I am trying to perform an "alter table temptable add
column "myCol" serial"
It gives the following msg
ERROR: adding columns with defaults is not
implemented
You cannot add a column that is serial in a table
which already has data in postgres 7.
Is there a w
