[GENERAL] Disable the more command

2000-07-21 Thread Marcos Barreto de Castro
Hi, Can someone tell me how can I disable the more command at the end of any one page display in PostgreSQL 7.0 ? I simply don't want to be asked to press a key to continue displaying the result of a query. Thanks a lot! Marcos Castro ___

[GENERAL] Cursor Problems

2000-06-12 Thread Marcos Barreto de Castro
Hi, I have the following situation: I AM USING THE C LANGUAGE INTERFACE (LIBPQ) but I have also tried the situation described below from within psql and got the same results. I am using PostgreSQL version 6.4. - I Have to keep a cursor for a select * from open most of the time and somet

[GENERAL] Questions about CURSORS

2000-05-28 Thread Marcos Barreto de Castro
Hi, Suppose there is a table that's being shared among 5 computers at the same time. Suppose I've created a CURSOR for a SELECT * FROM GROUP BY . Suppose I have fetched the 3rd record and am going to fetch the 4th and in the meantime someone at another computer just DELETED that 4th recor

[GENERAL] Limits on PostgreSQL

2000-05-25 Thread Marcos Barreto de Castro
Hi, I am developing an application that will use the C API for postgreSQL and I need to know this: 1 - How many tuples can be returned as a result of a query using a CURSOR? (Is it possible to do a SELECT * on a table that has 2 million records and OPEN a CURSOR for that SELECT and show all r

[GENERAL] Queries using the C API

2000-05-16 Thread Marcos Barreto de Castro
e software developed using the Postgresql C API? If so, where can I find them? Thanks a lot for any help on this matter. Marcos Barreto de Castro email: [EMAIL PROTECTED] phone: +55 61 3498747 fax..: +55 61 3498747 __ Do You Yahoo!? Send instant mess