Hello peopple,
I'm having some problems using postgres in symfony, I have a
database with several schemas defined on it and I can't make it work.
I tryed both propel and doctrine and allway arrived to the same
result: "SQLSTATE[3F000]: Invalid schema name:". Does anyone knows if
there is some document that explain how to write a schema.yml file for
this case?.
this is a copy of my schema.yml. is part of the schema.yml result of
build-schema process with propel
propel:
_attributes:
package: lib.model
defaultIdMethod: native
REO.CRMCCAS:
_attributes: { phpName: ReoCrmccas }
CODEMP: { phpName: Codemp, type: NUMERIC, size: '2', scale: '0',
primaryKey: true, required: true }
CODCAS: { phpName: Codcas, type: NUMERIC, size: '6', scale: '0',
primaryKey: true, required: true }
DESCRI: { phpName: Descri, type: VARCHAR, size: '80', required:
true }
IDENTI: { phpName: Identi, type: NUMERIC, size: '6', scale: '0',
required: true }
IDUSER: { phpName: Iduser, type: NUMERIC, size: '6', scale: '0',
required: true }
IDCONT: { phpName: Idcont, type: NUMERIC, size: '6', scale: '0',
required: true }
CODCAT: { phpName: Codcat, type: NUMERIC, size: '4', scale: '0',
required: true }
CBLCAT: { phpName: Cblcat, type: NUMERIC, size: '2', scale: '0',
required: true }
CODPRI: { phpName: Codpri, type: NUMERIC, size: '4', scale: '0',
required: true }
CODPRO: { phpName: Codpro, type: NUMERIC, size: '4', scale: '0',
required: true }
HORAFAC: { phpName: Horafac, type: NUMERIC, size: '4', scale: '0',
required: true }
HORAREA: { phpName: Horarea, type: NUMERIC, size: '4', scale: '0',
required: true }
SUBTFAC: { phpName: Subtfac, type: NUMERIC, size: '10', scale:
'2', required: true }
FECHA: { phpName: Fecha, type: DATE, required: true }
HORA: { phpName: Hora, type: TIME, required: true }
FECVEN: { phpName: Fecven, type: DATE, required: true }
FECFIN: { phpName: Fecfin, type: DATE, required: false }
NROREV: { phpName: Nrorev, type: NUMERIC, size: '5', scale: '0',
required: false }
_uniques: { i1201_fecha: [CODEMP, FECHA, CODCAS], i1201_fecha_uq:
[CODEMP, FECHA, CODCAS], i1202_prorev: [CODEMP, CODPRO, NROREV,
CODCAS], i1202_prorev_uq: [CODEMP, CODPRO, NROREV, CODCAS],
i1203_entrev: [CODEMP, IDENTI, CBLCAT, CODPRO, NROREV, CODCAS],
i1203_entrev_uq: [CODEMP, IDENTI, CBLCAT, CODPRO, NROREV, CODCAS],
i1204_catfec: [CODEMP, CBLCAT, FECHA, CODCAS], i1204_catfec_uq:
[CODEMP, CBLCAT, FECHA, CODCAS], i1205_entfec: [CODEMP, IDENTI,
CBLCAT, FECHA, CODCAS], i1205_entfec_uq: [CODEMP, IDENTI, CBLCAT,
FECHA, CODCAS], i1206_identi: [CODEMP, IDENTI, FECHA, CODCAS],
i1206_identi_uq: [CODEMP, IDENTI, FECHA, CODCAS], i1207_iduser:
[CODEMP, IDUSER, FECHA, CODCAS], i1207_iduser_uq: [CODEMP, IDUSER,
FECHA, CODCAS], i1208_nrorev: [CODEMP, CODPRO, NROREV, CODCAS],
i1208_nrorev_uq: [CODEMP, CODPRO, NROREV, CODCAS] }
REO.CRMDCAS:
_attributes: { phpName: ReoCrmdcas }
CODEMP: { phpName: Codemp, type: NUMERIC, size: '2', scale: '0',
primaryKey: true, required: true }
CODCAS: { phpName: Codcas, type: NUMERIC, size: '6', scale: '0',
primaryKey: true, required: true }
NROREN: { phpName: Nroren, type: NUMERIC, size: '4', scale: '0',
primaryKey: true, required: true }
DESCRI: { phpName: Descri, type: VARCHAR, size: '80', required:
true }
thanks
--
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 users" 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-users?hl=en
