George Nychis wrote:
> I tend to forget the important details ;)
>
> gnychis@sn001:~$ psql --version
> psql (PostgreSQL) 8.1.8
> contains support for command-line editing
> gnychis@sn001:~$ 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.