X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8647B9DCA42 for ; Thu, 2 Mar 2006 14:44:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32911-04 for ; Thu, 2 Mar 2006 14:44:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [125.62.94.225]) by postgresql.org (Postfix) with ESMTP id B78D29DC8A4 for ; Thu, 2 Mar 2006 14:43:59 -0400 (AST) Received: from kleptog by svana.org with local (Exim 4.50) id 1FEsmA-0001o7-3E; Fri, 03 Mar 2006 05:43:46 +1100 Date: Thu, 2 Mar 2006 19:43:46 +0100 From: Martijn van Oosterhout To: Mark Dilger Cc: Tom Lane , pgsql-hackers@postgresql.org Subject: Re: [SQL] Interval subtracting Message-ID: <20060302184346.GC3126@svana.org> Reply-To: Martijn van Oosterhout References: <200603012326.k21NQOv08610@candle.pha.pa.us> <4406331A.6080307@markdilger.com> <17317.1141257505@sss.pgh.pa.us> <44063632.20505@markdilger.com> <17752.1141259857@sss.pgh.pa.us> <440647D4.9060601@markdilger.com> <2476.1141310972@sss.pgh.pa.us> <44073422.7060606@markdilger.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="tqI+Z3u+9OQ7kwn0" Content-Disposition: inline In-Reply-To: <44073422.7060606@markdilger.com> X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: User-Agent: Mutt/1.5.9i X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: kleptog@svana.org X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.123 required=5 tests=[AWL=0.123] X-Spam-Score: 0.123 X-Spam-Level: X-Archive-Number: 200603/134 X-Sequence-Number: 80532 --tqI+Z3u+9OQ7kwn0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Mar 02, 2006 at 10:06:26AM -0800, Mark Dilger wrote: > I used grep -R to find all locations where interval_justify_time is=20 > mentioned, and for each one added an analogous entry for my new function= =20 > interval_justify. But I get lost where OID=3D1175 is associated with=20 > interval_justify_time. I can't really just grep for 1175 and add analo= gous=20 > entries of my new OID, because I don't know what all the tables mean. =20 > (BTW, I grabbed the next slot in the table and used OID=3D2711, but I don= 't=20 > know if that is the proper strategy for adding new OIDs.) >=20 > Is there an automated way of handling this task, such as a developer tool= =20 > that I didn't find? In the include/catalog directory there are two script, unused_oids and duplicate_oids. It tells you whats available. Have a ncie day, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. --tqI+Z3u+9OQ7kwn0 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFEBzziIB7bNG8LQkwRAlQnAJ4uPLUEUeQeg326Pbqj0FBwSkm1fgCbBwwd FLcLKtSCasatXELQYQVryCU= =Kwrf -----END PGP SIGNATURE----- --tqI+Z3u+9OQ7kwn0--