Thread: SPI Insert
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.
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