On mån, 2009-11-09 at 23:13 +0100, hubert depesz lubaczewski wrote:
configure:27984: checking for DocBook V4.2
onsgmls:/etc/xml/catalog:2:78:E: name expected
onsgmls:/etc/xml/catalog:2:18:E: cannot find PUBLIC; tried
/etc/xml/PUBLIC, /usr/share/sgml/PUBLIC, /usr/share/xml/PUBLIC
Looks like
On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote:
hubert depesz lubaczewski wrote:
= pacman -Ql docbook-sgml
docbook-sgml /usr/
docbook-sgml /usr/share/
docbook-sgml /usr/share/sgml/
docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
docbook-sgml
On Mon, Nov 09, 2009 at 07:49:12PM -0300, Alvaro Herrera wrote:
hubert depesz lubaczewski wrote:
= pacman -Ql docbook-sgml
docbook-sgml /usr/
docbook-sgml /usr/share/
docbook-sgml /usr/share/sgml/
docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
docbook-sgml
Alexandra Roy wrote:
I have always run gmake distclean before relaunching a build.
Maybe the32-bit build failed because I have not set and exported the
OBJECT_MODE environment variable.
I will try to build PostgreSQL once again with export
OBJECT_MODE=32.
I will look at the 32 bit case
Hi all,
Is there a reason we require fixed-size WAL files?
Thanks
Thom
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
More on this ...
To be clear, just after receiving the S confirmation that PostgreSQL
can handle SSL connections, I have to switch my TCPSocket into SSL.
Immediatly, I receive some errors, depending my configuration:
0 - SSLv2: SSL (Secure Sockets Layer) version 2. ERROR =
Hi Laurenz, hi all,
This is a summary of what I have noticed concerning PostgreSQL 8.3.8
compilation on AIX 5.3 TL9.
1. To do a successful 64-bit build, specify and execute:
# export
OBJECT_MODE="64"
# export CFLAGS="-maix64"
# export LDFLAGS="-maix64 -Wl,-bbigtoc"
# ./configure
#
On 9 Nov 2009, at 23:30, Baris Gerze wrote:
I have users table such as
create table users(
user_id bigserial,
user_name varchar(50),
user_surname varchar(100)
);
how can I write a function to return multiple rows? ( in plpgsql )
You can create set-returning functions
On 10 Nov 2009, at 3:48, akp geek wrote:
Dear all -
Is there way to create incremental backups in
postgres. I am currently using 8.4.1 on solaris.. I am new to
postgres. Can you please share your thoughts
Regards
IMHO The simplest solution is to just write a dump to
I CC: this to the hackers list as it seems to be an old problem that
was never fixed. See at the bottom.
Alexandra Roy wrote:
This is a summary of what I have noticed concerning
PostgreSQL 8.3.8 compilation on AIX 5.3 TL9.
1. To do a successful 64-bit build, specify and execute:
David Fetter da...@fetter.org wrote:
On Mon, Nov 09, 2009 at 06:09:19PM -0800, Richard Broersma wrote:
Out of curiosity, what are the favorite editor for authoring the
PostgreSQL document sgml files? (I would be shocked if the whole
thing was developed from scratch using a simple text
Peter Eisentraut wrote:
On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote:
hubert depesz lubaczewski wrote:
= pacman -Ql docbook-sgml
docbook-sgml /usr/
docbook-sgml /usr/share/
docbook-sgml /usr/share/sgml/
docbook-sgml /usr/share/sgml/docbook-sgml-4.2/
docbook-sgml
On Tue, 2009-11-10 at 09:39 +, Thom Brown wrote:
Is there a reason we require fixed-size WAL files?
Currently we reuse the files, which is much easier with fixed size
files.
It might have been interesting once to pass the size at log switch
through to the archiver as a parameter, though we
Hello all,
I need, after one specific table is created, with syncdb, to insert
in that new table some values from other table. Exactly I need to add
in a column of the new table all fields from other table. How can I do
this, I know that trigger can't fire after a create table event, what
else
On Mon, Nov 9, 2009 at 9:21 PM, Greg Smith gsm...@gregsmith.com wrote:
On Mon, 9 Nov 2009, Richard Broersma wrote:
Out of curiosity, what are the favorite editor for authoring the
PostgreSQL document sgml files?
http://developer.postgresql.org/pgdocs/postgres/docguide-authoring.html
I'll
On Mon, Nov 9, 2009 at 10:34 PM, David Fetter da...@fetter.org wrote:
You might be, but that's approximately what happened. Common editors
for this task are Emacs and Vim, each of which has varying levels of
support for SGML :)
That is amazing. The layout and organization of the PostgreSQL
Hello there!
I have a tablefoo( userid integer, data integer); with the
constraint unique(userid,data)
Now I wish to select one userid and calculate the differences between
the data -values (when they are sorted) .
For example
if the table contains:
4, 100
5, 200
5, 210
5, 231
I want the
On Tue, Nov 10, 2009 at 11:03 AM, Alban Hertroys
dal...@solfertje.student.utwente.nl wrote:
IMHO The simplest solution is to just write a dump to the same file every
now and then and have the backup software take care of storing only the
differences. It does have a few drawbacks; it means
On Tue, Nov 10, 2009 at 6:40 AM, A B gentosa...@gmail.com wrote:
For example
if the table contains:
4, 100
5, 200
5, 210
5, 231
I want the values
5,10
5,21
I guess that will work, but I'm curious, are there other ways?
I think this kind of operation is best suited for CTEs and
With 8.4's analytic capabilities you can do this:
select * from (
select userid, data - lag(data) over (partition by userid order by data)
diff
from foo) q
where diff is not null;
On Tue, Nov 10, 2009 at 5:40 PM, A B gentosa...@gmail.com wrote:
Hello there!
I have a tablefoo(
On Tue, Nov 10, 2009 at 06:23:16AM -0800, Richard Broersma wrote:
On Mon, Nov 9, 2009 at 10:34 PM, David Fetter da...@fetter.org wrote:
You might be, but that's approximately what happened. Common editors
for this task are Emacs and Vim, each of which has varying levels of
support for
I am running PostgresSQL 8.3.8 on windows XP-64Bit. I am using psql
client from the PostgreSQL installation and not the Cygwin client.
My issue is that the command line argument -c command is not
recognized. For example, if I run (from Cygwin)
psql -h localhost -p 5432 -d $database postgres -c
With 8.4's analytic capabilities you can do this:
select * from (
select userid, data - lag(data) over (partition by userid order by data)
diff
from foo) q
where diff is not null;
Thank you! That worked perfectly!
--
Sent via pgsql-general mailing list
2009/11/10 Antonio Ruggiero aruggier...@gmail.com:
I am running PostgresSQL 8.3.8 on windows XP-64Bit. I am using psql
client from the PostgreSQL installation and not the Cygwin client.
My issue is that the command line argument -c command is not
recognized. For example, if I run (from
Hi;
also you can try this query which should work for any version
SELECT
a.userid, a.data, max(f.data), a.data - max(f.data)
FROM
(SELECT userid, data FROM foo EXCEPT SELECT userid, min(data) FROM
foo GROUP BY userid) a LEFT JOIN foo f ON (f.userid = a.userid AND
f.data a.data) GROUP
Albe Laurenz laurenz.a...@wien.gv.at writes:
Why the OBJECT_MODE exported to 32 is not sufficient ?
I dug around a little, and the problem is in psqlscan.c which is generated
from psqlscan.l by flex.
The problem is that both _LARGE_FILES and _LARGE_FILE_API are #defined
in this case, which
On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark gsst...@mit.edu wrote:
It's always worth having the dump, even if you also implement PITR.
The dump allows you to restore just specific tables or to restore onto
a different type of system. The PITR backup is a physical
byte-for-byte copy which
On Mon, Nov 9, 2009 at 06:15, Jukka Inkeri p...@awot.fi wrote:
The native psql is written for Windows, not for Cygwin. You really
shouldn't be using it there... If you are using Cygwin, you should be
using a Cygwin psql.exe.
PG pages says: use native, not cygwin version anymore.
Yes,
Joshua Berry wrote:
On Mon, Nov 2, 2009 at 8:35 AM, Jasen Betts ja...@xnet.co.nz wrote:
|
| for this case: convert to seconds and then do abs.
|
| ?select * from enviados e, recibidos r where abs(extract ( epoch from
| ?(e.fecha - r.fecha) )) 1
Cheers for that. The query cost is pretty
Tom Lane wrote:
In most of the other cases the #include is done in an associated .y
file, but there is none in psql. Anyone have a thought which of
psql's .c files would be the most appropriate host?
mainloop.c?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
I have tested the procedure in the URL and it worked fine. I have
accidentally deleted my PGDATA folder after the backup procedure is done. I
could able to restore it. But still have few questions
Thanks for the help
Regards
On Mon, Nov 9, 2009 at 11:01 PM, Jing Tan j...@iheavy.com wrote:
I
So Is it always good to have the backup using PG_dump instead of PITR or a
combination of both
Please advice
Regards
On Tue, Nov 10, 2009 at 11:24 AM, Scott Mead
scott.li...@enterprisedb.comwrote:
On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark gsst...@mit.edu wrote:
It's always worth having
On Tuesday 10 November 2009, akp geek akpg...@gmail.com wrote:
So Is it always good to have the backup using PG_dump instead of PITR or
a combination of both
I like to do both. Ongoing PITR, daily base backups (by updating an rsync
copy), and weekly pg_dumps that in turn go to tape.
PITR
On tis, 2009-11-10 at 07:00 -0800, David Fetter wrote:
Well, there's the whole Docbook thing, which was pretty well thought
out. Apart from that, I don't know. Peter?
Well, a lot of hard work. ;-) Just like there are coding standards and
best practices, there are standards and customs in
How about using replication instead of incremental backups?
On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson ahodg...@simkin.ca wrote:
On Tuesday 10 November 2009, akp geek akpg...@gmail.com wrote:
So Is it always good to have the backup using PG_dump instead of PITR or
a combination of both
I
On Tue, Nov 10, 2009 at 2:04 PM, Peter Eisentraut pete...@gmx.net wrote:
Well, a lot of hard work. ;-) Just like there are coding standards and
best practices, there are standards and customs in writing and
publishing.
Are these published anywhere?
--
Regards,
Richard Broersma Jr.
Visit
I have set up the replication using Bucardo. This is just an additional set
up
regards
On Tue, Nov 10, 2009 at 5:09 PM, silly silly8...@gmail.com wrote:
How about using replication instead of incremental backups?
On Tue, Nov 10, 2009 at 4:56 PM, Alan Hodgson ahodg...@simkin.ca wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
Tom Lane wrote:
In most of the other cases the #include is done in an associated .y
file, but there is none in psql. Anyone have a thought which of
psql's .c files would be the most appropriate host?
mainloop.c?
Yeah, that's about the same
Albe Laurenz laurenz.a...@wien.gv.at writes:
The problem is that both _LARGE_FILES and _LARGE_FILE_API are #defined
in this case, which makes #include unistd.h fail.
Does anyone have an idea how to best fix this problem in the
source tree? I'm willing to implement and test.
I've committed
I'm still not buying the theory that the dump/restore method has
something to do with it. You might try the test yourself: run
pg_restore's output into a text file and compare with the text dump.
regards, tom lane
Haven't figured out exactly why yet, but I did find
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function which traps
for nulls (below) returns a null.
If I change it to type [real]. No problems
Function
You can try
If (IsNumeric(varToTest) And 0 = CDbl(varToTest)) Then IsNothing = True
Bret wrote:
This may not be the right group, if so, just let me know.
I have a table with a type [numeric].
When executing queries, I get the data which happens to
be (6.5) in this case, but my VB6 function
42 matches
Mail list logo