Solved
http://dev.umpirsky.com/soap-server-and-test-client-with-zend_soap-symfony2-doctrine2-and-postgresql/
On 7 апр, 15:06, cgb <cgbrando...@gmail.com> wrote:
> 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
