Re: Question about index on different tablespace and rebuild it

Condor wrote: > Thank you for your answer. > > It's seems this is a weak spot of Postgres. It isn't. If your secondary storage goes bad, a database is supposed to fail. That's why you take backups. Yours, Laurenz Albe -- +43-670-6056265 Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26, A-2700

Re: Question about index on different tablespace and rebuild it

On 16-11-2018 19:40, Alexey Bashtanov wrote: Yes, I know. My question is: Did the pg server will start at all if the NVME / table space somehow is broken and indexes is unable to be loaded, not how to drop an index. Since the Postgre server is not starting at all maybe I can try dropping my ind

Re: Invoking user of the function with SECURITY DEFINER

Got it.. In my case i was getting session_user in declare section and trying to validate later which always resulted in the function owner. DECLARE user text := SESSION_USER; So using it within the BEGIN; ...; END; clause worked for me. Thanks. Warm Regards, Madan Kumar K