[Bond-users] Open updatable <sql> from PostgeSQL Function

[Jasen Betts]

On Wed, Aug 07, 2013 at 08:59:46PM +0400, n.vorotnikova wrote:

> Warning: bonddb/bonddbid.c: 254: bonddb_id_get(): No primary key set
> in query: select * From dobancurrencies(341::int);

> Where is my mistake?

> Create TEMP  Table TMPTable( id int, fld1 int, fld2 int);

I think you need to declare a primary key:

 Create TEMP  Table TMPTable( id int PRIMARY KEY, fld1 int, fld2 int);

else if ID is not unique add another column as primary key, or possibly 
do this, but I don't rememver if OID support still works:

 Create TEMP  Table TMPTable( id int, fld1 int, fld2 int) WITH OIDS;

-- 
Jasen Betts
treshna Enterprises Ltd
Tel: +64 3 974 9169 or 0800 894 149  
(for Jasen dial ext 204 when the voice starts)
Fax: +64 28 894 860
Web: www.treshna.com
3/100 Manchester St, Christchurch, New Zealand
IT Consultancy - Websites - Database development - Computer tech support