On Monday 09 April 2007 05:35, Markus Schiltknecht wrote:
> Hi,
>
> David Fetter wrote in the weekly news:
> > Another PostgreSQL Diff Tool 1.0.0_beta20 released.
> > http://pgfoundry.org/projects/apgdiff/
>
> Why is it 'another' one? What others exist? (Specifically, are there
> ones, which don't
"Dhaval Shah" <[EMAIL PROTECTED]> writes:
> The question I have is, how far does it look behind in time?
I think you only need to hang onto the immediately preceding file;
it only backs up to the last applied WAL record, and that's certainly
not going to span multiple segment files. The attempt t
No, it isn't a debug-enabled build, and I don't think the debug symbols
package is installed on that system. I've never used GDB, I'm more of an
'applications' programmer, I may need a 'crash' course on it, if you pardon
the pun. However, if it's anything like the debugging tools I used to use
w
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Well, this trace doesn't prove any such thing. If it was a wild jump,
>> we can surmise that it landed someplace in the first few instructions of
>> FileRead (before the call to FileAccess), but there's no proof here that
>> it landed on-th
On Monday 09 April 2007 11:50, Erik Jones wrote:
> On Apr 9, 2007, at 9:46 AM, Vivek Khera wrote:
> > On Apr 9, 2007, at 10:09 AM, [EMAIL PROTECTED] wrote:
> >> It would be a really great service to this community if you would
> >> capture those issues and publish documentation (but feel free to
>
Here is the situation:
I have a standby postgres which is fed a WAL File every 2 minutes.
Whenever it is fed a WAL file it logs the following:
---
LOG: restored log file "00010070" from archive
pg_restore::copyWALFile: Moving
/opt/data/mirror/00010071 to pg_xlog
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
The trace is *really* suspicious given what you say here. I'm inclined
to think that what is really happening is that something is jumping to
never-never land (via a clobbered function pointer or overwriting a
return address
Here you go.
Fetches versions and prints most recent minor for each major
Tests all mirrors for speed and prints out the 4 fastest (takes some
time)
http://www.crummy.com/software/BeautifulSoup/
Have a nice day !
#! /bin/env python
# -*- coding: utf-8 -
Andrew Hammond escribió:
> On 4/9/07, CAJ CAJ <[EMAIL PROTECTED]> wrote:
> >On 9 Apr 2007 14:47:20 -0700, Andrew Hammond
> ><[EMAIL PROTECTED]> wrote:
> >> I'm writing a script that wants to know the latest release for a given
> >> major.minor version. Is there some better way than parsing
> >> htt
On 4/9/07, CAJ CAJ <[EMAIL PROTECTED]> wrote:
On 9 Apr 2007 14:47:20 -0700, Andrew Hammond
<[EMAIL PROTECTED]> wrote:
> I'm writing a script that wants to know the latest release for a given
> major.minor version. Is there some better way than parsing
> http://www.postgresql.org/ftp/source/ or tr
On 9 Apr 2007 14:47:20 -0700, Andrew Hammond <
[EMAIL PROTECTED]> wrote:
I'm writing a script that wants to know the latest release for a given
major.minor version. Is there some better way than parsing
http://www.postgresql.org/ftp/source/ or trying to connect to ftp
(which is invariably timing
Lorenzo Thurman wrote:
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a
query that would do that?
You could write a custom function doing the same sort of thing, or
(perhaps more portable) use generic sqls & v
I'm writing a script that wants to know the latest release for a given
major.minor version. Is there some better way than parsing
http://www.postgresql.org/ftp/source/ or trying to connect to ftp
(which is invariably timing out on me today. Is that box getting
hammered or something?) and doing the
On Sun, 8 Apr 2007, Andrus wrote:
> I have tables with large number of columns some of which are duplicate.
> I need to use
>
> SELECT t1.*, t2.* FROM t1 join t2 using (t)
>
> since I don't know all column names of t1 and t2 tables at design time.
>
> In this case PostgreSQL returns table with du
On 4/9/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
>> I have three tables using date fields. I want to retrieve the oldest
>> date contained in the tables. Can someone show me an example of a query
>> that wou
"Gary Winslow" <[EMAIL PROTECTED]> writes:
> I would be happy to provide a "self-contained" test case. I would have
> to send to you a pg_dump of it which would be rather large to send via
> email. Some of the code includes confidential business specific calc
> rules that I cannot release to the
"Raymond O'Donnell" <[EMAIL PROTECTED]> writes:
> On 09/04/2007 00:36, Bigjim wrote:
>> I am trying to combine 2 text variable togther to form the name of a
>> VIEW. example
>> SELECT * FROM ( 'april'||'may') ;
> I think you want to use EXECUTE from within a pl/pgsql function to
> construct and
"Dann Corbit" <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
>> I have three tables using date fields. I want to retrieve the oldest
>> date contained in the tables. Can someone show me an example of a query
>> that would do that?
> Just do a union and return the min
"Sergei Shelukhin" <[EMAIL PROTECTED]> writes:
> Due to limitations of both pg and php I gave up on the attempts to
> make bigint keys work;
Which limitations would those be?
> I have a choice between 16-byte character
> strings or "8-byte" bytea (decode(string_from_above, "hex")) for an
> index
Alan Hodgson <[EMAIL PROTECTED]> writes:
> On Friday 06 April 2007 13:17, Klaas Dellschaft <[EMAIL PROTECTED]>
> wrote:
>> I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a
>> "COPY FROM" into my database. But I'm waiting for the completion of this
>> job since more than 24h.
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The trace is *really* suspicious given what you say here. I'm inclined
>> to think that what is really happening is that something is jumping to
>> never-never land (via a clobbered function pointer or overwriting a
>> return address on the
OK, do you have the stats system enabled also? You require at least
row_level stats for autovacuum to work.
Schwenker, Stephen wrote:
I'm sure. That column is null for all tables in my databases accept for
the few tables that I've vacuumed manually.
Any other suggestions? :)
---
On 4/8/07, Andrus <[EMAIL PROTECTED]> wrote:
I have tables with large number of columns some of which are duplicate.
I need to use
SELECT t1.*, t2.* FROM t1 join t2 using (t)
since I don't know all column names of t1 and t2 tables at design time.
In this case PostgreSQL returns table with dup
samı escribió:
> Hi
>
> I am using PostgreSQL 8.2.3 on WindowsXP
>
> I am using the PL/Perl regression tests located here:
>
>
> http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/Attic/test_queries.sql
The fact that these files are in the "Attic" means they were deleted.
Schwenker, Stephen wrote:
> Hey,
>
> I've also notice one difference between my 8.1 instance and my 8.2
> instance. I run a ps and on the 8.1 instance there is a 'stats buffer
> process' and in the 8.2 instance there is no 'stats buffer instance'
>
> Does that give you anymore reasons as to wh
Just do a union and return the min
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Lorenzo Thurman
> Sent: Monday, April 09, 2007 7:32 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] NEWBIE: How do I get the oldest date cont
In response to Alexander Staubo <[EMAIL PROTECTED]>:
> On Apr 9, 2007, at 18:10 , Gerard Seibert wrote:
>
> > On Mon, 9 Apr 2007 10:34:22 -0500
> > Erik Jones <[EMAIL PROTECTED]> wrote:
> >
> >> Hmmm... I didn't have anything HTML set anywhere. I did however
> >> have message formatting set to
On 09/04/2007 00:36, Bigjim wrote:
I am trying to combine 2 text variable togther to form the name of a
VIEW. example
>
SELECT * FROM ( 'april'||'may') ;
I think you want to use EXECUTE from within a pl/pgsql function to
construct and execute a query dynamically - have a look at this:
Klaas Dellschaft wrote:
> Hi,
>
> I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a
> "COPY FROM" into my database. But I'm waiting for the completion of this
> job since more than 24h. I'm working under Linux and with "top" I can
> see the two processes which should copy
I have tables with large number of columns some of which are duplicate.
I need to use
SELECT t1.*, t2.* FROM t1 join t2 using (t)
since I don't know all column names of t1 and t2 tables at design time.
In this case PostgreSQL returns table with duplicate columns.
How to force Postgres to return
Bigjim wrote:
Hi there,
I am trying to combine 2 text variable togther to form the name of a
VIEW. example
SELECT * FROM ( 'april'||'may') ;
The table (or view) part is not a character string but an identifier.
--
Lew
---(end of broadcast)
Tom Lane wrote:
Magnus Hagander <[EMAIL PROTECTED]> writes:
Geoffrey wrote:
CREATE OR REPLACE FUNCTION pcm_getmiles_s(text,text,integer)
RETURNS float8 AS '/esc/pgrnd/prog/libpcmiler'
LANGUAGE 'c' WITH (isStrict);
Is this function actually a PostgreSQL callable function? Or is it just
a gene
On 7 Apr, 10:13, "filippo" <[EMAIL PROTECTED]> wrote:
solved, it is a DBD::PgPP bug. I changed to DBD::Pg, now it works fine.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hey, I've just found something else. When I compiled postgresql, I assumed
that because it compiled then it was a supported system. This was on the first
line of the configure output.
checking build system type... x86_64-unknown-linux-gnu
I've looked at the supported systems list and the x
I have three tables using date fields. I want to retrieve the oldest
date contained in the tables. Can someone show me an example of a query
that would do that?
TIA
---(end of broadcast)---
TIP 6: explain analyze is your friend
Tom Lane,
I would be happy to provide a "self-contained" test case. I would have
to send to you a pg_dump of it which would be rather large to send via
email. Some of the code includes confidential business specific calc
rules that I cannot release to the general public.
How can I pr
On Friday 06 April 2007 13:17, Klaas Dellschaft <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a
> "COPY FROM" into my database. But I'm waiting for the completion of this
> job since more than 24h. I'm working under Linux and with "top"
On Sat, 7 Apr 2007 12:07:44 -0700 (PDT), [EMAIL PROTECTED] (RPK)
wrote:
in <[EMAIL PROTECTED]>
>
>I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way
>of documenting the schema of PGSQL database so that I can get a printed copy
>of the same.
Björn's tool looks like you
I'm sure. That column is null for all tables in my databases accept for the
few tables that I've vacuumed manually.
Any other suggestions? :)
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general@postgr
> 1) If I use the 'check CD' option, it tests everything and then
> reports two failed checks.
This is strange...I tried the same CD at work this weekend on an IBM
workstation, and although the check also fails at two spots, if I try
it anyway, it appears to work flawlessly. I can jump on a
neigh
Hey,
I've also notice one difference between my 8.1 instance and my 8.2 instance. I
run a ps and on the 8.1 instance there is a 'stats buffer process' and in the
8.2 instance there is no 'stats buffer instance'
Does that give you anymore reasons as to why the autovacuum is not working?
:)
Hi
I am using PostgreSQL 8.2.3 on WindowsXP
I am using the PL/Perl regression tests located here:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/test/Attic/test_queries.sql
and comparing them to the expected output located here:
http://developer.postgresql.org/cvswe
Thanks,
I'll try to implement it.
Marcel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Is pcmiler a Postgres-specific backend extension?
No. It's a standalone application that provides an api to build calls
into there product from other applications. What we've done is created
functions that are called fro
Hi there,
I am trying to combine 2 text variable togther to form the name of a
VIEW. example
SELECT * FROM ( 'april'||'may') ;
I have a 12 different views and I want to be able to select a
different view depending on the contents of 2 fields in a database.
Has anyone done this before or hav
One more newbie question.
Due to limitations of both pg and php I gave up on the attempts to
make bigint keys work; I have a choice between 16-byte character
strings or "8-byte" bytea (decode(string_from_above, "hex")) for an
index column for a table.
Which one will be faster for exact matches and
Hi,
I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a
"COPY FROM" into my database. But I'm waiting for the completion of this
job since more than 24h. I'm working under Linux and with "top" I can
see the two processes which should copy the data but most of the time
they are
Salut,
I have four tables, two of which are relevant for this:
searchengine=# \d websites
Table "public.websites"
Column | Type | Modifiers
+--+--
Thanks very much, my issue was addressed exactly.
My implicit assumption that inserts of timestamps are not formatted by
local time (db time zone setting) in the absence of an explicit time
zone identifier was incorrect. Ok, it seems obvious now. TIMESTAMPTZ is
your friend.
The solution is to rew
On 7 Apr, 01:26, "filippo" <[EMAIL PROTECTED]> wrote:
> hello,
>
> if I try to insert text like
>
> $dbh->quote(qq/d'ambrose/);
>
> when I try to search names with character lile ', I get this error
I forgot to say that I need LIKE and %. I tried to use placeholders
but nothing changes.
Hi,
I'm currently trying to copy two large files (1.6 GB and 3.5 GB) with a
"COPY FROM" into my database. But I'm waiting for the completion of this
job since more than 24h. I'm working under Linux and with "top" I can
see the two processes which should copy the data but most of the time
they
How can i use multi-array parameter in PlPg/SQL?
This array want to put in parameter.
[[0, 1, 3, 0, 3, 4], [7, 12, 1, 9, 1, 2], [12, 24, 20, 42, 43, 44],
[24, 103, 65, 113, 72, 25], [179, 357, 335, 348, 309, 138], [3901,
3491, 4326, 878, 3785, 450]]
---(end of broadcast)-
hello,
if I try to insert text like
$dbh->quote(qq/d'ambrose/);
when I try to search names with character lile ', I get this error
DBD::PgPP::st execute failed: Unknown message type: '' at C:/Perl/
site/lib/DBD/
PgPP.pm line 730
I really need to store and select names with ' character, how ca
On 7 Apr, 01:47, "filippo" <[EMAIL PROTECTED]> wrote:
> On 7 Apr, 01:26, "filippo" <[EMAIL PROTECTED]> wrote:
just to clarify:
I can insert text into database. My problem are the SELECT query like
this
WHERE name LIKE $name
$name = $dbh->quote(qq/ d'am% / )
---(end of
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> Geoffrey wrote:
>>> CREATE OR REPLACE FUNCTION pcm_getmiles_s(text,text,integer)
>>> RETURNS float8 AS '/esc/pgrnd/prog/libpcmiler'
>>> LANGUAGE 'c' WITH (isStrict);
>
>> Is this function actually a PostgreSQL callable function? Or i
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Geoffrey wrote:
>> CREATE OR REPLACE FUNCTION pcm_getmiles_s(text,text,integer)
>> RETURNS float8 AS '/esc/pgrnd/prog/libpcmiler'
>> LANGUAGE 'c' WITH (isStrict);
> Is this function actually a PostgreSQL callable function? Or is it just
> a general C f
Geoffrey wrote:
> Tom Lane wrote:
>> Geoffrey <[EMAIL PROTECTED]> writes:
>>> A backtrace against this process produces:
>>
>>> Program received signal SIGSEGV, Segmentation fault.
>>> 0x0814acc9 in FileAccess (file=168481968) at fd.c:717
>>> 717 if (FileIsNotOpen(file))
>>> (gdb) bt
>>
Geoffrey <[EMAIL PROTECTED]> writes:
> (gdb) bt
> #0 0x0814acc9 in FileAccess (file=168481968) at fd.c:717
> #1 0x0814b2e7 in FileRead (file=168481968, buffer=0xbff816ce "", amount=2)
> at fd.c:972
> #2 0x00203ecc in ?? ()
> #3 0x0a0ad4b0 in ?? ()
> #4 0xbff816ce in ?? ()
> #5 0x0002
On Apr 9, 2007, at 18:10 , Gerard Seibert wrote:
On Mon, 9 Apr 2007 10:34:22 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
Hmmm... I didn't have anything HTML set anywhere. I did however
have message formatting set to Rich-Text (although I was unaware)
and have switched that to plaintext. Thi
Geoffrey <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Is pcmiler a Postgres-specific backend extension?
> No. It's a standalone application that provides an api to build calls
> into there product from other applications. What we've done is created
> functions that are called from the data
Tom Lane wrote:
Geoffrey <[EMAIL PROTECTED]> writes:
A backtrace against this process produces:
Program received signal SIGSEGV, Segmentation fault.
0x0814acc9 in FileAccess (file=168481968) at fd.c:717
717 if (FileIsNotOpen(file))
(gdb) bt
#0 0x0814acc9 in FileAccess (file=16848
Geoffrey <[EMAIL PROTECTED]> writes:
> A backtrace against this process produces:
> Program received signal SIGSEGV, Segmentation fault.
> 0x0814acc9 in FileAccess (file=168481968) at fd.c:717
> 717 if (FileIsNotOpen(file))
> (gdb) bt
> #0 0x0814acc9 in FileAccess (file=168481968) at
We have built into the backend of the database a third party application
called pcmiler that produces mileage between two locations. This has
been working in the past, but after upgrading to RHEL 4, Postgresql
7.4.16 and pcmiler 20 (from pcmiler 17), the server process is
terminated with a sig
On Mon, 9 Apr 2007 10:34:22 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
> Hmmm... I didn't have anything HTML set anywhere. I did however
> have message formatting set to Rich-Text (although I was unaware)
> and have switched that to plaintext. This look better?
Yes, much better. I believe t
On Apr 9, 2007, at 9:46 AM, Vivek Khera wrote:
On Apr 9, 2007, at 10:09 AM, [EMAIL PROTECTED] wrote:
It would be a really great service to this community if you would
capture those issues and publish documentation (but feel free to
change or omit the names to protect the incompetent^w inn
On Apr 9, 2007, at 9:40 AM, Gerard wrote:
On Monday April 09, 2007 at 10:19:53 (AM) Erik Jones wrote:
On Apr 9, 2007, at 8:15 AM, Vivek Khera wrote:
On Mar 27, 2007, at 4:09 PM, Tony Caduto wrote:
Another thing is this, how hard could it possibly be for a MS SQL
DBA or Oracle DBA to pic
Ich werde ab 02.04.2007 nicht im Büro sein. Ich kehre zurück am
10.04.2007.
Ich werde Ihre Nachricht gern nach meiner Rückkehr beantworten.
In dringenden Fällen wenden Sie sich bitte an Stephan Luxenburger.
Herr Luxenburger ist unter der Mailadresse [EMAIL PROTECTED] oder
telefonisch unter der
On Apr 9, 2007, at 10:09 AM, [EMAIL PROTECTED] wrote:
It would be a really great service to this community if you would
capture those issues and publish documentation (but feel free to
change or omit the names to protect the incompetent^w innocent!).
There's no incompetence involved... the
On Monday April 09, 2007 at 10:19:53 (AM) Erik Jones wrote:
> On Apr 9, 2007, at 8:15 AM, Vivek Khera wrote:
>
> >
> > On Mar 27, 2007, at 4:09 PM, Tony Caduto wrote:
> >
> >> Another thing is this, how hard could it possibly be for a MS SQL
> >> DBA or Oracle DBA to pick up using PostgreSQL?
On Apr 9, 2007, at 8:15 AM, Vivek Khera wrote:
On Mar 27, 2007, at 4:09 PM, Tony Caduto wrote:
Another thing is this, how hard could it possibly be for a MS SQL
DBA or Oracle DBA to pick up using PostgreSQL?
I don't think it would take a decent admin of any database to come
up to speed in
Vivek Khera wrote:
On Mar 27, 2007, at 4:09 PM, Tony Caduto wrote:
Another thing is this, how hard could it possibly be for a MS SQL DBA
or Oracle DBA to pick up using PostgreSQL?
I don't think it would take a decent admin of any database to come up
to speed in a very short time as long as th
On Mar 27, 2007, at 4:09 PM, Tony Caduto wrote:
Another thing is this, how hard could it possibly be for a MS SQL
DBA or Oracle DBA to pick up using PostgreSQL?
I don't think it would take a decent admin of any database to come
up to speed in a very short time as long as they were interested
Hello All,
here are many tools available to create the attractive documentation of
PostgreSQL Database in different formats.
With Reagrds
Ashish...
Björn Lundin <[EMAIL PROTECTED]> wrote:
7 apr 2007 kl. 21.07 skrev RPK:
I am using PGSQL 8.2.3 on Windows XP. I want
Hi,
David Fetter wrote in the weekly news:
Another PostgreSQL Diff Tool 1.0.0_beta20 released.
http://pgfoundry.org/projects/apgdiff/
Why is it 'another' one? What others exist? (Specifically, are there
ones, which don't depend on java?)
Regards
Markus
---(end of b
74 matches
Mail list logo
