Re: [BUGS] request

#1

Quote:

=09
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=20
tables don't ?)

=09=20
Doesn't that in itself promote bad programming?
Relying on the order of columns is a bad thing(tm), imo.

Quote:

I would really like postgres to model the alter syntax of mysql,
which is really easy to modify=20
table schema especially to include the AFTER col_name part.

http://dev.mysql.com/doc/mysql/en/alter-table.html

thanks,

Llewellyn.

=09

.... John

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#2

Quote:

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 (AT) postgresql (DOT) org

#3

John R Pierce wrote:

Quote:

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?

If coding without caring (about portability/robustness), unfortunately
programmers are seduced by MySQL to work like that..

Quote:

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 (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] request

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] request - 05-06-2005 , 11:39 PM

Re: [BUGS] request - 05-07-2005 , 12:38 AM

Re: [BUGS] request - 05-07-2005 , 01:05 PM