John Gage wrote:
Posters are correctly referred to the documentation as frequently as
possible. In fact, very frequently. The frequency might decrease if
the documentation were in plain text. It is easier to search a single
plain text file than any other source, except perhaps the database
On 09/06/2010, John Gage jsmg...@numericable.fr wrote:
1) On a list that howls with complaints when posts are in html, it is
surprising that there is resistance to the idea of documentation in
plain text.
2) Posters are correctly referred to the documentation as frequently
as possible. In
Thank you very much for your answer below.
Just to keep you in the picture, the first problem has been solved with a
FULL VACUUMING of the database.
With reference to the sequence, I experience this problem when I operate
with pgAdmin III. It seems that the sequence START value is replaced
Brian Modra schrieb:
Personally I like to use html docs, and it would be good if the
documentation were downloadable from the postgresql website in other
formats, for convenience...
But, what I use is this, which works pretty well:
(e.g. to get the 8.1 dosc)
mkdir postgresql
cd postgresql
Hi,
we had a kernel panic crashing our DB server today and all libpq clients (C and
Perl clients) got stuck in poll() for hours even after the server was back up,
i.e. longer than the tcp timeout should be:
#0 0x2b2283b31c8f in poll () from /lib/libc.so.6
#1 0x2b228446f4af in
My tupp'th:
Formatted text, whether PDF, HTML or (heaven forbid!) Word Documents,
is easier to read than unformatted plain text, and those of us without
the OP's very admirable proficiency in vi remain at the mercy of the
various readers and their associated search functions.
However, I sure
Plenty of solutions here:
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
-Ognjen
On 8.6.2010 18:29, Aaron Burnett wrote:
Greetings,
I hope this is the proper list for this, but I am a loss on how to achieve
one particular set of results.
I have
On 8 June 2010 17:29, Aaron Burnett aburn...@bzzagent.com wrote:
Greetings,
I hope this is the proper list for this, but I am a loss on how to achieve
one particular set of results.
I have a table which is a list of users who entered a contest. They can
enter as many times as they want,
Hi,
I am trying to figure out how I can show the current search_path, or
better the first search_path entry (the active schema) in the PROMPT
variable for psql.
Is there any way to do that? I couldn't find anything useful ...
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★
Dave Coventry dgcoven...@gmail.com writes:
Formatted text, whether PDF, HTML or (heaven forbid!) Word Documents,
is easier to read than unformatted plain text, and those of us without
the OP's very admirable proficiency in vi remain at the mercy of the
various readers and their associated
Hi,
I need to return an int4 subtracting two dates, but returns me an interval.
select
end_date - now() as interger_number
from hist_anuncios
How to return an integer out of this?
Best Regards,
Hello
2010/6/9 Andre Lopes lopes80an...@gmail.com:
Hi,
I need to return an int4 subtracting two dates, but returns me an interval.
select
end_date - now() as interger_number
from hist_anuncios
How to return an integer out of this?
Best Regards,
postgres=# select '2010-06-18'::date
On 09/06/2010 11:57, Andre Lopes wrote:
Hi,
I need to return an int4 subtracting two dates, but returns me an interval.
select
end_date - now() as interger_number
from hist_anuncios
How to return an integer out of this?
Hmmm, according to the docs, subtracting dates returns an
Hello,
within Section 34.9.6. of the PostgreSQL documentation (
http://www.postgresql.org/docs/8.4/static/xfunc-c.html) there is an
excellent summary how to compile and link extensions on a variaty of Unix
and Unix-like operating systems.
How do I do the same on Windows, using Visual C Express ?
In article 4c0f4ba8.3040...@gmail.com,
Ognjen Blagojevic ognjen.d.blagoje...@gmail.com writes:
Plenty of solutions here:
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
This doesn't mention the incredibly powerful windowing functions of
PostgreSQL =
Marinos Yannikos m...@geizhals.at writes:
It seems that poll() never receives a connection closed notification under
Linux
(https://lists.linux-foundation.org/pipermail/bugme-new/2003-April/008335.html
-
very old report,
very old report is right. What makes you think that has anything
Greetings,
I've got an 8.1.10 instance running on Linux-i686. The system hosts 5
databases, all of which get vacuumed via a cronjob 3 times a day. All
of a sudden, the vacuum job for 1 of the databases is hanging
indefinitely. It normally finishes in under 5 minutes. There are no
errors in the
Lonni J Friedman netll...@gmail.com writes:
I've got an 8.1.10 instance running on Linux-i686. The system hosts 5
databases, all of which get vacuumed via a cronjob 3 times a day. All
of a sudden, the vacuum job for 1 of the databases is hanging
indefinitely.
Is it actually blocked, or just
Excerpts from John Gage's message of mié jun 09 01:28:54 -0400 2010:
I recently was re-looking at my files and saw
tsvector::text. I had forgotten that the double colon is one way to
cast a type. Double colon is not in the html index of the
documentation.
I just added an index entry
On Wed, Jun 9, 2010 at 12:13 PM, Lonni J Friedman netll...@gmail.com wrote:
hat I'm running is vacuumdb -v -z -f -d inventory. I also tried
removing the -z and -f options to see if that would at least get it to
complete, but that had no impact. Here's the tail end of the output,
leading up
Is there a way to sort case-insensitively without using LOWER()?
I thought that a combination of encoding and LC_COLLATE would achieve
this, but everything I've tried so far has resulted in the dreaded
caps-come-first(tm) behavior.
A setting in the DB to force text fields to be sorted case
Hi,
we currently encounter an increasing load on our website. With the increasing
load we see some problems on our database. so we checked what happens and we
saw spikes in our load when checkpoints are about to finish.
Our configuration:
max_connections = 125
ssl = false
shared_buffers =
On Wed, Jun 9, 2010 at 10:13 AM, Lonni J Friedman netll...@gmail.com wrote:
Greetings,
I've got an 8.1.10 instance running on Linux-i686. The system hosts 5
databases, all of which get vacuumed via a cronjob 3 times a day. All
of a sudden, the vacuum job for 1 of the databases is hanging
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
Marinos Yannikos m...@geizhals.at writes:
It seems that poll() never receives a connection closed notification under
Linux
(https://lists.linux-foundation.org/pipermail/bugme-new/2003-April/008...-
very old report,
very old report
2010/6/8 Oliver Kohll - Mailing Lists oliver.li...@gtwm.co.uk
On 8 Jun 2010, at 20:12, uaca man uaca...@gmail.com wrote:
2) Think of the front end as changing states as the user interacts
with it, then figure out what queries need to be made to correspond to
the changes in state.
Excerpts from björn lundin's message of mié jun 09 16:17:57 -0400 2010:
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
Marinos Yannikos m...@geizhals.at writes:
It seems that poll() never receives a connection closed notification
under Linux
Brian Modra wrote:
Personally I like to use html docs, and it would be good if the
documentation were downloadable from the postgresql website in other
formats, for convenience...
Good thing it is, then, albeit not in the most convenient format, i.e.,
DocBook. But then, from there you can
Does postgresql have functions to calculate the distance between two
sets of longitude and latitude.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them.
- Thomas
2010/6/9 Geoffrey li...@serioustechnology.com
Does postgresql have functions to calculate the distance between two sets
of longitude and latitude.
--
Until later, Geoffrey
I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
Does postgresql have functions to calculate the distance between two
sets of longitude and latitude.
You're looking for the earthdistance contrib module. With most Linux distros
it's installed under /usr/share/postgresql/8.xx/contrib
You may have to install a postgresql-contrib package
=?ISO-8859-1?Q?bj=F6rn_lundin?= b.f.lun...@gmail.com writes:
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
very old report is right. What makes you think that has anything to
do with modern kernel versions?
Interesting. The bug report includes a short code snippet which
compiles to
i've found some videos of conference at
http://www.fosslc.org/drupal/category/event/pgcon2010
but some are missing.
also, there is no mention of videos on pgcon page.
anybody knows if missing videos will appear somewhere and why there is
no links on pgcon site?
Aljosa Mohorovic
--
Sent via
32 matches
Mail list logo