gh the issues
that I've 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 Er
"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 ERR
was: 34101631810987
(2491.8225222024057,8759.2336777975943)
(2440.9108777975944,8759.2336777975943) 35.69 35.69
f
f 0
34...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:
-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near
'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
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"
pg_resto
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
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.
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
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: langua
10 matches
Mail list logo
