| 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) | ||
[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!