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
Hello ,
You can use kill pid 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.
--
Sent
From: sw...@opspl.com sw...@opspl.com
Subject: Re: [GENERAL]
To: pgsql-general@postgresql.org
Date: Tuesday, 4 August, 2009, 11:03 AM
Hello ,
You can use kill pid command to
kill the slon daemons,
find
the pid's of the cluster and kill.
But that is
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
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
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
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:
In article 4a77c4af.2060...@gmx.de,
Andreas Kalsch andreaskal...@gmx.de 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
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
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 with
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:
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
In response to Paul Taylor ij...@fastmail.fm:
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
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
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
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
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,
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.
On Tue, 4 Aug 2009 16:01:58 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
I've
create or replace function(...
declare
col1 varchar(32);
...
create table pippo(
col1 varchar(32),
...
Unfortunately I can't
In response to Paul Taylor ij...@fastmail.fm:
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
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
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
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
Ivan Sergio Borgonovo wrote:
On Tue, 4 Aug 2009 16:01:58 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
Is there another way other than just simply rename the variable?
yes - the most common is an using of prefix '_' for local
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
Ivan Sergio Borgonovo m...@webthatworks.it writes:
Pavel Stehule pavel.steh...@gmail.com 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
2009/8/4 Alvaro Herrera alvhe...@commandprompt.com:
Ivan Sergio Borgonovo wrote:
On Tue, 4 Aug 2009 16:01:58 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
Is there another way other than just simply rename the variable?
yes -
On Tue, Aug 4, 2009 at 16:48, Abraham, Dannydanny_abra...@bmc.com 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
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
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
On Tue, 4 Aug 2009 16:01:58 +0200
Pavel Stehule pavel.steh...@gmail.com wrote:
2009/8/4 Ivan Sergio Borgonovo m...@webthatworks.it:
I've
create or replace function(...
declare
col1 varchar(32);
...
create table pippo(
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
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
On Tue, Aug 4, 2009 at 4:02 PM, Alban
Hertroysdal...@solfertje.student.utwente.nl 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
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
Sam Mason wrote:
On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote:
Does postgres have an embedded
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
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 be fully
On Tue, Aug 4, 2009 at 8:37 AM, Paul Taylorij...@fastmail.fm wrote:
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
Sam Mason wrote:
On Tue, Aug 04, 2009 at 01:37:34PM +0100, Paul Taylor wrote:
Does
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
In response to Paul Taylor ij...@fastmail.fm:
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
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
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
--
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
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
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,
In response to Paul Taylor ij...@fastmail.fm:
Bill Moran wrote:
In response to Paul Taylor ij...@fastmail.fm:
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
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
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 (delete
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
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
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
Hello
2009/8/4 Gert gert.conra...@gmail.com:
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
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
Richard Yen richy...@gmail.com 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
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
On Tue, Aug 4, 2009 at 5:09 AM, Der Tungdert...@gmx.de 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
- Original Message -
From: Paul Taylor ij...@fastmail.fm
To: pgsql-general@postgresql.org
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
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 stop the
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
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
Doug Gorley doug.gor...@gmail.com 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
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 mailto:doug.gor...@gmail.com
Tom Lane wrote:
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.
Doug Gorley doug.gor...@gmail.com 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.
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
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
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 AD are in
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
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
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 IDLE, while Process Explored
65 matches
Mail list logo