Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating

2006-01-24 Thread Agnes Bocchino
Hello Tom Do you know that this compiler generates trustworthy code with those options? The contents of the pg_control file are clearly good according to the dump from pg_controldata, and yet we have Perhaps we should use others options, could you tell us which are the write options with

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Magnus Hagander
George Pavlov wrote: they have the same kind of page setup for pg Admin: http://pgsql.navicat.com/PG_Admin/index.php this one renders... both pages seem to tell robots not to cache them, so can't view a cached view on google. At least PG Admin is free software and doing

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

2006-01-24 Thread Richard Huxton
Carl Conard wrote: I've successfully installed Postgres 8.1.2 on WS 2003 R2 on a Lenovo (IBM) ThinkPad. I used the default installation options and everything seems peachy keen for a single user (using localhost). However, when we started performance testing Postgres (vs. MySQL) using a

Re: [HACKERS] [GENERAL] [PATCH] Better way to check for getaddrinfo function.

2006-01-24 Thread R, Rajesh (STSD)
Its not a macro.I meant that the code generated by AC_REPLACE_FUNCS([getaddrinfo]) by configure.in for "configure"does not have "#include netdb.h". Hence function is not detected(unresolved getaddrinfo).Hence I thought AC_TRY_LINK could give test program instead of AC_REPLACE_FUNCS taking

Re: [HACKERS] [GENERAL] [PATCH] Better way to check for getaddrinfo function.

2006-01-24 Thread Martijn van Oosterhout
On Tue, Jan 24, 2006 at 02:33:13PM +0530, R, Rajesh (STSD) wrote: Its not a macro. I meant that the code generated by AC_REPLACE_FUNCS([getaddrinfo]) by configure.in for configure does not have #include netdb.h. Hence function is not detected(unresolved getaddrinfo). Hence I thought

Re: [GENERAL] FATAL: terminating connection due to administrator

2006-01-24 Thread Richard Huxton
surabhi.ahuja wrote: The exact message i saw is this: LOG: received fast shutdown request LOG: aborting any active transactions FATAL: terminating connection due to administrator command so does this mean that someone is trying to stop postmaster by sending it a kill signal? Someone or

Re: [GENERAL] Quoted NULLs with COPY FROM

2006-01-24 Thread Richard Huxton
George Pavlov wrote: Did you try NULL AS ''? yes i did. that is the default and does not change the outcome (same errors about trying to insert an empty string into a numeric field. Well there's your problem. Quotes tend to imply a text field. Assuming you don't want to write a short Perl

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 09:05 To: Tony Caduto; George Pavlov Cc: Bruce Momjian; pgsql-general@postgresql.org; Dave Page Subject: RE: [GENERAL] Does this look ethical to you? George Pavlov wrote: they have the

Re: [GENERAL] Updating rows (automatically) that are selected

2006-01-24 Thread Bruno Wolff III
On Wed, Jan 18, 2006 at 14:26:28 -0700, Assad Jarrahian [EMAIL PROTECTED] wrote: Hello, I have a table called X it contains 3 fields of importance(amongst others). time (timestamp), snooze (int) , inbox (int) The time column sometimes has null values. What I want is that every time a

Re: [HACKERS] [GENERAL] [PATCH] Better way to check for getaddrinfo function.

2006-01-24 Thread R, Rajesh (STSD)
sorry. It is a macro.so, would it be better to check for the macroas suggested by Tom or go with this patch$ diff -r configure.in configure.in.new918a919 AC_MSG_CHECKING([for getaddrinfo])920c921,926 AC_REPLACE_FUNCS([getaddrinfo])--- AC_TRY_LINK([#include netdb.h #include assert.h],

Re: [GENERAL] Isolation level in a function

2006-01-24 Thread Bruno Wolff III
On Thu, Jan 19, 2006 at 02:05:41 -0800, bgolda [EMAIL PROTECTED] wrote: Hello, this is my first post, please don't shoot... I was just experimenting with transactions (PG 8.1), and there is something which puzzles me. If i write 'SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;' in my

[GENERAL] execution plan : Oracle vs PostgreSQL

2006-01-24 Thread FERREIRA, William (VALTECH)
hi, i have a database storing XML documents. The main table contains the nodes of the document, the other tables contain data for each node (depending on the node's type : ELE, Text, PI, ...) My test document has 115000 nodes. the export of the document(extracting all informations from

[GENERAL] NOT HAVING clause?

2006-01-24 Thread Alban Hertroys
This is sort of a feature request, I suppose. I solved my problem, but NOT HAVING seems to match better with the desired result or the way you phrase the question in your mind, if that makes any sense... I was hoping to write a query rather short by using a NOT HAVING clause. The

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Michael Glaesemann
On Jan 24, 2006, at 20:00 , Alban Hertroys wrote: Though this does give the right results, I would have liked to be able to use NOT HAVING. Or is there a way using HAVING that would give the same results? I'm quite sure HAVING sort_order 1 doesn't mean the same thing. Why are you so

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Pandurangan R S
Hi, SELECT object_id FROM image GROUP BY object_id NOT HAVING sort_order = 1; After changing the NOT HAVING to HAVING the error message was column sort_order must appear in the GROUP BY clause or be used in an aggregate function The postgres document says SELECT list and HAVING clause can

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Alban Hertroys
Michael Glaesemann wrote: On Jan 24, 2006, at 20:00 , Alban Hertroys wrote: Though this does give the right results, I would have liked to be able to use NOT HAVING. Or is there a way using HAVING that would give the same results? I'm quite sure HAVING sort_order 1 doesn't mean the same

[GENERAL] Problems with pgsql 8.0.4 freebsd 6: partially solved

2006-01-24 Thread Vittorio
I have been using a postgresql 8.0.4 server under freebsd 5.4 like a charm for a long time . Yesterday, I upgraded freebsd from 5.4 to 6 via the CD (the iso was downloaded from ftp.freebsd.org). Restating postgresql it happened: # /usr/local/etc/rc.d/010.pgsql.sh start --: not found FATAL:

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Csaba Nagy
Alban, what you want is to put the sort_order 1 in the WHERE clause, not in the HAVING clause. Then it will do what you want. Cheers, Csaba. On Tue, 2006-01-24 at 13:51, Alban Hertroys wrote: Michael Glaesemann wrote: On Jan 24, 2006, at 20:00 , Alban Hertroys wrote: Though this

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Richard Huxton
Alban Hertroys wrote: Michael Glaesemann wrote: On Jan 24, 2006, at 20:00 , Alban Hertroys wrote: Though this does give the right results, I would have liked to be able to use NOT HAVING. Or is there a way using HAVING that would give the same results? I'm quite sure HAVING sort_order 1

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Alban Hertroys
Richard Huxton wrote: Alban Hertroys wrote: You're mixing up WHERE and HAVING. The WHERE clause applies to the individual rows before GROUP BY. The HAVING applies to the output of the GROUP BY stage. Ah, of course, now it makes sense. Combined with Csaba's reply my original problem has

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
Dave Page wrote: There most certainly are companies making money from pgAdmin, including at least 2 of the most well known large PostgreSQL companies. In addition to potentially hurting them, you are trading off our long established name, which to add insult to injury you haven't even spelt or

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Will Glynn
Alban Hertroys wrote: Michael Glaesemann wrote: On Jan 24, 2006, at 20:00 , Alban Hertroys wrote: Though this does give the right results, I would have liked to be able to use NOT HAVING. Or is there a way using HAVING that would give the same results? I'm quite sure HAVING sort_order

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Will Glynn
Alban Hertroys wrote: Richard Huxton wrote: Alban Hertroys wrote: You're mixing up WHERE and HAVING. The WHERE clause applies to the individual rows before GROUP BY. The HAVING applies to the output of the GROUP BY stage. Ah, of course, now it makes sense. Combined with Csaba's reply my

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Csaba Nagy
You're right, but only if there's no GROUP BY. As soon as you use a GROUP BY _and_ the mentioned WHERE clause, the result will be what the OP wanted... or you could use SELECT DISTINCT for what he wanted. On Tue, 2006-01-24 at 15:02, Will Glynn wrote: Alban Hertroys wrote: Richard Huxton

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Csaba Nagy
OK, I really didn't think it through, GROUP BY or DISTINCT won't help here. Sorry for the noise. Cheers, Csaba. On Tue, 2006-01-24 at 15:11, Csaba Nagy wrote: You're right, but only if there's no GROUP BY. As soon as you use a GROUP BY _and_ the mentioned WHERE clause, the result will be what

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Tony Caduto [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 13:56 To: Dave Page Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Does this look ethical to you? Those companies simply bundle pgAdmin III, they don't sell it, there is a big

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Magnus Hagander
There most certainly are companies making money from pgAdmin, including at least 2 of the most well known large PostgreSQL companies. In addition to potentially hurting them, you are trading off our long established name, which to add insult to injury you haven't even spelt or

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
There most certainly are companies making money from pgAdmin, including at least 2 of the most well known large PostgreSQL companies. In addition to potentially hurting them, you are trading off our long established name, which to add insult to injury you haven't even spelt or formatted

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 14:22 To: Tony Caduto; Dave Page Cc: pgsql-general@postgresql.org Subject: RE: [GENERAL] Does this look ethical to you? pgAdmin does not play fair either, if you want to talk fair

[GENERAL] PostgreSQL best practices?

2006-01-24 Thread Leonard Soetedjo
Hi, Is there any documentation or wiki on PostgreSQL best practices? For example: - run vacuum regularly and how to judge the frequency of running vacuum - when to use rule or trigger - etc. What I realized is that I joined PostgreSQL's mailing list and kept some of the advise that I feel

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Devrim GUNDUZ
Hi, On Tue, 2006-01-24 at 08:24 -0600, Tony Caduto wrote: No how about getting a link or something in the win32 Postgresql installer back to the commercial products page: http://www.postgresql.org/download/commercial Are you kidding? -- The PostgreSQL Company - Command Prompt, Inc.

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating template1]

2006-01-24 Thread Tom Lane
Agnes Bocchino [EMAIL PROTECTED] writes: Do you have some explanation or/and tips on how to build a successfull rpm on ia64, with icc, perhaps we shoud not please tell us Perhaps you should use gcc? I don't personally have the time or interest to dig into this. Considering that PG

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Tony Caduto [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 14:25 To: Dave Page Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Does this look ethical to you? There most certainly are companies making money from pgAdmin, including at

Re: [GENERAL] FATAL: terminating connection due to administrator command

2006-01-24 Thread Tom Lane
Richard Huxton dev@archonet.com writes: surabhi.ahuja wrote: so does this mean that someone is trying to stop postmaster by sending it a kill signal? Someone or something. It can be Linux's out-of-memory facility picking processes to kill. Google oom killer for discussion. No, because the

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
You're kidding, right? Should we also mention in the PostgreSQL installer that you should perhaps look at Oracle or DB2? No I am not kidding, it's more akin to MS bundling a web browser and a media player. That would be a more appropiate example. MS does it to destroy competitors. I

[GENERAL] user defined function

2006-01-24 Thread Yl Zhou
I want to implement a UDF that can accept a parameter which is a tuple of any table, and returns the number of NULL attributes in this tuple. Different tables may have different schemas. How can I implement this function? Thanks. andrew

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Tony Caduto [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 14:57 To: Dave Page Cc: Magnus Hagander; pgsql-general@postgresql.org Subject: Re: [GENERAL] Does this look ethical to you? No I am not kidding, it's more akin to MS bundling a web browser

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
Thank you, however I'm more concerned with: PGLA has many advanced features not found in pgAdmin III,. Aside from it being slightly misleading (not only are there not many 'advanced' things PGLA can do that pgAdmin can't, there are a similar number that pgAdmin can, that PGLA can't), it is

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Dave Page
-Original Message- From: Tony Caduto [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 15:24 To: Dave Page Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Does this look ethical to you? I changed it to say PGLA has many advanced GUI features not found in other admin

Re: [GENERAL] user defined function

2006-01-24 Thread Tom Lane
Yl Zhou [EMAIL PROTECTED] writes: I want to implement a UDF that can accept a parameter which is a tuple of any table, and returns the number of NULL attributes in this tuple. Different tables may have different schemas. How can I implement this function? Thanks. You could do that in C, but

[GENERAL]

2006-01-24 Thread Jimmy Rowe
UNSUBSCRIBE ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Stephan Szabo
On Tue, 24 Jan 2006, Alban Hertroys wrote: This is sort of a feature request, I suppose. I solved my problem, but NOT HAVING seems to match better with the desired result or the way you phrase the question in your mind, if that makes any sense... One problem is that HAVING really works on

Re: [GENERAL] Problems with pgsql 8.0.4 freebsd 6: partially solved

2006-01-24 Thread Tom Lane
Vittorio [EMAIL PROTECTED] writes: FATAL: XX000: failed to initialize lc_messages to LOCATION: InitializeGUCOptions, guc.c:3699 We've seen that reported before, on more than one platform (I recall hearing about it on OS X, for instance). But no one's ever been able to explain what causes

Re: [GENERAL] user defined function

2006-01-24 Thread Gevik
check http://archives.postgresql.org/pgsql-novice/2005-02/msg00227.php ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Devrim GUNDUZ
Hi, On Tue, 2006-01-24 at 07:56 -0600, Tony Caduto wrote: I don't think mentioning a product as a alternative to pgAdmin III is wrong since pgAdmin III has such a big advantage being distributed with the Windows version of Postgresql. It almost has monopoly written on it since the user

Re: [GENERAL] RAID 5 and postgresql

2006-01-24 Thread Sander Steffann
Hi, How about software RAID? Linux software RAID appears to perform better than most RAID controllers except perhaps those that can do read interleaving for RAID1 (I believe some 3ware controllers can do it). Linux RAID mirroring doesn't do read interleaving, only read balancing, which

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Peter Wilson
Tony Caduto wrote: Thank you, however I'm more concerned with: PGLA has many advanced features not found in pgAdmin III,. Aside from it being slightly misleading (not only are there not many 'advanced' things PGLA can do that pgAdmin can't, there are a similar number that pgAdmin can, that

Re: [GENERAL] user defined function

2006-01-24 Thread Richard Huxton
Tom Lane wrote: Yl Zhou [EMAIL PROTECTED] writes: I want to implement a UDF that can accept a parameter which is a tuple of any table, and returns the number of NULL attributes in this tuple. Different tables may have different schemas. How can I implement this function? Thanks. You could do

[GENERAL]

2006-01-24 Thread Rick Gigger
Every once in a while I've noticed the number of processes I've got running jumps up a little higher than normal. So I check it out and realize that I'm building up a bunch of processes that just aren't completing. About half of the one's not completing say SELECT waiting. I'm not doing

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
Magnus Hagander wrote: We (pginstaller hat goes on) don't know of any competing products. We will be happy to consider bundling any competing product, including PG Lightning Admin. One of the most important things in order to be distributed as part of an open source product is that the parts

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Magnus Hagander
Why? It is an Open Source package, distributed for free, at the personal expense of numerous people including myself. Why should we advertise your or anyone elses commercial products for free? Because the installer is not letting it be known that there are alternatives available, I

Re: [GENERAL] user defined function

2006-01-24 Thread Tom Lane
Richard Huxton dev@archonet.com writes: Tom Lane wrote: You could do that in C, but none of the available PLs support it. How would you define the signature for the function? One parameter of type anyelement? Type RECORD would be a better choice --- ANYELEMENT allows scalar types which is

Re: [GENERAL]

2006-01-24 Thread Tom Lane
Rick Gigger [EMAIL PROTECTED] writes: Every once in a while I've noticed the number of processes I've got running jumps up a little higher than normal. So I check it out and realize that I'm building up a bunch of processes that just aren't completing. About half of the one's not

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
Yes, that is all I am asking. Sorry about the MS reference, but I needed to make a point :-) I'd find it reasonable to add a blurb somewhere about note that there are other tools and addons available. See for example http://www.postgresql.org/download; or something like that. That certainly

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Tony Caduto
Devrim GUNDUZ wrote: I am kind of ticked off that they are hijacking my product name this way. Yep, but they were using direct links, and I changed any verbage I had immediatly when Dave asked me to. If navicat had mentioned my product in their web page I really wouldn't care, but they

[GENERAL] Access a temporary table of another session - is it possible ?

2006-01-24 Thread Csaba Nagy
Hi all, As the subject says, I would like to access a temporary table of another session, while being the postgres superuser. Is this possible somehow ? The problem is that I lost the terminal of the other session and I really would like to see the results (even if partial) of some long running

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Marc G. Fournier
On Tue, 24 Jan 2006, Tony Caduto wrote: You are not letting the user make a choice about which admin tool to use or even try... My understanding was that pgInstaller gave you the option to install pgAdmin III, it isn't a *requirement* to install it, like it is with your analogy of M$+IE

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Joshua D. Drake
I don't wan't to be bundled, I just want it to be known that there are alternatives available. I don't think it is reasonable to expect the OSS project within the OSS installer to mention commercial alternatives IF they are shipping an already available OSS product. What I mean is that

Re: [GENERAL] Quoted NULLs with COPY FROM (and pgAdmin export data options)

2006-01-24 Thread George Pavlov
Quotes tend to imply a text field. I think you meant to say quotes imply a non-null text field. And, yes, I am quite aware of that. The point of the thread was to see if there is any way of avoiding/overriding that assumption. Assuming you don't want to write a short Perl script to

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Do you mean this function? Seems I cannot get much information from it.../** record_out - output routine for pseudo-type RECORD.*/Datumrecord_out(PG_FUNCTION_ARGS){ elog(ERROR, Cannot display a value of type %s, RECORD); PG_RETURN_VOID(); /* keep compiler quiet */}On 1/24/06, Tom Lane [EMAIL

Re: [GENERAL] Access a temporary table of another session - is it possible ?

2006-01-24 Thread Tom Lane
Csaba Nagy [EMAIL PROTECTED] writes: As the subject says, I would like to access a temporary table of another session, while being the postgres superuser. Is this possible somehow ? No. It is not a matter of permissions, it is a matter of physically not having access to the data: buffers for

Re: [GENERAL] user defined function

2006-01-24 Thread Tom Lane
Yl Zhou [EMAIL PROTECTED] writes: Do you mean this function? Seems I cannot get much information from it... That would appear to be Postgres 7.3 :-( You need a considerably newer version of Postgres if you want to do much of anything useful with unspecified-type records. 8.0 has most of that

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
But I have to use 7.3 due to some limitations. Can I do it in 7.3? On 1/24/06, Tom Lane [EMAIL PROTECTED] wrote: Yl Zhou [EMAIL PROTECTED] writes: Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-(You need a considerably newer version

Re: [GENERAL] Backup and Restore mechanism in Postgres

2006-01-24 Thread Brian A. Seklecki
On Tue, 20 Sep 2005, Lincoln Yeoh wrote: At 10:00 AM 9/20/2005 -0400, Vivek Khera wrote: On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD Just curious what ever came of this? Also, were you reading the DB and writing

[GENERAL] Constraint that compares and limits field values

2006-01-24 Thread MargaretGillon
I have a table that I am using to hold keys for M:M relationships. I have six fields that can hold the keys and I do this because I validate the key with a foreign key constraint. Fields evevid1, evevid2 hold keys from the event table, evreid1, evreid2 hold keys from the resource table, etc. The

Re: [GENERAL] user defined function

2006-01-24 Thread Thomas Hallgren
For what it's worth, the next release of PL/Java has support for both RECORD parameters and SETOF RECORD return types. The adventurous can try out the current CVS HEAD. Regards, Thomas Hallgren Tom Lane wrote: Yl Zhou [EMAIL PROTECTED] writes: I want to implement a UDF that can accept a

Re: [GENERAL] user defined function

2006-01-24 Thread Yl Zhou
Can anyone tell me whether 7.3 supports unspecified record types or not? On 1/24/06, Tom Lane [EMAIL PROTECTED] wrote: Yl Zhou [EMAIL PROTECTED] writes: Do you mean this function? Seems I cannot get much information from it...That would appear to be Postgres 7.3 :-( You need a considerably newer

Re: [GENERAL] Problems with pgsql 8.0.4 freebsd 6: partially solved

2006-01-24 Thread Vivek Khera
On Jan 24, 2006, at 7:47 AM, Vittorio wrote: Yesterday, I upgraded freebsd from 5.4 to 6 via the CD (the iso was downloaded from ftp.freebsd.org). I've done this many times with no problems. However. You serve yourself very well by recompiling all your ports or reinstalling the

Re: [GENERAL] user defined function

2006-01-24 Thread Tom Lane
Yl Zhou [EMAIL PROTECTED] writes: But I have to use 7.3 due to some limitations. Can I do it in 7.3? Probably, but I forget how (and I can guarantee that it will break when you do move to 8.0 or later, because we changed the internal representation of rowtype arguments). You'd be *much* better

Re: [GENERAL] user defined function

2006-01-24 Thread Scott Marlowe
On Tue, 2006-01-24 at 14:38, Tom Lane wrote: Yl Zhou [EMAIL PROTECTED] writes: But I have to use 7.3 due to some limitations. Can I do it in 7.3? Probably, but I forget how (and I can guarantee that it will break when you do move to 8.0 or later, because we changed the internal

[GENERAL] Interpreting pg_locks; looking for deadlock

2006-01-24 Thread jao
I have a postgresql 7.4.8 database which has the same table declarations in several schemas. My application accesses each schema from a single thread; there is never more than one thread accessing a schema at a time. To try increasing concurrency, I've tried using multiple threads per schema.

[GENERAL] FATAL: invalid frontend message type 47

2006-01-24 Thread Sterpu Victor
After a commit I receive this message: FATAL: invalid frontend message type 47, and rollback. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] FATAL: invalid frontend message type 47

2006-01-24 Thread Michael Fuhr
On Tue, Jan 24, 2006 at 11:50:39PM -0500, Sterpu Victor wrote: After a commit I receive this message: FATAL: invalid frontend message type 47, and rollback. The client seems to have violated the communications protocol. What client interface are you using? What version of PostgreSQL (both

Re: [GENERAL] Are indexes used with LIKE?

2006-01-24 Thread Michael Fuhr
On Mon, Jan 23, 2006 at 08:00:01PM +0100, Kovcs Pter wrote: Are indexes on VARCHAR columns used with the LIKE operator, and if so, how efficiently are they used? I can imagine that using indexes can be easy with the starting literal characters up to the first percent sign such as in:

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

2006-01-24 Thread Carl Conard
Connections are through localhost. We've also connected via a client machine through a router to insure it is not something on the server. By drop connections, I mean Task Manager is showing additional postgres.exe tasks after the completion of the test. Also, when we try to drop the DB to

[GENERAL] pgxml

2006-01-24 Thread [EMAIL PROTECTED]
I’ am looking for pgxml module for postgres 7.2.1, someone can help me to find it? Thanks ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] NOT HAVING clause?

2006-01-24 Thread Andrew - Supernews
On 2006-01-24, Will Glynn [EMAIL PROTECTED] wrote: You might try: SELECT some_column FROM some_table GROUP BY some_column HAVING SUM(CASE WHEN sort_order=1 THEN 1 ELSE 0 END) = 0; SELECT some_column FROM some_table GROUP BY some_column HAVING every(sort_order 1); every() is in

[GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Foster, Stephen
I'm having a problem converting a simple date routing to PLPGSQL. I know the error has to be something stupid but I'm missing it. The error is in the ExpireDate := (date 'StartDate' + integer 'NumOfDays'); line in the procedure below. I didn't understand why I had to convert the date to a

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Michael Glaesemann
On Jan 25, 2006, at 9:45 , Foster, Stephen wrote: ERROR: invalid input syntax for type date: StartDate CONTEXT: SQL statement SELECT (date 'StartDate' + integer 'NumOfDays') PL/pgSQL function TF_BannerAd_Ads_InsMod line 8 at assignment Why are you single-quoting StartDate and NumOfDays?

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Foster, Stephen
Michael, I tried that line in the trigger procedure with double quotes, single quotes and without. The only way it would save was with single quotes and that is why you saw it that way. I know it has to be some sort of stupid syntax error but since I'm new to PostgreSQL (as far as this level of

[GENERAL] Postgresql Segfault in 8.1

2006-01-24 Thread Benjamin Smith
I'm running PostgreSQL 8.1 on CentOS 4.2, Dual proc Athlon 64 w/4 GB RAM. I'm trying to get a PHP app to work, but the failure happens when the command is copy/pasted into pgsql. Trying to run a large insert statement, and I get: server closed the connection unexpectedly This probably

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Michael Glaesemann
On Jan 25, 2006, at 10:12 , Foster, Stephen wrote: If I try to save without which was what I did in the first place I receive this using ExpireDate := (date StartDate + integer NumOfDays); ERROR: syntax error at or near $1 at character 16 QUERY: SELECT (date $1 + integer $2 )

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Stephan Szabo
On Tue, 24 Jan 2006, Foster, Stephen wrote: CREATE OR REPLACE FUNCTION TF_BannerAd_Ads_InsMod() RETURNS trigger AS $BODY$ DECLARE ExpireDate timestamptz; -- Date the Banner Ad will expire. StartDate char(10); -- Date the Banner Ad was created or renewed NumOfDays

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-24 Thread Doug McNaught
Benjamin Smith [EMAIL PROTECTED] writes: in /var/log/messages, I see Jan 24 17:00:04 kepler kernel: postmaster[26185]: segfault at 2516d728 rip 0043c82c rsp 007fbfffddd0 error 4 The insert statement is long, but doesn't seem to violate anything strange - no weird

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Foster, Stephen
Thanks guys it finally worked correctly. Just in case someone else get hung on this type of thing here is the working trigger function. CREATE OR REPLACE FUNCTION TF_BannerAd_Ads_InsMod() RETURNS trigger AS $BODY$ DECLARE ExpireDate timestamptz; -- Date the Banner Ad will expire. BEGIN

Re: [GENERAL] pgxml

2006-01-24 Thread Tom Lane
[EMAIL PROTECTED] [EMAIL PROTECTED] writes: I’ am looking for pgxml module for postgres 7.2.1, someone can help me to find it? *Please* tell me you are not still using PG 7.2.1. There are seven subsequent releases in the 7.2 series, each containing fixes for very serious bugs --- see

Re: [GENERAL] Setting expire date on insert/modify

2006-01-24 Thread Tom Lane
Foster, Stephen [EMAIL PROTECTED] writes: Michael, I tried that line in the trigger procedure with double quotes, single quotes and without. The only way it would save was with single quotes and that is why you saw it that way. Just for reference, the thing that was tripping you up (or one

Re: hardware checks (was Re: [GENERAL] invalid memory alloc request

2006-01-24 Thread Bruce Momjian
Greg Stark wrote: Tom Lane [EMAIL PROTECTED] writes: Janning Vygen [EMAIL PROTECTED] writes: one more question: You mentioned standard disk and memory checks. Can you point to some link where i can find more about it or which software do you mean? I guess i have to start

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-24 Thread Tom Lane
Benjamin Smith [EMAIL PROTECTED] writes: What information do you need to help figure this out? Best is to provide a recipe by which someone else can reproduce it from a standing start. You can find some useful hints at http://www.postgresql.org/docs/8.1/static/bug-reporting.html

Re: [GENERAL] Does this look ethical to you?

2006-01-24 Thread Bruce Momjian
The people who develop, package, and host pginstaller files are doing so to promote open source software for users, not to help you sell commercial software. For that, you are on your own. If you want to find volunteers to help you promote and sell your software, good luck. :-)

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-24 Thread Benjamin Smith
Thanks, What's the best way to do this? Take PG down (normally started as a service) and run directly in a single-user mode? I've never reallly worked with gdb... -Ben On Tuesday 24 January 2006 17:27, you wrote: What information do you need to help figure this out? Reproduce it

[GENERAL] hi all......................!!

2006-01-24 Thread AKHILESH GUPTA
hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? i think you all help me in solving my queries in future...!! -- Thanks Regards, Akhilesh DAV Institute of

Re: [GENERAL] hi all......................!!

2006-01-24 Thread Tino Wildenhain
AKHILESH GUPTA schrieb: hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? i think you all help me in solving my queries in future...!! Yes it is. All you have to