On 09/06/2010, John Gage 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 fact, very frequen
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 ever
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
wge
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 PQmble
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 that
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 a
On 8 June 2010 17: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 a table which is a list of users who entered a contest. They can
> enter as many times as they want, but only 5 will
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
★ E-G
Dave Coventry 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 search functions.
>
>
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 :
> 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 - CURRENT
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 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 >= 8.4.0:
SELECT username,
Marinos Yannikos 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 to
do with
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 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 busy? (strace
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 e
On Wed, Jun 9, 2010 at 12:13 PM, Lonni J Friedman 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 to the hang:
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 insen
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 = 500M
On Wed, Jun 9, 2010 at 10:13 AM, Lonni J Friedman 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
> indefinitely. I
On 9 Juni, 16:37, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Marinos Yannikos 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" is r
2010/6/8 Oliver Kohll - Mailing Lists
> On 8 Jun 2010, at 20:12, uaca man 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.
>
>
> [snip]
>
>
> That is exactly what w
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 writes:
> > > It seems that poll() never receives a connection closed notification
> > > under Linux
> > > (https://lists.linux-foundation.org/pipe
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 gen
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 Jef
2010/6/9 Geoffrey
> 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
> 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?= 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 a c program
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 pgsq
On tis, 2010-06-08 at 11:04 +0200, John Gage wrote:
>
> Yet, the only one file edition of the Postgres documentation is
> in...pdf format. Huh?
>
> I know. I know. I have already brought this up. And various ways
> of
> creating a one file text edition of the documentation have been
> p
32 matches
Mail list logo
