Re: Re: Call for platforms - Mailing list pgsql-hackers
| From | Mark Knox |
|---|---|
| Subject | Re: Re: Call for platforms |
| Date | |
| Msg-id | 3ABE10B3.18310.441231D@localhost Whole thread Raw |
| In response to | Re: Re: Call for platforms (Tom Lane <tgl@sss.pgh.pa.us>) |
| List | pgsql-hackers |
-----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 queryYou are currentlyconnected 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-----
pgsql-hackers by date: