[HACKERS] Creating Empty Index

Hello Is there a way by which we can create an empty index on a relation and later fill it manually by inserting tuples. I want to know how it can be done in Postgresql code. Thanks in advance -- View this message in context: http://postgresql.1045698.n5.nabble.com/Creating-Empty-Index-tp5

[HACKERS] Creating partial index on a relation

Hello I am doing a small project in Postgress where i have to achieve the following: Suppose i know the index name(lets say index1) and the relation(table1) on which partial index to has to be build. I was looking through the code and found that IndexStmt-->whereClause is the one that i need to