Don't think so. It's set to '"$user",public'. But the order of schemas should result with insert into wrong table, not in adding _just_ one column from table from scheme buffor to my insert into table from scheme public, shouldn't it? As i wrote before - problem isn't that my insert goes into wrong table - problem is that with pgpool on it adds to my insert some random column from other table.
On 6 August 2010 16:04, Glyn Astill <[email protected]> wrote: > > Surely this depends on what order you have the schemas detailed in the > search_path variable. > > > --- On Fri, 6/8/10, Marcin Kwiatkowski <[email protected]> wrote: > >> From: Marcin Kwiatkowski <[email protected]> >> Subject: [Pgpool-general] Problem with tables with same name >> To: [email protected] >> Date: Friday, 6 August, 2010, 14:20 >> Hello >> >> I'm using pgpool in replication mode and i have a big >> problem with >> tables with same name. It happens with postgres 8.4.4 and >> pgpool-II >> 2.3.3. I'm attaching a simplified dump of a database. It >> has 2 tables: >> mytable in schema public and in schema buffor. They both >> have very >> different columns. And when i try to make an insert: >> >> "INSERT INTO mytable (p5, p9, p8, p6, p7, p2, p3, p4, p10, >> p11, p12, >> p13, p14, p15, p17, p18, p1) values ('2010-08-04 >> 15:38:43.808000 >> +02:00:00', '2010-08-04 15:38:43.791000 +02:00:00', NULL, >> NULL, true, >> 599112, 599113, 1, NULL, NULL, NULL, NULL, NULL, null, >> NULL, NULL, >> 299299);" >> >> which should go into public.mytable i get an error: >> "ERROR: column "p59" of relation "mytable" does not >> exist >> LINE 1: ... p17, p18, p1) values ('2010-08-04 >> 15:38:43.808000 +02:00:00..." >> >> The problem that there's no column p59 in public.mytable - >> it exists >> only in buffor.mytable. >> >> Pgpool log says: >> "SimpleQuery: Error or notice message from backend: : DB >> node id: 0 >> backend pid: 18429 statement: INSERT INTO "mytable"("p5", >> "p9", "p8", >> "p6", "p7", "p2", "p3", "p4", "p10", "p11", "p12", "p13", >> "p14", >> "p15", "p17", "p18", "p1", "p59") VALUES ('2010-08-04 >> 15:38:43.808000 >> +02:00:00','2010-08-04 15:38:43.791000 >> +02:00:00',NULL,NULL,'t'::bool,599112,599113,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,299299,'2010-08-06 >> 15:14:37.669948+02') message: column "p59" of relation >> "mytable" does >> not exist" >> >> It seems then that it's pgpool which added that column to >> my insert. >> It works ok when i explicit write public.mytable in insert >> but that >> insert is autogenerated by an hibernate so i can't >> workaround it that >> way.That insert also works ok if i run it on same postgres >> but without >> pgpool. >> >> Any idea how to fix it? >> >> -- >> Pozdrawiam >> Marcin Kwiatkowski >> >> -----Inline Attachment Follows----- >> >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general >> > > > > -- Pozdrawiam Marcin Kwiatkowski _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
