Re: General error;-1002 POS(1) Too many columns

"Robert Klemme" <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
How wide are your varchar columns?  Maybe you hit some storage limit.

robert

2007/3/22, Chris Jölly <[email protected]>:
> Hello!
>
> i have a small table with one pk integer column and 4 varchar columns
> and want to issue the following alter statement to add a new column:
>
>         alter table my_table add ("delete_record" smallint)
>
> if the table both is filled or empty i can not add the column. i always
> get the error message:
>
>
> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Not Committed
> General error;-1002 POS(1) Too many columns
> alter table my_table add ( "delete_record" smallint )
>
> whats wrong with that statement?
>
> thx, chris
>
> --
> the version of the database is 7.5 running at suse linux...
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>


-- 
Have a look: http://www.flickr.com/photos/fussel-foto/

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.