I'm not sure. How can I tell? This database is running on a different server
than the one that created the data. I'm trying to restore a fried server
from a backup. Not sure if that matters.
Tony
On 10/23/07 6:20 PM, "Bastien Koert" <[EMAIL PROTECTED]> wrote:
>
> Is logging turned on?
>
> bas
Is logging turned on?
bastien
> Date: Tue, 23 Oct 2007 16:12:14
-0600> From: [EMAIL PROTECTED]> To: php-db@lists.php.net> Subject: [PHP-DB] PG:
Table last updated?>> We've got a huge table in one of our Postgres databases
and nobody seems to> know what
We've got a huge table in one of our Postgres databases and nobody seems to
know what it's for. Do any of the system tables keep track of the last time
the table was altered (i.e. Row INSERTs, UPDATEs, etc)?
Tony
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
Hello
I did look into the info from EXPLAIN. I can create the indexes also but
then I have to create indexes with all permutation of column order if I want
to get good performance from all search query regardless of what order user
enters the column.
On 10/23/07, Theodoros Goltsios <[EMAIL PROTEC
In order to find out what is wrong with your query you could use
exceptions. A sample code could be:
try {
$query= ...
..
}
catch (Exception $e){
$errmsg = $e->getMessage();
print $errmsg;
}
This will print out the reason that mysql has for failing your code. An
obvious statement is th
Hello all, I receive an error of the following: The used SELECT
statements have a different number of columns. Any help, pointers,
tutorials are appreciated.
Here are the two tables structure I am trying to pull from:
Table 1
mysql> describe orders;
++--+--+-+--
Hi
I am a looking for a php / mysql programmer in, or within reach, of
Birmingham UK
I
have a variety of work including some very interesting and challenging
projects.
You can work here or from home, or a bit of both.
If you are interested email me [EMAIL PROTECTED] or call 0121 242 1473
I wou
