Menu
▾
▴
#2300 (ok 2.10.1) export table structure: Postgresql integer field
-- phpMyAdmin SQL Dump
-- version 2.9.0.3-Debian-1
-- Server version: 5.0.24
-- PHP Version: 5.1.6-1
debian testing (etch) Linux host1 2.6.17-2-686 #1 SMP
Wed Sep 13 16:34:10 UTC 2006 i686 GNU/Linux
-- Table structure for table `cards`
--
CREATE TABLE "cards" (
"ID" int(11) NOT NULL,
[..]
will make psql return an error message:
"ID" int(11) NOT NULL
----------------------
Mysql 5.0 supports "int(n)", see the reference:
INT[(M)] [UNSIGNED] [ZEROFILL],
mysql-documentation/refman-5.0-en.html-chapter/data-types.html#numeric-type-overview
On contrast postgresql seems to accept "int" only.
Therefore phpmyadmins export [export ->
sql-compatibility-mode: postgresql] should be changed
accordingly.
Logged In: YES
user_id=192186
Originator: NO
IMHO this is MySQL bug, we only tell it to show create table command with postgresql compatibility option.
Logged In: YES
user_id=210714
Originator: NO
I agree, but if we cannot rely on this MySQL feature, maybe we should remove it from the interface?
Logged In: YES
user_id=210714
Originator: NO
I should retry this with the current MySQL version, then report a bug to MySQL.
Logged In: YES
user_id=835650
Originator: NO
Related but just for more information; a user in the forums reports (https://sourceforge.net/forum/forum.php?thread_id=1684929&forum_id=72909) additional problems than just the integer field:
[quote]
postgre 8.0 do not understand next statements:
1) IF EXISTS
2) int(10)
3) unsigned
4) UNIQUE KEY protocol
5) collate latin1_general_cs
[/quote]
Logged In: YES
user_id=210714
Originator: NO
Problem persists with MySQL 5.0.33, so, I re-suggest that we remove this feature from our interface.
Logged In: YES
user_id=835650
Originator: NO
I can't find a MySQL bug report about it; is it better to drop support or file a bug with MySQL? I'm tempted to agree with Marc and vote to drop it...especially since even if MySQL fixes it, we'd have to do version tests about whether to offer it...people could get very confused and those needing the functionality can write their own SQL statement.
Logged In: YES
user_id=210714
Originator: NO
Dropped support for this MySQL feature.