Thread: SPI Insert

SPI Insert

From
Anand Surelia
Date:
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.


Help...

From
Summer
Date:
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