| Lists: | pgsql-hackers |
|---|
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Need to contact driver authors about change in index naming behavior ... |
| Date: | 2010-05-04 23:40:22 |
| Message-ID: | 4BE0B066.8090106@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hackers, Driver maintainers,
The 9.0 "don't rename index cols" behavior has already broken JDBC. We
need to get in touch with other driver authors to see if they are
affected by this, and to let them know that they'll need a new driver
release for 9.0, if so.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Need to contact driver authors about change in index naming behavior ... |
| Date: | 2010-05-05 01:42:53 |
| Message-ID: | 20100505014252.GR28557@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Tue, May 04, 2010 at 04:40:22PM -0700, Josh Berkus wrote:
> Hackers, Driver maintainers,
>
> The 9.0 "don't rename index cols" behavior has already broken JDBC. We
> need to get in touch with other driver authors to see if they are
> affected by this, and to let them know that they'll need a new driver
> release for 9.0, if so.
Looks at first glance like it still works for PL/Perl.
I created a table t with single PK text column id, renamed it to
idiotic, and pointed the attached program at it. Git master
(92b93d85a49eb8d55060aaaa961c0d53e085ed92) is running on port 2225,
and I'm connecting as my shell user.
Here's the SQL I ran before the script.
CREATE table simple(id SERIAL PRIMARY KEY);
ALTER TABLE simple RENAME COLUMN id TO idiotic;
CREATE table complexer(a text, b text, primary key(a,b));
ALTER TABLE complexer RENAME a to alpha, b to bravo;
ALTER TABLE complexer RENAME a to alpha;
ALTER TABLE complexer RENAME b to bravo;
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| Attachment | Content-Type | Size |
|---|---|---|
| test_pk.pl | text/plain | 716 bytes |
| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Need to contact driver authors about change in index naming behavior ... |
| Date: | 2010-05-05 02:00:52 |
| Message-ID: | 4BE0D154.1020705@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
David Fetter wrote:
> On Tue, May 04, 2010 at 04:40:22PM -0700, Josh Berkus wrote:
>
>> Hackers, Driver maintainers,
>>
>> The 9.0 "don't rename index cols" behavior has already broken JDBC. We
>> need to get in touch with other driver authors to see if they are
>> affected by this, and to let them know that they'll need a new driver
>> release for 9.0, if so.
>>
>
> Looks at first glance like it still works for PL/Perl.
>
>
Er, ITYM Perl/DBD::Pg.
cheers
andrew
| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: Need to contact driver authors about change in index naming behavior ... |
| Date: | 2010-05-05 02:01:29 |
| Message-ID: | 20100505020129.GS28557@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Tue, May 04, 2010 at 10:00:52PM -0400, Andrew Dunstan wrote:
>
>
> David Fetter wrote:
> >On Tue, May 04, 2010 at 04:40:22PM -0700, Josh Berkus wrote:
> >>Hackers, Driver maintainers,
> >>
> >>The 9.0 "don't rename index cols" behavior has already broken JDBC. We
> >>need to get in touch with other driver authors to see if they are
> >>affected by this, and to let them know that they'll need a new driver
> >>release for 9.0, if so.
> >
> >Looks at first glance like it still works for PL/Perl.
> >
>
> Er, ITYM Perl/DBD::Pg.
You're right, of course. Oops.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate