|
Home > Archive > PostgreSQL Bugs > May 2005 > request
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Llewellyn Falco 2005-05-07, 3:24 am |
| It is really hard to currently alter table schema.
Particularly the order of the table schema.
to move a column position is very hard. worse if your table as references (and which proper tables don't ?)
I would really like postgres to model the alter syntax of mysql, which is really easy to modify table schema especially to include the AFTER col_name part.
http://dev.mysql.com/doc/mysql/en/alter-table.html
thanks,
Llewellyn.
| |
| John Hansen 2005-05-07, 3:24 am |
| >
> It is really hard to currently alter table schema.
>
> Particularly the order of the table schema.
>
> to move a column position is very hard. worse if your table as
references (and which proper
> tables don't ?)
Doesn't that in itself promote bad programming?
Relying on the order of columns is a bad thing(tm), imo.
> I would really like postgres to model the alter syntax of mysql,
which is really easy to modify
> table schema especially to include the AFTER col_name part.
>
> http://dev.mysql.com/doc/mysql/en/alter-table.html
>
>
> thanks,
>
> Llewellyn.
>
>
.... John
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
| |
| John R Pierce 2005-05-07, 3:24 am |
| > I would really like postgres to model the alter syntax of mysql, which
> is really easy to modify table schema especially to include the AFTER
> col_name part.
A) why does the order of the columns in a particular table matter at all?
B) is this any sort of SQL standard?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
| |
| Andreas Pflug 2005-05-07, 1:23 pm |
| John R Pierce wrote:
>
>
> A) why does the order of the columns in a particular table matter at all?
If coding without caring (about portability/robustness), unfortunately
programmers are seduced by MySQL to work like that..
>
> B) is this any sort of SQL standard?
Definitely no.
Do not use SELECT * if you need a specific column ordering, *that* is
SQL standard.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org
|
|
|
|
|