Re: [PORTS] is that ok?
| От | David Wetzel |
|---|---|
| Тема | Re: [PORTS] is that ok? |
| Дата | |
| Msg-id | 199910031452.QAA00257@cat.turbocat.de обсуждение исходный текст |
| Ответ на | is that ok? (David Wetzel <dave@turbocat.de>) |
| Список | pgsql-ports |
> From: Thomas Lockhart <lockhart@alumni.caltech.edu> > > > You will need to inspect your results to see what is failing. Which > > > release are you running? > > I run PG 6.5.2 on LinuxPPC 1999. > > which files should I look at? > > cd src/test/regress > diff expected/<test>.out results/<test>.out I hope, the following does help. --- _ _ _(_)(_)_ David Wetzel, Turbocat's Development, (_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG, _/ \_ Fax +49 33056 82835 NeXTmail dave@turbocat.de (______) http://www.turbocat.de/ DEVELOPMENT * CONSULTING * ADMINISTRATION [dave@morpheus regress]# diff expected/geometry.out results/geometry.out 115c115 < |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140473) --- > |(-10,0) |[(-1000000,200),(300000,-40)]|(-9.99715942258202,15.3864610140472) 132,134c132,134 < |(71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548) < |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738) < |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643) --- > |(71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547) > |(4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737) > |(3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642) 136c136 < |(170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548) --- > |(170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547) 411,418c411,418 < six|polygon < ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ < |((-3,0),(-2.59807621135332,1.5),(-1.5,2.59807621135332),(-1.83690953073357e-16,3),(1.5,2.59807621135332),(2.59807621135332,1.5),(3,3.67381906146713e-16),(2.59807621135332,-1.5),(1.5,-2.59807621135332),(5.5107285922007e-16,-3),(-1.5,-2.59807621135332),(-2.59807621135332,-1.5)) < |((-99,2),(-85.6025403784439,52),(-49,88.6025403784439),(0.999999999999994,102),(51,88.6025403784439),(87.6025403784439,52),(101,2.00000000000001),(87.6025403784439,-48),(51,-84.6025403784438),(1.00000000000002,-98),(-49,-84.6025403784439),(-85.6025403784438,-48)) < |((-4,3),(-3.33012701892219,5.5),(-1.5,7.33012701892219),(1,8),(3.5,7.33012701892219),(5.33012701892219,5.5),(6,3),(5.33012701892219,0.500000000000001),(3.5,-1.33012701892219),(1,-2),(-1.5,-1.33012701892219),(-3.33012701892219,0.499999999999998)) < |((-2,2),(-1.59807621135332,3.5),(-0.5,4.59807621135332),(1,5),(2.5,4.59807621135332),(3.59807621135332,3.5),(4,2),(3.59807621135332,0.500000000000001),(2.5,-0.598076211353315),(1,-1),(-0.5,-0.598076211353316),(-1.59807621135332,0.499999999999999)) < |((90,200),(91.3397459621556,205),(95,208.660254037844),(100,210),(105,208.660254037844),(108.660254037844,205),(110,200),(108.660254037844,195),(105,191.339745962156),(100,190),(95,191.339745962156),(91.3397459621556,195)) < |((0,0),(13.3974596215561,50),(50,86.6025403784439),(100,100),(150,86.6025403784439),(186.602540378444,50),(200,1.22460635382238e-14),(186.602540378444,-50),(150,-86.6025403784438),(100,-100),(50,-86.6025403784439),(13.3974596215562,-50)) --- > six|polygon > ---+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > |((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138)) > |((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795)) > |((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028)) > |((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616)) > |((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) > |((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795)) 423,430c423,430 < six|polygon < ---+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- < |((-3,0),(-2.12132034355964,2.12132034355964),(-1.83690953073357e-16,3),(2.12132034355964,2.12132034355964),(3,3.67381906146713e-16),(2.12132034355964,-2.12132034355964),(5.5107285922007e-16,-3),(-2.12132034355964,-2.12132034355964)) < |((-99,2),(-69.7106781186548,72.7106781186548),(0.999999999999994,102),(71.7106781186547,72.7106781186548),(101,2.00000000000001),(71.7106781186548,-68.7106781186547),(1.00000000000002,-98),(-69.7106781186547,-68.7106781186548)) < |((-4,3),(-2.53553390593274,6.53553390593274),(1,8),(4.53553390593274,6.53553390593274),(6,3),(4.53553390593274,-0.535533905932737),(1,-2),(-2.53553390593274,-0.535533905932738)) < |((-2,2),(-1.12132034355964,4.12132034355964),(1,5),(3.12132034355964,4.12132034355964),(4,2),(3.12132034355964,-0.121320343559642),(1,-1),(-1.12132034355964,-0.121320343559643)) < |((90,200),(92.9289321881345,207.071067811865),(100,210),(107.071067811865,207.071067811865),(110,200),(107.071067811865,192.928932188135),(100,190),(92.9289321881345,192.928932188135)) < |((0,0),(29.2893218813452,70.7106781186548),(100,100),(170.710678118655,70.7106781186548),(200,1.22460635382238e-14),(170.710678118655,-70.7106781186547),(100,-100),(29.2893218813453,-70.7106781186548)) --- > six|polygon > ---+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > |((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175)) > |((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) > |((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) > |((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) > |((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) > |((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) 468,493c468,493 < twentyfour|circle |point | distance < ----------+--------------+----------+----------------- < |<(100,0),100> |(5.1,34.5)|0.976531926977964 < |<(1,2),3> |(-3,4) | 1.47213595499958 < |<(0,0),3> |(-3,4) | 2 < |<(100,0),100> |(-3,4) | 3.07764064044151 < |<(100,0),100> |(-5,-12) | 5.68348972285122 < |<(1,3),5> |(-10,0) | 6.40175425099138 < |<(1,3),5> |(10,10) | 6.40175425099138 < |<(0,0),3> |(-10,0) | 7 < |<(1,2),3> |(-10,0) | 8.18033988749895 < |<(1,2),3> |(10,10) | 9.0415945787923 < |<(0,0),3> |(-5,-12) | 10 < |<(100,0),100> |(-10,0) | 10 < |<(0,0),3> |(10,10) | 11.142135623731 < |<(1,3),5> |(-5,-12) | 11.1554944214035 < |<(1,2),3> |(-5,-12) | 12.2315462117278 < |<(1,3),5> |(5.1,34.5)| 26.7657047773224 < |<(1,2),3> |(5.1,34.5)| 29.757594539282 < |<(0,0),3> |(5.1,34.5)| 31.8749193547455 < |<(100,200),10>|(5.1,34.5)| 180.778038568384 < |<(100,200),10>|(10,10) | 200.237960416286 < |<(100,200),10>|(-3,4) | 211.415898254845 < |<(100,200),10>|(0,0) | 213.606797749979 < |<(100,200),10>|(-10,0) | 218.254244210267 < |<(100,200),10>|(-5,-12) | 226.577682802077 --- > twentyfour|circle |point | distance > ----------+--------------+----------+---------------- > |<(100,0),100> |(5.1,34.5)|0.97653192697797 > |<(1,2),3> |(-3,4) |1.47213595499958 > |<(0,0),3> |(-3,4) | 2 > |<(100,0),100> |(-3,4) |3.07764064044152 > |<(100,0),100> |(-5,-12) |5.68348972285122 > |<(1,3),5> |(-10,0) |6.40175425099138 > |<(1,3),5> |(10,10) |6.40175425099138 > |<(0,0),3> |(-10,0) | 7 > |<(1,2),3> |(-10,0) |8.18033988749895 > |<(1,2),3> |(10,10) | 9.0415945787923 > |<(0,0),3> |(-5,-12) | 10 > |<(100,0),100> |(-10,0) | 10 > |<(0,0),3> |(10,10) | 11.142135623731 > |<(1,3),5> |(-5,-12) |11.1554944214035 > |<(1,2),3> |(-5,-12) |12.2315462117278 > |<(1,3),5> |(5.1,34.5)|26.7657047773223 > |<(1,2),3> |(5.1,34.5)| 29.757594539282 > |<(0,0),3> |(5.1,34.5)|31.8749193547455 > |<(100,200),10>|(5.1,34.5)|180.778038568384 > |<(100,200),10>|(10,10) |200.237960416286 > |<(100,200),10>|(-3,4) |211.415898254845 > |<(100,200),10>|(0,0) |213.606797749979 > |<(100,200),10>|(-10,0) |218.254244210267 > |<(100,200),10>|(-5,-12) |226.577682802077 [dave@morpheus regress]# cat results/sanity_check.out QUERY: VACUUM; ERROR: nodeRead: Bad type 0 QUERY: SELECT relname, relhasindex FROM pg_class WHERE relhasindex ORDER BY relname; relname |relhasindex --------------+----------- bt_f8_heap |t bt_i4_heap |t bt_name_heap |t bt_txt_heap |t fast_emp4000 |t hash_f8_heap |t hash_i4_heap |t hash_name_heap|t hash_txt_heap |t ihighway |t onek |t pg_attrdef |t pg_attribute |t pg_class |t pg_description|t pg_proc |t pg_relcheck |t pg_trigger |t pg_type |t road |t shighway |t tenk1 |t tenk2 |t (23 rows) [dave@morpheus regress]# cat expected/sanity_check.out QUERY: VACUUM; QUERY: SELECT relname, relhasindex FROM pg_class WHERE relhasindex ORDER BY relname; relname |relhasindex --------------+----------- bt_f8_heap |t bt_i4_heap |t bt_name_heap |t bt_txt_heap |t fast_emp4000 |t hash_f8_heap |t hash_i4_heap |t hash_name_heap|t hash_txt_heap |t ihighway |t onek |t pg_attrdef |t pg_attribute |t pg_class |t pg_description|t pg_proc |t pg_relcheck |t pg_trigger |t pg_type |t road |t shighway |t tenk1 |t tenk2 |t (23 rows) [dave@morpheus regress]# diff expected/select_views.out results/select_views.out 4a5 > Ada St |[(-122.2487,37.398),(-122.2496,37.401)] |Lafayette 5a7,8 > Allen Ct |[(-122.0131,37.602),(-122.0117,37.597)] |Berkeley > Alvarado Niles Road|[(-122.0325,37.903),(-122.0316,37.9)] |Berkeley 7a11,12 > Arden Road|[(-122.0978,37.177),(-122.1,37.177)] |Oakland > Arizona St |[(-122.0381,37.901),(-122.0367,37.898)] |Berkeley 12,55d16 < Calaveras Creek |[(-121.8203,37.035),(-121.8207,37.931)] |Oakland < Corriea Way |[(-121.9501,37.402),(-121.9505,37.398)] |Oakland < Cowing Road|[(-122.0002,37.934),(-121.9772,37.782)] |Oakland < Driscoll Road|[(-121.9482,37.403),(-121.948451,37.39995)] |Oakland < Enos Way |[(-121.7677,37.896),(-121.7673,37.91)] |Oakland < Fairview Ave |[(-121.999,37.428),(-121.9863,37.351)] |Oakland < I- 580 |[(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)] |Oakland < I- 580 |[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)] |Oakland < I- 580 Ramp|[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)] |Oakland < I- 580 Ramp|[(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)] |Oakland < I- 580 Ramp|[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)] |Oakland < I- 580 Ramp|[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)] |Oakland < I- 580/I-680 Ramp|((-121.9207,37.988),(-121.9192,37.016)) |Oakland < I- 680 |((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934)) |Oakland < I- 680 |[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)] |Oakland < I- 680 |[(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)] |Oakland < I- 680 Ramp|[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)] |Oakland < I- 680 Ramp|[(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)] |Oakland < I- 680 Ramp|[(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)] |Oakland < I- 880 |((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933)) |Oakland < I- 880 |[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)] |Oakland < Johnson Dr |[(-121.9145,37.901),(-121.915,37.877)] |Oakland < Juniper St |[(-121.7823,37.897),(-121.7815,37.9)] |Oakland < Las Positas Road|[(-121.764488,37.99199),(-121.75569,37.02022)] |Oakland < Livermore Ave |[(-121.7687,37.448),(-121.769,37.375)] |Oakland < Livermore Ave |[(-121.772719,37.99085),(-121.7728,37.001)] |Oakland < Mission Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)] |Oakland < Navajo Ct |[(-121.8779,37.901),(-121.8783,37.9)] |Oakland < Pimlico Dr |[(-121.8616,37.998),(-121.8618,37.008)] |Oakland < Rosedale Ct |[(-121.9232,37.9),(-121.924,37.897)] |Oakland < Saginaw Ct |[(-121.8803,37.898),(-121.8806,37.901)] |Oakland < Sp Railroad |[(-121.893564,37.99009),(-121.897,37.016)] |Oakland < Sp Railroad |[(-121.9565,37.898),(-121.9562,37.9)] |Oakland < State Hwy 84 |[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)] |Oakland < Sunol Ridge Trl |[(-121.9419,37.455),(-121.9345,37.38)] |Oakland < Tassajara Creek |[(-121.87866,37.98898),(-121.8782,37.015)] |Oakland < Theresa Way |[(-121.7289,37.906),(-121.728,37.899)] |Oakland < Tissiack Way |[(-121.920364,37),(-121.9208,37.995)] |Oakland < Vallecitos Road|[(-121.8699,37.916),(-121.8703,37.891)] |Oakland < Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)] |Oakland < Welch Creek Road|[(-121.7695,37.386),(-121.7737,37.413)] |Oakland < Whitlock Creek |[(-121.74683,37.91276),(-121.733107,37)] |Oakland < 1st St |[(-121.75508,37.89294),(-121.753581,37.90031)] |Oakland < Arden Road|[(-122.0978,37.177),(-122.1,37.177)] |Oakland 57,94d17 < Bridgepointe Dr |[(-122.0514,37.305),(-122.0509,37.299)] |Oakland < Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)] |Oakland < Celia St |[(-122.0611,37.3),(-122.0616,37.299)] |Oakland < Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)] |Oakland < Crystaline Dr |[(-121.925856,37),(-121.925869,37.00527)] |Oakland < Decoto Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)] |Oakland < Eden Creek |[(-122.022037,37.00675),(-122.0221,37.998)] |Oakland < Hesperian Blvd|[(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)] |Oakland < I- 580 |[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]|Oakland < I- 680 |((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934)) |Oakland < I- 880 |((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933)) |Oakland < I- 880 |[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)] |Oakland < I- 880 |[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)] |Oakland < I- 880 Ramp|[(-122.0019,37.301),(-122.002,37.293)] |Oakland < I- 880 Ramp|[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)] |Oakland < I- 880 Ramp|[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)] |Oakland < I- 880 Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)] |Oakland < I- 880 Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)] |Oakland < I- 880 Ramp|[(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)] |Oakland < I- 880 Ramp|[(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)] |Oakland < Kildare Road|[(-122.0968,37.016),(-122.0959,37)] |Oakland < Mildred Ct |[(-122.0002,37.388),(-121.9998,37.386)] |Oakland < Miramar Ave |[(-122.1009,37.025),(-122.099089,37.03209)] |Oakland < Mission Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)] |Oakland < Moores Ave |[(-122.0087,37.301),(-122.0094,37.292)] |Oakland < Oakridge Road|[(-121.8316,37.049),(-121.828382,37)] |Oakland < Paseo Padre Pkwy|[(-121.9143,37.005),(-121.913522,37)] |Oakland < Periwinkle Road|[(-122.0451,37.301),(-122.044758,37.29844)] |Oakland < Railroad Ave |[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)] |Oakland < Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)] |Oakland < Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)] |Oakland < Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)] |Oakland < Stanton Ave |[(-122.100392,37.0697),(-122.099513,37.06052)] |Oakland < Thackeray Ave |[(-122.072,37.305),(-122.0715,37.298)] |Oakland < Tissiack Way |[(-121.920364,37),(-121.9208,37.995)] |Oakland < Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)] |Oakland < Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)] |Oakland < Whitlock Creek |[(-121.74683,37.91276),(-121.733107,37)] |Oakland 95a19 > Avenue 134th |[(-122.1823,37.002),(-122.1851,37.992)] |Berkeley 96a21 > Avenue 140th |[(-122.1656,37.003),(-122.1691,37.988)] |Berkeley 101a27 > Bridgepointe Dr |[(-122.0514,37.305),(-122.0509,37.299)] |Oakland 103,160d28 < Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)] |Oakland < C St |[(-122.1768,37.46),(-122.1749,37.435)] |Oakland < Cameron Ave |[(-122.1316,37.502),(-122.1327,37.481)] |Oakland < Chapman Dr |[(-122.0421,37.504),(-122.0414,37.498)] |Oakland < Charles St |[(-122.0255,37.505),(-122.0252,37.499)] |Oakland < Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)] |Oakland < Coliseum Way |[(-122.2001,37.47),(-122.1978,37.516)] |Oakland < D St |[(-122.1811,37.505),(-122.1805,37.497)] |Oakland < Decoto Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)] |Oakland < E St |[(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)] |Oakland < Eden Ave |[(-122.1143,37.505),(-122.1142,37.491)] |Oakland < Eden Creek |[(-122.022037,37.00675),(-122.0221,37.998)] |Oakland < Hegenberger Exwy|[(-122.1946,37.52),(-122.1947,37.497)] |Oakland < Herrier St |[(-122.1943,37.006),(-122.1936,37.998)] |Oakland < I- 580 |[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)] |Oakland < I- 580 |[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)] |Oakland < I- 580 Ramp|[(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)] |Oakland < I- 580 Ramp|[(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)] |Oakland < I- 880 |[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)] |Oakland < I- 880 |[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)] |Oakland < I- 880 |[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)] |Oakland < I- 880 |[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)] |Oakland < I- 880 Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)] |Oakland < I- 880 Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)] |Oakland < Kaiser Dr |[(-122.067163,37.47821),(-122.060402,37.51961)] |Oakland < La Playa Dr |[(-122.1039,37.545),(-122.101,37.493)] |Oakland < Locust St |[(-122.1606,37.007),(-122.1593,37.987)] |Oakland < Magnolia St |[(-122.0971,37.5),(-122.0962,37.484)] |Oakland < Mattos Dr |[(-122.0005,37.502),(-122.000898,37.49683)] |Oakland < Maubert Ave |[(-122.1114,37.009),(-122.1096,37.995)] |Oakland < McClure Ave |[(-122.1431,37.001),(-122.1436,37.998)] |Oakland < National Ave |[(-122.1192,37.5),(-122.1281,37.489)] |Oakland < Portsmouth Ave |[(-122.1064,37.315),(-122.1064,37.308)] |Oakland < Railroad Ave |[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)] |Oakland < Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)] |Oakland < Redwood Road|[(-122.1493,37.98),(-122.1437,37.001)] |Oakland < Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)] |Oakland < Skyline Blvd|[(-122.1738,37.01),(-122.1714,37.996)] |Oakland < Skyline Dr |[(-122.0277,37.5),(-122.0284,37.498)] |Oakland < Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)] |Oakland < Sp Railroad |[(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)] |Oakland < Sp Railroad |[(-122.1947,37.497),(-122.193328,37.4848)] |Oakland < State Hwy 92 |[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)] |Oakland < State Hwy 92 Ramp|[(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)] |Oakland < Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)] |Oakland < Willimet Way |[(-122.0964,37.517),(-122.0949,37.493)] |Oakland < Wisconsin St |[(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)] |Oakland < 100th Ave |[(-122.1657,37.429),(-122.1647,37.432)] |Oakland < 107th Ave |[(-122.1555,37.403),(-122.1531,37.41)] |Oakland < 85th Ave |[(-122.1877,37.466),(-122.186,37.476)] |Oakland < 89th Ave |[(-122.1822,37.459),(-122.1803,37.471)] |Oakland < 98th Ave |[(-122.1568,37.498),(-122.1558,37.502)] |Oakland < 98th Ave |[(-122.1693,37.438),(-122.1682,37.444)] |Oakland < Allen Ct |[(-122.0131,37.602),(-122.0117,37.597)] |Berkeley < Alvarado Niles Road|[(-122.0325,37.903),(-122.0316,37.9)] |Berkeley < Arizona St |[(-122.0381,37.901),(-122.0367,37.898)] |Berkeley < Avenue 134th |[(-122.1823,37.002),(-122.1851,37.992)] |Berkeley < Avenue 140th |[(-122.1656,37.003),(-122.1691,37.988)] |Berkeley 162a31,32 > Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)] |Oakland > Butterfield Dr |[(-122.0838,37.002),(-122.0834,37.987)] |Oakland 163a34,35 > C St |[(-122.1768,37.46),(-122.1749,37.435)] |Oakland > Calaveras Creek |[(-121.8203,37.035),(-121.8207,37.931)] |Oakland 164a37,38 > California St |[(-122.2032,37.005),(-122.2016,37.996)] |Lafayette > Cameron Ave |[(-122.1316,37.502),(-122.1327,37.481)] |Oakland 165a40 > Capricorn Ave |[(-122.2176,37.404),(-122.2164,37.384)] |Lafayette 166a42 > Celia St |[(-122.0611,37.3),(-122.0616,37.299)] |Oakland 167a44,45 > Chambers Dr |[(-122.2004,37.352),(-122.1972,37.368)] |Lafayette > Chambers Lane|[(-122.2001,37.359),(-122.1975,37.371)] |Lafayette 168a47,51 > Champion St |[(-122.214,37.991),(-122.2147,37.002)] |Lafayette > Chapman Dr |[(-122.0421,37.504),(-122.0414,37.498)] |Oakland > Charles St |[(-122.0255,37.505),(-122.0252,37.499)] |Oakland > Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)] |Oakland > Claremont Pl |[(-122.0542,37.995),(-122.0542,37.008)] |Oakland 169a53 > Coliseum Way |[(-122.2001,37.47),(-122.1978,37.516)] |Oakland 170a55 > Coolidge Ave |[(-122.2007,37.058),(-122.1992,37.06)] |Lafayette 171a57,58 > Corriea Way |[(-121.9501,37.402),(-121.9505,37.398)] |Oakland > Cowing Road|[(-122.0002,37.934),(-121.9772,37.782)] |Oakland 172a60 > Creston Road|[(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)] |Lafayette 173a62 > Crystaline Dr |[(-121.925856,37),(-121.925869,37.00527)] |Oakland 174a64,66 > D St |[(-122.1811,37.505),(-122.1805,37.497)] |Oakland > Decoto Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)] |Oakland > Decoto Road|[(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)] |Oakland 177a70 > Dimond Ave |[(-122.2167,37.994),(-122.2162,37.006)] |Lafayette 178a72,76 > Driscoll Road|[(-121.9482,37.403),(-121.948451,37.39995)] |Oakland > E St |[(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)] |Oakland > Eden Ave |[(-122.1143,37.505),(-122.1142,37.491)] |Oakland > Eden Creek |[(-122.022037,37.00675),(-122.0221,37.998)] |Oakland > Eden Creek |[(-122.022037,37.00675),(-122.0221,37.998)] |Oakland 179a78,79 > Edgewater Dr |[(-122.201,37.379),(-122.2042,37.41)] |Lafayette > Enos Way |[(-121.7677,37.896),(-121.7673,37.91)] |Oakland 180a81,82 > Euclid Ave |[(-122.2671,37.009),(-122.2666,37.987)] |Lafayette > Fairview Ave |[(-121.999,37.428),(-121.9863,37.351)] |Oakland 184a87,89 > Heartwood Dr |[(-122.2006,37.341),(-122.1992,37.338)] |Lafayette > Hegenberger Exwy|[(-122.1946,37.52),(-122.1947,37.497)] |Oakland > Herrier St |[(-122.1943,37.006),(-122.1936,37.998)] |Oakland 185a91 > Hesperian Blvd|[(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)] |Oakland 186a93,97 > Hollis St |[(-122.2885,37.397),(-122.289,37.414)] |Lafayette > I- 580 |[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]|Oakland > I- 580 |[(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)] |Oakland > I- 580 |[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)] |Oakland > I- 580 |[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)] |Oakland 187a99 > I- 580 |[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)] |Oakland 189a102,106 > I- 580 |[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)] |Lafayette > I- 580 Ramp|[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)] |Oakland > I- 580 Ramp|[(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)] |Oakland > I- 580 Ramp|[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)] |Oakland > I- 580 Ramp|[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)] |Oakland 194a112 > I- 580 Ramp|[(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)] |Oakland 195a114,127 > I- 580 Ramp|[(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)] |Oakland > I- 580/I-680 Ramp|((-121.9207,37.988),(-121.9192,37.016)) |Oakland > I- 680 |((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934)) |Oakland > I- 680 |((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934)) |Oakland > I- 680 |[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)] |Oakland > I- 680 |[(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)] |Oakland > I- 680 Ramp|[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)] |Oakland > I- 680 Ramp|[(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)] |Oakland > I- 680 Ramp|[(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)] |Oakland > I- 80 Ramp|[(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)] |Lafayette > I- 880 |((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933)) |Oakland > I- 880 |((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933)) |Oakland > I- 880 |[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)] |Oakland > I- 880 |[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)] |Oakland 196a129,130 > I- 880 |[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)] |Oakland > I- 880 |[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)] |Oakland 197a132,133 > I- 880 |[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)] |Oakland > I- 880 |[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)] |Oakland 198a135 > I- 880 |[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)] |Oakland 201a139,143 > I- 880 Ramp|[(-122.0019,37.301),(-122.002,37.293)] |Oakland > I- 880 Ramp|[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)] |Oakland > I- 880 Ramp|[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)] |Oakland > I- 880 Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)] |Oakland > I- 880 Ramp|[(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)] |Oakland 202a145,146 > I- 880 Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)] |Oakland > I- 880 Ramp|[(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)] |Oakland 203a148,149 > I- 880 Ramp|[(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)] |Oakland > I- 880 Ramp|[(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)] |Oakland 207a154,155 > I- 880 Ramp|[(-122.2771,37.002),(-122.278,37)] |Lafayette > Indian Way |[(-122.2066,37.398),(-122.2045,37.411)] |Lafayette 208a157 > Johnson Dr |[(-121.9145,37.901),(-121.915,37.877)] |Oakland 209a159,160 > Juniper St |[(-121.7823,37.897),(-121.7815,37.9)] |Oakland > Kaiser Dr |[(-122.067163,37.47821),(-122.060402,37.51961)] |Oakland 210a162,163 > Kildare Road|[(-122.0968,37.016),(-122.0959,37)] |Oakland > La Playa Dr |[(-122.1039,37.545),(-122.101,37.493)] |Oakland 211a165 > Laguna Ave |[(-122.2099,37.989),(-122.2089,37)] |Lafayette 213a168,169 > Lakeshore Ave |[(-122.2586,37.99),(-122.2556,37.006)] |Lafayette > Las Positas Road|[(-121.764488,37.99199),(-121.75569,37.02022)] |Oakland 214a171,174 > Linden St |[(-122.2867,37.998),(-122.2864,37.008)] |Lafayette > Livermore Ave |[(-121.7687,37.448),(-121.769,37.375)] |Oakland > Livermore Ave |[(-121.772719,37.99085),(-121.7728,37.001)] |Oakland > Locust St |[(-122.1606,37.007),(-122.1593,37.987)] |Oakland 215a176,177 > Magnolia St |[(-122.0971,37.5),(-122.0962,37.484)] |Oakland > Mandalay Road|[(-122.2322,37.397),(-122.2321,37.403)] |Lafayette 217a180,181 > Mattos Dr |[(-122.0005,37.502),(-122.000898,37.49683)] |Oakland > Maubert Ave |[(-122.1114,37.009),(-122.1096,37.995)] |Oakland 218a183 > McClure Ave |[(-122.1431,37.001),(-122.1436,37.998)] |Oakland 219a185 > Mildred Ct |[(-122.0002,37.388),(-121.9998,37.386)] |Oakland 220a187,189 > Miramar Ave |[(-122.1009,37.025),(-122.099089,37.03209)] |Oakland > Mission Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)] |Oakland > Mission Blvd|[(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)] |Oakland 221a191,193 > Moores Ave |[(-122.0087,37.301),(-122.0094,37.292)] |Oakland > National Ave |[(-122.1192,37.5),(-122.1281,37.489)] |Oakland > Navajo Ct |[(-121.8779,37.901),(-121.8783,37.9)] |Oakland 222a195 > Oakridge Road|[(-121.8316,37.049),(-121.828382,37)] |Oakland 225a199 > Paseo Padre Pkwy|[(-121.9143,37.005),(-121.913522,37)] |Oakland 227a202,207 > Periwinkle Road|[(-122.0451,37.301),(-122.044758,37.29844)] |Oakland > Pimlico Dr |[(-121.8616,37.998),(-121.8618,37.008)] |Oakland > Portsmouth Ave |[(-122.1064,37.315),(-122.1064,37.308)] |Oakland > Proctor Ave |[(-122.2267,37.406),(-122.2251,37.386)] |Lafayette > Railroad Ave |[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)] |Oakland > Railroad Ave |[(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)] |Oakland 228a209,210 > Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)] |Oakland > Ranspot Dr |[(-122.0972,37.999),(-122.0959,37)] |Oakland 230a213 > Redwood Road|[(-122.1493,37.98),(-122.1437,37.001)] |Oakland 232a216 > Rosedale Ct |[(-121.9232,37.9),(-121.924,37.897)] |Oakland 234a219 > Saginaw Ct |[(-121.8803,37.898),(-121.8806,37.901)] |Oakland 235a221,222 > Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)] |Oakland > Santa Maria Ave |[(-122.0773,37),(-122.0773,37.98)] |Oakland 237a225 > Sheridan Road|[(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)] |Lafayette 238a227 > Skyline Blvd|[(-122.1738,37.01),(-122.1714,37.996)] |Oakland 239a229 > Skyline Dr |[(-122.0277,37.5),(-122.0284,37.498)] |Oakland 240a231,234 > Sp Railroad |[(-121.893564,37.99009),(-121.897,37.016)] |Oakland > Sp Railroad |[(-121.9565,37.898),(-121.9562,37.9)] |Oakland > Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)] |Oakland > Sp Railroad |[(-122.0734,37.001),(-122.0734,37.997)] |Oakland 242a237 > Sp Railroad |[(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)] |Oakland 243a239,240 > Sp Railroad |[(-122.1947,37.497),(-122.193328,37.4848)] |Oakland > Stanton Ave |[(-122.100392,37.0697),(-122.099513,37.06052)] |Oakland 245a243,244 > State Hwy 13 |[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)] |Lafayette > State Hwy 13 Ramp|[(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)] |Lafayette 247a247,250 > State Hwy 24 |[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)] |Lafayette > State Hwy 84 |[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)] |Oakland > State Hwy 92 |[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)] |Oakland > State Hwy 92 Ramp|[(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)] |Oakland 248a252,258 > Sunol Ridge Trl |[(-121.9419,37.455),(-121.9345,37.38)] |Oakland > Tassajara Creek |[(-121.87866,37.98898),(-121.8782,37.015)] |Oakland > Taurus Ave |[(-122.2159,37.416),(-122.2128,37.389)] |Lafayette > Thackeray Ave |[(-122.072,37.305),(-122.0715,37.298)] |Oakland > Theresa Way |[(-121.7289,37.906),(-121.728,37.899)] |Oakland > Tissiack Way |[(-121.920364,37),(-121.9208,37.995)] |Oakland > Tissiack Way |[(-121.920364,37),(-121.9208,37.995)] |Oakland 249a260,263 > Vallecitos Road|[(-121.8699,37.916),(-121.8703,37.891)] |Oakland > Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)] |Oakland > Warm Springs Blvd|[(-121.933956,37),(-121.9343,37.97)] |Oakland > Welch Creek Road|[(-121.7695,37.386),(-121.7737,37.413)] |Oakland 250a265,266 > Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)] |Oakland > Western Pacific Railroad Spur |[(-122.0394,37.018),(-122.0394,37.961)] |Oakland 251a268,271 > Whitlock Creek |[(-121.74683,37.91276),(-121.733107,37)] |Oakland > Whitlock Creek |[(-121.74683,37.91276),(-121.733107,37)] |Oakland > Willimet Way |[(-122.0964,37.517),(-122.0949,37.493)] |Oakland > Wisconsin St |[(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)] |Oakland 253a274,275 > 100th Ave |[(-122.1657,37.429),(-122.1647,37.432)] |Oakland > 107th Ave |[(-122.1555,37.403),(-122.1531,37.41)] |Oakland 254a277,278 > 1st St |[(-121.75508,37.89294),(-121.753581,37.90031)] |Oakland > 5th St |[(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)] |Lafayette 257,284c281,284 < Ada St |[(-122.2487,37.398),(-122.2496,37.401)] |Lafayette < California St |[(-122.2032,37.005),(-122.2016,37.996)] |Lafayette < Capricorn Ave |[(-122.2176,37.404),(-122.2164,37.384)] |Lafayette < Chambers Dr |[(-122.2004,37.352),(-122.1972,37.368)] |Lafayette < Chambers Lane|[(-122.2001,37.359),(-122.1975,37.371)] |Lafayette < Champion St |[(-122.214,37.991),(-122.2147,37.002)] |Lafayette < Coolidge Ave |[(-122.2007,37.058),(-122.1992,37.06)] |Lafayette < Creston Road|[(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)] |Lafayette < Dimond Ave |[(-122.2167,37.994),(-122.2162,37.006)] |Lafayette < Edgewater Dr |[(-122.201,37.379),(-122.2042,37.41)] |Lafayette < Euclid Ave |[(-122.2671,37.009),(-122.2666,37.987)] |Lafayette < Heartwood Dr |[(-122.2006,37.341),(-122.1992,37.338)] |Lafayette < Hollis St |[(-122.2885,37.397),(-122.289,37.414)] |Lafayette < I- 580 |[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)] |Lafayette < I- 80 Ramp|[(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)] |Lafayette < I- 880 Ramp|[(-122.2771,37.002),(-122.278,37)] |Lafayette < Indian Way |[(-122.2066,37.398),(-122.2045,37.411)] |Lafayette < Laguna Ave |[(-122.2099,37.989),(-122.2089,37)] |Lafayette < Lakeshore Ave |[(-122.2586,37.99),(-122.2556,37.006)] |Lafayette < Linden St |[(-122.2867,37.998),(-122.2864,37.008)] |Lafayette < Mandalay Road|[(-122.2322,37.397),(-122.2321,37.403)] |Lafayette < Proctor Ave |[(-122.2267,37.406),(-122.2251,37.386)] |Lafayette < Sheridan Road|[(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)] |Lafayette < State Hwy 13 |[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)] |Lafayette < State Hwy 13 Ramp|[(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)] |Lafayette < State Hwy 24 |[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)] |Lafayette < Taurus Ave |[(-122.2159,37.416),(-122.2128,37.389)] |Lafayette < 5th St |[(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)] |Lafayette --- > 85th Ave |[(-122.1877,37.466),(-122.186,37.476)] |Oakland > 89th Ave |[(-122.1822,37.459),(-122.1803,37.471)] |Oakland > 98th Ave |[(-122.1568,37.498),(-122.1558,37.502)] |Oakland > 98th Ave |[(-122.1693,37.438),(-122.1682,37.444)] |Oakland [dave@morpheus regress]# [dave@morpheus regress]# diff expected/rules.out results/rules.out 1068,1090c1068,1070 < viewname |definition < ------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- < iexit |SELECT "ih"."name", "ih"."thepath", "interpt_pp"("ih"."thepath", "r"."thepath") AS "exit" FROM "ihighway" "ih", "ramp" "r" WHERE ("ih"."thepath" ## "r"."thepath"); < pg_indexes |SELECT "c"."relname" AS "tablename", "i"."relname" AS "indexname", "pg_get_indexdef"("x"."indexrelid") AS "indexdef" FROM "pg_index" "x", "pg_class" "c", "pg_class" "i" WHERE (("c"."oid" = "x"."indrelid") AND ("i"."oid" = "x"."indexrelid")); < pg_rules |SELECT "c"."relname" AS "tablename", "r"."rulename", "pg_get_ruledef"("r"."rulename") AS "definition" FROM "pg_rewrite" "r", "pg_class" "c" WHERE (("r"."rulename" !~ '^_RET'::"text") AND ("c"."oid" = "r"."ev_class")); < pg_tables |SELECT "c"."relname" AS "tablename", "pg_get_userbyid"("c"."relowner") AS "tableowner", "c"."relhasindex" AS "hasindexes", "c"."relhasrules" AS "hasrules", ("c"."reltriggers" > '0'::"int4") AS "hastriggers" FROM "pg_class" "c" WHERE ((("c"."relkind" = 'r'::"char") OR ("c"."relkind" = 's'::"char")) AND (NOT (EXISTS (SELECT "pg_rewrite"."rulename" FROM "pg_rewrite" WHERE (("pg_rewrite"."ev_class" = "c"."oid") AND ("pg_rewrite"."ev_type" = '1'::"char")))))); < pg_user |SELECT "pg_shadow"."usename", "pg_shadow"."usesysid", "pg_shadow"."usecreatedb", "pg_shadow"."usetrace", "pg_shadow"."usesuper", "pg_shadow"."usecatupd", '********'::"text" AS "passwd", "pg_shadow"."valuntil" FROM "pg_shadow"; < pg_views |SELECT "c"."relname" AS "viewname", "pg_get_userbyid"("c"."relowner") AS "viewowner", "pg_get_viewdef"("c"."relname") AS "definition" FROM "pg_class" "c" WHERE ("c"."relhasrules" AND (EXISTS (SELECT "r"."rulename" FROM "pg_rewrite" "r" WHERE (("r"."ev_class" = "c"."oid") AND ("r"."ev_type" = '1'::"char"))))); < rtest_v1 |SELECT "rtest_t1"."a", "rtest_t1"."b" FROM "rtest_t1"; < rtest_vcomp |SELECT "x"."part", ("x"."size" * "y"."factor") AS "size_in_cm" FROM "rtest_comp" "x", "rtest_unitfact" "y" WHERE ("x"."unit" = "y"."unit"); < rtest_vview1 |SELECT "x"."a", "x"."b" FROM "rtest_view1" "x" WHERE ('0'::"int4" < (SELECT "count"("y"."a") AS "count" FROM "rtest_view2" "y" WHERE ("y"."a" = "x"."a"))); < rtest_vview2 |SELECT "rtest_view1"."a", "rtest_view1"."b" FROM "rtest_view1" WHERE "rtest_view1"."v"; < rtest_vview3 |SELECT "x"."a", "x"."b" FROM "rtest_vview2" "x" WHERE ('0'::"int4" < (SELECT "count"("y"."a") AS "count" FROM "rtest_view2" "y" WHERE ("y"."a" = "x"."a"))); < rtest_vview4 |SELECT "x"."a", "x"."b", "count"("y"."a") AS "refcount" FROM "rtest_view1" "x", "rtest_view2" "y" WHERE ("x"."a" = "y"."a") GROUP BY "x"."a", "x"."b"; < rtest_vview5 |SELECT "rtest_view1"."a", "rtest_view1"."b", "rtest_viewfunc1"("rtest_view1"."a") AS "refcount" FROM "rtest_view1"; < shoe |SELECT "sh"."shoename", "sh"."sh_avail", "sh"."slcolor", "sh"."slminlen", ("sh"."slminlen" * "un"."un_fact") AS "slminlen_cm", "sh"."slmaxlen", ("sh"."slmaxlen" * "un"."un_fact") AS "slmaxlen_cm", "sh"."slunit" FROM "shoe_data" "sh", "unit" "un" WHERE ("sh"."slunit" = "un"."un_name"); < shoe_ready |SELECT "rsh"."shoename", "rsh"."sh_avail", "rsl"."sl_name", "rsl"."sl_avail", "int4smaller"("rsh"."sh_avail", "rsl"."sl_avail") AS "total_avail" FROM "shoe" "rsh", "shoelace" "rsl" WHERE ((("rsl"."sl_color" = "rsh"."slcolor") AND ("rsl"."sl_len_cm" >= "rsh"."slminlen_cm")) AND ("rsl"."sl_len_cm" <= "rsh"."slmaxlen_cm")); < shoelace |SELECT "s"."sl_name", "s"."sl_avail", "s"."sl_color", "s"."sl_len", "s"."sl_unit", ("s"."sl_len" * "u"."un_fact") AS "sl_len_cm" FROM "shoelace_data" "s", "unit" "u" WHERE ("s"."sl_unit" = "u"."un_name"); < shoelace_candelete|SELECT "shoelace_obsolete"."sl_name", "shoelace_obsolete"."sl_avail", "shoelace_obsolete"."sl_color", "shoelace_obsolete"."sl_len", "shoelace_obsolete"."sl_unit", "shoelace_obsolete"."sl_len_cm" FROM "shoelace_obsolete" WHERE ("shoelace_obsolete"."sl_avail" = '0'::"int4"); < shoelace_obsolete |SELECT "shoelace"."sl_name", "shoelace"."sl_avail", "shoelace"."sl_color", "shoelace"."sl_len", "shoelace"."sl_unit", "shoelace"."sl_len_cm" FROM "shoelace" WHERE (NOT (EXISTS (SELECT "shoe"."shoename" FROM "shoe" WHERE ("shoe"."slcolor" = "shoelace"."sl_color")))); < street |SELECT "r"."name", "r"."thepath", "c"."cname" FROM "road" "r", "real_city" "c" WHERE ("c"."outline" ## "r"."thepath"); < toyemp |SELECT "emp"."name", "emp"."age", "emp"."location", ('12'::"int4" * "emp"."salary") AS "annualsal" FROM "emp"; < (20 rows) --- > viewname|definition > --------+---------- > (0 rows) 1094,1123c1074,1076 < tablename |rulename |definition < -------------+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ < rtest_emp |rtest_emp_del |CREATE RULE "rtest_emp_del" AS ON DELETE TO "rtest_emp" DO INSERT INTO "rtest_emplog" ("ename", "who", "action", "newsal", "oldsal") VALUES (old."ename", "getpgusername"(), 'fired'::"bpchar", '$0.00'::"money", old."salary"); < rtest_emp |rtest_emp_ins |CREATE RULE "rtest_emp_ins" AS ON INSERT TO "rtest_emp" DO INSERT INTO "rtest_emplog" ("ename", "who", "action", "newsal", "oldsal") VALUES (new."ename", "getpgusername"(), 'hired'::"bpchar", new."salary", '$0.00'::"money"); < rtest_emp |rtest_emp_upd |CREATE RULE "rtest_emp_upd" AS ON UPDATE TO "rtest_emp" WHERE (new."salary" <> old."salary") DO INSERT INTO "rtest_emplog" ("ename", "who", "action", "newsal", "oldsal") VALUES (new."ename", "getpgusername"(), 'honored'::"bpchar", new."salary", old."salary"); < rtest_nothn1 |rtest_nothn_r1 |CREATE RULE "rtest_nothn_r1" AS ON INSERT TO "rtest_nothn1" WHERE ((new."a" >= '10'::"int4") AND (new."a" < '20'::"int4")) DO INSTEAD SELECT '1'::"int4"; < rtest_nothn1 |rtest_nothn_r2 |CREATE RULE "rtest_nothn_r2" AS ON INSERT TO "rtest_nothn1" WHERE ((new."a" >= '30'::"int4") AND (new."a" < '40'::"int4")) DO INSTEAD NOTHING; < rtest_nothn2 |rtest_nothn_r3 |CREATE RULE "rtest_nothn_r3" AS ON INSERT TO "rtest_nothn2" WHERE (new."a" >= '100'::"int4") DO INSTEAD INSERT INTO "rtest_nothn3" ("a", "b") VALUES (new."a", new."b"); < rtest_nothn2 |rtest_nothn_r4 |CREATE RULE "rtest_nothn_r4" AS ON INSERT TO "rtest_nothn2" DO INSTEAD NOTHING; < rtest_order1 |rtest_order_r1 |CREATE RULE "rtest_order_r1" AS ON INSERT TO "rtest_order1" DO INSTEAD INSERT INTO "rtest_order2" ("a", "b", "c") VALUES (new."a", "nextval"('rtest_seq'::"text"), 'rule 1 - this should run 3rd or 4th'::"text"); < rtest_order1 |rtest_order_r2 |CREATE RULE "rtest_order_r2" AS ON INSERT TO "rtest_order1" DO INSERT INTO "rtest_order2" ("a", "b", "c") VALUES (new."a", "nextval"('rtest_seq'::"text"), 'rule 2 - this should run 1st'::"text"); < rtest_order1 |rtest_order_r3 |CREATE RULE "rtest_order_r3" AS ON INSERT TO "rtest_order1" DO INSTEAD INSERT INTO "rtest_order2" ("a", "b", "c") VALUES (new."a", "nextval"('rtest_seq'::"text"), 'rule 3 - this should run 3rd or 4th'::"text"); < rtest_order1 |rtest_order_r4 |CREATE RULE "rtest_order_r4" AS ON INSERT TO "rtest_order1" WHERE ("rtest_order2"."a" < '100'::"int4") DO INSTEAD INSERT INTO "rtest_order2" ("a", "b", "c") VALUES (new."a", "nextval"('rtest_seq'::"text"), 'rule 4 - this should run 2nd'::"text"); < rtest_person |rtest_pers_del |CREATE RULE "rtest_pers_del" AS ON DELETE TO "rtest_person" DO DELETE FROM "rtest_admin" WHERE ("rtest_admin"."pname" = old."pname"); < rtest_person |rtest_pers_upd |CREATE RULE "rtest_pers_upd" AS ON UPDATE TO "rtest_person" DO UPDATE rtest_admin SET "pname" = new."pname" WHERE ("rtest_admin"."pname" = old."pname"); < rtest_system |rtest_sys_del |CREATE RULE "rtest_sys_del" AS ON DELETE TO "rtest_system" DO (DELETE FROM "rtest_interface" WHERE ("rtest_interface"."sysname" = old."sysname"); DELETE FROM "rtest_admin" WHERE ("rtest_admin"."sysname" = old."sysname"); ); < rtest_system |rtest_sys_upd |CREATE RULE "rtest_sys_upd" AS ON UPDATE TO "rtest_system" DO (UPDATE rtest_interface SET "sysname" = new."sysname" WHERE ("rtest_interface"."sysname" = old."sysname"); UPDATE rtest_admin SET "sysname" = new."sysname" WHERE ("rtest_admin"."sysname" = old."sysname"); ); < rtest_t4 |rtest_t4_ins1 |CREATE RULE "rtest_t4_ins1" AS ON INSERT TO "rtest_t4" WHERE ((new."a" >= '10'::"int4") AND (new."a" < '20'::"int4")) DO INSTEAD INSERT INTO "rtest_t5" ("a", "b") VALUES (new."a", new."b"); < rtest_t4 |rtest_t4_ins2 |CREATE RULE "rtest_t4_ins2" AS ON INSERT TO "rtest_t4" WHERE ((new."a" >= '20'::"int4") AND (new."a" < '30'::"int4")) DO INSERT INTO "rtest_t6" ("a", "b") VALUES (new."a", new."b"); < rtest_t5 |rtest_t5_ins |CREATE RULE "rtest_t5_ins" AS ON INSERT TO "rtest_t5" WHERE (new."a" > '15'::"int4") DO INSERT INTO "rtest_t7" ("a", "b") VALUES (new."a", new."b"); < rtest_t6 |rtest_t6_ins |CREATE RULE "rtest_t6_ins" AS ON INSERT TO "rtest_t6" WHERE (new."a" > '25'::"int4") DO INSTEAD INSERT INTO "rtest_t8" ("a", "b") VALUES (new."a", new."b"); < rtest_v1 |rtest_v1_del |CREATE RULE "rtest_v1_del" AS ON DELETE TO "rtest_v1" DO INSTEAD DELETE FROM "rtest_t1" WHERE ("rtest_t1"."a" = old."a"); < rtest_v1 |rtest_v1_ins |CREATE RULE "rtest_v1_ins" AS ON INSERT TO "rtest_v1" DO INSTEAD INSERT INTO "rtest_t1" ("a", "b") VALUES (new."a", new."b"); < rtest_v1 |rtest_v1_upd |CREATE RULE "rtest_v1_upd" AS ON UPDATE TO "rtest_v1" DO INSTEAD UPDATE rtest_t1 SET "a" = new."a", "b" = new."b" WHERE ("rtest_t1"."a" = old."a"); < shoelace |shoelace_del |CREATE RULE "shoelace_del" AS ON DELETE TO "shoelace" DO INSTEAD DELETE FROM "shoelace_data" WHERE ("shoelace_data"."sl_name" = old."sl_name"); < shoelace |shoelace_ins |CREATE RULE "shoelace_ins" AS ON INSERT TO "shoelace" DO INSTEAD INSERT INTO "shoelace_data" ("sl_name", "sl_avail", "sl_color", "sl_len", "sl_unit") VALUES (new."sl_name", new."sl_avail", new."sl_color", new."sl_len", new."sl_unit"); < shoelace |shoelace_upd |CREATE RULE "shoelace_upd" AS ON UPDATE TO "shoelace" DO INSTEAD UPDATE shoelace_data SET "sl_name" = new."sl_name", "sl_avail" = new."sl_avail", "sl_color" = new."sl_color", "sl_len" = new."sl_len", "sl_unit" = new."sl_unit" WHERE ("shoelace_data"."sl_name" = old."sl_name"); < shoelace_data|log_shoelace |CREATE RULE "log_shoelace" AS ON UPDATE TO "shoelace_data" WHERE (new."sl_avail" <> old."sl_avail") DO INSERT INTO "shoelace_log" ("sl_name", "sl_avail", "log_who", "log_when") VALUES (new."sl_name", new."sl_avail", 'Al Bundy'::"name", "datetime"('epoch'::"text")); < shoelace_ok |shoelace_ok_ins|CREATE RULE "shoelace_ok_ins" AS ON INSERT TO "shoelace_ok" DO INSTEAD UPDATE shoelace SET "sl_avail" = ("shoelace"."sl_avail" + new."ok_quant") WHERE ("shoelace"."sl_name" = new."ok_name"); < (27 rows) --- > tablename|rulename|definition > ---------+--------+---------- > (0 rows) [dave@morpheus regress]#
В списке pgsql-ports по дате отправления: