Hello

I'm trying to create a simple database with PgAdmin3 but I got an error
message: ERROR: column "datpath" does not exist

I had never get this kind type of error message.

I've used PostgreSQL and PgAdmin3 casually some about a year now. Can
anyone help me to figure out this problem?

OS: Fedora Core 4
PostgreSQL 8.0.4
PgAdmin3

I do not think so that how I'd created the datatabe could be the cause
to this problem. I did not used any additional parameters in a
commandline when I created this database.

This is a part of my studywork and I'm now on a dead-end in here. I did
not found any helpful answers from this and other Postgres mailing list
or from the Google.

Regards,
Jarkko Elfving


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

http://archives.postgresql.org

Jarkko Elfving <jarelf (AT) kotiportti (DOT) fi> schrieb:

What do you do before, can you tell us your SQL?


It is better to use the native psql - tool.



Regards, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

---------------------------(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

On Sun, 2005-11-06 at 11:26 +0100, Andreas Kretschmer wrote:
That't the point. I'm not able to create any tables or any other jobs
either. I open the connection to "server" via pgAdmin3 and move to
Database "column". Then I got the error message. When I try to create
another database within pgAdmin3, I got the error message.

Are there any other graphical environments to work in PostgreSQL or do I
have to do it by hand (=text based in pgsql prompt)

---------------------------(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

On Sun, Nov 06, 2005 at 12:35:39PM +0200, Jarkko Elfving wrote:
What version of pgAdmin3 are you running? According to www.pgadmin.org
the latest versions are 1.2.2 and 1.4Beta-3. datpath was one of the
columns in pg_database in pre-8.0 versions of PostgreSQL; your version
of pgAdmin3 appears to be assuming datpath's presence.

--
Michael Fuhr

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

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

Jarkko Elfving <jarelf (AT) kotiportti (DOT) fi> writes:
Better get a newer version of PgAdmin --- it appears to be too old for
PG 8.0.

regards, tom lane

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

http://archives.postgresql.org