Today presented a new set of challenges to create a basic Postgres extension. Although my attempts at building an extension using only SQL were unsuccessful, these setbacks provided valuable insights into the underlying issues I needed to address.

My initial attempts to create a basic extension using SQL were hampered by problems with the makefile and SQL script file. Troubles with the inclusion of the necessary postgres.h and fmgr.h files while compiling the C file added further complications. In a subsequent attempt using Python, I encountered difficulties with the psycopg import.

Acknowledging the importance of hands-on experience, I decided to shift my focus from solely learning about definitions and code to actually implementing them. By diving into the practical aspects of extension development, I aimed to gain a more tangible understanding of the concepts and techniques involved. While this approach may present additional challenges, I believe it will ultimately deepen my comprehension and pave the way for future success.