On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
I am getting Undefined symbols in build ecpg
...
ld: 0711-317 ERROR: Undefined symbol: .PQfinish
ld: 0711-317 ERROR: Undefined symbol: .PQexec
ld: 0711-317 ERROR: Undefined symbol: .PQclear
ld: 0711-317 ERROR: Undefined symbol:
On Fri, 19 Sep 2003 11:35:35 -0700, Jenny Zhang [EMAIL PROTECTED]
wrote:
I posted more results as you requested:
Unfortunately they only confirm what I suspected earlier:
2) - Index Scan using i_ps_suppkey on partsupp
(cost=0.00..323.16 rows=80 width=34)
Michael Meskes wrote:
On Tue, Sep 23, 2003 at 04:21:10PM -0400, Samuel A Horwitz wrote:
I am getting Undefined symbols in build ecpg
...
ld: 0711-317 ERROR: Undefined symbol: .PQfinish
ld: 0711-317 ERROR: Undefined symbol: .PQexec
ld: 0711-317 ERROR: Undefined symbol: .PQclear
ld: 0711-317 ERROR:
Are these patches going to be applied soon?
On Wed, 24 Sep 2003,
[ISO-8859-1] Hans-Jürgen Schönig wrote:
Date: Wed, 24 Sep 2003 13:18:32 +0200
From: [ISO-8859-1] Hans-Jürgen Schönig [EMAIL PROTECTED]
To: Michael Meskes [EMAIL PROTECTED]
Cc: Samuel A Horwitz [EMAIL PROTECTED],
I am writing a backend C function whose behavior should depend on the
setting of a new runtime parameter that can be set with SET. I have
several questions concerning how to implement this, as I can find no
information in the documentation.
- How can I introduce a new variable (e.g., XXX) to the
Samuel A Horwitz wrote:
Are these patches going to be applied soon?
Correct.
I had the same error on AIX 5.1 last week (see hackers' list).
As far as 7.4beta is referred two additional patches are needed (see
postings by Tom Lane on this topics).
Adding the linker options will solve your
On Tue, 2003-09-23 at 22:40, Greg Stark wrote:
[But then I'm not a fan of treating pg_dump files as if they were backups.]
If you don't use pg_dump for backups what do you use? Stop the database
and copy the data directory? That is not a valid choice for most people.
[EMAIL PROTECTED] writes:
- How can I introduce a new variable (e.g., XXX) to the system so that
for example SET XXX=1 will work?
The basic thing is to add an appropriate table entry to guc.c. You
might try searching the sources for all references to one of the
lesser-used GUC variables,
Manfred Koizar [EMAIL PROTECTED] writes:
Cutting down the number of heap page fetches if PF1 * L P and P
effective_cache_size seems like an obvious improvement, but I was not
able to figure out where to make this change. Maybe it belongs into
costsize.c near
run_cost +=
Hello ,
I m new to this list .
Hopefully some feedback is coming to my questions.
1) Did somebody a compile with the Intel ICC inclusive performance logging
2) Is there a hint where to find in the source the REGEX module and is there any
connection to inheritance of table.(module ???).
3)
Slackware 8.1, linux 2.4.18 i586, gcc version 2.95.3 20010315 (release)
This is perl, v5.6.1 built for i386-linux (is this too old?)
parts from config.log
configure:4214: checking for perl
configure:4232: found /usr/local/bin/perl
configure:4244: result: /usr/local/bin/perl
configure:4253:
Tom Lane writes:
The basic thing is to add an appropriate table entry to guc.c.
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function? All runtime variables are
hard-coded into the backend?
Thanks for your help.
Cheers,
Brook
[EMAIL PROTECTED] writes:
Tom Lane writes:
The basic thing is to add an appropriate table entry to guc.c.
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function?
Not at the moment, although IIRC the guc.c data structures are designed
to make
[EMAIL PROTECTED] wrote:
Tom Lane writes:
The basic thing is to add an appropriate table entry to guc.c.
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function? All runtime variables are
hard-coded into the backend?
Maybe you can implement your
Hello Tom,
In trying to come up with a test scenario, I loaded this db into a 7.4 db
and got a similar message. It shows up as follows:
dropsites= begin;
BEGIN
dropsites= delete from te_users where reseller = 21;
ERROR: attempted to mark4update invisible tuple
CONTEXT: PL/pgSQL function
On Wed, Sep 24, 2003 at 01:18:32PM +0200, Hans-Jrgen Schnig wrote:
Correct.
I had the same error on AIX 5.1 last week (see hackers' list).
As far as 7.4beta is referred two additional patches are needed (see
postings by Tom Lane on this topics).
So adding $(filter -lssl -lm) does fix this?
Andreas Pflug writes:
Maybe you can implement your stuff using a temporary table?
Perhaps, but the runtime variable route is much more natural from a
user interface perspective, as there are strong parallels with
existing variables. I'll see what I can do in that arena first.
Thanks for the
Wade Klaver [EMAIL PROTECTED] writes:
In trying to come up with a test scenario, I loaded this db into a 7.4 db
and got a similar message. It shows up as follows:
ERROR: attempted to mark4update invisible tuple
CONTEXT: PL/pgSQL function c_delete_categories line 14 at SQL statement
Is
Nigel J. Andrews wrote:
I never knew running indent was so damn complicated. All three of my
development systems can not manage it without throughing a fault (I've
absolutely no idea why indent in the shell works but doesn't in pgindent on
one).
Anyway, has anyone pgindented the version
Tom Lane wrote:
[EMAIL PROTECTED] writes:
I take it there is not way to do this dynamically, for example to
support a dynamically loaded function?
Not at the moment, although IIRC the guc.c data structures are designed
to make it possible to add things on-the-fly. (There's a pointer table
that's
Matthew T. O'Connor [EMAIL PROTECTED] writes:
On Tue, 2003-09-23 at 22:40, Greg Stark wrote:
[But then I'm not a fan of treating pg_dump files as if they were backups.]
If you don't use pg_dump for backups what do you use? Stop the database
and copy the data directory? That is not a
Bruce Momjian wrote:
It is actually this code that is causing it:
LOOPBYTE(
if ((sign[i] 0xff) != 0xff)
PG_RETURN_POINTER(retval);
);
With the macro being:
#define LOOPBYTE(a) \
for(i=0;iSIGLEN;i++) {\
Tom Lane wrote:
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: [EMAIL PROTECTED] 03/09/19 17:47:59
Modified files:
src/template : darwin
Log message:
Latest version of gcc from Apple does not work well with -traditional-cpp
(it rejects some
On Wed, 24 Sep 2003, Bruce Momjian wrote:
Nigel J. Andrews wrote:
I never knew running indent was so damn complicated. All three of my
development systems can not manage it without throughing a fault
...
There are about 6 files that can't be run through pgindent, and tsearch2
has
Bruce Momjian writes:
Yes, I saw this failure in Atlanta on their Mac's. The compiler is
clearly broken with that flag. Why is that flag used anyway? I see it
in template/darwin, or it used to be there before the commit.
In early versions you needed to use it to turn of the header
Peter Eisentraut [EMAIL PROTECTED] writes:
In early versions you needed to use it to turn of the header precompiler.
(The precompiler is apparently buggy.) Now there is a separate flag for
that.
I just two days ago verified that with Apple's latest compiler release,
you can only build PG with
Philip Yarra wrote:
It's funny timing - I had to prepare a comparison between PostgreSQL and
MySQL recently, explaining why we would prefer PostgreSQL. I know some
people here have issues with the MySQL crashme test results, but I have to
say I found it possibly one of the best postgreSQL
Gottfried F. Zojer writes:
1) Did somebody a compile with the Intel ICC inclusive performance logging
There have been varying degrees of success with the Intel compiler suite.
The 7.4 development branch can be compiled with icc, earlier versions not
without extra hacking. Some people have
Joe Conway writes:
I had a patch about 80% complete to do this, but it was rejected. The
comment was that I should use a temp table instead. I still think it
would be useful myself. See this thread:
http://archives.postgresql.org/pgsql-hackers/2002-12/msg00988.php
I'm sorry that was
[EMAIL PROTECTED] writes:
As far as the general utility of it goes, I claim that it could be
quite valuable. I am thinking of complex new datatypes (that might be
dynamically loaded) that could benefit from having some run-time
variables specify some aspect of their behavior. Currently, we
I've been observing a interesting behavior with our DBT-2 workload. It
appears that a commit to a transaction is taking some time to occur.
I'll try to briefly describe what we're seeing. The transaction goes
something like this:
1. BEGIN
2. SELECT d_next_o_id
INTO current_o_id
FROM
Wade Klaver [EMAIL PROTECTED] writes:
OK, I set you up a login on arch.wavefire.com
Okay, what I find is this sequence of events:
1. delete from te_users where id = 954;
2. The ON DELETE CASCADE RI constraint propagates this to a delete of
some row(s) in c_categories.
3. That fires the
On 22 Sep, Greg Stark wrote:
[EMAIL PROTECTED] writes:
http://developer.osdl.org/markw/74/
Are those response times in the right unit? 7-10s?
Yeah, the database really isn't tuned at all. I've gotten some
suggestions off the list that I will be trying. I'll report them as I
complete
Peter Eisentraut [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] writes:
As far as the general utility of it goes, I claim that it could be
quite valuable. I am thinking of complex new datatypes (that might be
dynamically loaded) that could benefit from having some run-time
variables specify
[EMAIL PROTECTED] writes:
This only occurs about 1% of the time. I'm not sure how else to analyze
the situation. Let me know if I can clarify anything or provide any
more information.
Are you running more than one of these transactions in parallel,
overlapping?
--
Peter Eisentraut
On 25 Sep, Peter Eisentraut wrote:
[EMAIL PROTECTED] writes:
This only occurs about 1% of the time. I'm not sure how else to analyze
the situation. Let me know if I can clarify anything or provide any
more information.
Are you running more than one of these transactions in parallel,
I wonder if we should have an auto-responder so when someone says they
are running 6.5, we can reply --- Yikes, upgrade.
In fact, we could go with a little chart:
7.3.4 great
7.3.0-3 please upgrade, it is easy
7.2 consider upgrading
7.1 wow, that is old
[EMAIL PROTECTED] writes:
On 22 Sep, Greg Stark wrote:
Are those response times in the right unit? 7-10s?
The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show
any table scans. They appears to be mostly index scans. There aren't
any batch updates.
Would it be easy to
Robert Treat [EMAIL PROTECTED] writes:
Slackware 8.1, linux 2.4.18 i586, gcc version 2.95.3 20010315 (release)
This is perl, v5.6.1 built for i386-linux (is this too old?)
Hm. On HPUX 10.20, I can report that CVS tip plperl seems to work with
perl 5.8.0 (at least it can execute a simple
On Wed, 24 Sep 2003, Tom Lane wrote:
Wade Klaver [EMAIL PROTECTED] writes:
OK, I set you up a login on arch.wavefire.com
Okay, what I find is this sequence of events:
1. delete from te_users where id = 954;
2. The ON DELETE CASCADE RI constraint propagates this to a delete of
some
On 24 Sep, Greg Stark wrote:
[EMAIL PROTECTED] writes:
On 22 Sep, Greg Stark wrote:
Are those response times in the right unit? 7-10s?
The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show
any table scans. They appears to be mostly index scans. There aren't
any batch
[EMAIL PROTECTED] wrote:
2. SELECT d_next_o_id
INTO current_o_id
FROM district
WHERE d_w_id = 1
AND d_id = 8
3. UPDATE district
SET d_next_o_id = d_next_o_id + 1
WHERE d_w_id = 1
AND d_id = 8
I don't know exactly what you are trying to do
but usualy in cases like this, in
[EMAIL PROTECTED] writes:
On 24 Sep, Greg Stark wrote:
[EMAIL PROTECTED] writes:
On 22 Sep, Greg Stark wrote:
Are those response times in the right unit? 7-10s?
No problem: http://developer.osdl.org/markw/misc/plana.out
Ok, I guess I misunderstood you. These queries are taking 0.5ms
On Sun, Sep 21, 2003 at 05:37:59PM +0200, Peter Eisentraut wrote:
I've looked through the messages in the backend and identified some areas
that still deserve some cleanup. Below I list some issues that deserve
some discussion or that deserve being remembered by other developers.
id, oid,
Ruben Safir Secretary NYLXS wrote:
And what is the licensing?
Looking at their web pages, they provide the services, not the software.
On Tue, Sep 23, 2003 at 06:06:00PM -0700, Richard Schilling wrote:
Just wanted to drop you all a quick note that CogBilling, an online billing system which
I'll be posting the license on our website soon. But, the license for our original
work, prior to an Open Source release, is an open source license except that the end
user cannot distribute the product beyond their immediate control (e.g. their
company). And, the changes one client makes to
And what is the licensing?
On Tue, Sep 23, 2003 at 06:06:00PM -0700, Richard Schilling wrote:
Just wanted to drop you all a quick note that CogBilling, an online billing system
which integrates with GnuCash, is now available for review at
http://www.rsmba.biz/download. CogBilling is an
Just wanted to drop you all a quick note that CogBilling, an online billing system
which integrates with GnuCash, is now available for review at
http://www.rsmba.biz/download. CogBilling is an online database driven billing system
written entirely on open source products. In its present
Zak Greant wrote:
Thanks for the Cc: and for noticing the fixes!
To be fair, Paul DuBois and Andrey Stroganov did the actual work - I
only did some pointing and grunting. I am not sure that we have removed
everything yet - I still need to do a full sweep of the docs. In any
case, this is
Alvaro Herrera [EMAIL PROTECTED] writes:
Are you going to change relation to table? In most cases that is
the intended meaning. ISTM in some other cases it refers to anything
that can appear in pg_class, but I'm not 100% sure.
Quite a lot of the code considers relation to mean anything that
50 matches
Mail list logo