[symfony-users] Case problem with doctrine2, symfony2 and postgresql entities

[umpirsky]

Hi.

I have a problem with doctrine2 in symfony2 app with postgres
database.

I get error:

    SQLSTATE[3F000]: Invalid schema name: 7 ERROR: schema "main" does
not exist

Problem is that my schema is Main not main. When I rename it, similar
thing happends for table relation:

    SQLSTATE[42P01]: Undefined table: 7 ERROR: relation
"main.brand_brandid_seq" does not exist

Problem is case sensitivity and I guess maybe it have something to do
with quoting or some doctrine configuration.

Entity:


    namespace GateSecure\ResellerApiBundle\Entity;

    /**
     * GateSecure\ResellerApiBundle\Entity\Brand
     *
     * @orm:Table(name="Main.Brand")
     * @orm:Entity
     */
    class Brand
    {
        /**
         * @var integer $brandid
         *
         * @orm:Column(name="BrandId", type="integer", nullable=false)
         * @orm:Id
         * @orm:GeneratedValue(strategy="SEQUENCE")
         *
@orm:SequenceGenerator(sequenceName="Main.Brand_BrandId_seq",
allocationSize="1", initialValue="1")
         */
        private $brandid;

        /**
         * @var string $brandname
         *
         * @orm:Column(name="BrandName", type="string", length=32,
nullable=false)
         */
        private $brandname;

        /**
         * Set name.
         *
         * @param string $name
         */
        public function setName($name) {
            $this->brandname = $name;
        }
    }

Schema:


    SET search_path = "Main", pg_catalog;

    CREATE SEQUENCE "Brand_BrandId_seq"
        START WITH 2
        INCREMENT BY 1
        NO MAXVALUE
        NO MINVALUE
        CACHE 1;


    SET default_tablespace = '';

    SET default_with_oids = false;


    CREATE TABLE "Brand" (
        "BrandId" integer DEFAULT
nextval('"Brand_BrandId_seq"'::regclass) NOT NULL,
        "BrandName" character varying(32) NOT NULL
    );

Controller:


            $reseller = new \GateSecure\ResellerApiBundle\Entity
\Brand();
            $reseller->setName('Sasa');

            $em = $this->get('doctrine.orm.entity_manager');
            $em->persist($reseller);
            $em->flush();

Any idea?

-- 
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 symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en