> -Original Message-
> Zeugswetter Andreas SB
>
> > As I mentioned already I'm implementing updatable cursors
> > in ODBC and have half done it. If OIDs would be optional
> > my trial loses its validity but I would never try another
> > implementation.
>
> But how can you do that ? The oi
Sure. The mailing list is
http://www.greatbridge.org/mailman/listinfo/pgreplication-general
It's not only for Postgres-R, but any PostgreSQL
replication ideas, discussions, or projects.
Feel free to listen or contribute.
Darren
BTW: My apologies for the email issues. Should be fixed now.
Sean
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Steve Howe" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 1:39 AM
Subject: Re: [HACKERS] Large queries - again...
>
> OK, I just applied a patch to add the fin
Howdy. Darren, I'd reply in person, but there are issues with
your mail account. ;~) At anyrate, is there a mailing list that the
Postgres-R development is happening on so that I could drop in and
either listen/contribute? Thanks. -sc
<[EMAIL PROTECTED]>:
63.136.234.38 does not like r
OK, I just applied a patch to add the final fixes to Win32 libpq.
Please try the CVS or later snapshot to see how it works. The patch
suggested adding
#define snprintf _snprintf
to win32.h and I have done that. There was already one there for
vsnprintf. I am quite confused about th
> "Steve Howe" <[EMAIL PROTECTED]> writes:
> >> (Thinks for awhile...) You're not using PQsetnonblocking() are you,
> >> by any chance?
>
> > No, I'm not.
>
> Drat, another perfectly good theory down the drain :-(.
>
> Well, we're not going to find out anymore until we discover what the
> error c
Has anyone here thought about using the spread libraries for WAL
replication amongst mutliple hosts? With this library I think it'd be
possible to have a multi-master replication system...
http://www.spread.org/
I'm not familiar enough with the guts of postgres to be able to
imp
> > On to the next batch There are a few perl and python scripts shipped as
> > examples -- every last one of them shebangs to '/usr/local/perl' or
> > '/usr/local/python' -- to make them usable, I patch this to '/usr/bin/perl'
> > or python, as appropriate.
> Hmm. Given that they're only ex
Lamar Owen <[EMAIL PROTECTED]> writes:
> How is this search path defined? Blindly using libdir is not ok --
Why not?
The search path is defined in postgresql.conf (and I see Peter forgot
to add an example to the postgresql.conf.sample file), but the default
is the backend-compile-time $libdir.
On Friday 20 July 2001 18:45, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > On to the next batch There are a few perl and python scripts shipped
> > as examples -- every last one of them shebangs to '/usr/local/perl' or
> > '/usr/local/python' -- to make them usable, I patch th
On Fri, Jul 20, 2001 at 07:05:46PM -0400, Trond Eivind Glomsr?d wrote:
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > BTW, the only python shebangs I can find in CVS look like
> > #! /usr/bin/env python
> > Isn't that OK on RedHat?
>
> It is.
Probably the perl scripts should say, likewise,
"Steve Howe" <[EMAIL PROTECTED]> writes:
>> (Thinks for awhile...) You're not using PQsetnonblocking() are you,
>> by any chance?
> No, I'm not.
Drat, another perfectly good theory down the drain :-(.
Well, we're not going to find out anymore until we discover what the
error code actually is -
Tom Lane <[EMAIL PROTECTED]> writes:
> BTW, the only python shebangs I can find in CVS look like
> #! /usr/bin/env python
> Isn't that OK on RedHat?
It is.
--
Trond Eivind Glomsrød
Red Hat, Inc.
---(end of broadcast)---
TIP 5: Have you che
> > "As expected"? That's not what I'd expect, especially not for a
> > behavior that's dependent on the size of an *outgoing* message.
> It is expected, because it's the default message when a PQexec() query
> returns NULL: pqReadData() will return nothing yet no error is signed.
> Of course, th
Lamar Owen <[EMAIL PROTECTED]> writes:
> Ok, let's look. First, there is a createlang issue: during build, @libdir@
> as referenced in the createlang script references /usr/lib, instead of
> /usr/lib/pgsql, which is desired.
Okay, that problem is gone in current sources, anyway (createlang no
[cc: to GENERAL replacedby cc: to HACKERS]
On Friday 20 July 2001 17:14, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > The biggest patching by far is
> > in the regression tests, which really are not designed to live outside
> > the source tree, but can be munged into shape fairly e
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Steve Howe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 5:17 PM
Subject: Re: [HACKERS] Large queries - again...
> "Steve Howe" <[EMAIL PROTECTED]> writes:
> > It returns "Error: pqReadData
"Steve Howe" <[EMAIL PROTECTED]> writes:
> It returns "Error: pqReadData() -- read() failed: errno=0 No error
> " as expected when a nil pointer is returned.
"As expected"? That's not what I'd expect, especially not for a
behavior that's dependent on the size of an *outgoing* message.
Hello Tom,
It returns "Error: pqReadData() -- read() failed: errno=0 No error
" as expected when a nil pointer is returned.
Best Regards,
Steve Howe
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Steve Howe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Frid
"Steve Howe" <[EMAIL PROTECTED]> writes:
> Nope, I'm 100% sure that the libpq.dll used is the one I just
> compiled. And I never installed an older libpq.dll on this system.
Hmph. So what is left in PQerrorMessage() after the failure?
regards, tom lane
-
mlw <[EMAIL PROTECTED]> writes:
> Does anyone know if it is possible to define a Postgres C function as
> taking a variable number of parameters? The fmgr code will pass it,
> but I don't see any way to use "create function" to register it.
No, it's not. There is some (purely speculative) suppor
Hello Tom,
Nope, I'm 100% sure that the libpq.dll used is the one I just
compiled. And I never installed an older libpq.dll on this system.
My application loads specifically the libpq.dll I compiled (I use
the full library path on the call to LoadLibrary() call, so there is no way
jozzano <[EMAIL PROTECTED]> writes:
> My system is i686/Linux Mandrake 7.0/Postgresql v-7.0.2.
> I found a bug in the sql command ALTER TABLE ADD CONSTRAINT...,
This bug seems to be already fixed in release 7.1.
regards, tom lane
---(end of broad
Straight out of Allied peace talks, we've got this article up at mysql.com
http://www.mysql.com/news/article-76.html
One wonders what happened to the postal or email systems that this couldn't
have been delivered privately.
In all honesty, it appears mysql.org was overdue, the level of rhetoric
On Thursday 19 July 2001 06:08, you wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> I think it should be off on user tables by default, but kept on system
> tables just for completeness. It could be added at table creation time
> or from ALTER TABLEL ADD. It seems we just use them too mu
Just another way to get your name on the top 10 lists, eh?
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
Hi !
My system is i686/Linux Mandrake 7.0/Postgresql v-7.0.2.
I found a bug in the sql command ALTER TABLE ADD CONSTRAINT..., when I tried to add a
composite foreign key constraint
(a FK with more than one attribute). The problem is in the file identified by
$Header: /home/projects/pgsql/cvsro
Well, I tested the query you sent, and I got these results accessing the
data:
1) libpq from Windows (freshly compiled from 7.1.2 sources): Error:
pqReadData() -- read() failed: errno=0
No error
2) ODBC from Windows: It works ok.
Steve Howe <[EMAIL PROTECTED]> escreveu nas notícias de
mensag
Bruce Momjian <[EMAIL PROTECTED]> writes:
> What about moving the oid column out of the tuple header. This saves 4
> bytes in the header in cases where there is no oid on the table.
No it doesn't --- at least not on machines where MAXALIGN is eight
bytes.
I don't think this is worth the trouble
Hi !
My system is i686/Linux Mandrake 7.0/Postgresql v-7.0.2.
I found a bug in the sql command ALTER TABLE ADD CONSTRAINT..., when I tried to add a
composite foreign key constraint
(a FK with more than one attribute). The problem is in the file identified by
$Header: /home/projects/pgsql/cvsro
"\(::\) Bob Ippolito" <[EMAIL PROTECTED]> writes:
> semantic=# DROP table ttmptable;
> DROP
> semantic=# create temp table ttmptable(lookup_id int, rating int);
> CREATE
> semantic=# SELECT doEverythingTemp(20706,2507);
> ERROR: Relation 4348389 does not exist
Yeah, temp tables and plpgsql funct
On Friday 20 July 2001 08:09, The Hermit Hacker wrote:
> there, and I just cleared out about 500Meg+ of old garbage ... 1.2gig free
> again ...
Unless I get protests to the contrary, I'm going to remove all but the last
supported RPM versions in /pub/binary for each major version. IE, all but
"Steve Howe" <[EMAIL PROTECTED]> writes:
> I downloaded the PostgreSQL v7.12 sources, compiled libpq.dll using
> Microsoft's Visual C++ 6.0, and tried sending a large query.
> The problem is, when the query is > 8192 large, a NULL pointer is
> returned from PQexec().
It sure sound
> As I mentioned already I'm implementing updatable cursors
> in ODBC and have half done it. If OIDs would be optional
> my trial loses its validity but I would never try another
> implementation.
But how can you do that ? The oid index is only created by
the dba for specific tables, thus your u
Reported by Tatsuo with 1000 backends all waking up at the same time:
* Create spinlock sleepers queue so everyone doesn't wake up at once
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a har
Tom mentioned what should be stored in the OID system column if no oid's
are in the table. He also mentioned that he doesn't want a
variable-length tuple header so will always have an oid system column.
What about moving the oid column out of the tuple header. This saves 4
bytes in the header i
pg_dump/pg_dumpall fail with the following messages (verbose output
selected):
...
-- dumping out user-defined procedural languages
-- dumping out user-defined functions
failed sanity check, type with oid 59770787 was not found
OS: Linux kernel 2.2.16
PostgreSQL v. 7.0.3
I've seen similar pos
Someone on IRC just mentioned that mere mortals can create tables in
template1. If the user restricts template1 access to users via
pg_hba.conf, certain commands will not work that use template1
connection.
Any solutions? I think we need table creation permissions even if we
don't overhaul th
Does anyone know if it is possible to define a Postgres C function as taking a
variable number of parameters? The fmgr code will pass it, but I don't see any
way to use "create function" to register it.
Does one have to issue a create function for each additional parameter?
I am trying to port s
there, and I just cleared out about 500Meg+ of old garbage ... 1.2gig free
again ...
On Fri, 20 Jul 2001, Chris Bowlby wrote:
> On Thu, 19 Jul 2001, Tom Lane wrote:
>
> Hi Tom,
>
> I removed an ISO that Corey had made for me, that should free up some
> space.
>
> > /home/projects/pgsql partiti
On Fri, 20 Jul 2001, Chris Bowlby wrote:
> On Thu, 19 Jul 2001, Tom Lane wrote:
>
> Hi Tom,
>
> I removed an ISO that Corey had made for me, that should free up some
> space.
And I removed some stuff.
Vince.
>
> > /home/projects/pgsql partition at hub.org is down to zero free space...
> >
> >
On Thu, 19 Jul 2001, Tom Lane wrote:
Hi Tom,
I removed an ISO that Corey had made for me, that should free up some
space.
> /home/projects/pgsql partition at hub.org is down to zero free space...
>
> regards, tom lane
>
> ---(end of broadcast)-
Tom Lane wrote:
> >> What's wrong with 64-bit oids (except extra 4bytes)?
>
> > Portability, mostly.
>
> Oh, there's one other small problem: breaking the on-the-wire protocol.
So 8-byte-OID is for PostgreSQL 8? :-)
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services
I'm pretty new to postgresql.. I'm using a fresh compile/install of postgresql 7.1.2
without any special options.. but here's my problem:
semantic=# create temp table ttmptable(lookup_id int, rating int);
CREATE
semantic=# SELECT doEverythingTemp(20706,2507);
doeverythingtemp
-
Hello all,
I've tried again sending large queries using libpq on Windows
environment, without success.
I downloaded the PostgreSQL v7.12 sources, compiled libpq.dll using
Microsoft's Visual C++ 6.0, and tried sending a large query.
The problem is, when the query is > 8192
45 matches
Mail list logo
