Выполнял запрос

SELECT
tb_inv_header.pos_id,
tb_inv_detail.invd_amount as fld_INVD_AMOUNT,
tb_article.art_name as fld_ART_NAME,
tb_articlegroup.grpname as fld_GRPNAME,
tb_pricemodificator.prm_name as fld_PRM_NAME,
tb_article.art_id as fld_ART_ID,
tb_inv_detail.invd_price_per as fld_INVD_PRICE_PER,
tb_inv_detail.invd_price_complete as fld_INVD_PRICE_COMPLETE
FROM
tb_inv_header
Inner Join tb_inv_detail ON tb_inv_header.invh_id = tb_inv_detail.invh_id
Inner Join tb_article ON tb_inv_detail.id = tb_article.id
Inner Join tb_articlegroup ON tb_article.grpid = tb_articlegroup.grpid
left Join tb_pricemodificator ON tb_inv_detail.prm_id = tb_pricemodificator.prm_id

v pgAdmin III работает

когда выполняю из Java, проблем:

ERROR: relation "tb_inv_header" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:339)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:238) ....

код создания таблиц:

CREATE TABLE tb_inv_detail
(
invd_id int8 NOT NULL,
invd_ordernr int8,
invh_id int8,
id int4,
invd_price_per float8,
invd_price_complete float8,
prm_id int4,
invd_amount int4,
invd_comment varchar(256),
CONSTRAINT tb_inv_detail_pkey PRIMARY KEY (invd_id),
CONSTRAINT fk_invdet_art FOREIGN KEY (id)
REFERENCES tb_article (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invdet_invh FOREIGN KEY (invh_id)
REFERENCES tb_inv_header (invh_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invdet_pm FOREIGN KEY (prm_id)
REFERENCES tb_pricemodificator (prm_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE tb_inv_detail OWNER TO dimo;



CREATE TABLE tb_inv_header
(
invh_id int8 NOT NULL,
invh_number varchar(25),
invh_crea_date timestamp,
pos_id int4 NOT NULL,
usrid int4 NOT NULL,
cus_id int4,
invh_state float8,
invh_pay_type int4,
CONSTRAINT tb_inv_header_pkey PRIMARY KEY (invh_id),
CONSTRAINT fk5b51152c211c062a FOREIGN KEY (cus_id)
REFERENCES tb_customer (cus_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invh_pos FOREIGN KEY (pos_id)
REFERENCES tb_pos (pos_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_invh_usr FOREIGN KEY (usrid)
REFERENCES tb_user (usrid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT tb_inv_header_invh_number_key UNIQUE (invh_number)
)
WITHOUT OIDS;
ALTER TABLE tb_inv_header OWNER TO dimo;

ето похоже глюк. (предполагаю в JDBC драйвере)
Postgres 8.1 для Windows

подключение к одной и той же БД