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
Just a bit more info: Running Postgres 8.0
and the: 255454 3 WestSalem 2006-05-12 14:10:18.578-05 greg
clean it
2006-05-12 17:00:00-05 W6037 Ruth Lane OnalaskaWisconsin 54650
...
is a row (the first row) that should be inserted/restored into the
'workorder.w
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
