Ticket #330 (closed defect: fixed)

Opened 1 year ago

Last modified 6 months ago

Query error when generating XML from postgres database

Reported by: propel@fractalmonkey.com Assigned to: hans
Priority: normal Milestone:
Component: Generator Version: 1.2.0RC1
Severity: normal Keywords:
Cc:

Description

Using: Propel 1.2.0 (tarball) Creole 1.1.0 (tarball) Phing 2.2.2 (tarball) PHP 5.1.6

../phing/bin/phing -Dproject=project_name creole

...

[propel-creole-transform] Propel - CreoleToXMLSchema starting [propel-creole-transform] Your DB settings are: [propel-creole-transform] driver : (default) [propel-creole-transform] URL : pgsql://www@localhost/project_name [propel-creole-transform] DB connection established [propel-creole-transform] Processing database [propel-creole-transform] Processing table: some_table [PHP Error] pg_query(): Query failed: ERROR: column "name" does not exist [line 96 of /path/to/propel/generator/classes/creole/drivers/pgsql/metadata/PgSQLDatabaseInfo.php] [propel-creole-transform] There was an error building XML from metadata: Could not list sequences [Native Error: ERROR: column "name" does not exist]

The query on line 96 references "name" instead of "relname" in it's ORDER BY. Making this change fixed the problem.

  • Bill M

Attachments

Change History

11/16/07 00:20:43 changed by hans

  • status changed from new to closed.
  • resolution set to fixed.

This has been fixed in Creole 1.2; I also just backported that fix to the 1.1 branch. Obviously it was an easy change ;)


Add/Change #330 (Query error when generating XML from postgres database)




Action