> I would like to learn the primary key value of successful SQL
> Insert command.

see "Returning". I think it was introduced with 2.1 or 2.5, definitely
not with 1.5.x

Suppose you don't include an ID in the statement, but only "other
fields" and have the ID created by a Trigger.

Insert into TableXYZ
(
OtherField_1,
OtherField_2
)
Values
(
value_1,
value_2
)
RETURNING
IDField