parent table (the one you
##dropped and re-added) for every reference in the child
##table.
##
## Modification History
####
## 2000.08.16 - Genesis
## By John Pagakis, Toolsmythe
only as
fields - no relationship to the other tables).
Basically, you use SELECT * INTO to create a temporary holding place for
data while you do something destructive to the original table.
Hope this helps
_______
John Pagakis
DevelopOnline.com
-Origin
.
By doing it this way, I avoid the problem I was having with the primary key
index mis-named at the end of the process (last paragraph of original
message).
I suppose I really ought to read up on the pg_ tables ...
Thanks again!!!
___
John Pagakis
. This means if I
ever want to do something like this again, the create of company_temp will
fail because company_temp_pkey already exists.
Any help would be much appreciated.
___
John Pagakis
DevelopOnline.com
480.377.6828
<>
John Pagak
ularly efficiently.
Good Luck!!
______
John Pagakis - [EMAIL PROTECTED]
DevelopOnline.com
(480)377-6828
"Not everyone is going to like what I do, and
that's something I can accept; if everyone liked
what I did, I probably wouldn't be playing