Re: [GENERAL] Postgres locks table schema?

2005-09-22 Thread Stas Oskin
Hi. I will give it a try. Although, I do remember that the lock occurs on the first transaction - so basically there should be nothing to commit yet? Thanks, Stas. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 9:35 PM To: Stas Oskin Cc

[GENERAL] Postgres locks table schema?

2005-09-21 Thread Stas Oskin
the server is restarted, which is very problematic for a production environment. Perhaps someone is familiar with this behavior, and how it can be resolved, without the restart of the server? The server used is PostgreSQL 8.0.3, and the OS is Fedora Core 3. Thanks. Stas Oskin.

[GENERAL] Blob data type and it's efficiency on PostgreSQL

2005-09-19 Thread Stas Oskin
with the blob data type, and is it practical to store these files as blobs? Thanks in advance, Stas Oskin.

[GENERAL] Using pgcrypto with AES-256 bits?

2005-04-30 Thread Stas Oskin
Hello. I tried the pgcrypto contrib module with the AES default encryption. It works pretty nice, but I understand that it's using 128 bit key strength. Is there any built-in support for the 256 bit key strength? Or it should be used via external libraries? AFAIK, the support of