[SQL] Droping indexes

Hi all, Please, if I drop all indexes from a table, can I recreate them after performing a vacuum full at this table? I mean, I do not know details about the indexes, so what I am asking is if I issue a REINDEX on this table, will it create the proper indexes again? Please advise. Thanks in

Re: [SQL] Droping indexes

Hi Tomas, Thank you. Please help me here.I am not a database guy...how do I use this CLUSTER command and what does it do? Please keep in mind that I do not have disk space left. Also, please check the table I am talking about below: opennms=# \d events

Re: [SQL] Droping indexes

Mario Behring wrote: Hi Tomas, Thank you. Please help me here.I am not a database guy...how do I use this CLUSTER command and what does it do? Please keep in mind that I do not have disk space left. If the disk is full you cannot use CLUSTER anyway. Suggestion:

Re: [SQL] Droping indexes

Hi Alvaro, Thank you for your advise..I was thinking about doing exactly that, I wasn't sure on how to do it though, meaning, considering the info below, how should I use the CREATE INDEX command to create these indexes?? opennms=# \d events Tabela

Re: [SQL] Droping indexes

Mario Behring wrote: Hi Alvaro, Thank you for your advise..I was thinking about doing exactly that, I wasn't sure on how to do it though, meaning, considering the info below, how should I use the CREATE INDEX command to create these indexes?? Have you read the documentation?

[SQL] Removing CONTEXT message

Hi all, I know I can remove the CONTEXT messages from the file log with: SET log_error_verbosity = terse Is there any possibility to remove it from the client pgAdmin Query messages as well ? TIA, Sabin

Re: [SQL] Droping indexes

On Tue, 2007-01-16 at 07:51, Mario Behring wrote: Hi all, Please, if I drop all indexes from a table, can I recreate them after performing a vacuum full at this table? I mean, I do not know details about the indexes, so what I am asking is if I issue a REINDEX on this table, will it create

Re: [SQL] Removing CONTEXT message

Sabin Coanda [EMAIL PROTECTED] writes: I know I can remove the CONTEXT messages from the file log with: SET log_error_verbosity = terse Is there any possibility to remove it from the client pgAdmin Query messages as well ? This is the wrong place to ask; try the pgAdmin support lists.

Re: [SQL] Droping indexes

At 10:42 AM 1/16/07, Mario Behring wrote: Thank you for your advise..I was thinking about doing exactly that, I wasn't sure on how to do it though, meaning, considering the info below, how should I use the CREATE INDEX command to create these indexes?? This might provide a clue:

Re: [SQL] Droping indexes

At 11:27 AM 1/16/07, Frank Bax wrote: At 10:42 AM 1/16/07, Mario Behring wrote: Thank you for your advise..I was thinking about doing exactly that, I wasn't sure on how to do it though, meaning, considering the info below, how should I use the CREATE INDEX command to create these

Re: [SQL] Removing CONTEXT message

Hi Tom, In fact, I found setting the configuration parameter 'client_min_messages', I get the expected results according to the documentation, and it works equivalent to 'log_min_messages ' that controls the messages of the log file. I'd just wonder an equivalent parameter as

Re: [SQL] Droping indexes RESOLVED

Hi all, Thank you very much for your help. I've found a create.sql script among the millions of files from openNMS installation that has all SQL statements for creating all tables, constraints, indexes and such. :-) I've just executed a drop table at the guilty table (32GB in size...),

Re: [SQL] Removing CONTEXT message

Sabin Coanda [EMAIL PROTECTED] writes: I'd just wonder an equivalent parameter as 'log_error_verbosity', but for client messages, not log file. Is it something available ? No, because it's the client-side code's responsibility to decide how much to display. In psql there's \set VERBOSITY, in