On 5/30/06, Bruce Momjian pgman@candle.pha.pa.us wrote:
The crux of the matter was if its possible to use fwrite
as easy string combining mechanism and the answer is no,
because it's not lightweight enough.
So your patch to src/backend/storage/file/fd.c should be discarded? OK.
Yes. It
ppport.h is throwing warnings when compiling on Fedora Core 5
(with perl-5.8.8-4). I gather from the comments in the head
of that file that we ought to look for a newer version.
regards, tom lane
---(end of broadcast)---
Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x
assuming x is the same and integer-date-times are not enabled ?
Dave
---(end of broadcast)---
TIP 1: if posting/reading
On Tue, May 30, 2006 at 08:50:23AM -0400, Dave Cramer wrote:
Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x
assuming x is the same and integer-date-times are not enabled ?
I doubt it very much. Or put another way,
Hi, I cant find any function, which tells me something like session
id. Is there something like that? I need it in my AM, because I need
to know, if something which I wrote in file was written in this
current session or previously.
And second thing - it would be great if I could save pointer in
Tom Lane wrote:
ppport.h is throwing warnings when compiling on Fedora Core 5
(with perl-5.8.8-4). I gather from the comments in the head
of that file that we ought to look for a newer version.
I don't currently have an FC5 box to test with. Here's what to try: move
the ppport.h aside,
Rafael Martinez, Guerrero [EMAIL PROTECTED] writes:
The problem was that 000100080010.0006D5E8.backup was
already archived, but under pg_xlog/archive_status/ there were two
files:
-
000100080010.0006D5E8.backup.done
Andrew Dunstan [EMAIL PROTECTED] writes:
I don't currently have an FC5 box to test with. Here's what to try: move
the ppport.h aside, and in the plperl directory run this command to
generate a replacement:
perl -MDevel::PPPort -e 'Devel::PPPort::WriteFile();'
and then recompile.
Hm.
Martijn van Oosterhout kleptog@svana.org writes:
On Tue, May 30, 2006 at 08:50:23AM -0400, Dave Cramer wrote:
Is it possible to use a binary copy of the cluster on a 64 bit build
of pg 7.4.x that was created on a 32bit bild of 7.4.x
I doubt it very much. Or put another way, no effort has been
When is this patch going to be applied? Is there a bug that I can
follow along?
thanks.
jeff
* From: Bruce Momjian pgman ( at ) candle ( dot ) pha ( dot ) pa (
dot ) us
* To: Yannick ybgn ( at ) free ( dot ) fr
* Subject: Re: Compile libpq with vc8
* Date: Mon, 29 May
Andrew Dunstan [EMAIL PROTECTED] writes:
Tom Lane wrote:
Hm. It compiles without warnings, but the new ppport.h is about 100K
larger than the old one :-(. The change we seem to actually need is
just to put #ifndef PERL_UNUSED_DECL around the attempted declaration
of that macro, so I'm
Averbukh Stella [EMAIL PROTECTED] writes:
I'm building postgresQL on Sparc10 and the build goes fine unil initdb.
/usr/local/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Winline -Wendif-labels -fno-strict-aliasing initdb.o
-L../../../src/port -lpgport
Hi Tom,
Actually I'm building it first time. The system didn't have prior
versions of postgreSQL installed. I took postgresql-8.1.3.tar.gz code
distribution.
I'll try to remove it from the code.
Thanks.
Stella Averbukh
_
Senior Software Lead, Arbitron Inc.
Andrew Dunstan [EMAIL PROTECTED] writes:
It is, but this misses the point. You want to use the latest ppport.h
even when building with earlier perls.
Doh, of course. Well, for the moment I'll just put in the #ifndef.
FWIW, it looks like a large part of the bloat in the newer file is
in-line
On Mon, May 29, 2006 at 02:14:42PM -0300, Marc G. Fournier wrote:
On Sun, 28 May 2006, Magnus Hagander wrote:
AFAICS, this is caused by the machine attempting to relay thousands and
thousands of spam emails (some quick checked showed a rate of about 1
spam / 5 seconds enytering the queue -
Jim C. Nasby wrote:
Postfix allows you to specify a list of valid email addresses. It should
be a simple matter of specifying what all the valid mailing list email
addresses are.
umm ... we allow non-subscribers to post, the posts just have to be
approved. How would we still do that?
Andrew Dunstan wrote:
Jim C. Nasby wrote:
Postfix allows you to specify a list of valid email addresses. It should
be a simple matter of specifying what all the valid mailing list email
addresses are.
umm ... we allow non-subscribers to post, the posts just have to be
approved. How would
Alvaro Herrera wrote:
Andrew Dunstan wrote:
Jim C. Nasby wrote:
Postfix allows you to specify a list of valid email addresses. It should
be a simple matter of specifying what all the valid mailing list email
addresses are.
umm ... we allow non-subscribers to post, the posts just
On Tue, 2006-05-30 at 09:45 -0400, Tom Lane wrote:
Rafael Martinez, Guerrero [EMAIL PROTECTED] writes:
The problem was that 000100080010.0006D5E8.backup was
already archived, but under pg_xlog/archive_status/ there were two
files:
On Tue, 30 May 2006, Jim C. Nasby wrote:
On Mon, May 29, 2006 at 02:14:42PM -0300, Marc G. Fournier wrote:
On Sun, 28 May 2006, Magnus Hagander wrote:
AFAICS, this is caused by the machine attempting to relay thousands and
thousands of spam emails (some quick checked showed a rate of about 1
Martijn,
On Fri, May 26, 2006 at 03:03:15PM +0200, Martijn van Oosterhout wrote:
I think you may be thinking of yet a separate TODO item, which is to
be able to use the zic timezone names in timestamptz input, viz
'2006-05-24 21:11 Americas/New_York'::timestamptz
But names like 'IST'
Rafael Martinez [EMAIL PROTECTED] writes:
What happens if we have a race condition and the archiver creates
a .done file between the last check for the .done file and the creation
of the .ready file by XLogArchiveNotify?
That can't happen; the archiver creates the .done file by rename()ing
the
Hi,
Perhaps one of you can help me.
I am a IT Executive Recruiter from a Search firm in Toronto looking
for a Postgres Developer/ Administrator to work on a Two week(80
hours) contract to fix my clients Postgres Problem.
My client in situated in Toronto, Canada and needs someone to start
One of the first things an IT Executive Recruiter needs to learn is
where to post job info - in this case it would be the pgsql-jobs list ;-)
cheers
andrew
Mandy Abrahams wrote:
Hi,
Perhaps one of you can help me.
I am a IT Executive Recruiter from a Search firm in Toronto looking
for a
On Tue, 2006-05-30 at 15:38 -0400, Tom Lane wrote:
[...]
My thought is that the stat()s on the .done file failed for some obscure
reason, perhaps insufficient kernel resources, even though the file was
actually there.
If you have postmaster log output for the interval in which this
On Tue, May 30, 2006 at 02:01:07PM -0400, Andrew Dunstan wrote:
Jim C. Nasby wrote:
Postfix allows you to specify a list of valid email addresses. It should
be a simple matter of specifying what all the valid mailing list email
addresses are.
umm ... we allow non-subscribers to post,
Martijn van Oosterhout kleptog@svana.org writes:
On Sun, May 07, 2006 at 08:21:43PM -0400, Tom Lane wrote:
I'm pretty sure we had agreed that magic blocks should be required;
otherwise this check will accomplish little.
Sure, I just didn't want to break every module in one weekend. I was
Tom Lane:
ALTER TABLE childN DROP INHERITS old_parent;
ALTER TABLE childN ADD INHERITS new_parent;
I think you would have to make INHERITS a reserved word to make that happen:
stark= create table integer (i integer);
CREATE TABLE
stark= alter table test add inherits integer;
ALTER TABLE
--
On Tue, May 30, 2006 at 04:21:46PM -0300, Marc G. Fournier wrote:
On Tue, 30 May 2006, Jim C. Nasby wrote:
On Mon, May 29, 2006 at 02:14:42PM -0300, Marc G. Fournier wrote:
On Sun, 28 May 2006, Magnus Hagander wrote:
AFAICS, this is caused by the machine attempting to relay thousands and
On Tue, 30 May 2006, Jim C. Nasby wrote:
Depending on what the exact setup is, a friend has a script that should
help: http://slacker.com/~nugget/projects/postfixrelaymaps/
Thanks, but the script would involve a fair amount of work, since our mail
system isn't based on the pasword file :)
On Tue, May 30, 2006 at 16:52:09 -0400,
Andrew Dunstan [EMAIL PROTECTED] wrote:
One of the first things an IT Executive Recruiter needs to learn is
where to post job info - in this case it would be the pgsql-jobs list ;-)
But his timing is pretty good, there will shortly be a bunch of
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Bruno
Wolff III) transmitted:
On Tue, May 30, 2006 at 16:52:09 -0400,
Andrew Dunstan [EMAIL PROTECTED] wrote:
One of the first things an IT Executive Recruiter needs to learn is
where to post job info - in this
Here's a question. I wish to add a function to libpq to escape
PostgreSQL identifiers. Will this function be subject to the same
security/encoding issues as PQescapeString?
Chris
--
Christopher Kings-Lynne
Technical Manager
CalorieKing
Tel: +618.9389.8777
Fax: +618.9389.8444
[EMAIL
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Here's a question. I wish to add a function to libpq to escape
PostgreSQL identifiers. Will this function be subject to the same
security/encoding issues as PQescapeString?
Is this of any general-purpose use? How many apps are really
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Here's a question. I wish to add a function to libpq to escape
PostgreSQL identifiers. Will this function be subject to the same
security/encoding issues as PQescapeString?
Is this of any general-purpose use? How many apps are really
Hi hackers,
I sent this to the hackers list, as this is the people I wish to contact.
Do any of you guys use linkedin.com and want to add me to your contacts
network?
I'm keen to get into a network of PostgreSQL-related people - for future
jobs/contracts purposes.
My linkedin.com email is
KL,
Do any of you guys use linkedin.com and want to add me to your contacts
network?
Ironically, I don't use LinkedIn, even though they use PostgreSQL (not
exclusively, though).
--
Josh Berkus
PostgreSQL @ Sun
San Francisco
---(end of
37 matches
Mail list logo