had; you guys ROCK and the help is greatly appreciated!
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: Thursday, January 11, 2007 9:28 PM
To: Jeanna Geier
Cc: pgsql-general
Subject: Re: [GENERAL] RESTORE Error
Jeanna Geier [EMAIL
Hi List!
I'm attempting to do a restore of a database and I'm getting the following
error the I'm not familiar with:
COPY workorder (work_order_id, projectname, request_date, requestor,
request_detail, request_completion_date, request_a...
pg_restore: restoring data for table worksite
into the
'workorder.workorder' table.
Hope that helps!
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:10 PM
To: pgsql-general
Subject: [GENERAL] RESTORE Error
Hi List!
I'm attempting to do a restore of a database
:48 ERROR: syntax error at or near 255454 at character 1
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:20 PM
To: pgsql-general
Subject: Re: [GENERAL] RESTORE Error
Just a bit more info: Running Postgres 8.0
35.69
f
f 0
34...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:43 PM
To: pgsql-general
Subject: Re: [GENERAL] RESTORE Error
And log file shows the following (what I posted before was through
Jeanna Geier [EMAIL PROTECTED] writes:
And log file shows the following (what I posted before was through pgAdmin):
2007-01-11 15:38:47 ERROR: relation temp_measurement does not exist
2007-01-11 15:38:47 ERROR: syntax error at or near 7094982 at character 1
2007-01-11 15:38:47 ERROR: syntax
Christopher Murtagh [EMAIL PROTECTED] writes:
[ pg_dump script failed with ]
ERROR: language plperlu is not trusted
and it gave a line number, which contained the following:
GRANT ALL ON LANGUAGE plperlu TO postgres WITH GRANT OPTION;
Hm. The backend flat-out rejects all attempts at GRANT
Tom Lane wrote:
Hm. The backend flat-out rejects all attempts at GRANT on untrusted
languages, even if you are superuser and the grantee is too. I'm not
totally sure about the rationale for that (Peter?)
Why would you need it? It's only going to create fuss about useless
functionality.
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane wrote:
pg_dump has evidently not gotten the word. If we think the backend's
behavior is right then we'd better change pg_dump to suppress trying
to GRANT permissions on untrusted languages.
There should not be any permissions, so there
Greetings,
I just had to dump and restore one of my DBs (7.4RC2), and I got an
interesting message.
I first did:
pg_dump dbname db_restore.sql
Then at console did the following:
\i db_restpre.sql
which performed everything as expected with the following ERROR
message:
ERROR:
10 matches
Mail list logo