- Begin Forwarded Message -
>From To:[EMAIL PROTECTED] Mon Apr 19 11:08:57 2004
Date: Mon, 19 Apr 2004 11:08:57 METDST
To: [EMAIL PROTECTED] (Tom Lane)
Subject: Re: [HACKERS] executing prepared select, missing RowDescription info
In-Reply-To: <[EMAIL PROTECTED]>; from "Tom
>
>
> How can I use a prepared select statement as mentioned in the documentation=
> on SQL PREPARE. Preparing the statement is easy, the problem is using the =
> plan to get a cursor. My assumption is the SQL OPEN command is not document=
> ed or there is some other libpq API to make this happe
>
> Tom Lane wrote:
> > I said:
> > > If there wasn't disk space enough to hold the clog page, the checkpoint
> > > attempt should have failed. So it may be that allowing a short read in
> > > slru.c would be patching the symptom of a bug that is really elsewhere.
> >
> > After more staring at t
Fairly good idea IMHO, especially considering Christopher's point
about the unlikeliness of needing an exact count anyway.
Regards, Christoph
>
> How about:
>
> Implement a function "estimated_count" that can be used instead of
> "count". It could use something like the algorithm in
> src/
>
> Joshua D. Drake wrote:
>
> > Hello,
> >
> > If Win32 actually makes it into 7.5 then yes I believe 8.0 would be
> > appropriate.
>
> It might be interesting to track Oracle's version number viz. its
> feature list. IOW, a PostgreSQL 8.0 database would be feature
> equivalent to an Oracle
There is a pgsql-performance list, which was created for questions like yours.
Your problem was brought up many times before, so searching the archives is
an alternative.
Regards, Christoph
>
> Hi Everyone,
>
> This is my first post here so please tell me to go somewhere else if this
> is
>
> I am putting together a DB that records information about a set of web
> sites and how they link to one another. As one site refers to another, I
> monitor the first site and then record when I find the referred site.
>
> [snip]
>
> I also have a function called add_site that adds the newly
>
> On Wednesday 22 October 2003 07:37, Neil Conway wrote:
> > The second audience is the people who are really interested in exactly
> > what has changed between the new release of PostgreSQL and the previous
> > release series. It is important that we make it easy for an admin
> > planning a Pos
> We have a development server running
>
> OS - Linux development-server 2.4.20-openmosix-r4 #1 SMP Mon May 19
02:32:52
> PDT 2003 i686 Intel(R) Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux
>
> Database - PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC)
> 3.2.1
>
> We have a table ctce
delayed, and requires the approval
of the moderators, for the following reason(s):
The author (Christoph Haller <[EMAIL PROTECTED]>)
is not a member of any of the restrict_post groups.
---(end of broadcast)---
TIP 3: if posting/reading through Use
>
> hi
> whenever i call an execute on a prepared statement, i get the return
value
> of PQcmdTuples() as NULL even if the query did modify tuples...
> how can i get the number of affected tuples?
> thanx in adv.
> rahul
>
I'm observing the same pretty odd behavior.
Do we both expect something wron
>
> Paulo Scardine wrote:
> > LockAcquire has a "dontWait" parameter, which do just what I want.
> >
> > The executor level calls "heap_open(relid, RowShareLock)" when doing
"FOR
> > UPDATE"s.
> > Should we define something like RowShareLockNoWait, so heap_open()
or other
> > lower level functions
>
> I have just seen a nice feature provided by DB2 which seems very
useful
> to me.
> When importing huge amounts of data (dozens of gigs) with the help of
> COPY errors might occur from time to time (especially when migrating).
> The problem with COPY is that it stops after the first error. So i
>
> Rod Taylor wrote:
> -- Start of PGP signed section.
> > On Fri, 2003-07-18 at 19:46, Paulo Scardine wrote:
> > > My boss is asking for something like Oracle's "SELECT FOR UPDATE
NOWAIT".
> > >
> > > Is there any such feature? If no, should I look forward into
implementing
> > > this? Any advice
>
> I had a bug in one of my queries that wasn't detected by pg because if
> filled in the from clause by itself. Take for example a querie like
>
> select foo.a;
>
> which I guess is transformed to
>
> select foo.a
> from foo;
>
> Is this really a good thing to do? Is it part of the standard? Can
>
> on one of the AIX4.3.3,
> the 7.1.3 pgsql is installed by root on the system,
> then I tried to install
> 7.3.1/or 7.3.2 under another non-root user,
> I can run make, make check, make install,
> postmaster can start without errors, but when
> I try to createdb, here're some errors -
>
> cr
>
> Hmm, maybe the transformation in the other direction is the culprit.
> What I do is call ts1 = PGTYPEStimestamp_atot("2000-7-12 17:34:29",
NULL); followed by a text = PGTYPEStimestamp_ttoa
(ts1); Needless to say the resulting text is not "2000-7-12 17:34:29".
:-(
>
I could not dig too deep into
>
> I started working on date/timestamp in ecpg. So far I can read date
> types from the DB and I can insert date into the DB. However there
seems
> to be a bug in converting timestamp to ascii or vice versa.
>
> If anyone of you knows more about timestamp2tm etc. could you please
> have a look at
>
> On Tue, 4 Nov 2003 18:28:12 -0300, Franco Bruno Borghesi
> <[EMAIL PROTECTED]> wrote:
> >Below you can find a simplified example of a real case.
> >I don't understand why I'm getting the "john" record twice.
>
> ISTM you have found a Postgres 7.3 bug.
>
> I get one john with
> PostgreSQL 7.1.3
>
> Christoph Haller <[EMAIL PROTECTED]> writes:
> > I've installed postgresql-7.3.2 on HP-UX yesterday.
> > When running 'gmake -C regress check'
> > the process does not return.
>
> See doc/FAQ_HPUX:
>
> : The parallel regression test sc
Maybe this is related to the thread [HACKERS] regression failure in CVS
HEAD
I've installed postgresql-7.3.2 on HP-UX yesterday.
When running 'gmake -C regress check'
the process does not return.
File ./src/test/regress/regression.out shows
parallel group (13 tests): float8 int2 varchar text
Have you seen
libpq - C Library
Functions Associated with the COPY Command
This is best way to INSERT large amounts of data.
Regards, Christoph
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
> Given the repeatedly-asked-for functionalities (like error codes)
> for which the stopper has been the long-threatened protocol revision,
> I'd think it might be boring, but would hardly be thankless. Heck, I'd
> expect a few whoops of joy around the lists.
>
Yes. Error codes would be great.
>
> Just as a suggestion: In most of my applications, we have a security
layer
> which is implemented through server-side functions. These functions
keep a
> table updated which contains:
>
> lock_table
> record_id
> lock_user
> time_locked
That's an excellent and even portable idea.
>
> This all
>
> That's my fallback position. Obviously, this will lead to false
> positives depending on server load. In my case, I'm targeting between
> 30-50 users so its likely to throw timeouts for various reasons other
> than locks even though my queries of interest are generally select a
> from b wher
>
> Michael Meskes kirjutas K, 26.02.2003 kell 13:00:
> > Did anyone ever think about creating a library that is able to
handle
> > our numeric datatype? I'm currently thinking about adding this
datatype
> > among others to the ones know to ecpg so no one is forced to convert
> > them or work on t
>
> I am trying to emulate a pessimistic locking system you would find in
an
> old school database file system, for example cobol. Generally, when a
> cobol program tries to read a record that is locked by somebody else,
> the read fails and either a message is displayed by the user or a
error
>
>
> On Tuesday 25 February 2003 09:28, Christoph Haller wrote:
> > > On Mon, Feb 24, 2003 at 07:53:05PM +, Darko Prenosil wrote:
> > > > I need two answers I did not find in documentation :
> > > > How can I get exact number of rows in DECLARED CURS
> > > How can I get information is TRANSACTION already started ?
> I did not mean 'TRANSACTION ISOLATION LEVEL', but 'TRANSACTION LEVEL'
!
> OK, it is bad construction - my fault !
> What I meant is : IS-TRANSACTION-ALREADY-STARTED ?
> I used 'TRANSACTION LEVEL' because I saw that Bruce is working
>
> On Mon, Feb 24, 2003 at 07:53:05PM +, Darko Prenosil wrote:
> > I need two answers I did not find in documentation :
> > How can I get exact number of rows in DECLARED CURSOR ?
> > OK, I can FETCH until NULL, but this does not fits my needs !
You may want to use FETCH ALL, otherwise wha
>
> On Mon, 2003-02-24 at 07:22, Christoph Haller wrote:
> > I've noticed subsequent executions of the same insert command are
slow.
> > I've searched the list archives for this matter and found several
> > entries
> > related, including suggestions how t
>
> > The key word REPEATED directs INGRES to encode the INSERT and save
its
> > execution plan when it is first executed. This encoding can account
for
> > significant performance improvements on subsequent executions of the
> > same INSERT.
>
> > What do you others think of it?
>
> You can do th
I've noticed subsequent executions of the same insert command are slow.
I've searched the list archives for this matter and found several
entries
related, including suggestions how to speed up.
The standard answer from the core team is, use COPY.
Sorry, but this is from an application point of vie
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
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
--
> >
> > I was wondering what kind of functions/constants exist in Postgre to
dig
> up
> > metadata. I barely scratched the surface of Oracle but I know you
find
> > things like user_tables there that can be used to extract info about
your
> > tables. What I'm looking for is some kind of functions t
>
> Consider this query on a large table with lots of different IDs:
>
> SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
>
> It has an index on id. Obviously, the index helps to evaluate
count(id)
> for a given value of id, but count()s for all the `id's should be
> evaluated,
>
> This is a fairly spectacular failure :-(. As far as I can see from
the
> semctl and shmctl man pages, the only plausible reason for EINVAL is
> that something had deleted the semaphores and shared memory out from
> under Postgres. I do not believe that Postgres itself could have done
> that
Hi,
I've seen this (see below) in the postmaster's log-file.
I doubt this is normal behaviour.
I'm using PostgreSQL 7.2.3 on hppa-hp-hpux10.20, compiled by GCC 2.95.2
Does anybody know what may cause calls to semctl resp. shmctl
(semaphore control resp. shared memory control) to fail?
The applic
39 matches
Mail list logo
