Re: [JDBC] [ADMIN] Missing documentation for error code: 80S01

From: "Oliver Jowett" If the server is shut down mid-query, doesn't the backend complete the current query cycle before closing the connection? i.e. we'd see ErrorResponse, ReadyForQuery, and return control to the app before seeing EOF anyway? The protocol spec is a bit vague there. From an o

Re: [ADMIN] Missing documentation for error code: 80S01

From: "Kevin Grittner" "Donald Fraser" wrote: the JDBC driver does know that the server has terminated the connection [...] (via end of stream or EOF). Is the error class "57" a better prefix for this type of error? Possibly. Is it really true that the cli

Re: [ADMIN] Missing documentation for error code: 80S01

- Original Message - From: "Kevin Grittner" "Donald Fraser" wrote: I was expecting the code to be something like: crash_shutdown, however that appears to be under a completely different error class: 57P02. If a JDBC client detects that the connection is broke

Re: [ADMIN] Missing documentation for error code: 80S01

- Original Message - From: "Tom Lane" "Donald Fraser" writes: Correction error code should be: 08S01 and NOT 80S01 The reason it's not documented by us is that Postgres doesn't generate any such error code. Must be coming from some client-side sof

Re: [ADMIN] Missing documentation for error code: 80S01

Correction error code should be: 08S01 and NOT 80S01 - Original Message - Subject: Missing documentation for error code: 80S01 PostgreSQL version 8.3.14 There appears to be no documentation on the following error code: Error code is: 80S01 Message: "The backend has broken the connectio

[ADMIN] Missing documentation for error code: 80S01

PostgreSQL version 8.3.14 There appears to be no documentation on the following error code: Error code is: 80S01 Message: "The backend has broken the connection. Possibly the action you have attempted has caused it to close." I was expecting the code to be something like: crash_shutdown, however

Re: [ADMIN] Shutdown fails with both 'fast' and 'immediate'

LETE statements in our restore procedure and we don't execute pg_ctl stop untill all statements are complete. Regards Donald Fraser -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Partial WAL file replay before fail-over startup

he standby server if the restore_command only takes whole WAL files. I would assume that copying the partial WAL file into the pg_xlog directory would suffice before startup. However as I've been caught out many times before with assumptions, I would therefore like to clarify this? Regards Donald Fraser

[ADMIN] Timing problem wtih pg_stat_activity

ediately execute the statement, I see the result of 1. Is this normal behaviour? Regards Donald Fraser

[ADMIN] Timing problem wtih pg_stat_activity

o the displayed information lags behind actual activity. However, current-query information collected by stats_command_string is always up-to-date." Regards Donald Fraser ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] WAL segment question

- Original Message - From: Chander Ganesan > DRBD is a synchronous method of transferring data - it's not asynchronous. Assuming you are using Protocol C you should find that both are always in sync. If you are using protocol B then things will be in sync so long as the remote system did

[ADMIN] WAL segment question

point of failure, without starting the database up? Regards Donald Fraser.

[ADMIN] WAL file creation

be rolled forward in the WAL files, yet without a valid WAL file its impossible to start PostgreSQL. Thanks in advance, regards Donald Fraser

[ADMIN] PL/pgSQL Return statements

anks in advance, regards Donald Fraser

Re: [ADMIN] How to enforce the use of the sequence for serial columns ?

nually retrieve the serial number from a trigger function and modify column "id" in the function. Regards Donald Fraser - Original Message - From: Marc Mamin I'd like to ensure that nobody provide the ID in an insert statement when the id is linked to a sequence. I tried

Re: [ADMIN] [JDBC] currval() race condition on server?

tion. >Yes, and this is done in a C trigger that is called as a result of the >update (it is a BEFORE INSERT OR DELETE OR UPDATE ... trigger). The C >code does a Are you absolutely certain you are not calling currval from within your BEFORE trigger function, before a call to nextval?

[ADMIN] Odd behaviour with WAL and pg_stop_backup

the archive command is to edit the postgresql.conf file, remove the archive command and either issue a SIGHUP or a server restart. Can someone confirm that this is the correct behaviour or not? Thanks in advance, Donald Fraser ---(end of broadcast

Re: [ADMIN] Beginning SSL Questions

y of PostgreSQL and it must be named root.crt. User the pg_hba.conf file to force clients to use ssl or not. Hope that helps. Regards Donald Fraser ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] Strange message followed by server crash

>"Donald Fraser" <[EMAIL PROTECTED]> writes:>> Log messages:>> <1Tmenteshvili 10709 2006-08-24 17:48:19 BST 0> ERROR:  invalid message format>> < 3670 2006-08-24 17:48:19 BST > LOG:  server process (PID 10709) was terminated by signal 11>

[ADMIN] Strange message followed by server crash

the building, was working on the network and changing a network switch. Therefore can I assume this crash was caused by some form of corrupt / incomplete data sent to PostgreSQL?   Thanks in advance regards Donald Fraser    

[ADMIN] hooks for User login process

Is there a mechanism for attaching a trigger function, or the likes, to be activated when a user logs into the PostgreSQL database? I'm looking for a means of performing additional house keeping tasks when a user logs in.   Regards Donald Fraser

[ADMIN] Constraint Triggers

ed this command?   Thanks in advance, Donald Fraser

[ADMIN] Initial request packet for SSL

'm required to send the SSLRequest packet first.   Any thoughts would be appreciated, regards Donald Fraser.     

Re: [ADMIN] could not accept SSL connection: peer did not return a

ome reason, with a root.crt present, 7.4.x distributions do not enforce receiving a client certificate so I never got this problem before. Thanks again regards Donald Fraser. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] could not accept SSL connection: peer did not return a certificate

meter that allows clients to connect with SSL on a 8.0.x server like it was a 7.4.x server?   Regards Donald Fraser

[ADMIN] Announcement regarding GBorg project citext

lower case versions. Unless you have been using these support functions you want have had any problems. Many thanks to Mike Kock for finding and reporting these bugs. Mike also required aggregate functions min and max, so these have been added to the type set up (citext.sql). Regards Donald

Re: [ADMIN] support for using runas for pg

ram. Regards Donald Fraser Ps. Please do not include email addresses in your reply - they become public domian and allow spam engines to find them! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] support for using runas for pg

s without password prompting and again I have no problems with PostgreSQL - therefore please try one of these options before blaming PostgreSQL. If any one of these options work then the problem will be with your third party tool "runasv" Regards Donald Frase

Re: [ADMIN] PG Report Generator

l, xls, and many more. Combine that with iReports (http://sourceforge.net/projects/ireport) as the gui for report design and you will find the two together are a great combination: Regards Donald Fraser ---(end of broadcast)--- TIP 4: Have

Re: [ADMIN] WITH SYSID feature dropped

> On Wed, Dec 21, 2005 at 04:35:00PM -0000, Donald Fraser wrote: > > Roles are a great improvement to postgresql, but we also talking security > > issues here: > > Our module controls things like: > > 1) how long before a user must change their password (daily, wee

Re: [ADMIN] WITH SYSID feature dropped

- Original Message - From: "Alvaro Herrera" > Donald Fraser wrote: > > > We developed and have been using since 7.1, and currently running 7.4, > > bespoke client / database software. The ability to manage users and security > > was of high priority

Re: [ADMIN] WITH SYSID feature dropped

e I haven't sounded negative, I do appreciate all the work that goes on from the postgreql team and I think the new features in 8.1 far out way the minor inconveniences that it will cause us in upgrading Keep up the good work, and cheers for the feed back. Regards Donald Fraser ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] WITH SYSID feature dropped

- Original Message - From: "Tom Lane" > "Donald Fraser" writes: > > 1) Was there a good reason for dropping this feature? > Users/groups are identified by OIDs now, not by sysids. > > The original motivation for allowing manual assignment of use

[ADMIN] WITH SYSID feature dropped

any am I likely to encounter if I patch that feature back in?   Thanks in advance, Donald Fraser  

Re: [ADMIN] Are cached IMMUTABLE values persistent between sessions

"Donald Fraser" writes: Is the returned value of a function defined as IMMUTABLE cached = globally? "Tom Lane" writes: No, in fact it isn't cached at all. IMMUTABLE tells the planner that it's OK to fold a function call with constant inputs to a constant resul

[ADMIN] Are cached IMMUTABLE values persistent between sessions

Is the returned value of a function defined as IMMUTABLE cached globally? In other words could postgresql potentially return a cached value obtained from one client session to a different client session?   Thanks in advance Donald Fraser 

[ADMIN] problem with connection logging

m this problem and if so have you found a solution for dealing with it?   thanks Donald Fraser

Re: [ADMIN] pg_hba.conf

in pg_hba means that it must use ssl to connect, where as the host setting in pg_hba can mean either or, depending on your client. What client software are you using? Regards Donald Fraser - Original Message - From: "Dick Davies" <[EMAIL PROTECTED]> To: "PostgreSQL

[ADMIN] postgresql-7.4.6-2PGDG.src.rpm broken for Redhat 7,8 or 9

ectory is set via: %{?build7x:%define kerbdir /usr/kerberos} %{?build89:%define kerbdir /usr/kerberos}   where as the 7.4.6 version has the kerberos directory is set via: %{?build7x:%define kerbdir "/usr"} %{?build89:%define kerbdir "/usr"}   I think you'll agree that this directory change is not the default for Redhat 7, 8 or 9   Regards Donald Fraser

Re: [ADMIN] Notifications

Just a final follow up to this message thread - Sun Microsystems confirm that there is a bug with their implementation of the ssl input stream socket in the 1.4 series JVM. Regards Donald Fraser - Original Message - From: "Sun Microsystems" Sent: Friday, December 31, 20

Re: [ADMIN] Notifications

asy work around.... Thanks again for the input, regards Donald Fraser - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, December 16, 20

Re: [ADMIN] Notifications

- Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 5:07 PM Subject: Re: [ADMIN] Notifications On Thu, Dec 16, 2004 at 02:20:07PM -0000, Donald Fraser wrote: I'm having problems receiving NOTIFY messages when outside our l

Re: [ADMIN] Notifications

m lost as to what is happening to the messages Regards Donald Fraser - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 4:41 PM Su

[ADMIN] Notifications

elcom   Cheers Donald Fraser

[ADMIN] Function to get client IP address

the job. I thought I would post it here (may be it should go into hackers) so that others can find and use it as they wish.   regards Donald Fraser.     Place the following into an appropriate file and follow the c compiling rules as with contrib examples.   #include "postgres.h"#include &

[ADMIN] Source RPMS

resql-7.4.3-2PGDG.src.rpmerror: parse error in _expression_error: /usr/src/redhat/SPECS/postgresql-7.4.3-2PGDG.spec:98: parseExpressionBoolean returns -1error: Package has no %description: postgresql   The same command for the source package 7.4.2-1 works ok. Regards Donald Fraser

[ADMIN] Binary/source for 7.4.3

Hi, does anyone know if binary versions or at least the source rpm are going to be produced for the latest release 7.4.3?   Thanks in advance Donald Fraser

Re: [ADMIN] Autovacuum option in init script

Attached is a script I created to run on Redhat. Someone might find it useful. It's not a big deal to make it run as the next script after postgresql.   Regards Donald Fraser   - Original Message - From: Roy Walker To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2

Re: [ADMIN] postgresql 7.4.2 binary for Red Hat Enterprise Linux 2.1

m I don't know what Red Hat Enterprise Linux 2.1 is equivalent to with regards to desktop versions so can't help you with choosing a correct define. Have a look at the end of the rpm build script for a list of available defines.   Regards Donald Fraser - Original Message -

Re: [ADMIN] Updgrade from 7.3 to 7.4

- Original Message - > > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > 2) One of my queries does an ORDER BY on a column that is of type BOX. > > This query no longer runs and returns the following error message: > > ERROR: could not identify an

Re: [ADMIN] tcl-devel build dependencies for 7.4.2

- Original Message - > On Tuesday 13 April 2004 16:43, Donald Fraser wrote: > > I am trying to build Postgres 7.4.2 from the source rpm on Red Hat Linux > > 7.1 2.96-98 > > While I do test builds on a Red Hat 7.3 compatible system, I do not do so on a > 7.1 system.

[ADMIN] Updgrade from 7.3 to 7.4

query. The only things I can think of doing is splitting the box out into the four separate values, but how do I do that with a box? my_box[0] returns a point and my_box[0][0] is not recognised (I tried various other forms but to no avail). Any help/hints would be appreciated. Regards Donald F

Re: [ADMIN] tcl-devel build dependencies for 7.4.2

imum requirements list for building rpms from source anywhere - I can't think of any other reason why it wouldn't complete? Thanks again Donald Fraser ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[ADMIN] tcl-devel build dependencies for 7.4.2

this problem or alternatively are there any Red Hat 7.1 binaries for PostgreSQL 7.4.2? Thanks in advance Donald Fraser ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] Tsearch1 problem

elease under Redhat Linux version 2.4.7-10 (gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)) #1 Thu Sep 6 17:27:27 EDT 2001 I am also using postgres 7.3.4, but unfortunatley I am using tsearch2 so I cannot run the same tests. Donald Fraser ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] Sensitive sort problem?

- Original Message - > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > PostgreSQL 7.3.x and anything below has never had case insensitive sorting = > > - period. > > This is incorrect. In point of fact it will depend on the locale the > data

Re: [ADMIN] Sensitive sort problem?

PostgreSQL 7.3.x and anything below has never had case insensitive sorting - period. I can't speak for the new 7.4 version?   If you want to add a case insensitive data type try this: http://gborg.postgresql.org/project/citext/projdisplay.php     Regards Donald Fraser. - Ori

Re: [ADMIN] 7.3.5

planner tries to convert that string back to OID form). Regards Donald Fraser ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] 7.3.5

Will there be a 7.3.5 version released, containing relevant patches, before the release of the 7.4 version?   Thanks in advance Regards Donald Fraser

Re: [ADMIN] [PERFORM] backup/restore - another area.

t the DB up while doing this. > > Even had a program sitting around committing data to try and corrupt > things. (Which is how I discovered I was doing the snapshot wrong) > > You could do pg_ctl stop; snapshot; pg_ctls tart for a "clean" image. >

Re: [ADMIN] Case Insensitive Test

- Original Message - From: "Manuel Sugawara" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 12:28 AM Subject: Re: [ADMIN] Case Insensitive Test > "Dona

Fw: [ADMIN] Case Insensitive Test

- Original Message - From: "Manuel Sugawara" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 11:12 PM Subject: Re: [ADMIN] Case Insensitive Test > "D

[ADMIN] Case Insensitive Test

The Case Insensitive Text data type for PostgreSQL is now part of the GBorg projects.   http://gborg.postgresql.org/project/citext/projdisplay.php   Regards Donald Fraser

Re: [ADMIN] Case Insensitive comparison

Ok I have started the process... I now have to wait for GBorg to get back to me on whether they want it on the site our not. Regards Donald Fraser - Original Message - From: "Jamie Lawrence" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Sent

Re: [ADMIN] Case Insensitive comparison

Ok I will have a look at how to put it on gborg. Regards Donald Fraser - Original Message - From: "scott.marlowe" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 20

Re: [ADMIN] Case Insensitive comparison

If you would like I can email you the library files to make and install it. Regards Donald Fraser ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] STATEMENT level TRIGGER functions

In the up and coming 7.4 version of PostgreSQL will it be possible for TRIGGER functions be definable on a STATEMENT level rather than just ROW level? Thanks in advance Donald Fraser. ---(end of broadcast)--- TIP 2: you can get off all lists at

[ADMIN] Views

PostgreSQL version 7.3.4   Quick question: With respect to a VIEW, why does PostgreSQL internally return all of the columns when, for example, the SELECT statement only requests say 2 out of 10 columns ?   Thanks in advance, Donald Fraser.

Re: [ADMIN] Are 50 million rows a problem for postgres ?

ems with nobody on these email lists will be able to fully help you. Minimum we need to see an SQL statement, and the results of EXPLAIN. Regards Donald Fraser. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] Extracting single coordinate from a box

Thanks for the quick response. - Original Message - > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > But when I try something like b[0][0] the passer ignores the second array > > subscript parameter and returns only a "point". > You need the

[ADMIN] Extracting single coordinate from a box

from a "box" with b[0] or b[1] where b is of type "box". But when I try something like b[0][0] the passer ignores the second array subscript parameter and returns only a "point". Many thanks in advance, Donald Fraser. ---(end of broadcast)--

Re: [ADMIN] Postgresql slow on XEON 2.4ghz/1gb ram

or may not detect the Xeon as a multiple processor system and therefore only install the single processor version of the kernel. So you might want to check that you have multiple processor version of the kernel installed? If you have got the multiple processor version installed then the kernel obvio

Re: [ADMIN] Arrays in pl/pgsql functions

Many thanks for clearing that one up. I have avoided using arrays for the mean time and gone for the more elegant solution of using an additional table. More flexible and powerful but, in the simple case that I needed, meant more work... Roll on 7.4 ! Regards Donald Fraser. - Original

[ADMIN] Arrays in pl/pgsql functions

e please inform me what the correct syntax for accessing arrays is or tell me if its not possible with pl/pgSQL functions. Thanks in advance, Donald Fraser. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if yo

[ADMIN] Overloading functions that are used by operators.

rator.oprjoin and pg_operator.oprrest have identical names defined by the column pg_proc.proname for which they are also retrieving? If so then those corresponding joins are also unnecessarily.   Many thanks in advance, regards Donald Fraser.

Re: [ADMIN] generic SQL implementations

I believe Borland's database engine (part of Delphi and C++ builder) tried to do this. My experience with it, albeit some years ago now, was that it was extremely slow.   Regards Donald Fraser - Original Message - From: Vinay To: [EMAIL PROTECTED] Sent: Monday, Ju

Re: [ADMIN] Login as different user inside of a function.

Set the function to run as SECURITY DEFINER The owner/creator of the function must have the privileges to insert data into the fore mentioned tables and it should do as you asked. This feature is only available in 7.3 and above. Regards Donald Fraser - Original Message - From: "

[ADMIN] Redhat 9.0

tched (re-badged?) version of PostgreSQL 7.3.2. If it is patched does anyone know what the main differences between Redhat patched PostgreSQL 7.3.2 and the original is?   Thanks in advance Donald Fraser.

[ADMIN] Changing the time on the server

Could somebody tell me the consequences of setting the date forward in time on the server running PostgreSQL and then at a later date, after some transactions have been committed, setting the date back in time?   Thanks in advance, Donald Fraser

Re: [ADMIN] uppercase = lowercase

blic please do so.   Here's the contents of the readme file: ======= Module citext created by Donald Fraser. First release to public: 17th Feb. 2003. Files: citext.c, Makefile, citext.sql, readme.citext This module was created to implement a Case-Insensitive text data type named ci

Re: [ADMIN] Indexes on Large Tables

- Original Message - From: "Curt Sampson" <[EMAIL PROTECTED]> To: "Donny Drummonds" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 5:13 AM Subject: Re: [ADMIN] Indexes on Large Tables > On Mon, 3 Feb 2003, Donny Drummonds wrote: > > > If I do not index the co

[ADMIN] Lost connections

 client applications that can avoid this situation. That is can the client software do something extra when connecting such as additional parameters, keep alive socket options... to avoid this scenario?   Thanks in advance Donald Fraser