[SQL] Canceling other backend's query

Hi, Can i cancel querys runing on other backends, or disconnect a client from the server? I can kill the backend process, but sometimes this causing shared memory troubles. DAQ ---(end of broadcast)--- TIP 7: don't forget to increase your free spa

Re: [SQL] postgres 7.1.3: why does the query plan ignore indexes?

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Should we consider adding some warning when someone creates an index on > > an int2 column? > > I don't think so. Better to expend our energy on solving the > fundamental problem. I am thinking _until_ we fix the problem. Is it act

[SQL] How to return a record set from function.

Dear Friends,   I am newbie to Postgres. I am running 7.3.4 on Linux 7.3. I am using Pgadmin tool. I need to return the table rows via record set.   Create table t1 (c1 int, c2 varchar, c3 varchar);   Create or Replace function sel_t1 () returns setof records as ' select c1, c2, c3 from t1;

Re: [SQL] postgres 7.1.3: why does the query plan ignore indexes?

Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >>> Should we consider adding some warning when someone creates an index on >>> an int2 column? >> >> I don't think so. Better to expend our energy on solving the >> fundamental problem. > I