[GENERAL] Get user defined type OID (PostgreSQL extension in C)

2017-08-25 Thread Fabiana Zioti
I'm developing an extension to PostgreSQL using C. I created a user-defined type called geo_trajc_elem. I also created a function to generate an array of this new type. () ArrayType *result_array; struct geo_trajc_elem *traje = (struct geo_trajc_elem *)palloc(sizeof(struct

Re: [GENERAL] Development of an extension for PostgreSQL and PostGIS

2017-08-17 Thread Fabiana Zioti
rrectly, but I can not return the structure pointer.. It is wrong the way I'm programming the extension with the PostGIS? Thanks in advance De: Paul Ramsey <pram...@cleverelephant.ca> Enviado: segunda-feira, 14 de agosto de 2017 15:36 Para: Fabiana Zi

[GENERAL] Development of an extension for PostgreSQL and PostGIS

2017-08-14 Thread Fabiana Zioti
Hello. I will start developing an extension to PostgreSQL next to PostGIS using the C language. If my new type were: CREATE TYPE mytype (.., .., .., geom geometry); The creation of the structure in c, would be something like? #include "liblwgeom.h" Struct mytype { Int32 id; LWGEOM

[GENERAL] Receive a string in Composite-type Arguments

2017-08-11 Thread Fabiana Zioti
Hi! I am studying how to program extensions for PostgreSQL in C language. In the example to return to return Composite-type Arguments, from the PostgreSQL 9.6 documentation, I could not make the cash from a cstring to the HeapTupleHeader type. That is, instead of the function receive as a

[GENERAL] Configure Qt Creator to work with PostgreSQL to extensions development

2017-06-25 Thread Fabiana Zioti
I'm creating an extension to PostgreSQL, with user-defined types and user-defined functions. Extensions can be written in C as well as C ++, correct? I am currently using ATOM to develop in Ubuntu. But I would like to work with Qt. PostgreSQL provides the tutorial for working with eclipse:

[GENERAL] Create extension C using IDE

2017-06-12 Thread Fabiana Zioti
I already have postgresql 9.6 installed. I'm developing extensions for it in C. What would be the best IDE to debug the code? Eclipse has many errors.

[GENERAL] Enc: Extending SQL in C using VARIABLE length type in user defined type

2017-06-09 Thread Fabiana Zioti
I am trying around a little bit with creating my own types using shared objects, written in C. The usage of static types with fixed length was actually no problem for me, so I proceeded to variable length types. I created an n-dimensional point structure called "Geo_Polygon" that contains a