Are there the following SQL commands in psotgreSQL?
ALTER TABLE CATALOGITEM_LNK ADD
CONSTRAINT PK_CATALOGITEM_LNK PRIMARY KEY(catalogid,
itemid);
ALTER TABLE CATALOGITEM_LNK ADD
CONSTRAINT FK_CATALOGITEM_LNK_CATALOG FOREIGN KEY
(catalogid) REFERENCES CATALOG(id);
Thanks all.
The problem is changed to
[xyang@d141-67-217 xyang]$ psql -h localhost
psql: Missing or erroneous pg_hba.conf file, see
postmaster log for details
Where are thses files?
--- Henry House <[EMAIL PROTECTED]> wrote:
> On Tue, Jul 10, 2001 at 11:24:26PM -0400, Xue-Feng
>
Thanks all.
The problem is changed to
[xyang@d141-67-217 xyang]$ psql -h localhost
psql: Missing or erroneous pg_hba.conf file, see
postmaster log for details
Where are thses files?
--- Henry House <[EMAIL PROTECTED]> wrote:
> On Tue, Jul 10, 2001 at 11:24:26PM -0400, Xue-Feng
>
--- Henry House <[EMAIL PROTECTED]> wrote:
> On Tue, Jul 10, 2001 at 10:02:03PM -0400, Xue-Feng
> Yang wrote:
> > Sounds that the postmaster does not listen on TCP.
> > How can I add it to TCP?
>
> You need to pass the -i switch to the postmaster
> whe
Can anyone help me on the following problem?
$psql -h localhost
psql: PQconnectPoll() -- connect() failed: Connection
refused
Is the postmaster running (with -i) at
'localhost'
and accepting connections on TCP/IP port '5432'?
_
