* Hagen Finley:
Yes but I couldn't input your second line - the ('ä,ß,ö') was not
possible via the psql client - just got beeped when I tried to type or
paste those characters.
If you start cat instead of psql, can you enter those characters?
What about python or the shell itself? What
2012/1/3 roberto sanchez muñoz trev2...@gmail.com
i tried but still had the same error and i dont know how to see the logs
$ cd /usr/local/Cellar/postgresql/9.1.2/bin/
$ ./pg_ctl -D /usr/local/var/postgres stop -mi
waiting for server to shut
i tried but still had the same error and i dont know how to see the logs
$ cd /usr/local/Cellar/postgresql/9.1.2/bin/
$ ./pg_ctl -D /usr/local/var/postgres stop -mi
waiting for server to shut
down... failed
pg_ctl: server does not shut
On 01/02/12 10:10 PM, roberto sanchez muñoz wrote:
i tried but still had the same error and i dont know how to see the logs
/usr/local/var/postgres/server.log is probably your log, as thats what
your PS output shows was the -r argument...its that or its in
Am 02.01.2012 20:13, schrieb Hagen Finley:
I am using psql (8.2.15) and I would like to input German characters
(e.g. ä,ß,ö) into char fields I have in a database
I see that you are using Outlook which leads me to assume you are
running Windows as host for your transaction. Therefor you might
On 01/02/12 6:21 PM, Hagen Finley wrote:
Yes but I couldn't input your second line - the ('ä,ß,ö') was not possible via
the psql client - just got beeped when I tried to type or paste those
characters.
the problem is, MS Windows and only MS Windows uses UTF16 instead of the
UTF8 that the
Simon Windsor wrote:
[pg_largeobject keeps growing]
The data only has to be kept for a few days, and generally the system
is
performing well, but as stated in the email, regular use of vacuumlo,
vacuum
and autovacuum leaves the OS disc space slowly shrinking.
As a last resort this week, I'm
Nulik Nol wrote:
I have 2 questions regarding the asynchronous C api (I am using vers.
8.4):
1) To make a connection in non-blocking manner the api provides PGconn
*PQconnectStart(const char *conninfo) function. The parameters are
passed in 'conninfo' variable which is a string so I have to
On Dec 21, 2011, at 8:26 AM, Jacques Lamothe wrote:
Hi, I have 2 cluster databases, running on the same host, Linux with redHat.
My fist database port is set to default, 5432, but my second database port is
set to 5436 in the postgresql.conf file. While everything is ok with local
On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez trev2...@gmail.com wrote:
no when i use /usr/local/var/postgres/pg_log directory show me
this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_log/:
No such file or directory and i use the homebrew installation
Sorry friend,, am
no when i use /usr/local/var/postgres/pg_log directory show me
this /usr/local/var/postgres/pg_log/-bash: /usr/local/var/postgres/pg_log/:
No such file or directory and i use the homebrew installation
El 3 de enero de 2012 02:18, Raghavendra
raghavendra@enterprisedb.comescribió:
2012/1/3
On Tue, Jan 3, 2012 at 1:42 AM, Alban Hertroys haram...@gmail.com wrote:
On 3 Jan 2012, at 5:20, 邓尧 wrote:
Hi,
I'm new to pgsql, I need the do something like the INSERT IGNORE in mysql.
After some searching I got a solution, which is adding a do instead
nothing rule to the corresponding
Thank you all for your thoughtful suggestions. I just left for a 5 day East
Coast business trip so I won't have a chance to tackle this gain until the
weekend. For the record, I am running Centos as a VM on both a MAC OS 10.7
laptop and a Windows 7 Workstation. In theory, I ought to be able use
thanks, doesn't stop the server i think i have to reinstall postgresql
2012/1/3 Raghavendra raghavendra@enterprisedb.com
On Tue, Jan 3, 2012 at 8:21 PM, Roberto Sanchez trev2...@gmail.comwrote:
no when i use /usr/local/var/postgres/pg_log directory show me
this
I'm probably not seeing the obvious so I keep making the same mistake. The
table holds water chemistry data from multiple streams, sites within each
stream, sampling dates, and many chemical constituents.
What I need to do are three things:
1.) Find the date and site for the maximum value
Rich Shepard rshep...@appl-ecosys.com writes:
What I need to do are three things:
1.) Find the date and site for the maximum value of a specified constituent
on a named stream.
2.) Find the values of that same constituent at other sites on the named
stream on that same date.
Hi,
On 4 January 2012 10:26, Rich Shepard rshep...@appl-ecosys.com wrote:
select max(quant), site, sampdate from chemistry where stream = 'SheepCrk'
and param = 'TDS' group by site, sampdate;
but this gives me the value of each site and date, not the maximum for all
dates at a specific site.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rich Shepard
Sent: Tuesday, January 03, 2012 6:27 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Single Table Select With Aggregate Function
I'm probably not
On Tue, 3 Jan 2012, Tom Lane wrote:
You can do that type of thing using subqueries, eg
select ... from mytab
where col = (select max(col) from mytab where ...)
Thanks, Tom. That's what I thought I needed.
or if you don't mind a nonstandard construct, consider SELECT
On Wed, 4 Jan 2012, Ondrej Ivanič wrote:
window functions might be helpful:
http://www.postgresql.org/docs/9.1/static/tutorial-window.html
Thanks. I'll carefully read this.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
20 matches
Mail list logo