pg_get_serial_sequence is inconsistent

From: "Frank Millman" <frank(at)chagford(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pg_get_serial_sequence is inconsistent
Date: 2006-11-20 13:26:12
Message-ID: 20061120132843.02E753F439A@fcserver.chagford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I found the following post dated October 2004 -

Tom Lane wrote:
> Christopher Kings-Lynne <chriskl ( at ) familyhealth ( dot ) com ( dot )
au> writes:
> >> pg_get_serial_sequence() does dequoting/downcasing on its relation-name
> >> argument, but not on its column-name argument.
>
> > I presume the reason for that is that the first paramater can be
qualified:
>
> Right. From a bare-functionality point of view there's nothing wrong
> with it, it just seems inconsistent and therefore likely to trip someone
> up in future.
>
> But it seems no one else cares, so I'll shut up about it ...

This inconsistency has just bitten me. Did anyone decide to fix it, or does
it still behave the same?

I am using 8.1.3. Apologies if this has been fixed in 8.2 - I could not find
anything in the Release Notes.

Thanks

Frank Millman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonah H. Harris 2006-11-20 15:07:21 Re: [GENERAL] Allowing SYSDATE to Work
Previous Message Marc Evans 2006-11-20 12:22:46 Re: pg_hba.conf