Re: Proposal: CREATE CONVERSION - Mailing list pgsql-hackers

Here is a proposal for new pg_conversion system table. Comments?

/*-------------------------------------------------------------------------** pg_conversion.h*      definition of the
system"conversion" relation (pg_conversion)*      along with the relation's initial contents.*** Portions Copyright (c)
1996-2002,PostgreSQL Global Development Group* Portions Copyright (c) 1994, Regents of the University of California**
$Id$**NOTES*      the genbki.sh script reads this file and generates .bki*      information from the DATA()
statements.**-------------------------------------------------------------------------*/
#ifndef PG_CONVERSION_H
#define PG_CONVERSION_H

/* ----------------*        postgres.h contains the system type definitions and the*        CATALOG(), BOOTSTRAP and
DATA()sugar words so this file*        can be read by both genbki.sh and the C compiler.* ----------------*/
 

/* ----------------------------------------------------------------*        pg_conversion definition.**        cpp
turnsthis into typedef struct FormData_pg_namespace**    conname                name of the conversion*    connamespace
      name space which the conversion belongs to*    conowner            ower of the conversion*    conforencoding
 FOR encoding id*    contoencoding        TO encoding id*  conproc                OID of the conversion proc*
----------------------------------------------------------------*/
CATALOG(pg_conversion)
{NameData    conname;Oid            connamespace;int4        conowner;int4        conforencoding;int4
contoencoding;Oid           conproc;
 
} FormData_pg_conversion;

/* ----------------*        Form_pg_conversion corresponds to a pointer to a tuple with*        the format of
pg_conversionrelation.* ----------------*/
 
typedef FormData_pg_conversion *Form_pg_conversion;

/* ----------------*        compiler constants for pg_conversion* ----------------*/

#define Natts_pg_conversion                6
#define Anum_pg_conversion_conpname        1
#define Anum_pg_conversion_connamespace    2
#define Anum_pg_conversion_conowner        3
#define Anum_pg_conversion_conforencoding        4
#define Anum_pg_conversion_contoencoding        5
#define Anum_pg_conversion_conproc        6

/* ----------------* initial contents of pg_conversion* ---------------*/

/** prototypes for functions in pg_conversion.c*/
extern Oid    ConversionCreate(const char *conname, Oid connamespace,                         int32 conowner,
             int4 conforencoding, int4 contoencoding,                         Oid conproc);
 

#endif   /* PG_CONVERSION_H */