Development

#2584 (propel:build-schema fail on postgresql for sequences)

You must first sign up to be able to contribute.

Ticket #2584 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

propel:build-schema fail on postgresql for sequences

Reported by: timu Assigned to: fabien
Priority: minor Milestone: 1.0.11
Component: model Version: 1.0.10
Keywords: postgresql propel creole Cc:
Qualification: Unreviewed

Description

if you try build schema from existing database for posgresql you'll get this exception message from symfony, "There was an error building XML from metadata: Could not list sequences [Native Error: ERROR: column "name" does not exist" if you are at PgSQLDatabaseInfo.php on line 96 it's says:

"SELECT c.oid, case when n.nspname='public' then c.relname else n.nspname'.'c.relname end as relname FROM pg_class c join pg_namespace n on (c.relnamespace=n.oid) WHERE c.relkind = 'S' AND n.nspname NOT IN ('information_schema','pg_catalog') AND n.nspname NOT LIKE 'pg_temp%' AND n.nspname NOT LIKE 'pg_toast%' ORDER BY name";

but "name" is not in select list, "name" it must be "relname" on order by clauser.

PS: sory for my bad english.

Attachments

propel.patch (0.5 kB) - added by timu on 11/26/07 10:47:16.
patch for typo error on PgSQLDatabaseInfo.php

Change History

11/26/07 10:47:16 changed by timu

  • attachment propel.patch added.

patch for typo error on PgSQLDatabaseInfo.php

12/26/07 23:13:44 changed by fabien

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

This is a Propel bug, not a symfony one. Please create a ticket on the Propel trac.

12/26/07 23:59:54 changed by FabianLange

  • keywords changed from postgresql propel to postgresql propel creole.
  • version changed from 1.1.0 to 1.0.10.
  • milestone set to 1.0.11.

to be more precise, it is a creole bug. Even the Propel team will not fix this (creole neither as it has been discontinued). I wonder if in that case a bugfix for 1.0.x could be made by symfony team. Especially as a patch exists?

12/27/07 00:22:55 changed by timu

Fabian Lange is right this is creole bug (and i am wrong for) and this is fixed in trunk, branches/1.1 and branches/1.2 on creole svn repository. this bug just only in tags/1.1.0 on creole svn repo.

already have a ticket and patch for this bug on creole trac system.

http://creole.phpdb.org/trac/ticket/31

12/27/07 00:41:03 changed by timu

This bug coming with symfony version 1.0.9, i am now realize. i dont know should i change Version for this bug.

12/27/07 08:45:07 changed by fabien

  • status changed from closed to reopened.
  • resolution deleted.

12/27/07 08:45:47 changed by fabien

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

in r6740 and r6741