Hi all, I am new to postgres developement. Want some help. Can we run nested query in postgres? Means, can I do like -
When somequery is being executed (say "create database") it goes through exec_simple_query():backend/tcop/postgres.c (if I am not wrong) then can I call exec_simple_query() from createdb():backend/commands/dbcommands.c Actually I tried to do that but I think portal used for "create database" is still ACTIVE when I call exec_simple_again, and thats why it give error like "can not drop portal - still active" Is it due to exec_simple_query() creates unnamed portal? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings