PGINTERFACE = ../pginterface/pginterface.o ../pginterface/halt.o# these have to be in your library search path

INSTALLDIR = /usr/local/pgsql

TARGET = findoidjoins

CFLAGS = -g -Wall -I. -I../pginterface -I../../src/interfaces/libpq -I/usr/local/pgsql/include

LDFLAGS = -L/usr/local/pgsql/lib -lpq

PGEASY = ../../src/interfaces/libpgeasy

CFLAGS = -g -Wall -I. -I$(PGEASY) -I$(INSTALLDIR)/include

LIBPGEASY =$(PGEASY)/libpgeasy.a

LDFLAGS = -L$(INSTALLDIR)/lib -lpq

all :$(TARGET)

findoidjoins:$(PGINTERFACE)findoidjoins.c

gcc -o$@$(CFLAGS)$@.c$(PGINTERFACE)$(LDFLAGS)

findoidjoins:findoidjoins.c$(LIBPGEASY)

gcc -o$@$(CFLAGS)$^$(LDFLAGS)

clean:

rm -f*.o$(TARGET) log core

install:

install -s -o bin -g bin$(TARGET)/usr/local/pgsql/bin

install -s -o bin -g bin$(TARGET)$(INSTALLDIR)/bin

This program scans a database, and prints oid fields (also regproc fields)

and the tables they join to. CAUTION: it is ver-r-r-y slow on a large

database, or even a not-so-large one. We don't really recommend running

it on anything but an empty database.

it on anything but an empty database, such as template1.

Uses pgeasy library.

Run on an empty database, it returns the system join relationships (shown

below for6.5). Note that unexpected matches may indicate bogus entries

below for7.0). Note that unexpected matches may indicate bogus entries

in system tables --- don't accept a peculiar match without question.

In particular, a field shown as joining to more than one target table is

probably messed up. In6.5, the *only* field that should join to more

probably messed up. In7.0, the *only* field that should join to more

than one target is pg_description.objoid. (Running make_oidjoins_check

is an easy way to spot fields joining to more than one table, BTW.)

Join pg_am.ammarkpos => pg_proc.oid

Join pg_am.amrestrpos => pg_proc.oid

Join pg_am.ambuild => pg_proc.oid

Join pg_am.amcostestimate => pg_proc.oid

Join pg_amop.amopid => pg_am.oid

Join pg_amop.amopclaid => pg_opclass.oid

Join pg_amop.amopopr => pg_operator.oid

Join pg_amop.amopselect => pg_proc.oid

Join pg_amop.amopnpages => pg_proc.oid

Join pg_amproc.amid => pg_am.oid

Join pg_amproc.amopclaid => pg_opclass.oid

Join pg_amproc.amproc => pg_proc.oid

Join pg_proc.prolang => pg_language.oid

Join pg_proc.prorettype => pg_type.oid

Join pg_rewrite.ev_class => pg_class.oid

Join pg_statistic.starelid => pg_class.oid

Join pg_statistic.staop => pg_operator.oid

Join pg_trigger.tgrelid => pg_class.oid

Join pg_trigger.tgfoid => pg_proc.oid

Join pg_type.typrelid => pg_class.oid

Join pg_type.typelem => pg_type.oid

Join pg_type.typinput => pg_proc.oid

PGresult*attres,

*relres;

sprintf(query,"\

WHERE t1.%s = t2.oid ",relname,relname2,attname);

WHERE t1.%s = t2.oid ",relname,relname2,attname);

sprintf(query,"\

WHERE RegprocToOid(t1.%s) = t2.oid ",relname,relname2,attname);

WHERE RegprocToOid(t1.%s) = t2.oid ",relname,relname2,attname);

doquery(query);

doquery("FETCH ALL IN c_matches");