On Sat, Dec 28, 2002 at 16:13:17 +0100,
pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> wrote:
>
> Actualy I use the table as a simple counter for unique values and I
> expect that Connection2 will wait until Connection1 finish the task.
> Is it normal for pg to work so with transactions?
> If yes how can I lock all the tables after beginning the transaction?
> If no where can I make mistake?
If you just want a unique value use sequences. They will be faster.
You didn't provide the exact commands you used in your test. Without
seeing them it is hard to tell what you might have done wrong.