Re: [GENERAL] Idle processes chewing up CPU?

On Wed, 2009-08-05 at 15:26 +1000, Brendan Hill wrote: > I copied a few of the stack traces (at the end of this email), it kept > changing each time I looked. Yep, that's to be expected. If the process is busy, unless it's in a _REALLY_ simple infinite loop, it'll be looping through some non-triv

Re: [GENERAL] Idle processes chewing up CPU?

Hi all, We managed to trap further details of the problem today. Some large queries were terminated prematurely, perhaps causing a dirty SSL or TCP disconnect, and they seem to have left a few runaway processes. SELECT * FROM pg_stat_activity showed each process was , while Process Explored showed

Re: [GENERAL] LDAP Configuration for Postgres authenticating against AD

On Aug 4, 2009, at 6:41 PM, Richard Esmonde wrote: Hi, I’m new to PostGres (so go easy on my naivety). I am trying to configure the postgres host based configuration file to permit users to authenticate against our Active Directory. Needless to say both Ubuntu server and AD are in the sa

Re: [GENERAL] LDAP Configuration for Postgres authenticating against AD

On Tue, 2009-08-04 at 21:41 -0400, Richard Esmonde wrote: > Three days into this I am none the wiser - I’m exhausting Google > servers. Can anyone tell me what I have forgotten to do or have > overlooked in getting this setup correctly? To my mind it’s behaving > as though it’s not honoring anyt

Re: [GENERAL] LDAP Configuration for Postgres authenticating against AD

On Tuesday 04 August 2009 19:41:57 Richard Esmonde wrote: > Hi, > > > > I'm new to PostGres (so go easy on my naivety). I am trying to configure > the postgres host based configuration file to permit users to authenticate > against our Active Directory. > > Needless to say both Ubuntu server and A

[GENERAL] LDAP Configuration for Postgres authenticating against AD

Hi, I'm new to PostGres (so go easy on my naivety). I am trying to configure the postgres host based configuration file to permit users to authenticate against our Active Directory. Needless to say both Ubuntu server and AD are in the same Domain. . I am running PostGRESQL v8.3.7

[GENERAL] LISTEN ON table WHERE attr1 LIKE '%abc%';

Hi, there are already some items in the TODO list regarding LISTEN/NOTIFY, and I saw the discussion in the thread "Feature request: NOTIFY enhancement" on Jan 2008. Now I was hoping for a feature that goes even further than the ones discussed and allows clients to listen on changes in the data

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Doug Gorley writes: > That looks like exactly what I want. Is there an easy way to cast that > to a string so that I can concatenate it into a GRANT statement? Well, since 8.3 you just cast it to a string ;-) In older versions I'd suggest a plpgsql wrapper function. plpgsql has always been ve

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Guy Rouillier wrote: Paul Taylor wrote: I am testing the code that extracts information from a read only database. These are UNIT tests so only interested in getting the right results given a particular set of data, anything else is a distraction. I don't understand your test environment. I

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

That looks like exactly what I want. Is there an easy way to cast that to a string so that I can concatenate it into a GRANT statement? *Doug Gorley* | doug.gor...@gmail.com Tom Lane wrote:

Re: [GENERAL] Generating GRANT/REVOKE on functions from catalog

Doug Gorley writes: > The statement I need to generate is: > revoke all on function public.add(integer, integer) from someuser; > I'm attempting to use the pg_proc table in the system catalogs, and I'm > good up to the point where I need the parameter types. Can anyone give > me a hand with t

Re: [GENERAL] Error when assigning default value for function parameter

Thanks Pavel & Frank. Installed version 8.4, work perfect. Apologies. I did check ver 8.3 documentation earlier as well, but can confirm that I clearly read what I wanted to hear, and not what was actually there. Thanks again! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

[GENERAL] Generating GRANT/REVOKE on functions from catalog

I am attempting to script the generation of grant/revoke statements for a database, and I'm having some trouble when it comes to functions. consider the following function: create function add(a integer, b integer) returns integer as $$ select $1 + $2; $$ language SQL; The statement I need to

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Bayless Kirtley wrote: > Yes, I'm afraid you're gonna be out of luck on finding the array type > in any > of > the smaller embedded databases. Honestly, the beg project I've been on > for a > year or so has used Postgres right through full development and testing. > It's > not hard to start and sto

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

- Original Message - From: "Paul Taylor" To: Sent: Tuesday, August 04, 2009 9:56 AM Subject: Re: [GENERAL] Does derby have an embedded Mode like Derby ? Of course you can always use Derby for testing the Postgres later. I have found HSQLDB to be closer to Postgres than Derby is. I do

Re: [GENERAL] timestamp with time zone, retrieving input offset/timezone

On Tue, Aug 4, 2009 at 5:09 AM, Der Tung wrote: > Hello there, > > We are creating an Application that needs to handle timestamps in different > timezones in particular: > > Input and output in timezone of the User is no problem with > > Set Time Zone and At Time Zone > > But know I have two Users

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Paul Taylor wrote: I am testing the code that extracts information from a read only database. These are UNIT tests so only interested in getting the right results given a particular set of data, anything else is a distraction. I don't understand your test environment. If all your code is doin

Re: [GENERAL] CHECK constraint fails when it's not supposed to

Richard Yen writes: > When I run my update, it fails: >> tii=# begin; update only "public"."m_class" set date_end='2009-09-03 >> 05:38:24.030331-07',term_length='177 days 17:59:09.868431' where >> id='2652020'; >> BEGIN >> ERROR: new row for relation "m_class" violates check constraint >> "end_wi

Re: [GENERAL] Error when assigning default value for function parameter

You can't use default values in a function, that option is available as of version 8.4. You are using 8.3. Regards, Frank Op 4 aug 2009, om 19:16 heeft Gert het volgende geschreven: I'm a bit in the dark: I use Windows XP I use pgAdmin ver 1.8.4 I use PostGres 8.3.6 All the documentation p

Re: [GENERAL] Error when assigning default value for function parameter

Hello 2009/8/4 Gert : > I'm a bit in the dark: > I use Windows XP > I use pgAdmin ver 1.8.4 > I use PostGres 8.3.6 > You have to upgrade to 8.4. Default parameter's values are implemented in 8.4. regards Pavel Stehule > All the documentation points out that it is allowed to assign default > val

[GENERAL] Error when assigning default value for function parameter

I'm a bit in the dark: I use Windows XP I use pgAdmin ver 1.8.4 I use PostGres 8.3.6 All the documentation points out that it is allowed to assign default values to parameters, but I get a syntax error here. I would appreciate feedback. CREATE OR REPLACE FUNCTION myfunc(a integer , b integer DEF

[GENERAL] CHECK constraint fails when it's not supposed to

Hi All, I encountered an odd issue regarding check constraints complaining when they're not really violated. For this particular machine, I am running 8.3.7, but on a machine running 8.3.5, it seems to have succeeded. I also upgraded a third machine from 8.3.5 to 8.3.7, and the query succeeded (

[GENERAL] ECPG: insert array?

I am using ECPG in a C application, and I would like to insert a C array of integers into an array in a PostgreSQL table. The documentation does not talk about this at all. Is it possible and if so, how? -- Edward Amsden FXCM IT Intern eams...@fxcm.com Cell: 937 638 6959

[GENERAL] Recovery from crashed DB seems to occur progressively

Hello, I'm using version 8.3.5. The partition in which the 'pgsql' directory was became full. This database is normally used via an Hibernate/JDBC layer and one of the most common request is "SELECT * FROM MYTABLE LIMIT 10", from a webpage. I tried to delete some rows manually from psql ("dele

[GENERAL] timestamp with time zone, retrieving input offset/timezone

Hello there, We are creating an Application that needs to handle timestamps in different timezones in particular: Input and output in timezone of the User is no problem with Set Time Zone and At Time Zone But know I have two Users A and B in different timezones. When A saves a timest

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

In response to Paul Taylor : > Bill Moran wrote: > > In response to Paul Taylor : > > > >> Bill Moran wrote: > >> > >>> Then replace the DB client class with a class that returns fabricated > >>> data for the purpose of your test. > >>> > >>> > >> Won't work because I am writing SQL

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Bill Moran wrote: In response to Paul Taylor : Bill Moran wrote: Then replace the DB client class with a class that returns fabricated data for the purpose of your test. Won't work because I am writing SQL and I want to test the SQL is correct Well, be warned that not

Re: [GENERAL] Line Number

On 04/08/2009 17:30, Bob Pawley wrote: > I haven''t required line numbers on my query pages before now. > > I'm using PGAdmin version 1.8.4. > > Is this something that can be turned on? Hi Bob, Do you mean the source code of your queries, in the Edit Query window? If so, it doesn't show line

Re: [GENERAL] Line Number

On Tue, 2009-08-04 at 09:30 -0700, Bob Pawley wrote: > I haven''t required line numbers on my query pages before now. > > I'm using PGAdmin version 1.8.4. > > Is this something that can be turned on? Maybe but it should be asked here: http://www.pgadmin.org/support/list.php Joshua D. Drake

[GENERAL] Line Number

I haven''t required line numbers on my query pages before now. I'm using PGAdmin version 1.8.4. Is this something that can be turned on? Bob

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

In response to Paul Taylor : > Bill Moran wrote: > > > > Then replace the DB client class with a class that returns fabricated > > data for the purpose of your test. > > > Won't work because I am writing SQL and I want to test the SQL is correct Well, be warned that not all alternatives to Pos

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

>Thats a shame, I wanted to write junit test for a java program that queried a >database, requiring a full database to be available for unit tests is not >really an >environment I want to have. Why not? if you doesn't test the real thing you test is meaningless. you should test the real database

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

On Tue, Aug 4, 2009 at 8:37 AM, Paul Taylor wrote: > Bill Moran wrote: >> >> In response to Paul Taylor : >> >> >>> >>> Bill Moran wrote: >>> In response to Paul Taylor : > > Sam Mason wrote: > >> >> On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

On Tue, Aug 04, 2009 at 04:04:42PM +0100, Paul Taylor wrote: > >You don't really need to run an installer and/or create registry > >entries (for windows). This would then resemble more the Derby > >network server setup. > Yeah, but this is messy and low because you have to wait the > database to b

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Paul Taylor wrote on 04.08.2009 17:04: Well if you want to test the database, you will need a full database. It was a simple question, does Postgres have an embedded mode (which is still a full database) but unfortunately it does not. I'm just trying to help get your test environment into prop

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Bill Moran wrote: In response to Paul Taylor : Bill Moran wrote: In response to Paul Taylor : Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be embedde

[GENERAL] Re: character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

On Tue, Aug 4, 2009 at 4:02 PM, Alban Hertroys wrote: > P.S. Please don't top post and keep some context of what you're replying to. > Your messages are a bit confusing the way you write them. These arguments are more convincing if you don't leave the remainder of the OP's message quoted right be

Re: [GENERAL] character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

I know what you are talking about, but I am not sure how many websites really check for incoming encoding. Usually you trust that the client will use the same encoding for sending data as the server has sent. (This is what I mean with my simplified chain) It's some extra work to do converting

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Thomas Kellerer wrote: Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you will n

Re: [GENERAL] parameters in functions and overlap with names of columns

2009/8/4 Ivan Sergio Borgonovo : > On Tue, 4 Aug 2009 16:01:58 +0200 > Pavel Stehule wrote: > >> 2009/8/4 Ivan Sergio Borgonovo : >> > I've >> > >> > create or replace function(... >> > >> > declare >> >  col1 varchar(32); >> > ... >> > >> >  create table pippo( >> >    col1 varchar(32), >> > ...

Re: [GENERAL] character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

On 4 Aug 2009, at 15:02, Andreas Kalsch wrote: Alban, what I do to simplify the data chain: HTTP encoding > PHP string encoding > client connection > server - all is UTF8. Plus invalid byte check in PHP (or server). You're missing my point. You start dealing with the encoding of the data

Re: [GENERAL] InitDB 8.3.7 fails on Windows - Failed system call was MapViewOfFileEx

On Tue, Aug 4, 2009 at 16:48, Abraham, Danny wrote: > Hi, > > InitDB of 8.3.7 fails. > Windows XP. > Compiled with VC2008, SP1 Please note that VC2008 is not a supported build environment for the backend. you need to get VC2005. > creating template1 database in ... > > 2009-08-04 11:46:53.954 GM

Re: [GENERAL] parameters in functions and overlap with names of columns

2009/8/4 Alvaro Herrera : > Ivan Sergio Borgonovo wrote: >> On Tue, 4 Aug 2009 16:01:58 +0200 >> Pavel Stehule wrote: >> >> > 2009/8/4 Ivan Sergio Borgonovo : > >> > > Is there another way other than just simply rename the variable? >> > >> > yes - the most common is an using of prefix '_' for loc

Re: [GENERAL] parameters in functions and overlap with names of columns

Ivan Sergio Borgonovo writes: > Pavel Stehule wrote: >> yes - the most common is an using of prefix '_' for local plpgsql >> variables. Other possibility is using qualified names. > Just to be sure... by qualified names you mean schema qualified name > or table qualified names in case of columns

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Bayless Kirtley wrote: Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you wi

Re: [GENERAL] parameters in functions and overlap with names of columns

Ivan Sergio Borgonovo wrote: > On Tue, 4 Aug 2009 16:01:58 +0200 > Pavel Stehule wrote: > > > 2009/8/4 Ivan Sergio Borgonovo : > > > Is there another way other than just simply rename the variable? > > > > yes - the most common is an using of prefix '_' for local plpgsql > > variables. Other po

[GENERAL] InitDB 8.3.7 fails on Windows - Failed system call was MapViewOfFileEx

Hi, InitDB of 8.3.7 fails. Windows XP. Compiled with VC2008, SP1 creating template1 database in ... 2009-08-04 11:46:53.954 GMTFATAL: could not create shared memory segment: 8 2009-08-04 11:46:53.970 GMTDETAIL: Failed system call was MapViewOfFileEx. child process exited with exit code 1 A

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you will need a full database.

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

In response to Paul Taylor : > Bill Moran wrote: > > In response to Paul Taylor : > > > >> Sam Mason wrote: > >> > >>> On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: > >>> > >>> > Does postgres have an embedded mode to allow a database to be embedded > with

Re: [GENERAL] parameters in functions and overlap with names of columns

On Tue, 4 Aug 2009 16:01:58 +0200 Pavel Stehule wrote: > 2009/8/4 Ivan Sergio Borgonovo : > > I've > > > > create or replace function(... > > > > declare > >  col1 varchar(32); > > ... > > > >  create table pippo( > >    col1 varchar(32), > > ... > > > > Unfortunately I can't schema specify the c

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Paul Taylor, 04.08.2009 15:48: Thats a shame, I wanted to write junit test for a java program that queried a database, requiring a full database to be available for unit tests is not really an environment I want to have. Well if you want to test the database, you will need a full database.

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Bill Moran wrote: In response to Paul Taylor : Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby da

Re: [GENERAL] parameters in functions and overlap with names of columns

2009/8/4 Ivan Sergio Borgonovo : > I've > > create or replace function(... > > declare >  col1 varchar(32); > ... > >  create table pippo( >    col1 varchar(32), > ... > > Unfortunately I can't schema specify the column to avoid name > overlap. > > Is there another way other than just simply rename

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

In response to Paul Taylor : > Sam Mason wrote: > > On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: > > > >> Does postgres have an embedded mode to allow a database to be embedded > >> with Java application without requiring seperate db manager, like the > >> derby database does

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

Sam Mason wrote: On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby database does ? No, and I think the consensus is that this w

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote: > Does postgres have an embedded mode to allow a database to be embedded > with Java application without requiring seperate db manager, like the > derby database does ? No, and I think the consensus is that this would be bad. See:

Re: [GENERAL] parameters in functions and overlap with names of columns

On Tue, Aug 04, 2009 at 02:20:00PM +0200, Ivan Sergio Borgonovo wrote: > create or replace function(... > declare > col1 varchar(32); > Unfortunately I can't schema specify the column to avoid name > overlap. I think this is a limitation of plpgsql's parser; I tend to declare local variables wi

Re: [GENERAL] character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

Alban, what I do to simplify the data chain: HTTP encoding > PHP string encoding > client connection > server - all is UTF8. Plus invalid byte check in PHP (or server). What I have tested inside Postgres is entering a 3 byte UTF8 character to this function. And I have got an error. This is a

Re: [GENERAL] Refer to another database

In article <4a77c4af.2060...@gmx.de>, Andreas Kalsch writes: > To be completely > in context of a schema - so that I can use all tables without the > prefix - I have to reset the search_path very often. Why? Just say "ALTER DATABASE foo SET search_path = public, bar, baz" once and you're done.

[GENERAL] Does derby have an embedded Mode like Derby ?

Hi Does postgres have an embedded mode to allow a database to be embedded with Java application without requiring seperate db manager, like the derby database does ? Paul -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

[GENERAL] parameters in functions and overlap with names of columns

I've create or replace function(... declare col1 varchar(32); ... create table pippo( col1 varchar(32), ... Unfortunately I can't schema specify the column to avoid name overlap. Is there another way other than just simply rename the variable? thanks -- Ivan Sergio Borgonovo http://

Re: [GENERAL] Refer to another database

On 4 Aug 2009, at 7:43, Andreas Kalsch wrote: 1) I have to rewrite many lines of code = time Why? You do know that you can set multiple schemas in search_path do you? It's a path ;) Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no fore

Re: [GENERAL] character 0xe29986 of encoding "UTF8" has no equivalent in "LATIN2"

On 4 Aug 2009, at 24:57, Andreas Kalsch wrote: I think the real problem is: Where do you lose the original encoding the users input their data with? If you specify that encoding on the connection and send it to a database that can handle UTF-8 then you shouldn't be getting any conversion pr

Re: [GENERAL]

> From: sw...@opspl.com > Subject: Re: [GENERAL] > To: pgsql-general@postgresql.org > Date: Tuesday, 4 August, 2009, 11:03 AM > > Hello , > > >> > >          >    You can use "kill " command to > kill the slon daemons, > > find > > the pid's of the cluster and kill. > > > > > >      But tha

Re: [GENERAL]

Hello , >> > You can use "kill " command to kill the slon daemons, > find > the pid's of the cluster and kill. > > But that is not totally right :P . If there is no other way we will use it.. But I want to stop slony properly using slony command. :) Regards , Sweta. --

[GENERAL]

Hello , I know this is not the right place to post following query... but any help offered will help me a lot :) Can anyone tell me how to stop slony (its a postgres replication system ) I tried slon_kill but it says bash-3.2$ /usr/bin/slon_kill slon_kill.pl... Killing all