DragonFly On-Line Manual Pages

Search: Section:  

PQregisterUserDefinedTypes(3)  libpqtypes Manual PQregisterUserDefinedTypes(3)


PQregisterUserDefinedTypes - Registers a user-defined types.


#include <libpqtypes.h> int PQregisterUserDefinedTypes(PGconn *conn, PGregisterType *types, int count);


THIS FUNCTION IS DEPRECATED. New applications should use PQregisterTypes. This function is now a wrapper to PQregisterTypes.


The PQregisterUserDefinedTypes() function allows an application to register one or more user-defined types at runtime. User-defined types are custom types in a backend that implement their own C procedures for in/out/send/recv. This function must execute a query against the backend to retrieve type information for each user-defined type, thus this should not be called from within a transaction. It is recommended to register multiple types at the same time to avoid round trip overhead. The types argument is an array containing count user-defined types to register. If any type does not exist, the register is aborted. Either typput and/or typget must be specified for each type in the types array. NOTE: The typname member of the PGregisterType structure can optionally contain the type's schema: schema.typname. WARNING: PQparamCreate is only aware of types that have already been registered. If you need to put a type into a param, make sure it is first registered. User-defined Types Registration This example registers two user-defined types. PGregisterType types[] = { {"graphics.rgb", rgb_put, rgb_get}, {"graphics.digon", digon_put, digon_get} }; if (!PQregisterUserDefinedTypes(conn, types, 2)) fprintf(stderr, "PQregisterUserDefinedTypes: %s\n", PQgeterror());


On success, a non-zero value is returned. On error, zero is returned and PQgeterror(3) will contain an error message.




A contribution of eSilo, LLC. for the PostgreSQL Database Management System. Written by Andrew Chernow and Merlin Moncure.


Report bugs to <libpqtypes@esilo.com>.


Copyright (c) 2011 eSilo, LLC. All rights reserved. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.


pqt-handlers(3), PQputf(3), PQgetf(3) libpqtypes 2011 PQregisterUserDefinedTypes(3)

Search: Section: