From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Wrong error message from server |
Date: | 2008-07-03 10:18:24 |
Message-ID: | 002801c8dcf6$22822840$1200a8c0@kharkov.localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
ERROR: syntax error at or near "and" at character 307
Actually error is at character 618
-------------------------------------------------
/*
DELETE FROM akh_test_suit_detail
WHERE ID in (
select atsd.id as id1
from akh_test_suit_detail atsd
left join akh_test_suit ats on ats.ID = atsd.test_suit_id
where atsd.test_group_id = 6204 and ats.suit_status_id = get_property_id( 'suit_status', 'IN DEV' )
)
-- */
-- /*
INSERT INTO akh_test_suit_detail
( test_suit_id, test_group_id )
select
atst.value::integer, atsd.test_group_id as id2
from akh_test_suit_detail atsd
left join akh_test_suit ats on ats.ID = atsd.test_suit_id
left join akh_test_suit_type atst on atst.ID = ats.test_suit_type_ID
where atsd.test_group_id = ? and ats.suit_status_ID = get_property( 'suit_status', 'IN DEV' )
group by atsd.test_group_id, atst.value
-- */
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas ANTONINI | 2008-07-03 13:03:48 | Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows |
Previous Message | Joe Conway | 2008-07-03 04:03:39 | Re: Re: [BUGS] BUG #4203: perform dblink() in begin/exception returns wrong SQLSTATE code |