ID:               47048
 Comment by:       webs dot support at gmail dot com
 Reported By:      ml-php dot net at bettercom dot de
 Status:           Feedback
 Bug Type:         PostgreSQL related
 Operating System: FreeBSD 7.0-RELEASE
 PHP Version:      5.2.8
 New Comment:

Felipe, check your code for the operating system FreeBSD 7.0 and you
catch a bug.


Previous Comments:
------------------------------------------------------------------------

[2009-01-17 22:56:08] fel...@php.net

It works fine for me, see:


teste=# SELECT table_schema, table_name FROM information_schema.tables
WHERE table_schema = 'public';
 table_schema | table_name 
--------------+------------
 public       | id

var_dump(pg_meta_data($x, 'id'));

array(1) {
  ["id"]=>
  array(6) {
    ["num"]=>
    int(1)
    ["type"]=>
    string(4) "int4"
    ["len"]=>
    int(4)
    ["not null"]=>
    bool(false)
    ["has default"]=>
    bool(false)
    ["array dims"]=>
    int(0)
  }
}


------------------------------------------------------------------------

[2009-01-17 21:59:53] igulyaev at gmail dot com

part of pgsql.c

        src = estrdup(table_name);
        tmp_name = php_strtok_r(src, ".", &tmp_name2);

        if (!*tmp_name2) {
                /* Default schema */
                tmp_name2 = tmp_name;
                tmp_name = "public";
        }

in condition tmp_name2 is NULL if table_name without scheme name

------------------------------------------------------------------------

[2009-01-17 21:06:11] webs dot support at gmail dot com

(gdb) where
#0  0x0000000804d338e1 in php_pgsql_meta_data () from
/usr/local/lib/php/20060613-debug/pgsql.so
#1  0x0000000804d344e9 in zif_pg_meta_data () from
/usr/local/lib/php/20060613-debug/pgsql.so
#2  0x00000000005c7e29 in zend_do_fcall_common_helper_SPEC
(execute_data=0x7fffffffcf50) at zend_vm_execute.h:200
#3  0x00000000005cea3f in ZEND_DO_FCALL_SPEC_CONST_HANDLER
(execute_data=0x7fffffffcf50) at zend_vm_execute.h:1729
#4  0x00000000005c7864 in execute (op_array=0x929588) at
zend_vm_execute.h:92
#5  0x000000000059b830 in zend_execute_scripts (type=8, retval=0x0,
file_count=3) at /usr/ports/lang/php5/work/php-5.2.8/Zend/zend.c:1134
#6  0x000000000053aecb in php_execute_script
(primary_file=0x7fffffffe890) at
/usr/ports/lang/php5/work/php-5.2.8/main/main.c:2023
#7  0x0000000000629957 in main (argc=2, argv=0x7fffffffea10) at
/usr/ports/lang/php5/work/php-5.2.8/sapi/cli/php_cli.c:1133

------------------------------------------------------------------------

[2009-01-16 11:30:59] j...@php.net

Compile PHP using --enable-debug option and provide a new, useful
backtrace.

------------------------------------------------------------------------

[2009-01-14 06:33:39] ml-php dot net at bettercom dot de

postgres-8.3.5 is the version I'm using here (server & libs)

------------------------------------------------------------------------

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/47048

-- 
Edit this bug report at http://bugs.php.net/?id=47048&edit=1

Reply via email to