Re: [GENERAL] What is statement ID of table?

2009-10-12 Thread A. Kretschmer
In response to Jignesh Shah : Thanks Andreas. Sorry for confusion here. I mean statement ID that can be associated with prepared query(not table) to improve performance of building query. I just need to find plan using statement ID and execute it. I don't know how to do this. Please, answer

Re: [GENERAL] What is statement ID of table?

2009-10-12 Thread paragasu
you can create a primary key to associate with each row in the table On 10/12/09, A. Kretschmer andreas.kretsch...@schollglas.com wrote: In response to Jignesh Shah : Thanks Andreas. Sorry for confusion here. I mean statement ID that can be associated with prepared query(not table) to improve

[GENERAL] What is statement ID of table?

2009-10-11 Thread Jignesh Shah
Hi, Could any one please tell me what is statement ID of table? How to get it and in which scenarios it can be helpful? Any documentation or example about statement ID would also really helpful for me. Thanks, Jignesh

Re: [GENERAL] What is statement ID of table?

2009-10-11 Thread A. Kretschmer
In response to Jignesh Shah : Hi,   Could any one please tell me what is statement ID of table? There isn't such ID, but every table has an OID, an Object Identifier. How to get it and The (hidden) column oid of pg_class contains this OID. in which scenarios it can be helpful? Any

Re: [GENERAL] What is statement ID of table?

2009-10-11 Thread Jignesh Shah
Thanks Andreas. Sorry for confusion here. I mean statement ID that can be associated with prepared query(not table) to improve performance of building query. I just need to find plan using statement ID and execute it. I don't know how to do this. Thanks, Jignesh On Sun, Oct 11, 2009 at 8:06 PM,