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 fun
l for any help and if you need more details I can provide
them if possible.
Best regards.
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,
> >>>
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
a
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 kno
n 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
Hi,
I've got PostgreSQL 6.5.2 installed and strange things happens when I
try to create temp table in transaction block.
Here's SQL commands send to backend:
SELECT data FROM aukcje WHERE aukcja_id = '1'
SELECT reklama,logo_loid,logo_content,www,nazwa FROM domy WHERE dom_id =
'0'
BEGIN
SELECT *
