[GENERAL] Partition check constraint is ignored if parameter is passed from SQL function

2017-09-26 Thread Lukasz Kaminski
Hello, When query is executed in function that has language set to "sql" then parameters passed to it are not considered as either externally supplied parameters or constants as far as partitioning goes. It will scan all partitions, despite parameters clearly limiting it to just one. Changing

[GENERAL] very slow queries and ineffective vacuum

2015-06-30 Thread Lukasz Wrobel
regards. Lukasz

[GENERAL] Connecting to PostgreSQL Server

2006-09-24 Thread Lukasz
Hello, I installed a postgresql server on one of the machine in my network with an example IP 192.168.254.102. I have no problem to connect to the server from this machine, but when I want to have access to pgsql server from other pc with an example IP 192.168.254.105 it says that I have no

Re: [GENERAL] Access to databas from the Internet

2006-09-24 Thread Lukasz
Shane Ambler napisal(a): On 20/9/2006 16:55, Lukasz [EMAIL PROTECTED] wrote: Shane Ambler napisal(a): On 19/9/2006 22:41, Lukasz [EMAIL PROTECTED] wrote: Hello, I would like to install a PostgreSQL. I know how to manage the database itself, creae databases, user, groups and so

Re: [GENERAL] Access to databas from the Internet

2006-09-20 Thread Lukasz
Shane Ambler napisal(a): On 19/9/2006 22:41, Lukasz [EMAIL PROTECTED] wrote: Hello, I would like to install a PostgreSQL. I know how to manage the database itself, creae databases, user, groups and so on. But I don't know how to allow other users, who are outside LAN to connect

[GENERAL] Access to databas from the Internet

2006-09-19 Thread Lukasz
in the local network is yyy.yyy.yyy.yyy. I want to install PostgreSQL on the computer with yyy.yyy... What and where I need to configure to have access to my database from Internet? Regards, Lukasz ---(end of broadcast)--- TIP 6: explain analyze is your