Received: from smtp-2.ig.com.br (smtp-2.ig.com.br [200.225.157.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB1MoQF29124 for ; Fri, 1 Dec 2000 17:50:27 -0500 (EST) (envelope-from edipoelder@ig.com.br) Message-Id: <200012012250.eB1MoQF29124@mail.postgresql.org> Received: (qmail 28390 invoked from network); 1 Dec 2000 22:50:29 -0000 Received: from unknown (HELO MYHOSTNAME) (200.217.202.207) by smtp-2.ig.com.br with SMTP; 1 Dec 2000 22:50:29 -0000 From: "Edipo E. F. Melo" To: "pgsql-sql" , "sara@conectiva.com.br" , "sarafabiana@starmedia.com" Date: Fri, 01 Dec 2000 19:48:44 -0400 (AST) Reply-To: "Edipo E. F. Melo" X-Mailer: (Demonstration) PMMail 2.00.1500 for OS/2 Warp 4.00 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="_=_=_=IMA.BOUNDARY.G4X0X8138764=_=_=_" Subject: I can be a BUG? X-Archive-Number: 200012/8 X-Sequence-Number: 339 --_=_=_=IMA.BOUNDARY.G4X0X8138764=_=_=_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi all, My wife is working on a university graduate project with PHP and PostgreSQL. She used ERWin to model the tables and exported the model into ASCII file with a set of SQL commands to create the tables (with a short corrections of types). Whe she tried to import into PostgreSQL, using pgsql and "\i" command, it create about 95% of the tables. The others wasn't created because she forgot change the type of some fields. To delete the tables, I sugest to drop the database and create it again. She droped the database and, when she created the new one, all tables was there. We repeat this process some times and it can't create a empty database. Even on a new, uncreated, with another name, database, all the tables of the problematic database was there. Can anyone explain if we are making somethink wrong or this is a BUG? We using PostgreSQL 7.0.3. under Conectiva Linux 5.0. I'm sending the ASCII script attached. PS.: Sara, sorry if you receive more than one copy of this mensage, but I was uncertain about you correct e-mail address. Thank's and "Feliz Natal" to all, []'s Edipo Elder F. de Melo --_=_=_=IMA.BOUNDARY.G4X0X8138764=_=_=_ Content-Type: application/octet-stream; name="TESTE.ZIP" Content-Transfer-Encoding: base64 UEsDBBQAAAAIAKatfinYYk+sJBQAAB7TAAAJAAAAVEVTVEUuc3Fs3V3LcuM6 Dt13Vf+DlvdWzaLzcpKalSIrbs3Ykq8kd/XMxv//F0PqyQcAAhSd5I423bFA 4vDwCIQoivr+bd8256zP345l9l4VP/Nr3pf1vjqVdd9cT+W+KvKsyLsi35dZ 0dRd3+ZV3Xf//P7t+7eiLZV1qPQf379l41Htr75VtW+6JlN1loeyzeqmz+rL 8fiPpdBYy2CbLYdr/v3bnwOioTVVvS9/Z7/P/8YgeabV+/3DTmT9TFpPxFzq 6q9LGcaTNTVK3/dvHP5AumZSJjSctm5HgjtFKeM6BZr2ndbvRgEzFZzvL8f+ wyRMqfIBMwetH0lrtobJXuRqZ+RQKGO0uSmw4G5R3thuY5W8TcghHRdtldeq Iz9UyKAyf4is71LqmOrDoHImBoUyRlubAgvuFqWN61am4mvXHKui6vO4eGwW 36xjVaz8rZBn5hGjYwMVJM0fr5g5ZH33g7RmCdmkyetG46RcyjNnqKDwxiZB gvrFaZP4tdpGBeNrX52b6768xqUVRvEUMl5qWwvGBeS1JlDIbsa4mIPWbqpn W/MiskGUH4/Wk1FCBljDZY02PQku3C9KosQv0dJAxlEqcKeqjk055uJJYvVY 189xrOmy+JxjqgkULZBNjuagNZAEGtbspGOmCRxyp5NxsdrmDJcZ2uwkmHC/ KIESv0grQ8n0uW2Kch+dTU/FU0h7rGoK3OOPsen0WBUoVijDHMxBaygxXK35 +fREE5xNjiejpG1yhusLbXMSQLhflD2JX6iJuKiNrKaJELVVfONsXarM2sQE iPTu9RkzB61fSGuOpC2S3J40T0on7EJ5NdHUBDhwryhlEq/crNrIU6JuDo3i 2wWcKqc2KgJF+YiZg9ZPpDXv5tCgyb81Wk9GSFiQURMNT4AK94oSKPEam08v mUpc0rEWTxCfE2XTS0WgXL1hkMi9717vSWtmyrGSBIy0y8mY+MzLpYlGJ0CE e0XJk3iNy6SnPCU2k56Lbxd1ujx6qgmS6csLZg5av5LW7Dx6JglMH6eTEaLm ZNFEixPAwb2izEm8RufQ21LozU8Lb5BCg/J8ElnvSGthBk2lkOJHhcEEGm9p Ahy4V5QxgVd5/rwtfU4h3vTpMyjIe5H1A2ktzJ6phDFGvpLkGW93AlS4V5Q/ gdetufO21DlJXE6cOkNSffYGP8r6xZvm2pI5UwljVFxmJs54mxMgwkWNcifw uiVv3pY2pxB06rQZFDSw2oywBpaJxWfNVL4YI2hW0ow3OAEc3CtKnMBrMGc2 pvp0KB/yk46nY7ion+5k5oGrt24cU338ylvVzvaPxx9/EuoFkVDygqErWsET 7BwOypRYVEIFQ0PtbagEHFFEQrgUjWBmEJU7uCM0i063EBXgsxtp0nFDkegi UgR6o5B4jDKvfCZtdhE0jkw/3oI0CwFFmQ1VEWb9IA2Cqva9YkfrscsvmiYO XV4py6l3lh64u/JgkDv8SJmfVPVFda5WezrP7fp8b9QdMD9375l9LObynl7N 91Vb9k1Lm8PCcNmEMo3dK8Nq9wM0QmTmdaJSmvubIzb3NNjLcF8CXYZmB35j GdhUv2IV+rww6otujnX1qf8e8u56LruuYU532EUsTOOpzDhoqY9VEOawIC0E oBp3YZNn3wQRot1g1TPWD063jOeAZuJq2kU4wGt7FtVmY7MHseEU+gSBN6rR dQBQMuMgxYPVyZMQAQxSy90LVgC0fiWtsWEVhzQMsiSVYLdy+EKFhDc5Eg3u CaVL7CnQSFff8I0hW9pI8bSqRmYeUFnDVYAyfcLMQesdaY2LGmFp7Fr4ZIya A3f0eGPlSHAnKEcSJ6G2OSoG7IuW+RQZLZ1Ww9jqTUzEcBWgKu9F1g+kNaph hKShT+FzMQoOrIYk2ipGgvtAGRL4CDYNzzPervuKmYcC5bardqjnrexLwJyR SQzFIeX9eOXZ3f1A7DhJw0iCO2YOv3L1uLQfVQjUEoFPXHlAy1n1IsApjfWX tyiN6XIpNKbrgc1ZGlPFQY3tmHbPiB1PYxq83y/qV77GBmNMX0ArBP7weoFW s+oFQFPa+pkzn60C5VJoS9cDm7O0pYqDmnlg2j0idjxtafB+n6hf+doajDEN AK0Q+MPrBVrNqhcATWsrUlqJlIWZM5UFCObVZw6yeoKtuKIC+0IiKaznAfh8 X2ilfms5lfpoKSkduE8agXLbxbQvdUV9Xg/tjhDTYXrG6Ojkjmd2j5jx9HQY H1f6v3IVZbQe1QDQEoFTtFqg5axqUeCQxs553xybgzCRX0tt0ddaC2ZO6msp DsjmZccxegaNaGWtoNe+WH4Lq8owhbvdR852hFbptZNTpQsUUk9TXM78l+/c Qlu0s1SCmpPamYsDqnh+Ydi8Qja0cBbEK/fzT2HZrJZwF3uguV7QCt0Whit0 MUKCUfrQe6c017Z8L9tqLws7fuktEvJrE0nIKw7p5ElivCONaXX5jVn7yzsX 1htQBNEJ2kIxANQFyovABdogQKUSTW5LsPJTdaxMe9w8vIbAK9KVv621DMMx 2N9B5vu8z6+1avr0QGf+sfSAa26cAwfeHlzbbAV+9wQhqfP+0uZH2xG+XqLO i6qpHXvc/L0t1RVUq8aWXdEcR/rfmubo2PXl6Xo+5nUzL0xB7HTPeIYE2sE8 rzLzwM3HhQWO/cK2ZaqMrhq0ARcHfMrtPgwhcOxhBMqIQECFUyAePu6MU2T0 W+OAKLDMDtDi0/UJhor52uUtZZ6Modqz9SCDxamshpWARTOsHBnGZLgXDGOF qO7OTWveu7m2h/ZybqZq+7ytGNUW6vJ0IHvJPXNtlDLdq/uUSl097+V/y+56 aas6x43zt7zry2J+2na4ELaq9X1uGDIwHKvf7sI9r9ZpSabqeZKEIZ4qbeRa F3NIHeOp178q027zfXNpzYBNxJDLqWzd2A6jUP16PpZGRDdrHsKvZf6WV61X Mw6kKM+Zdwy2rwDm6Xrspmi5rKAykcNBYrpWgChxt3shTj7fUSfvqZMP1MlH /OQj4fKR8PhIOHyk/D2Z55A4OccaFemWoEaFOm/adGEZr4JYNbf2A17cjC14 PffBerxwhlf2wAa1xlG8tkd+E9cQjo5NYcLMOIRWE+bLjHxoNWGmnFiL1hRm yY/waGVP7NYZYwuc+avhipf2K0NX9pl94MP4MCSoLqtOOgKOe+pAKXbz9q+y r3411vrMvvxN3pZ272SmpGDqPEdfpNhlazOiJ4CmycTcXKXF5AktDk8zLc2k 75j8+iQrCTFMUIx/fMbMQesX0hrrFJQk3VXYSWymjsMUGr7w5kZhwf2gREn8 BFrnCRkowL3Nx0qnlbFs6SCCCRTmo8j6ibQmZAxyNPUodC5SxIGlg3hrY7Dg blCaBG5CjbNEfKqKtskVDp5qV3M7AVl+ng9SppZl2Pyz382BL5alzYDen17t s4i+V9pU7y5/uMnd/LtHIUgSTAXQYkyEBnYKVjoAdlBtm/eq64Z5N/Zbc2sJ +3ozz4w/kkL461Kd4ckoz7zsziqTRKYG78FZ04iJ1r/P7TgynhgdAFwl9/ee ATYQmD2pI6HxtxtkrVOwxG3HgQpHWYBiHU8JX1t0CwHOTJa/dGQURnVYJQ4h kFDuIBtEKy6/qnedn8gO9rTi+g5XeKPQyB+l/QH6/2LExQbb59A4O49lNx3G vHH0mXCbRhFLN/H2i5itQSTZcnyFrp5RQd29s04iXb40S/E//z9VH3g9vWN4 E3fuyjQvM1/MYbfZfCQL+Rv2GVhQQf37ZJ/FcuelYTpJnf+IIN3rzSdW1UTP TSTysoHRFqjaZHVjJ6zmF3dOUR9j0kpupjEgIkfdEbMeGydiuGzJ1nrBi7zC q7YkjJGRibMyy1zbFLOoKXI1U2AZU3hdUpJrW7TKCFx6k2bNjfU4lcWfVcLy SDyalVE334nB1JluKNYsOE2d2U9sUOQgTdYDahZNVgnLGfGwOyVNphuKJguO osl+IoUih9XkPPLnCcopZPcMvoggqaZsN6SsHERaWe7TN6oJ8F2Lv66Cdw/j l7MTd2K9Rkr+fD8UhQAqfQMAPHkMNIa8Vs0FLaJL1iwI6h9cKnOLa9dwxLmE TVzGlWw9fQ01CM6ygdVPvHwbKGjnntS6Khml93Qy7TuiKIVw6TwXWkMQahBN qV7MJeNSl4B9+gvDZBQ+8ChUbljcaTgmacPaEhQ5SJO/PI7FlV/Mckssukup Oc8NxZqPSVEHLKehG0JqzViPKFKcUQ7svR5Y55gyHPp+OPIzUBki7I21RIHG gFwijxeLdtMDbVXcArP5ibZwIxEMlWdbvd/d32PmoPUDaY30IU4T/oS3aCOf aoe2E8EbHIUG94NSJfETbJ8nZ8kbiIt5tFw3ziwsrkLyWV+1W4mnO8QiBr+k WEThxXmdRV/v+yo/1I3K3QoVstQdfk2bn/O2t2bKCPNx3bRq2uXYL92JrJtW ZkV5LoZdiLvyX/leF4BeebicdGSt2lPedNdf49K6BYJnOtmdVAwe1+DBpuem G+Y3JsaWFf2wtXEXdm7La63+OkJY9UsU75dTc8mMA7GrauWnulzzY6ENQLuq 6JVNUeXX8nR92P3E6tNzf/2Sv03H+7HJ+0e33UXmH6Blfj7k7d6xHBM9d8qz U6w1J3tLymnNo9ftir9OkW7NJK7rI1e75q0r21950ZRGtYF1lOgFAY0t0Mfk R3PQ2vtilWWNhBL8Cm2g/c2XWCuLyd5YgDdN4ne48HEfKCESH14sYobTac1d ZDSdSgdYDn6MYFwS7AQ8JNoRlwh4ecCyT315jE2UKXiiBezkeRUci1lmVwv2 QcUKB+CEvtX29+/noYWybh5JAXt565ago+2w/4Uad/tGUaFH+LbqClFHIzUA uPbERih2fu9WxrwHIgCBo8kjVgC0fiKtyS4FIa3dClMI9q3BIUkZPmKgjd6K B3eJMid1iTQS07VYxptUq5DpuKQGUBWlhiI6tVUZocpS4YRWEtJmW2VXnXLl 7KASTeDNl8Hu3Da/8l/lUY/m450DZqmCWlXn17ts/ZGyu2faPTDtlj36Abvx Ufq1vvQ6+dYLFq/DJ2Pm9++BZl/K9qxS9WZqD0rPYneP2cVHfGwjpruHnWsQ jhnOBRJ/Ce7YlRIyJq839l6AZgGgOdSufq6Iqq5S/+RFt/zo9qNOA5Rs9uM0 vs50VQYM3bwNFU4Xlxozy2t3URLRHpTy9lDV8+MBhbEbvtWjBK1KIte6Zd2W RflWtvnp+lYciNtos9Dw4/Y4skXYgf0Nzf4zJCbfCXA9L1UUJqi5oWnSS674 3vP/KsWVvTUjAG2UYYkUt9P1lb/LttDxULWuU5krZKfT2k5ftK2euJjeCRji prc+3pT90vTE8ZDewNDoJEs0qGZIybB3uzULgI7wfWtvGIUUQk3xVbOjp+N+ lVUXilZUtw2fENMjhLrPyecXIYD6ZLFM3Vo07fUpr5tOh6ghiPFMZyd/n5gX 2C/YVIshX/nOuvN59pbgZgHQE765t8+ipeENkYwboS5drjSuOk6vcyDqGy6c n9W5ORyrojxVWhXXpoXnfbkXxUdJJ7CdudmBhnTiNv3ej18j4i2SGW3tKUDB 14y2rIoZ3FCsTECa+VM+7lSl9UUgi4J5BeB4wyNaCDkW8eddrRZGEsL7DOLg juLFhmqshZwmiPFJY4ukcRAa5oaYarFKrF6Mn9c234QiEwDFkAV0WC6w/m3y Y/wOX0rekzneVeUVo+fYoy8wkizPDXmteZj0Zec/DIh5WBA3o0jPIganBZkU 0mukXDdkDHch6UCeYBKLmktiMUlVwL3dl9JbBF+vIJxRLFMYFeHkjIV8biM/ qrsm9FnGGD2WSvP9Psv+yN5Vl1aHOvt3+Z/sDyPA/LkYwsewsL+sC5VdWOHr zywVGPypgAAbUgMX5tciLZq18YHZJtqmx3YipF+KNjlr0yPnTbTNz+sZUK/r l7VDWIebYwEu+GPeaTF9On/1+sXsEFbg09oClNAXvdPi+3wulfn0Ce2gFu0v bQsQuh/1TovrS3A4fVg7hNX8/LYAnv2J77SQPps+I/I0XyUcSjB9aupiBLgv GQoF+D45BVzC2xcLg2xcn8xfM8e2rxQCmZA+k7ovmAxuygU/9A7kiyeCW/LA D76T+6JJYHwO+OF3wl8vAYzN/25M3aUevzaxX3bsogGeu3cJU917GrfLlkR6 Vm7dvEb/NS77kkTieU8iENn4wGj5kAUNa7SSEDJ+/2K759FY4Hl6TgZ6nj7p g4ybX2zA3gY2aY+dS/Sj9TSKD7/Mo5Em5gu+wZXTdfO74lioqfW1Sn160k+7 N0z1o38xP+PqgkRgbsnFsCyGdm+YRvCgF+gkAnJLHoYlkbR7wzSCB704MxGQ 2/LApyGKhUQobsnBsDabdj+a7tcV4BFcHLD7VjmcW7BhvOMdcD4bSvwvb5mn gXCD9q8b6NG+ZzuB92X7vhT+b9H2wt8AjwbhFRDg8cqmhXYDfoLRYXydXhIT phfw4Zvg+QNBtFdg+yQBAmjXphRo1j1hIsAY+9BsweJt9SOA4u8tlKSPLq1E Hta2UFv8J5p2YHoD9kiT3GkDW7NtQePvgScAA+y7twVLb29sKADilEzSP3pT yoiOGba93MSCsXeohAJzd1I4TOfo15hoRB89BxOL8xY5lzoNzW3IKbv1HEwk 0BtwZny7hvY9fAVAz7JiE7AupCpiQnb4HABMmfX1kakkAnX89ITArfv5ChCB 90ELGsQn88Xp0o+bSl83/KcRbQSx7koPa30+HRSQ1PFYQHSx663baBSfMdcZ i/UGkQmFHswJ3NcMJImB915DWmzD6zURicL47g6BBdsFg4bj2ovu95z3F9KD u+UMlWBqilj6L0BEvYmwIPz+7X9QSwECFAAUAAAACACmrX4p2GJPrCQUAAAe 0wAACQAAAAAAAAABACAAtoEAAAAAVEVTVEUuc3FsUEsFBgAAAAABAAEANwAA AEsUAAAAAA== --_=_=_=IMA.BOUNDARY.G4X0X8138764=_=_=_--