[sf-perl] PostgreSQL DBD ---- repost: sorry,
I had the wrong subject in my previous post
shanehill00 at gmail.com
Fri Apr 1 11:11:52 PST 2005
nice find david, this works well and is probably more bomb-proof than
concatenating strings and guessing the seq_name.
looks like I am buying a new poster this evening :-)
> (string_to_array(d.adsrc, '\''))
> FROM pg_catalog.pg_class c
> JOIN pg_catalog.pg_attribute a
> ON (
> c.relname = 'foo_tab'
> c.oid = a.attrelid
> JOIN pg_catalog.pg_attrdef d
> ON (
> d.adsrc LIKE 'nextval%'
> d.adrelid = a.attrelid
> d.adnum = a.attnum
> > thanks for your help, I really appreciate it.
> Hope this does. Oh, and try talking your client into upgrading to
> 8.0x :)
> David Fetter david at fetter.org http://fetter.org/
> phone: +1 510 893 6100 mobile: +1 415 235 3778
> Remember to vote!
More information about the SanFrancisco-pm