-----BEGIN PGP SIGNED MESSAGE-----
On 25 Mar 2001, at 15:02, Tom Lane wrote:
> > (rounding on the final digit) and this rather troubling output from
> > type_sanity.
>
> Most bizarre --- and definitely indicative of trouble. Would you send
> along the output of this query in that database:
>
> select p1.oid,attrelid,relname,attname,attlen,attalign,attbyval
> from pg_attribute p1, pg_class p2
> where atttypid = 27 and p2.oid = attrelid
> order by 1;
I was afraid of that ;) Here's the output:
[PostgreSQL 7.1beta6 on armv4l-unknown-linux-gnuoldld, compiled by
GCC 2.95.1]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: postgres
postgres=> select
p1.oid,attrelid,relname,attname,attlen,attalign,attbyval from
pg_attribute p1, pg_class p2 where atttypid = 27 and p2.oid =
attrelid order by 1;
oid|attrelid|relname |attname|attlen|attalign|attbyval
- -----+--------+--------------+-------+------+--------+--------
16401| 1247|pg_type |ctid | 6|i |f
16415| 1262|pg_database |ctid | 6|i |f
16439| 1255|pg_proc |ctid | 6|i |f
16454| 1260|pg_shadow |ctid | 6|i |f
16464| 1261|pg_group |ctid | 6|i |f
16486| 1249|pg_attribute |ctid | 6|i |f
16515| 1259|pg_class |ctid | 6|i |f
16526| 1215|pg_attrdef |ctid | 6|i |f
16537| 1216|pg_relcheck |ctid | 6|i |f
16557| 1219|pg_trigger |ctid | 6|i |f
16572| 16567|pg_inherits |ctid | 8|i |f
16593| 16579|pg_index |ctid | 8|i |f
16610| 16600|pg_statistic |ctid | 8|i |f
16635| 16617|pg_operator |ctid | 8|i |f
16646| 16642|pg_opclass |ctid | 8|i |f
16678| 16653|pg_am |ctid | 8|i |f
16691| 16685|pg_amop |ctid | 8|i |f
16873| 16867|pg_amproc |ctid | 8|i |f
16941| 16934|pg_language |ctid | 8|i |f
16953| 16948|pg_largeobject|ctid | 8|i |f
16970| 16960|pg_aggregate |ctid | 8|i |f
17038| 17033|pg_ipl |ctid | 8|i |f
17051| 17045|pg_inheritproc|ctid | 8|i |f
17067| 17058|pg_rewrite |ctid | 8|i |f
17079| 17074|pg_listener |ctid | 8|i |f
17090| 17086|pg_description|ctid | 8|i |f
17206| 17201|pg_toast_1215 |ctid | 8|i |f
17221| 17216|pg_toast_17086|ctid | 8|i |f
17236| 17231|pg_toast_1255 |ctid | 8|i |f
17251| 17246|pg_toast_1216 |ctid | 8|i |f
17266| 17261|pg_toast_17058|ctid | 8|i |f
17281| 17276|pg_toast_16600|ctid | 8|i |f
17301| 17291|pg_user |ctid | 8|i |f
17314| 17309|pg_rules |ctid | 8|i |f
17327| 17322|pg_views |ctid | 8|i |f
17342| 17335|pg_tables |ctid | 8|i |f
17355| 17350|pg_indexes |ctid | 8|i |f
(37 rows)
-----BEGIN PGP SIGNATURE-----
Version: N/A
iQCVAwUBOr5XA/+IdJuhyV9xAQGfOgP6ApV6ia44bxCo/KyIE20knn/1FTysECW9
Rq9mLDhpYKHYtTWz1cgGtxzCEiRAMN+ZuO7u5nydy6TB8dp8iCd9eLAro4GAzqYM
aD9V9S3nK3YwV9RaKBWJqHXNPI5enp19YS74GxN0f9VIw/4PXlYVm2tQJLVWNGs+
lFfQnraYEZQ=
=Cj2l
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
