ID: 31393 User updated by: mauroi at digbang dot com Reported By: mauroi at digbang dot com Status: Assigned Bug Type: PostgreSQL related PHP Version: Irrelevant Assigned To: yohgaki New Comment:
The database is very big (lots of schemas). I couldn't find a way to make that query faster. Of course, I make a regular vaccum full, but I don't get better results with this particular query. I don't think there's another use for this function (in fact, it can be used in the same situations where you use pg_field_type). Thanks in advance.... Previous Comments: ------------------------------------------------------------------------ [2005-01-12 07:17:03] yohgaki at ohgaki dot net Although, it seems 500 ms execution time for the query is too long. (Try vaccumedb -f , if you haven't done yet) The patch itself seems good. Question is getting OID of data type is good for anything else. ------------------------------------------------------------------------ [2005-01-03 22:39:59] [EMAIL PROTECTED] Assigning to the maintainer. ------------------------------------------------------------------------ [2005-01-03 22:18:54] mauroi at digbang dot com http://webmail.digbang.com/patch_type_oid.diff Thanks in advance ------------------------------------------------------------------------ [2005-01-03 22:14:35] [EMAIL PROTECTED] Can you provide a patch of this in unified diff format? (External please, and provide a link) ------------------------------------------------------------------------ [2005-01-03 22:07:18] mauroi at digbang dot com I can send the patch with the new function (tested on PHP-5.0.3) in case you need it. Just tell me where. Thanks in advance. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31393 -- Edit this bug report at http://bugs.php.net/?id=31393&edit=1
