diff -ur phpPgAdmin-4.2.2.orig/classes/database/Postgres.php phpPgAdmin-4.2.2/classes/database/Postgres.php --- phpPgAdmin-4.2.2.orig/classes/database/Postgres.php 2008-12-18 06:28:57.000000000 +0100 +++ phpPgAdmin-4.2.2/classes/database/Postgres.php 2010-09-30 01:01:41.000000000 +0200 @@ -302,6 +302,14 @@ class Postgres extends ADODB_base { echo htmlspecialchars($value); echo "\n"; break; + case 'date': + $showsTime='false'; $timeFormat=''; + case 'timestamp': + if(!isset($showsTime)) { $showsTime='true'; $timeFormat=' %H:%M:%S'; } + echo "\n"; + echo ""; + echo ""; + break; default: echo "\n"; break; diff -ur phpPgAdmin-4.2.2.orig/classes/Misc.php phpPgAdmin-4.2.2/classes/Misc.php --- phpPgAdmin-4.2.2.orig/classes/Misc.php 2008-12-18 06:28:57.000000000 +0100 +++ phpPgAdmin-4.2.2/classes/Misc.php 2009-04-13 17:22:01.000000000 +0200 @@ -395,6 +395,12 @@ echo "\n"; // Theme echo "\n"; +?> + + + + +\n"; echo "\n"; echo "", htmlspecialchars($appName); diff -ur phpPgAdmin-4.2.2.orig/display.php phpPgAdmin-4.2.2/display.php --- phpPgAdmin-4.2.2.orig/display.php 2008-12-18 06:28:57.000000000 +0100 +++ phpPgAdmin-4.2.2/display.php 2010-10-02 01:41:27.000000000 +0200 @@ -61,6 +61,7 @@ echo "<th class=\"data\">{$lang['strnull']}</th><th class=\"data\">{$lang['strvalue']}</th></tr>"; $i = 0; + $shift=0; while (!$attrs->EOF) { $attrs->fields['attnotnull'] = $data->phpBool($attrs->fields['attnotnull']); @@ -106,7 +107,7 @@ // keep track of which element offset we're up to. We can't refer to the null checkbox by name // as it contains '[' and ']' characters. if (!$attrs->fields['attnotnull']) { - $extras['onChange'] = 'elements[' . ($elements - 1) . '].checked = false;'; + $extras['onChange'] = 'elements[' . ($elements - 1 + $shift) . '].checked = false;'; } if (($fksprops !== false) && isset($fksprops['byfield'][$attrs->fields['attnum']])) { @@ -116,6 +117,7 @@ echo $data->printField("values[{$attrs->fields['attnum']}]", $rs->fields[$attrs->fields['attname']], $attrs->fields['type'], $extras); + if (in_array(substr($attrs->fields['type'],0,9),array('date','timestamp'))) $shift++; echo "</td>"; $elements++; echo "</tr>\n";