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

Re: Patch for Statement.getGeneratedKeys()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Johanson <pg-user(at)kensystem(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Patch for Statement.getGeneratedKeys()
Date: 2008-01-16 15:01:58
Message-ID: 23430.1200495718@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Ken Johanson <pg-user(at)kensystem(dot)com> writes:
> Here is what I have so far (not sure of my conditionals yet or if I need 
> any joins for them):

> select attname from pg_attribute
> where attrelid = 'postgres.public.test'::regclass
> and attstattarget=-1
> and attisdropped='f'
> order by attnum asc

I'd do "where attrelid = ... and attnum > 0 and not attisdropped".
Not sure what you think the attstattarget condition would accompllish,
but it doesn't seem like anything that client-side code ought to be
touching.

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Albe LaurenzDate: 2008-01-16 16:00:38
Subject: Re: trying to connect to pg from within a local network
Previous:From: Albretch MuellerDate: 2008-01-16 14:22:19
Subject: trying to connect to pg from within a local network

pgsql-general by date

Next:From: beer@cmu.eduDate: 2008-01-16 15:02:23
Subject: Building 8.1.11 on FC4
Previous:From: Josh HarrisonDate: 2008-01-16 14:56:08
Subject: Re: Online Oracle to Postgresql data migration

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