Hi:
i have a posgrest db and i use enum type.
when i generate the scheme.yml file there is a notice on:
symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Import/Pgsql.php
this is because the query (listTableColumns) has a missing columns
i fix it by adding the typtype columns like this:
over the line 101 of
symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Import/Pgsql.php
in posgres 8.4
(SELECT typcategory
FROM pg_catalog.pg_type
WHERE typname = udt_name) as typtype
in postgres 9.x
(SELECT typtype
FROM pg_catalog.pg_type
WHERE typname = udt_name) as typtype
in pogres 9 over the line 196:
if ($val['typtype'] == 'E'){
Change the e by E
over the line 198:
$t_result = $this->conn->fetchAssoc(sprintf('select enum_range(null::%s) as
range ', $decl['enum_name']));
change the end of the line $decl['enum_name'] by $val['type']
i hope u understend me.
best regard,
Maceo.
________________________________
Ing. Adonys Maceo
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
