On Wed, 2004-07-28 at 06:09, Prabu Subroto wrote:
> Dear Scott...
>
> My God so I can not use "alter table" to define a
> column with int data type?
Not define, REdefine. Right now, the version going into beta will let
you redefine columns from one type to another. Til then, you have to
mak
This is exactly what I need..
Thank you very much for your kindness, Doug.
Thank you...thank you...veryvery,,, much.
--- Doug McNaught <[EMAIL PROTECTED]> wrote:
> Prabu Subroto <[EMAIL PROTECTED]> writes:
>
> > If I read your suggestion, that means...I have
> drop
> > the column "salesid" a
Prabu Subroto <[EMAIL PROTECTED]> writes:
> If I read your suggestion, that means...I have drop
> the column "salesid" and re-create the column
> "salesid". and it means, I will the data in the
> current "salesid" column.
>
> Do you have further suggestion?
You can do it "by hand" without droppin
On Wed, Jul 28, 2004 at 05:09:33AM -0700, Prabu Subroto wrote:
> Dear Scott...
>
> My God so I can not use "alter table" to define a
> column with int data type?
eh? Sure you can:
alter table x add column y integer;
What's he's saying is that the "serial" shortcut isn't there and
proceeded
Dear Scott...
My God so I can not use "alter table" to define a
column with int data type?
Here is the detail condition:
I have created a table "sales". And I forgot to define
auto_increment for primary key "salesid" (int4). the
table has already contented the data.
I built an application wi
