Christoph,
> This is no good programming style.
> Does anybody have another, better idea or is
> there at least a header file available, where
> all the error messages can be found?
Try posting this question to pgsql-hackers instead. I think you'll get
more knowledgable help there.
-Josh
I'm having trouble finding the best solution for the following plpgsql
function.
The function does the following:
- gets an integer from table1 (using function getHighMark)
- Updates info.lastused with the latest timestamp from usage_log where
info.id = usage_log.id, but only if the sequence numb
[SQL] ERROR: Cannot insert a duplicate key into a unique index
I'm working on a C code application using loads of
insert commands.
It is essential to distinguish between an error
coming from a misformed command or other fatal
reasons and a duplicate key.
In either case, the PQresultStatus()
victor writes:
> CREATE FUNCTION add_one (integer) RETURNS integer AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'plpgsql';
>
> >from postgres doc.
> When I try somethin like this:
>
> SELECT add_one(4);
>
> I get :
>
> ERROR: fmgr_info: function 20086: cache lookup failed
Possibly you have
Hi,
I have this function:
CREATE FUNCTION add_one (integer) RETURNS integer AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';
from postgres doc.
When I try somethin like this:
SELECT add_one(4);
I get :
ERROR: fmgr_info: function 20086: cache lookup failed
please tell me what it's rong.
If you refere to more than one table in a query, you have to specify
which column to which table belongs. So your query must be
Select XID, xi.DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
xi.System=1 and xi.Category=c.Index
Arne.
Olle Wijk wrote:
>
> Hi,
>
> I am pretty new att
Sorry If i didnt make clear which are the fields and which are the tables.
The tables are the ones "underlined", so I have cdroms, items, cdroms_items,
loans and reservations. I just left the important
fields in order not to confuse the people, and just wrote the name of the
fields that are the p
