variable question with postgresql

From: "jeff kuo" <jhck81(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: variable question with postgresql
Date: 2001-02-15 04:32:49
Message-ID: F181Eb6MXb0zrAXBirb00001e17@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<html><DIV>
<DIV>
<DIV>hi, all</DIV>
<DIV>I am using phpPgAdmin to create tables and fields, and how do I use SET variables to defind a title, eg. Mr. Miss. Mrs.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Another question, when I use the pg_connect("localhost","","","","dbname"); to connect to a the database, the server returns this message </DIV>
<DIV>&nbsp;</DIV>
<DIV>Unable to connect to PostgreSQL server: connectDB() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'localhost' and accepting connections on TCP/IP port '5432'? </DIV>
<DIV>&nbsp;</DIV>
<DIV>and when I chage to pg_connect("","","","","dbname");</DIV>
<DIV>return this message</DIV>
<DIV>Unable to connect to PostgreSQL server: FATAL 1: SetUserId: user 'www-data' is not in 'pg_shadow' </DIV>
<DIV>&nbsp;</DIV>
<DIV>can&nbsp;anyone please tell me why !? thank you very much</DIV>
<DIV>&nbsp;</DIV>
<DIV>Jeff K.</DIV>
<DIV>&nbsp;</DIV></DIV></DIV><br clear=all><hr>Get Your Private, Free E-mail from MSN Hotmail at <a href="http://www.hotmail.com">http://www.hotmail.com</a>.<br></p></html>

Attachment Content-Type Size
unknown_filename text/html 1.1 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Victor Muntes Mutero 2001-02-15 08:48:17 TPCH questions
Previous Message Schmidt, Peter 2001-02-14 17:37:24 RE: v7.1b4 bad performance