Re: [GENERAL] Why grantor is owner in this case?

2009-12-27 Thread donniehan
Dear Tom, I'm sorry to bother you. i really care about this behavior, but i couldn't find the discussions you mentioned in pgsql-hackers archives. Would you please tell me more about the discussions(about date? the related issue?), so that i can search it and find it more easily? Thank you very

Re: [GENERAL] Why grantor is owner in this case?

2009-12-27 Thread donniehan
Hi Tom, Thanks for your information. One more question, if i wanna get the accurate information about grantor(Sometimes the application just needs the information), what can i do? Apparently i cannot get from the acls, so where can i get the info? -Dongni "Tom Lane" news:4759.1261758..

Re: [GENERAL] Finding the bin path

2009-12-27 Thread Craig Ringer
On 27/12/2009 2:12 PM, Rob Jaeger wrote: I was not clear in my initial question. I need to access the pg_dump.exe and pg_restore.exe files from within a c++ program. I can't execute pg_config.exe because it's in that bin that I'm seeking. I don't quite follow Greg Smith's reply of 'try guess bas

Re: [GENERAL] Finding the bin path

2009-12-27 Thread Craig Ringer
On 27/12/2009 2:12 PM, Rob Jaeger wrote: I don't quite follow Greg Smith's reply of 'try guess based on "which postmaster"' (can you clarify?) He's talking about UNIX systems. This will not help you. But - I think I have found what I need! I can do a "SHOW data_directory;" and then from ther

Re: [GENERAL] Finding the bin path

2009-12-27 Thread John R Pierce
Rob Jaeger wrote: I was not clear in my initial question. I need to access the pg_dump.exe and pg_restore.exe files from within a c++ program. I can't execute pg_config.exe because it's in that bin that I'm seeking. I don't quite follow Greg Smith's reply of 'try guess based on "which postmas

Re: [GENERAL] Finding the bin path

2009-12-27 Thread Rob Jaeger
I was not clear in my initial question. I need to access the pg_dump.exe and pg_restore.exe files from within a c++ program. I can't execute pg_config.exe because it's in that bin that I'm seeking. I don't quite follow Greg Smith's reply of 'try guess based on "which postmaster"' (can you clarify?

Re: [GENERAL] Get Comments on Tables / Functions

2009-12-27 Thread Thomas Kellerer
Alex - wrote on 27.12.2009 14:57: Hi, i am adding comments to tables and functions with version information and would like to extract that information through a query. Is there and easy way to do that? simple list. table_name, comment SELECT n.nspname as schema_name, c.relname as table

[GENERAL] Get Comments on Tables / Functions

2009-12-27 Thread Alex -
Hi,i am adding comments to tables and functions with version information and would like to extract that information through a query. Is there and easy way to do that? simple list. table_name, comment ThanksAlex

Re: [GENERAL] Optimizing data layout for reporting in postgres

2009-12-27 Thread Alban Hertroys
On 24 Dec 2009, at 21:01, Doug El wrote: > Hi, > > I have to summarize some data to be queried and there are about 5 million raw > records a day I need to summarize. In a nutshell I don't think I'm laying it > out in an optimal fashion, or not taking advantage of some postgres features > perha

Re: [GENERAL] How to get a list of tables that have a particular column value?

2009-12-27 Thread Alban Hertroys
On 24 Dec 2009, at 14:35, Rajan, Pavithra wrote: > > Hello -Yes I need to find out the column value like '%Volt%' in any > column of data_type (character varying) of any table. Basically what I > need to do is go thro each columns of all tables and find any entries > that have Voltage followed b

Re: [GENERAL] Who writes "CONTEXT" ?

2009-12-27 Thread Jasen Betts
On 2009-12-21, Nicola Farina wrote: > Hello all, > > I am trying to debug a plperlu set of stored procedures. in pg 8.3.7. > When I launch a procedure I see messages, in the output window, > beginning with the string "CONTEXT: SQL statement "SELECT ..." > Which procedure or predefined function p