Re: [HACKERS] Writing and Reading bytea

2009-02-12 Thread Heikki Linnakangas
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 */ int2parttype; /* Type of par

Re: [HACKERS] Writing and Reading bytea

2009-02-12 Thread Heikki Linnakangas
Amit Gupta wrote: The following code didn't work: pg_partrel = heap_open(PartitionRelationId, AccessShareLock); pg_partscan = systable_beginscan(pg_partrel, PartitionParentIndexId, true, SnapshotNow, 1, &skey); while (HeapTupleIsValid(pg_parttup= s

[HACKERS] Writing and Reading bytea

2009-02-12 Thread Amit Gupta
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 */ int2parttype; /* Type of partition, list, hash,