FAQ
Edit report at http://pear.php.net/bugs/bug.php?id=16017&edit=1

ID: 16017
Updated by: daniel.oconnor@gmail.com
Reported By: simon dot jackson at carringbush dot net
Summary: Postgres default field value metadata
-Status: Feedback
+Status: Duplicate
Type: Bug
Package: MDB2
PHP Version: 5.2.5
Roadmap Versions:
New Comment:

-Status: Feedback
+Status: Duplicate



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

[2010-01-17 09:41:09] hschletz

This looks like a duplicate of bug #16281 for which a solution is
available.

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

[2009-10-03 11:37:49] quipo

-Status: Open
+Status: Feedback
Can I have an example or a reproducing test case?

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

[2009-05-24 21:41:52] ifeghali

-Summary: Issue with field validation length
+Summary: Postgres default field value metadata
-Package: MDB2_Schema
+Package: MDB2

Im looping this to the MDB2 guys so we can get their thoughts on it.

Best,
~IF.

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

[2009-03-12 07:00:08] slj

This is with PostgreSQL 8.2.

I haven't tried this with any other versions of PostgreSQL or any
versions of MySQL yet.

A default value of a single space comes back as the rather long:

' '::character varying

Alternatively, it might be possible/better to persuade
MDB2_Driver_pgsql to just pass back the actual default value (i.e. the
single space) rather than the fully enquoted and cast value. This would
remove the need to modify MDB2_Schema. On the other hand if one is
reverse engineering the metadata, it would be best to know the full
defaults value.

I confess I'm not sure which is the best way to proceed.

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

[2009-03-11 23:44:08] ifeghali

Hello Simon,

what RDBMS is that ? I am not sure putting database specific checks in
there is the best way to go. Let me think about that a bit more. Perhaps
you could create your own Validate class and pass it as a option ?

Regards,
Igor Feghali.

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

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://pear.php.net/bugs/bug.php?id=16017

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppear-bugs @
categoriesphp
postedMar 2, '10 at 9:40a
activeMar 2, '10 at 9:40a
posts1
users1
websitepear.php.net

1 user in discussion

Daniel Oconnor: 1 post

People

Translate

site design / logo © 2022 Grokbase