Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Bruce Momjian - CVS <momjian(at)hub(dot)org>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-committers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)
Date: 2000-09-12 23:59:12
Message-ID: 200009122359.TAA21692@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
> > As if my JDBC patch hasn't already caused enough grief, there is now a
> > one-line change necessary. Due to the Mark Holloman "New Relkind for
> > Views" patch, my support for views in the driver will need to be updated
> > to match. The change to DatabaseMetaData.getTableTypes[][] is as
> > follows:
> > 
> > -    {"VIEW",           "(relkind='r' and relhasrules='t' and relname !~
> > '^pg_' and relname !~ '^xinv')"},
> > +    {"VIEW",           "(relkind='v' and relname !~ '^pg_' and relname
> > !~ '^xinv')"},
> >
> 
> Current jdbc driver seems to be able to get no VIEW information
> from any RELEASE version of backends.
> 
> Hmm,it seems that client app/libs don't mind backward incompatibility.
> Don't I have to bother about backward incomatibility which would be
> caused by my change ?
> If so,I would commit my change about ALTER TABLE DROP COLUMN.

So the issue is how to make the 7.1 jdbc driver handle views from >=7.1
databases, and <7.1 databases.  Good question.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-09-13 00:41:45
Subject: Re: Status of new relation file naming
Previous:From: Hiroshi InoueDate: 2000-09-12 23:46:39
Subject: RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)

pgsql-committers by date

Next:From: Peter MountDate: 2000-09-13 01:17:05
Subject: Re: [HACKERS] RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)
Previous:From: Hiroshi InoueDate: 2000-09-12 23:46:39
Subject: RE: pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group