On Thu, Dec 2, 2010 at 08:44, Craig Ringer cr...@postnewspapers.com.au wrote:
On 02/12/10 01:11, Anibal David Acosta wrote:
So, I don't know how to recover the database from the data directory of a
windows postgres 8.1 installation.
You'll need PostgreSQL 8.1 for Windows. This appears to
On 02/12/10 01:11, Anibal David Acosta wrote:
So, I only have the postgres directory on my hands. I decide to install the
same database version in another computer and replace DATA directory, but I
notice that 8.1 (windows binary) is not available for download.
So, I don't know how to
Hello
I have the next query in mysql to get the time difference from two rows, but
I would like to implement it in postgres, but I'm getting some errors when I
try to query it.
select speed,mobile,date,
timediff(@nexttime,date) as tdiff2, (@nexttime:=date) as Next
from positions
where speed=0
Hey Konstantin,
Use MOVE ALL, then PQcmdTuples to get number of rows,
then MOVE BACKWARD ALL to point cursor at initial position.
2010/12/2 Konstantin Izmailov pgf...@gmail.com
Maybe this question was discussed previously, but I could not find an
answer:
An application used PQntuples
ftp://svimik.servehttp.com/soft/postgresql-8.1.4-1-binaries-no-installer.zip
ftp://po.istu.ru/public/distrib/Windows/Devel/db/postgresql/postgresql-8.1.5-1.zip
ftp://ftp.lviv.farlep.net/opensource/DataBases/postgresql-8.1.2-1.zip
ftp://svimik.servehttp.com/soft/postgresql-8.1.4-1.zip
On 2010-12-01 09.26, Andrus wrote:
Thom,
You can list available locales on your system with: locale -a
Thank you.
How to resolve this issue if only 5432 port is open in server ?
Maybe asking the sysadmin of that host to return the result of locale -a?
Btw, are you sure et_EE.UTF-8 is
On 2010-12-01 16.16, ma...@manfbraun.de wrote:
Hello !
I am coming from Sql Server right now and have to learn about the
infrastructure.
What I missed first, is, to execute procedures regularly/repeatedly
on a given time. I want to prevent my to write a lot external
programs und use cron :-(
Because, as opposed to the developers of the projects that you're
apparently familiar with, the Postgres developers have common sense ;)
intidb fallbacks to en_US locale if locale specified in command line is not
found.
This causes invalid cluster to be created.
How to fix this ?
Is this really
Hello
PostgreSQL hasn't a timediff function and hasn't a session variables.
You can see how can be implemented this function in pg
http://okbob.blogspot.com/2009/08/mysql-functions-for-postgresql.html.
If you can compare values from different rows, you have to have a pg
= 8.4 with window
Thank you Merlin for your answer,
I tried that and is working as you said.
But when I do
other_array=some_array[1:2];
I'm getting the entire
'{{samba,sarath,sreenivas},{samba,mukhesh,pavan}}';
not just the second subarray, i.e.
On 2 Dec 2010, at 13:34, Andrus wrote:
Because, as opposed to the developers of the projects that you're
apparently familiar with, the Postgres developers have common sense ;)
intidb fallbacks to en_US locale if locale specified in command line is not
found.
Aren't you confusing different
Thanks!!!
I'll download right now :)
-Mensaje original-
De: Radosław Smogura [mailto:rsmog...@softperience.eu]
Enviado el: jueves, 02 de diciembre de 2010 08:22 a.m.
Para: Craig Ringer
CC: Anibal David Acosta; pgsql-ad...@postgresql.org;
pgsql-general@postgresql.org
Asunto: Re:
AI Rumman rumman...@gmail.com writes:
Is it possible to match %text' in Postgresql 9 Full Text.
See http://www.sai.msu.su/~megera/wiki/wildspeed
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-general mailing list
On Thu, Dec 2, 2010 at 9:03 AM, Samba saas...@gmail.com wrote:
Thank you Merlin for your answer,
I tried that and is working as you said.
But when I do
other_array=some_array[1:2];
I'm getting the entire
On Thu, Dec 2, 2010 at 12:20 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Thu, Dec 2, 2010 at 9:03 AM, Samba saas...@gmail.com wrote:
Thank you Merlin for your answer,
I tried that and is working as you said.
But when I do
other_array=some_array[1:2];
However, if the locale that your database needs isn't available, what did
you intend to do about that? You can't just pick a different one, it
probably wouldn't behave the same. Apparently you can't just use the
default locales either, or you wouldn't be asking about this.
I'm trying to
On 2 Dec 2010, at 18:53, Andrus wrote:
However, if the locale that your database needs isn't available, what did
you intend to do about that? You can't just pick a different one, it
probably wouldn't behave the same. Apparently you can't just use the default
locales either, or you wouldn't
Hello !
And thanks to all, for answers.
Naturally, cron does not operate on DB tables and if I add/remove/change
a line in a control table dynamically, cron would not notice that ;-)
So I had to write a daemon, which acts on that table. This might happen
about ~5 - 20 seconds and cron is
In Fedoraet_EE.UTF8
Other linuxeset_EE.UTF-8
These are the same locales, just a differently named encoding.
Postgres requires those suffixes in locale names.
They must me exactly UTF8 or UTF-8 or 1257 .
If those are missing, or even if - sign is missed in UTF-8, error occurs on
create
On Dec 2, 2010, at 11:32 AM, ma...@manfbraun.de ma...@manfbraun.de wrote:
The usual notification from postgreSQL does not allow to write
an [own, better to evaluate] identifier in the syslog. This is
not a matter of the syslog daemon, its on the program which logs.
May be, I have just not
On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
AI Rumman rumman...@gmail.com writes:
Is it possible to match %text' in Postgresql 9 Full Text.
See http://www.sai.msu.su/~megera/wiki/wildspeed
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL :
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: canceling statement due to
conflict with recovery
DETAIL: User query might have needed to see row versions that must be
removed.
pg_dump: The command was: COPY public.i.. TO stdout;
pg_dumpall: pg_dump failed on database
On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote:
AFAIK, the Red Hat RPMs work out-of-the-box with SELinux; I'm a bit
surprised to hear that the PGDG ones don't, because last I heard
they use the same file layout.
They should -- we are using the same routines for initdb'ing.
--
Devrim
Hello !
a)
The idea with to test a RAISE statement with an prefix, could
be good. But I am just that new, I could not make it working.
I have not understand, where I can issue direct sql statements
and it looks like, the RAISE is not possible with plSql:
mbtest=# RAISE NOTICE 'mynotice: %',
On Thu, December 2, 2010 15:23, Devrim GÜNDÜZ wrote:
On Wed, 2010-12-01 at 16:54 -0500, Tom Lane wrote:
AFAIK, the Red Hat RPMs work out-of-the-box with SELinux;
They should -- we are using the same routines for initdb'ing.
I will do a touch /.autorelabel and restart the server before I try
On 12/02/2010 12:27 PM, ma...@manfbraun.de wrote:
Hello !
a)
The idea with to test a RAISE statement with an prefix, could
be good. But I am just that new, I could not make it working.
I have not understand, where I can issue direct sql statements
and it looks like, the RAISE is not possible
I have read the documentation respecting backups but I cannot seem
to find any mention of the specific case that I wish performed.
I have a pair of tables in a production database that I wish to dump
and then restore to a new, different database. I can, and probably
will, recreate the tables and
On 12/02/2010 12:49 PM, James B. Byrne wrote:
I have read the documentation respecting backups but I cannot seem
to find any mention of the specific case that I wish performed.
I have a pair of tables in a production database that I wish to dump
and then restore to a new, different database. I
On 12/02/2010 12:49 PM, James B. Byrne wrote:
I have read the documentation respecting backups but I cannot seem
to find any mention of the specific case that I wish performed.
I have a pair of tables in a production database that I wish to dump
and then restore to a new, different database. I
On Thu, December 2, 2010 15:57, Adrian Klaver wrote:
a
different database, using PG utilities?
pg_dump -U postgres -a -t cell_per -f cell_per.sql production
followed by:
/usr/bin/psql -f cell_per.sql production
works wonderfully. Thank you.
--
*** E-Mail is NOT a SECURE
Hello !
Rellay good;I see, the track is not wong ;-)
But currently, I stuck in 8.4 [debian/squeeze].
I'll try to write a function and leran if and how
I can call it.
Thanks a lot!
br++mabra
-Original Message-
From: pgsql-general-ow...@postgresql.org
On Dec 2, 2010, at 1:27 PM, ma...@manfbraun.de ma...@manfbraun.de wrote:
I have not understand, where I can issue direct sql statements
and it looks like, the RAISE is not possible with plSql:
Right, it's not actually SQL, so you can't use it in plain SQL. It is part of
the plpgsql
On tor, 2010-12-02 at 19:53 +0200, Andrus wrote:
I'm trying to create portable application which can automatically
create
database using estonian locale in any server.
Postgres returns different values for same locale:
In Fedoraet_EE.UTF8
Other linuxeset_EE.UTF-8
In Windows
Hello !
Very good, thanks !
I've just not understood, when I have to write a function to test sql code
and when I can do it interactively.
Your shown function compiles and works, but I do not have the
result in the logs [altough I see th executing function with
my settings to 'debug' ;-) ].
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
James B. Byrne 12/03/10 12:56 PM
I have read the documentation respecting backups but I cannot seem
to find any mention of the specific case that I wish performed.
Hi James,
pg_dump can take arguments to dump a specified table, the
Excerpts from mabra's message of jue dic 02 20:04:36 -0300 2010:
I've just not understood, when I have to write a function to test sql code
and when I can do it interactively.
In Postgres, PL/pgSQL and SQL are two different languages. There are
things in PL/pgSQL that you cannot do in pure
begin w/o commit or rollback?
and thanks. you've been very helpful!
On Nov 30, 2010, at 2:21 PM, Merlin Moncure wrote:
Begin w/o commit is a grave application error and you should
consider reworking your code base so that it doesn't happen (ever).
--
Sent via pgsql-general mailing list
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:
i couldn't find anything in the docs, and the project has decent traffic, so
its going to be an issue to log all statements so I can sift through the data
by PID
With machine-readable logs, it shouldn't be *that* serious an issue.
1.
Dmitriy,
It worked like a charm! Bol'shoe spasibo!
I'm curious what are the Postgres versions that support MOVE ALL. The
documentation does not even mention ALL option.
Konstantin
On Thu, Dec 2, 2010 at 3:49 AM, Dmitriy Igrishin dmit...@gmail.com wrote:
Hey Konstantin,
Use MOVE ALL, then
Le 03/12/2010 07:34, Konstantin Izmailov a écrit :
Dmitriy,
It worked like a charm! Bol'shoe spasibo!
I'm curious what are the Postgres versions that support MOVE ALL. The
documentation does not even mention ALL option.
Actually, it does:
40 matches
Mail list logo