[GENERAL] edb-debugger, debugging pl/pgsql

Hi, I don't know if here is the right place to post this, but anyway ... Does anybody know if there is any binary dist for win32 edb-debugger for pgsql8.3? If not, do you know which compiler I have to use? I don't need to install anything on the client side where is my pgadmin, right? thx Josep

Re: [GENERAL] Connection reset by peer / broken pipe

Jeff Wigal wrote: >>> I am running Postgres 8.2.3 and am seeing the following error messages in my >>> logs: >>> >>> LOG: SSL SYSCALL error: Connection reset by peer >>> LOG: could not receive data from client: Connection reset by peer >>> LOG: unexpected EOF on client connection >>> LOG: could

Re: [GENERAL] select distinct and index usage

On Mon, Apr 7, 2008 at 2:05 AM, Alban Hertroys <[EMAIL PROTECTED]> wrote: > On Apr 7, 2008, at 1:32 AM, David Wilson wrote: > > > > > The databases estimates seem consistent with yours, so why is it doing > this? Could you provide an EXPLAIN ANALYSE? It shows the actual numbers next > to the estim

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, Apr 7, 2008 at 8:11 AM, josep porres <[EMAIL PROTECTED]> wrote: > > Hi, > > I don't know if here is the right place to post this, but anyway ... > Does anybody know if there is any binary dist for win32 edb-debugger for > pgsql8.3? > If not, do you know which compiler I have to use? > I do

Re: [HACKERS] [GENERAL] ANALYZE getting dead tuple count hopelessly wrong

Pavan Deolasee wrote: On Fri, Apr 4, 2008 at 11:10 AM, Tom Lane <[EMAIL PROTECTED]> wrote: The policy of this project is that we only put nontrivial bug fixes into back branches, and I don't think this item qualifies ... Got it. I will submit a patch for HEAD. Thanks, As I mentio

Re: [GENERAL] edb-debugger, debugging pl/pgsql

ok, thx, I can debug from server pgadmin which ships with pg8.3 (1.8.2 rev 7030), because it runs on windows, but in the client side, running pgadmin1.8.2 rev 7050 it seems to hang, it freezes. Do I need to config anything? thx Josep Porres 2008/4/7, Dave Page <[EMAIL PROTECTED]>: > > On Mon, A

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, Apr 7, 2008 at 9:29 AM, josep porres <[EMAIL PROTECTED]> wrote: > ok, thx, > I can debug from server pgadmin which ships with pg8.3 (1.8.2 rev 7030), > because it runs on windows, > but in the client side, running pgadmin1.8.2 rev 7050 it seems to hang, it > freezes. > Do I need to config a

Re: [GENERAL] edb-debugger, debugging pl/pgsql

I downloaded it from: http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/ spaninsh http mirror http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2.zip Is this version wrong? Josep Porres 2008/4/7, Dave Page <[EMAIL PROTE

Re: [GENERAL] edb-debugger, debugging pl/pgsql

well, when you asked me about where I downloaded it, I downloaded it from I installed it again. It seems I can debug with no problems till now. However, when I begin to debug and the function parameters window appears, if I click cancel it freezes. the log says: 2008-04-07 11:05:05 STATUS : Obten

Re: [GENERAL] Silent install 8.3 diiffers from 8.2

"You should probably send those logs to the list, rather than straight to me. However, this line sticks out at me: 2008-04-07 07:43:14 GMT FATAL: lock file "postmaster.pid" already exists 2008-04-07 07:43:14 GMT HINT: Is another postmaster (PID 3724) running in data directory "F:/B"? Is it

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, Apr 7, 2008 at 9:40 AM, josep porres <[EMAIL PROTECTED]> wrote: > I downloaded it from: > http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/ > spaninsh http mirror > http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, Apr 7, 2008 at 10:21 AM, josep porres <[EMAIL PROTECTED]> wrote: > well, when you asked me about where I downloaded it, I downloaded it from I > installed it again. > It seems I can debug with no problems till now. > However, when I begin to debug and the function parameters window appears,

Re: [GENERAL] Conversion to 8.3

On Saturday 05 April 2008 11:21, Tom Lane wrote: > "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > what type is new.ontime ?? timestamp or interval. I would expect it > > to be an interval. But intervals are either negative or positive, not > > "ago" unless that's something peculiar to 7.4 that

Re: [GENERAL] edb-debugger, debugging pl/pgsql

if I try to close the parameter window using X button instead of Cancel, it's the same. It's a bit annoying when I finnish debugging, but I can debug, so it's fine :) I will be looking forward new versions. thanks again Dave Josep Porres 2008/4/7, Dave Page <[EMAIL PROTECTED]>: > > On Mon, Apr

Re: [GENERAL] calendar best practices for postgres

pgAgent works well for me and it is built into pgAdmin. http://www.pgadmin.org/docs/1.8/pgagent.html Jon > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Tim Uckun > Sent: Sunday, April 06, 2008 11:10 PM > To: pgsql-general@postgresq

Re: [GENERAL] Exception messages -> application?

On Sat, Apr 05, 2008 at 08:42:34PM -0700, Frank Miles wrote: > Unfortunately this does not help for lesser events (i.e. NOTICE and WARNING). > My preliminary effort suggests that psycopg isn't passing these. Not as exceptions, certainly. For one thing there's cursor.statusmessage which (should)

Re: [GENERAL] drop database regardless of connections

On Apr 6, 1:34 pm, [EMAIL PROTECTED] (Craig Ringer) wrote: > Kev wrote: > > So I tried to do this in Perl, but for some reason neither > > kill() nor Win32::Process::KillProcess() actually terminate the > > threads. > > Threads? Each backend is a distinct process. I haven't the foggiest why > they

Re: [GENERAL] slow pgsql tables - need to vacuum?

On Apr 5, 6:36 pm, [EMAIL PROTECTED] ("Douglas McNaught") wrote: > On Thu, Apr 3, 2008 at 2:34 PM, Dan99 <[EMAIL PROTECTED]> wrote: > > Hi, > > > I am having some troubles with a select group of tables in a database > > which are acting unacceptably slow. For example a table with > > approximat

[GENERAL] plperlu and perl 5.10

I'm trying to upgrade to perl 5.10, and realized that plperlu is still using 5.8. How exactly does pgsql determine where to look/what version to use for plperlu? Thanks, Kev -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] plperlu and perl 5.10

Kev <[EMAIL PROTECTED]> writes: > I'm trying to upgrade to perl 5.10, and realized that plperlu is still > using 5.8. How exactly does pgsql determine where to look/what > version to use for plperlu? You need to recompile. You also need a pretty darn recent release of PG (we only fixed things fo

Re: [GENERAL] slow pgsql tables - need to vacuum?

On Mon, Apr 7, 2008 at 9:51 AM, Dan99 <[EMAIL PROTECTED]> wrote: > Unfortunately, I did not design this database (or the website for that > matter) and am only maintaining it. As a result of the inexperience > of the website designer, there are no indexes in any of the tables and > it would b

Re: [GENERAL] slow pgsql tables - need to vacuum?

On Monday 07 April 2008, Dan99 <[EMAIL PROTECTED]> wrote: > Does TRUNCATE TABLE keep all necessary table > information such as indexes, constraints, triggers, rules, and > privileges? Yes. It does require an exclusive lock on the table very briefly, though, which DELETE does not. > Currently a m

Re: [GENERAL] edb-debugger, debugging pl/pgsql

josep porres wrote: Hi, I don't know if here is the right place to post this, but anyway ... Does anybody know if there is any binary dist for win32 edb-debugger for pgsql8.3? If not, do you know which compiler I have to use? I don't need to install anything on the client side where is my pg

Re: [GENERAL] edb-debugger, debugging pl/pgsql

josep porres wrote: 2008/4/7, Dave Page <[EMAIL PROTECTED] >: On Mon, Apr 7, 2008 at 10:21 AM, josep porres <[EMAIL PROTECTED] > wrote: > well, when you asked me about where I downloaded it, I downloaded it from I > install

Re: [GENERAL] too many LWLocks taken

It appears the errors were caused by table corruption. I've truncated and reloaded some large table (300m entries), and the problem disappeared. Table corruption was probably caused by hardware failure, not by PostgreSQL :) On Fri, 2008-04-04 at 20:15 -0400, Tom Lane wrote: > Alex Vinogradovs <[E

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, 07 Apr 2008 10:26:23 -0500 Tony Caduto <[EMAIL PROTECTED]> wrote: > > > You can use the Lightning Admin win32 debugger, very stable and FREE. The edb-debugger is open source??? Or are you just saying that although the Lightning Admin debugger is not open source it is FREE? (which is fine

Re: [GENERAL] edb-debugger, debugging pl/pgsql

Joshua D. Drake wrote: On Mon, 07 Apr 2008 10:26:23 -0500 Tony Caduto <[EMAIL PROTECTED]> wrote: You can use the Lightning Admin win32 debugger, very stable and FREE. The edb-debugger is open source??? Or are you just saying that although the Lightning Admin debugger is not open source it is

Re: [GENERAL] edb-debugger, debugging pl/pgsql

On Mon, 07 Apr 2008 19:07:22 +0200 Magnus Hagander <[EMAIL PROTECTED]> wrote: > Yes. The edb debugger is open source (it's on pgfoundry), and the LA > debugger client is free-as-in-beer. You know, kinda like PostgreSQL > vs Oracle Express ;) Uhmm Oracle Express is crippleware. I don't think Ton

Re: [GENERAL] edb-debugger, debugging pl/pgsql

Joshua D. Drake wrote: > On Mon, 07 Apr 2008 19:07:22 +0200 > Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > > Yes. The edb debugger is open source (it's on pgfoundry), and the > > LA debugger client is free-as-in-beer. You know, kinda like > > PostgreSQL vs Oracle Express ;) > > Uhmm Oracle E

Re: [GENERAL] edb-debugger, debugging pl/pgsql

Magnus Hagander wrote: You know, kinda like PostgreSQL vs Oracle Express ;) Well, not quite the same since LA Debugger Client is not crippled in some way Like Oracle or MS SQL Express :-) It's just plain old freeware. Later, Tony -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] select distinct and index usage

On Apr 7, 2008, at 9:47 AM, David Wilson wrote: On Mon, Apr 7, 2008 at 2:05 AM, Alban Hertroys <[EMAIL PROTECTED]> wrote: The databases estimates seem consistent with yours, so why is it doing this? Could you provide an EXPLAIN ANALYSE? It shows the actual numbers next to the estimates, alth

Re: [GENERAL] select distinct and index usage

On Mon, 7 Apr 2008 19:42:02 +0200 Alban Hertroys <[EMAIL PROTECTED]> wrote: > > explain analyze select distinct datestamp from vals; > >QUERY > > PLAN > > -- > >

[GENERAL] Subtracting Two Intervals

In porting from 7.4.19 to 8.3.1 I have found the following: 7.4.19: mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours'; ?column? @ 10 hours 30 mins (1 row) 8.3.1: mwr83=# select interval '1 day 15 hours 30 minutes' - interval '29 hours';

Re: [GENERAL] select distinct and index usage

On Mon, Apr 7, 2008 at 1:42 PM, Alban Hertroys <[EMAIL PROTECTED]> wrote: > > Have you tried this query with enable_seqscan=off? If my guess is right > (and the planners, in that case) it'd be even slower. set enable_seqscan=off; explain select distinct datestamp from vals;

Re: [GENERAL] Subtracting Two Intervals

Terry Lee Tucker wrote: > In porting from 7.4.19 to 8.3.1 I have found the following: > > 7.4.19: > mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours'; > ?column? > > @ 10 hours 30 mins > (1 row) > > 8.3.1: > mwr83=# select interval '1 day 15 hours

[GENERAL] BD removed

Hi there, I need some help. We have a Web application connecting to a postgresql 8.2 database on Windows Server 2003. According to the log, we logged on the server using a remote control desktop, after uninstalling Tomcat we installed a new Tomcat version. After that, we shutted down the Postg

[GENERAL] test ignore

test -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Sent via

Re: [GENERAL] edb-debugger, debugging pl/pgsql

thanks Tony, I'm going to take a look to it tomorrow morning. Josep Porres 2008/4/7, Tony Caduto <[EMAIL PROTECTED]>: > > josep porres wrote: > > > > > 2008/4/7, Dave Page <[EMAIL PROTECTED] >: > > > >On Mon, Apr 7, 2008 at 10:21 AM, josep porres <[EMAIL PROTECTED] >

Re: [GENERAL] [pgsql-advocacy] pgus-general now up

On Mon, 7 Apr 2008 10:47:58 -0700 "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > http://www.postgresql.org/mailpref/pgus-general Sorry for the confusion folks. The /community/lists link is currently broken. It has just been fixed but will take a little bit to migrate to the mirrors. Please use t

Re: [GENERAL] select distinct and index usage

"David Wilson" <[EMAIL PROTECTED]> writes: > I appreciate the responses so far! I'm used to several minutes for > some of the complex queries on this DB, but 12.5 minutes for a select > distinct just seems wrong. :) You could try changing it to the equivalent GROUP BY query. The planner, unfortun

[GENERAL] Most Occurring Value

There is probably a really simple solution for this problem, but for the life of me I can't see to think of it. I have three tables --contains u/p for all users in the site TABLE users (user_id INT primary key, username VARCHAR(50), password TEXT) --list of all possible events (login, logout, t

Re: [GENERAL] select distinct and index usage

On Mon, Apr 7, 2008 at 7:57 PM, Gregory Stark <[EMAIL PROTECTED]> wrote: > > You could try changing it to the equivalent GROUP BY query. The planner, > unfortunately, doesn't know they're equivalent and has two separate sets of > plans available. In this case where there are only 4,000 distinct

Re: [GENERAL] select distinct and index usage

David Wilson escribió: > explain analyze select datestamp from vals group by datestamp; > QUERY > PLAN >

Re: [GENERAL] Most Occurring Value

Mike Ginsburg wrote: There is probably a really simple solution for this problem, but for the life of me I can't see to think of it. I have three tables --contains u/p for all users in the site TABLE users (user_id INT primary key, username VARCHAR(50), password TEXT) --list of all possible ev

Re: [GENERAL] select distinct and index usage

> Still doing the sequential scan on the table, but at least it's > avoiding the expensive disk merge sort. It still seems as if I ought > to be able to coax it into using an index for this type of query, > though- especially since it's using one on the other table. Is there > perhaps some way to r

[GENERAL] Cannot use a standalone backend to VACUUM in "postgres""

We have a PostgreSQL 8.2.6 installation running for about six-months now. There was a lot of log entries saying (sometimes 10 or more in just one second): WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. (actually it was in Spanish but I t

Re: [GENERAL] Cannot use a standalone backend to VACUUM in "postgres""

Manuel Sugawara wrote: Hi Manuel, > The funny thing is that there was no open transactions, even after > restarting the cluster the same message was logged. Today, the > database stopped working as expected: > > ERROR: database is shut down to avoid wraparound data loss in database > "postgres"

[GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! I am in the process of migrating a PostgreSQL 8.2.4 database to 8.3. So far, everything has worked fine, even tsearch2-searching an indexed table. There's something severely wrong with the trigger-function I use to keep the tsvector-column updated. Here's my table definition: CREATE TABLE

Re: [GENERAL] select distinct and index usage

"David Wilson" <[EMAIL PROTECTED]> writes: > It appears to be doing a sequential scan regardless of the set, as if > it doesn't believe it can use the index for some reason More likely, it's getting a cost estimate for the indexscan that's so bad that it even exceeds the 1-unit thumb on th

Re: [GENERAL] select distinct and index usage

Tom Lane escribió: > What I think you'll find, though, is that once you do force an indexscan > to be picked it'll be slower. Full-table index scans are typically > worse than seqscan+sort, unintuitive though that may sound. Hmm, should we switch the CLUSTER code to do that? -- Alvaro Herrera

Re: [GENERAL] select distinct and index usage

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane escribió: >> What I think you'll find, though, is that once you do force an indexscan >> to be picked it'll be slower. Full-table index scans are typically >> worse than seqscan+sort, unintuitive though that may sound. > Hmm, should we switch

Re: [GENERAL] Cannot use a standalone backend to VACUUM in "postgres""

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Hi Manuel, Hi Alvaro! > I suggest you look for temp tables that have not been reclaimed. > We've had a couple of reports where leftover temp tables have > stopped the frozen-xid counter from advancing. (They would have a > very old relfrozenxid.) Th

Re: [GENERAL] select distinct and index usage

Alban Hertroys wrote > Something that might help you, but I'm not sure whether it > might hurt > the performance of other queries, is to cluster that table on > val_datestamp_idx. That way the records are already (mostly) sorted > on disk in the order of the datestamps, which seems to be the

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

"Markus Wollny" <[EMAIL PROTECTED]> writes: > Now when I do anything that fires the trigger like > UPDATE ct_com_board_message set count_reply = 1 where message_id = 12345; > I get an error > ERROR: column "idxfti" is not of tsvector type This is leaping to conclusions, but what I suspect is that

Re: [GENERAL] Cannot use a standalone backend to VACUUM in "postgres""

Manuel Sugawara <[EMAIL PROTECTED]> writes: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >> Hi Manuel, > > Hi Alvaro! > >> I suggest you look for temp tables that have not been reclaimed. >> We've had a couple of reports where leftover temp tables have >> stopped the frozen-xid counter from adva

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! Tom Lane wrote: > This is leaping to conclusions, but what I suspect is that you've got > two types "tsvector" in your database and the column is the wrong > one. > This situation is not too hard to get into if you try to restore a > dump from an old database that used contrib/tsearch2 --- the

Re: [GENERAL] Most Occurring Value

Mike Ginsburg <[EMAIL PROTECTED]> writes: > There is probably a really simple solution for this problem, but for > the life of me I can't see to think of it. I have three tables > > --contains u/p for all users in the site > TABLE users (user_id INT primary key, username VARCHAR(50), password TEXT

Re: [GENERAL] select distinct and index usage

On Sun, Apr 06, 2008 at 07:32:58PM -0400, David Wilson wrote: > I have a reasonably large table (~75m rows,~18gb) called "vals". It > includes an integer datestamp column with approximately 4000 unique > entries across the rows; there is a normal btree index on the > datestamp column. When I attemp