> -Original Message-
> From: Mike Aubury [mailto:[EMAIL PROTECTED]]
> Sent: 20 February 2003 19:10
> To: Dave Page; Tom Lane; Hannu Krosing
> Cc: Dave Cramer; Peter Eisentraut; Pgsql Hackers
> Subject: Re: [HACKERS] request for sql3 compliance for the
> update command
>
>
> Informix s
Hi,
The new cluster is cool in that :
1. It works
2. It saves the indisclustered status
However, after a dump and restore, this indisclustered status will be lost.
Would it be an idea to issue a CLUSTER command after the CREATE TABLE
statement in SQL dumps for tables that have an indisclustered
> The new cluster is cool in that :
>
> 1. It works
> 2. It saves the indisclustered status
>
> However, after a dump and restore, this indisclustered status will be
lost.
> Would it be an idea to issue a CLUSTER command after the CREATE TABLE
> statement in SQL dumps for tables that have an indisc
I am wondering if there is any difference in performance between
using ecpg and libpq. If I understand the concept of ecpg correctly,
calls to the lecpg interface are internally converted to calls to libpq.
So there is no big difference at all. Is this right?
Regards, Christoph
--
On 21 Feb 2003 at 11:26, Christoph Haller wrote:
>
> I am wondering if there is any difference in performance between
> using ecpg and libpq. If I understand the concept of ecpg correctly,
> calls to the lecpg interface are internally converted to calls to libpq.
>
> So there is no big differenc
I am wondering if there is a fundamental difference in performance
between
using embedded SQL or libpq functions in a C application. If I
understand the
documentation correctly, calls to lecpg are simply transferred to calls
to libpq.
So, the difference in performance is, if any, marginal. Is this
Adam Witney wrote:
PL/R compiles and installs ok on my OS X 10.2.4, the corresponding line is
gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -flat_namespace -bundle -undefined suppress plr.o
pg_conversion.o pg_backend_support.o pg_userfuncs.o pg_rsupport.o -L/sw/l
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
>> Would it be an idea to issue a CLUSTER command after the CREATE TABLE
>> statement in SQL dumps for tables that have an indisclustered index?
Yeah...
> Actually, rather than a full-blown CLUSTER, how about...:
> UPDATE pg_index SET indiscl
Brandon Craig Rhodes <[EMAIL PROTECTED]> writes:
> The current CVS version of PostgreSQL gives us the error:
> ERROR: UNION/INTERSECT/EXCEPT member statement
> may not refer to other relations of same query level
> when given the following test case, despite the fact that the EXCE
Joe Conway writes:
> Below is the Makefile. The key problem is that I need to get a "bundle"
> built instead of a "dynamiclib", or so I am told.
The PostgreSQL makefiles do use "bundle". Tell the user to use the
standard distribution.
--
Peter Eisentraut [EMAIL PROTECTED]
-
Just some fixups to a couple contrib directories I was trying out.
. replace CREATE OR REPLACE AGGREGATE with a separate DROP and CREATE
. add DROP for all CREATE OPERATORs
. use IMMUTABLE and STRICT instead of WITH (isStrict)
. add IMMUTABLE and STRICT to int_array_aggregate's accumulator functi
On Fri, Feb 21, 2003 at 11:26:02AM +0100, Christoph Haller wrote:
> I am wondering if there is any difference in performance between
> using ecpg and libpq. If I understand the concept of ecpg correctly,
> calls to the lecpg interface are internally converted to calls to libpq.
That's correct. The
On Thu, 20 Feb 2003, Kevin Brown wrote:
> Tom Lane wrote:
> > UPDATE totals SET
> > xmax = ss.xmax, xmin = ss.xmin, ...
> > FROM
> > (SELECT groupid, max(x) AS xmax, ... FROM details GROUP BY groupid) ss
> > WHERE groupid = ss.groupid;
>
> As long as any individual item th
So I'm reading Sun's _Configuring & Tuning Databases on the Solaris
Platform_ book (ISBN: 0-13-083417-3). One of the first things mentioned
in the book is that UFS is, well, slow. Especially because of how
Solaris utilizes it. The authors contend that enabling directio(3C) can
increase performa
PL/R compiles and installs ok on my OS X 10.2.4, the corresponding line is
gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes
-Wmissing-declarations -flat_namespace -bundle -undefined suppress plr.o
pg_conversion.o pg_backend_support.o pg_userfuncs.o pg_rsupport.o -L/sw/lib
-L/sw/lib/R/bin
On Thu, Feb 20, 2003 at 03:21:09PM -0500, Tom Lane wrote:
> "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> > question about pgsql's time zone parsers. It appears there's at least
> > two, since SET TIME ZONE accepts strings like 'US/Eastern', while general
> > timestamp parsing doesn't:
>
> The
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> If the time zone came back UNKOWN, we go ahead and see if tzset() can
> interpret it. Criteria for failure: if the timezone offset came back 0,
> and the reported tzname[0] is the same as the string that we passed in. If
> it does, we fire a NOTICE
I'm seeing a regression failure on the horology test on two different
machines. I'd venture a guess that it is related to this change:
http://archives.postgresql.org/pgsql-committers/2003-02/msg00166.php
Joe
---(end of broadcast)---
TIP 5: Have
When compiling CVS HEAD with SSL enabled, I get this warning:
be-secure.c: In function `open_server_SSL':
be-secure.c:707: warning: assignment from incompatible pointer type
The code in question is:
/* set up debugging/info callback */
SSL_CTX_set_info_callback(SSL_context, info_
AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when
lower(expr) LIKE 'foo' provides a solution that can use an index and is
more standard, too?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you sea
Peter Eisentraut writes:
> Example: Create a cluster with non-C CTYPE, create a LATIN1 database,
> create a table with a bytea column, and store something with non-ASCII
> characters in it. Then change the client encoding (to UNICODE, say) and
> read the data. I stored 'ätsch bätsch' and got 'Ã
21 matches
Mail list logo
