Dear all,
When I try to use the command line tool shp2pgsql in the shell I have this
error:
Error: pg_wrapper: invalid command name
I already read some information in the Debian lists but I don't understand the
problem/relation with PostgreSQL.
If anyone can help me with this problem plea
On 10/26/2012 06:16 AM, José Pedro Santos wrote:
Dear all,
When I try to use the command line tool shp2pgsql in the shell I have
this error:
*Error: pg_wrapper: invalid command name*
I already read some information in the Debian lists but I don't
understand the problem/relation with PostgreSQL
Postgres 9.1 in Ubuntu Distribution (12.04 LTS).
When I try to use the shp2pgsql after the pg_wrapper error said that I don't
have that function, so I enable that function with this command:
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /usr/local/bin/shp2pgsql
then I try to import agai
Postgres 9.1 in Ubuntu Distribution (12.04 LTS).
When I try to use the shp2pgsql, BEFORE the pg_wrapper error, said that I don't
have that function, so I enable that function with this command:
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /usr/local/bin/shp2pgsql
then I try to impor
On 10/26/2012 06:33 AM, José Pedro Santos wrote:
Postgres 9.1 in Ubuntu Distribution (12.04 LTS).
When I try to use the shp2pgsql after the pg_wrapper error said that I
don't have that function, so I enable that function with this command:
sudo ln -sf /usr/share/postgresql-common/pg_wrapper /us
José Pedro Santos wrote:
> When I try to use the command line tool shp2pgsql in the shell I
> have this error:
>
> Error: pg_wrapper: invalid command name
>
> I already read some information in the Debian lists but I don't
> understand the problem/relation with PostgreSQL.
shp2pgsql converts
HI,
I only made that to enable the shp2pqsql but don't work well... (I read in one
website). The problem if I don't had made that I have one error saying that I
don't have that package (I' m using Postgis 2.0)...
how can undo the operation?
Thanks!
JSantos
> Date: Fri, 26 Oct 2012 06:56:4
On Fri, Oct 26, 2012 at 9:37 AM, Kevin Grittner wrote:
> José Pedro Santos wrote:
>
>> When I try to use the command line tool shp2pgsql in the shell I
>> have this error:
>>
>> Error: pg_wrapper: invalid command name
>>
>> I already read some information in the Debian lists but I don't
>> underst
the cyclic change idea is really marvellous , thank you
but we store each round, because we need player actions for further analysis
about game trends
returnstrikeHP is a random number in range, that is calculated when a player
strikes back. although as you write,
we can calculate the diffe
Hello listmates,
When I run the following:
postgres@zeus:~$ export PGDATA=/var/postgres/8.4/data_64/
postgres@zeus:~$ /usr/postgres/8.4/bin/amd64/pg_ctl stop
waiting for server to shut
down... failed
pg_ctl: server does not shut down
p
Boris Epstein writes:
> The Postgres 8.4 would simply not shutdown for me. Don't know why:
> Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly
> corresponding to these shutdown attempts:
> LOG: database system was shut down at 2012-10-25 13:49:14 EDT
> LOG: database system is
On Fri, Oct 26, 2012 at 12:46 PM, Tom Lane wrote:
> Boris Epstein writes:
> > The Postgres 8.4 would simply not shutdown for me. Don't know why:
>
> > Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly
> > corresponding to these shutdown attempts:
>
> > LOG: database system was
Hi,
I have many functions which i want to finetune. Is there any profiler
available which i can use to check performance of function and finetune it.
Regards
Ds
Hello,
I've encountered an unexpected behavior when converting a number to char. I
need to match an INTEGER with a VARCHAR(9) that has leading zeros. When I
tried to match them using to_char(num, '0') I didn't get anything. I
later found out that to_char adds a leading space. This
Placeholder for a +/- sign so that both positive and negative values have equal
lengths.
David J.
On Oct 26, 2012, at 14:50, Samuel Gilbert wrote:
> Hello,
>
> I've encountered an unexpected behavior when converting a number to char. I
> need to match an INTEGER with a VARCHAR(9) that has
On 10/26/12 11:50, Samuel Gilbert wrote:
>
>(SELECT to_char(42, '0') AS string) AS example;
>
>string | length | showthemtome
> ++--
> 00042 | 10 | " 00042"
Sign padding. Try using:
select to_char(42, 'FM0') ...
To see
You want to use a format of 'FM0' (fill mode, doesn't leave an
extra space for sign)
On Fri, Oct 26, 2012 at 2:50 PM, Samuel Gilbert wrote:
> Hello,
>
> I've encountered an unexpected behavior when converting a number to
> char. I
> need to match an INTEGER with a VARCHAR(9) that has l
Hi,
I am facing a problem when I try to install PostgresQL (version 9.2.1.). I get
the following message:
"Unable to write inside TEMP environment variable path"
I need some help with this as I've read lots of posts about how to solve the
problem and I have not succeed.
Here I forward to yo
Thank you, it works. The documentation gave me the impression that the FM
modifier only applied to date/time since it was under "Usage notes for
date/time formatting:"
Samuel
On Friday, October 26, 2012 16:01:08 Moshe Jacobson wrote:
> You want to use a format of 'FM0' (fill mode, does
Seems you are using Win7 or above environment.
You perhaps need to run the installer in administrator mode. An alternative way
is to disable UAC.
--
Thanks&Regards,
Xiong He
-- Original --
From: "Raul Feliu";
Date: Sat, Oct 27, 2012 04:04 AM
On 10/24/12 4:04 PM, Chris Angelico wrote:
Is this a useful and plausible testing methodology? It's definitely
showed up some failures. On a hard-disk, all is well as long as the
write-back cache is disabled; on the SSDs, I can't make them reliable.
On Linux systems, you can tell when Postgres
On Sat, Oct 27, 2012 at 4:26 PM, Greg Smith wrote:
> In general, through, diskchecker.pl is the more sensitive test. If it
> fails, storage is unreliable for PostgreSQL, period. It's good that you've
> followed up by confirming the real database corruption implied by that is
> also visible. In
22 matches
Mail list logo
