| From: | Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PQsendQuery |
| Date: | 1999-08-05 03:02:45 |
| Message-ID: | 199908050302.EAA18663@argh.demon.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
Hi
I have a query regarding PQsendQuery that doesnt seem to be well explained
in the docs. My basic situation is that I want to run a series of queries
quickly, and I dont care what the result of them is (it is an insert).
1 ) When I run PQsendQuery(), can I then immediately run PQexec() or do I
have to wait till the PQsendQuery has returned.
2 ) If I use PQconsumeInput(), does this tell the backend to not send the
results of any queries pending? Or do I still get new ones coming back at me?
3 ) Finally, what happens if I close the database connection when I still have
a queue of queries sitting in the PQsendQuery queue?
>From what I have observed, I would guess:
1 ) PQexec is safe and jumps to the front of the queue
2 ) All future queries are still piped through
3 ) The unhandled queries are trashed.
Thanks
M Simms
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kaare Rasmussen | 1999-08-07 09:57:29 | Re: [GENERAL] ElephantWear Now Available... |
| Previous Message | The Hermit Hacker | 1999-08-04 22:14:41 | Re: [GENERAL] ElephantWear Now Available... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DE VOLDER Fabrice | 1999-08-05 06:25:29 | unsuscribe |
| Previous Message | Héctor Morales | 1999-08-05 00:30:23 | Problem with pgaccess |