George Nychis wrote: > I tend to forget the important details ;) > > [EMAIL PROTECTED]:~$ psql --version > psql (PostgreSQL) 8.1.8 > contains support for command-line editing > [EMAIL PROTECTED]:~$ uname -a > Linux sn001 2.6.17-10-server #2 SMP Tue Dec 5 21:17:26 UTC 2006 x86_64 > GNU/Linux
Just tried it here, worked without a hitch. create a table "parent", then 2000 children for i in `seq 1 2000`; do psql -c "create table child_$i (b int) inherits (parent)"; done then DROP TABLE parent CASCADE and it took some seconds. I have 1 GB of physical RAM here. You're going to give us a lot more details ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
