[pgadmin-support] Hi I have a problem in PGAdmin 8.0

2005-08-18 Thread Sriram Aravamuthan
Hi 
   I am doing a research about rule engine and saw your RuleCore and postgreSQL and thought i can get some knowledge and if this fulfill my requirement i thought of buying it also..
   I have installed the Rulecore and the postgreSQL.I have created a simple rule,event,situation and events in the rule designer.When I tried to use the generator iam getting "Error connecting to server :Connection refused".I tried changing the local_addresses='*' in the conf file but still not 
working.Can u tell me the password field to connect to the postgreSQL. by default.
 
Thanks
Sriram


[pgadmin-support] Connecting to a remote database

2005-08-18 Thread Nigel Horne
When I connect to a remote database I get this message:

"An error has occured:

Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf
file, see postmaster log for details."

Naturally I have something wrong, this is NOT a bug report for
that, rather it is a plea (RFE) for a more informative message.

This message falls down in a number of ways:

1) Is it missing or is it erroneous? Why doesn't pgadmin know the
difference?
2) Is the file on the local system or remote system?
3) Where is the ph_hba.conf file?
4) What is erroneous about it?
5) Where is the postmaster log file, on which machine, and what details
am I looking for?
6) Why doesn't this box allow me to view the log file?
7) Last and least: occurred has two 'r's ;-)

-Nigel Horne


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [pgadmin-support] Connecting to a remote database

2005-08-18 Thread Tino Wildenhain

Nigel Horne schrieb:

When I connect to a remote database I get this message:

"An error has occured:

Error connecting to the server: FATAL: Missing or erroneous ph_hba.conf
file, see postmaster log for details."

Naturally I have something wrong, this is NOT a bug report for
that, rather it is a plea (RFE) for a more informative message.

This message falls down in a number of ways:

1) Is it missing or is it erroneous? Why doesn't pgadmin know the
difference?


Ah well, the message comes from the server, so guess what
pgadmin can really know about it :-)


2) Is the file on the local system or remote system?


postmaster is the server. So look there (or ask your DBA)


3) Where is the ph_hba.conf file?


Again, ask your sysadmin of the server. If you set up yourself,
you would have read the documenation, right?  ;)) *hint*


4) What is erroneous about it?


It told you to read the logfile on the server to find out :)


5) Where is the postmaster log file, on which machine, and what details
am I looking for?


See above :-)


6) Why doesn't this box allow me to view the log file?


Because you cant connect? And there is no fileaccess to joe
average anyway ;)


7) Last and least: occurred has two 'r's ;-)


Try to mess up your /etc/passwd on a unix box
and then connect via ssh. Compare the messages
you get and what to do :-)


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[pgadmin-support] Mac OSX 10.4.2 problem...

2005-08-18 Thread Jerry LeVan

I am running Mac OSX 10.4.2 and PgAdmin 1.2.2

Attempts to add a record to a simple database result
in crashing the application.

Frequently the crash occurs while trying to enter data
in the "bottom" row of the grid.

I don't have this problem on my windows box.

Is this a well known problem? Do you need more info?

Jerry


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


[pgadmin-support] some way to continue forward even when an error occurs

2005-08-18 Thread Brad Langhorst
eg.
set continue_on_error = true

or maybe an option in the gui to continue execution.

This is a problem when you run ddl that attempts to drop some
non-existant items.  I think it should report that the item being
deleted does not exist but then should continue on to the next statement
instead of aborting the run.

Oracle, Sybase, and MSSQL do this by default.

thanks!

brad


---(end of broadcast)---
TIP 6: explain analyze is your friend


[pgadmin-support]

2005-08-18 Thread kate evans


Request for support for pgAdmin

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[pgadmin-support] Error Message: ERROR: catalog is missing 4 attribute(s) for relid 649444

2005-08-18 Thread hjwang
-- System Information --

Platform: Windows 2000
Version: 5.0
Build: 2195 Service Pack 4

-- Application Information --

Name: pgAdmin II
Version: 1.6.0
Descripton:

Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0

-- Database Information --

Version: 7.4.0
Descripton: PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC)
3.3.1 (cygming special)

-- Driver Information --

Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC)
3.3.1 (cygming special)

-- Error Information --

Description: ERROR: catalog is missing 4 attribute(s) for relid 649444
Number: -2147467259
Routine: pgAdmin II:frmMain.tvTable



Insert your comment:


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match