Re: [SQL] Connecting to Postgres from other machines (outside localhost)

Ok, I found it, it was my mistake.   An IP entry should be have /32 or /128. I used different values. Now I got it (RTFM).   Regards, Catalin  On 5/4/06, Oisin Glynn <[EMAIL PROTECTED]> wrote: Catalin Pitis wrote:> I did all you said:>> I set pg_hba.conf:>> # IPv4 local conne

Re: [SQL] Connecting to Postgres from other machines (outside localhost)

rroneous pg_hba.conf file 2006-05-04 21:57:26 HINT:  See server log for details.  The pg_hba.conf file is attached...   Catalin  On 5/4/06, Catalin Pitis <[EMAIL PROTECTED]> wrote: I did all you said:   I set pg_hba.conf:   # IPv4 local connections:host    all all 127.0.0

[SQL] Connecting to Postgres from other machines (outside localhost)

Hello   I installed PostgreSQL 8.0 on Windows and I can connect from localhost only. How can I configure the server to allow connection from other machines?   Thank you Catalin

Re: [SQL] ERROR: plan should not reference subplan's variable

Hi Tom   Could you tell me when will 8.1.4 be released with the problem solved?   Thanks, Catalin  On 5/3/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Catalin Pitis" <[EMAIL PROTECTED]> writes: > ERROR:  plan should not reference subplan's variableI've applied a pa

[SQL] ERROR: plan should not reference subplan's variable

Hi *   I'm trying to run the following SQL statement on a PostgreSQL 8.1, installed on a Windows machine:   INSERT INTO PROJECT(PROJECT_ID,PROJECT_DESC) (SELECT MAX(PROJECT_ID),'MYPROJECT'FROM PROJECT WHERE NOT EXISTS  (  SELECT PROJECT_DESC FROM PROJECT WHERE PROJECT_DESC = 'MYPROJECT' ))   and I