Re: Writing and Reading bytea

Amit Gupta wrote:
> We need insert rows to a catalog table that would store partitions info:
>
> CATALOG(pg_partition,2336) BKI_WITHOUT_OIDS
> {
> Oid partrelid; /* partition table Oid */
> Oid parentrelid; /* Parent table Oid */
> int2 parttype; /* Type of partition, list, hash, range */
> int2 partkey; /* partition key */
> Oid keytype; /* type of partition key */
> int2 keyorder; /* order of the key in multi-key partitions */
> bytea minval;
> bytea maxval; /* min and max for range partition */
> bytea listval;
> int2 hashval; /* hash value */
> } FormData_pg_partition;

I realize you're still in early phase of hacking, but let me just point
out that bytea is hardly the right data type for min/max value, unless
the partitioning key is actually a bytea column. I can't suggest a
better alternative off the top of my head. We have hacked around that
problem in pg_statistic stavalues columns, but it really is a hack.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com