Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5
Bug #56 createTables.php doesn't handle bytea columns
Submitted: 2003-10-02 18:37 UTC
From: ieure at debian dot org Assigned: alan_k
Status: Closed Package: DB_DataObject
PHP Version: Irrelevant OS: Debian GNU/Linux 3.0
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
2003-10-22 10:32 UTC
Package:
Bug Type:
Summary:
From: ieure at debian dot org
New email:
PHP Version: Package Version: OS:

 

 [2003-10-02 18:37 UTC] ieure at debian dot org
Description: ------------ I have a PostgreSQL database, with a table which has a 'bytea' field type. 'bytea' is the PostgreSQL equivalent of MySQL's BLOB type, e.g. a binary string. When I run createTables.php, the bytea field is flagged as an integer (type 1) type in the schema. Reproduce code: --------------- This is the create statement for the offending table: CREATE TABLE "terminals" ( "model" text, "manufacturer" integer, "resolution" character varying(12), "bpp" smallint, "image" bytea, "id" integer DEFAULT nextval('"terminals_id_seq"'::text) NOT NULL ); Expected result: ---------------- The bytea field should be flagged as a string (type 2), not an integer. Actual result: -------------- The bytea field is flagged as an integer.

Comments

 [2003-10-02 23:49 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2003-10-03 04:28 UTC] ieure at debian dot org
With the (revised) patch posted to pear-dev[1], I'm able to work with bytea fields in a PostgreSQL 7.2.1 database. Versions newer than 7.2.1 don't require a cast to work, though there are other situations where it can be useful. [1]: http://marc.theaimsgroup.com/?l=pear-dev&m=106513287909758&w=2
 [2003-10-14 00:53 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2003-10-22 10:32 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!