Re: using DROP in a transaction

>     ==in TTY1==
>     --11. expect result at last, value 2  only.  (concurrent transaction
>     2 (in TTY3) completes after this, and will delete values 2 and 4
>     (added after select was issued) upon commit)
>     --11. true result: ERROR: relation <large nr> deleted while still in
>     use

The table 'test' which tty1 was looking at (which was dropped in tty2)
doesn't exist any more.

Postgres doesn't look at the name, it looks at the id that is created
behind the scenes.

So in tty1, the id is 'x'.
Then you recreate the table in tty2 which gives it id 'y'.

So tty1 looking at id 'x' doesn't exist any more.

--
Postgresql & php tutorials
http://www.designmagick.com/