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 "{$lang['strnull']} | {$lang['strvalue']} | ";
$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 "";
$elements++;
echo "\n";