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

Re: [COMMITTERS] pgsql: Implement remaining fields of information_schema.sequences view

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: [COMMITTERS] pgsql: Implement remaining fields of information_schema.sequences view
Date: 2011-01-07 17:37:35
Message-ID: 87hbdkboo0.fsf@cbbrowne.afilias-int.info (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
peter_e(at)gmx(dot)net (Peter Eisentraut) writes:
> Implement remaining fields of information_schema.sequences view
>
> Add new function pg_sequence_parameters that returns a sequence's start,
> minimum, maximum, increment, and cycle values, and use that in the view.
> (bug #5662; design suggestion by Tom Lane)
>
> Also slightly adjust the view's column order and permissions after review of
> SQL standard.

http://git.postgresql.org/gitweb?p=postgresql.git;a=blobdiff;f=src/backend/catalog/information_schema.sql;h=5b8b9417701a06b423636fe8b6e4bff91f1aa563;hp=090c10c3220e6f8b41f60ad83135830206417de4;hb=39b88432968a2f4c01c20948f12bf9c8e388474d;hpb=e657b55e661577cf664949bce78068e2922f594f

Is there a particular reason that the start/min/max/inc values are now
being cast to character_data, rather than integer, as they have been?  I
have some views I'm using that just broke because of this.

I'd rather not work around this if it's not necessary, and it doesn't
seem to make sense for these values to be of other than a numeric type
(and likely BIGINT, as that's what pg_sequence_parameters() returns).
-- 
(reverse (concatenate 'string "ofni.secnanifxunil" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/slony.html
E.V.A., pod 5, launching...

In response to

pgsql-hackers by date

Next:From: Joel JacobsonDate: 2011-01-07 18:10:34
Subject: obj_unique_identifier(oid)
Previous:From: Jeff DavisDate: 2011-01-07 17:33:29
Subject: Re: WIP: Range Types

pgsql-committers by date

Next:From: Tom LaneDate: 2011-01-08 00:17:34
Subject: pgsql: Fix GIN to support null keys, empty and null items,and full ind
Previous:From: Robert HaasDate: 2011-01-07 16:09:03
Subject: Re: Re: [COMMITTERS] pgsql: New system view pg_stat_replication displays activity of wal sen

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