SPI Insert

Started by Anand Sureliaover 27 years ago2 messagesgeneral
Jump to latest
#1Anand Surelia
anand@bytekinc.com

Hi All,
When you insert a row within a SPI procedure is the inserted tuple or
its oid returned somewhere? There is a variable SPI_Tuptable which is
set with the tuples returned from a select query.
Thanks,
Anand.

#2Summer
summerd@cs.unm.edu
In reply to: Anand Surelia (#1)
Help...

I have set up a database using psql and everything has been going pretty
well. I am storing a relatively significant amount of data in the tables.
One particular table has about 22000 entries. All of a sudden I cannot get
any queries to return on this table. Even a simple:

select * from table;

The database actually hangs. I have not encountered this type of problem
before. Is there some limitation to the size of a table? Is there a way I
can try and get into the data? The other tables are behaving normally.....

Any suggestions would be greatly appreciated.

Summer
UNM