Skip site navigation (1) Skip section navigation (2)

Wrong error message from server

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 (view raw or flat)
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
-- */

pgsql-bugs by date

Next:From: Nicolas ANTONINIDate: 2008-07-03 13:03:48
Subject: Re: BUG #4167: When generating UUID using UUID-OSSP module, UUIDs are not unique on Windows
Previous:From: Joe ConwayDate: 2008-07-03 04:03:39
Subject: Re: Re: [BUGS] BUG #4203: perform dblink() in begin/exception returns wrong SQLSTATE code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group