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?
