replace "main" to "public"
On 6 abr, 19:44, umpirsky <umpir...@gmail.com> wrote:
> 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
