The first is easy; simply configure data sources pointed at the PostgreSQL
database. Note that the JDBC drivers that ship with Pentaho are, in my
experience, of inconsistent version, and you might want to update them to the
latest available for your PostgreSQL and Java versions.
In my
This is PostgreSQL 8.4, but the behaviour has not changed from earlier versions:
test= SHOW timezone;
TimeZone
---
Europe/Vienna
(1 row)
test= SELECT date_part('timezone_hours', timestamp with time zone '2009-06-26
10:05:57.46624+11');
date_part
---
2
(1
On 2009-06-26, luca.cicirie...@email.it luca.cicirie...@email.it wrote:
I've wrote a PLPGSQL stored procedure for a DB I've to delivery to my
customer. The problem is that I want to hide the code of the stored
procedure. I don't want that my customer is able to read the code of the my
sp.
Do
On 2009-06-27, Merlin Moncure mmonc...@gmail.com wrote:
I've noticed over a wide variety of operating systems that when you
paste from an application into psql through a terminal (currently
using the default gnome terminal in ubuntu), large pastes tend to get
garbled with some of the input
In my case (FreeBSD 6 and 7) psql does not freezes, but for some reason
part of pasted code get corrupted when size of the code relatively big.
It seems like some timeout used, or buffer overflows:
1. locally with xterm for the first time pasting function of 9K:
base= create or replace
On 2009-06-24, Philippe Amelant pamel...@companeo.com wrote:
Le mercredi 24 juin 2009 à 12:45 +, Jasen Betts a écrit :
On 2009-06-24, Philippe Amelant pamel...@companeo.com wrote:
Ok but if I work with hours or whatever the problem is still there
SELECT (EXTRACT(EPOCH FROM TIMESTAMP
Albe Laurenz wrote:
test= SELECT date_part('timezone_hours', timestamp with time zone '2009-06-26
10:05:57.46624+11');
date_part
---
2
(1 row)
2 being the offset of my local time zone.
Now an EXPLAIN shows that this is due to the fact that the timestamp
is converted to my
On Sun, 2009-06-28 at 09:01 -0700, David Fetter wrote:
Are there any rules of thumb to consider for making an application
easier to work with a general replication solution?
The applications I mostly deal with are e-commerce sites.
It really depends on what replication solution you
Hi!
I wanna ask something. I came from IB/FB world.
In this world I was everytime in transaction, because of reads are also
working under transactions.
In the FB world the transactions without any writes/updates are not
locking the database, so another clients can makes a transactions on any
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All,
When configuring a Slony cluster I get the infamous 'ERROR: invalid
input syntax for type timestamp: Mon Jun 29 13:00:36.628805 2009 WEST'
I know that this is a timezone setting issue.
In my case I have my system set to 'Atlantic/Madeira'
On Mon, 29 Jun 2009 19:11:43 +0800
Craig Ringer cr...@postnewspapers.com.au wrote:
On Sun, 2009-06-28 at 09:01 -0700, David Fetter wrote:
Are there any rules of thumb to consider for making an
application easier to work with a general replication
solution?
The applications I
I'm trying to create a PostGIS database by using
CREATE DATABASE mydb TEMPLATE template_postgis;
using the Windows one-click installer package, with PostGIS 1.3 /
Postgres 8.3.7.
But my question is more general:
When a new database is created base on a template, the owner of those
tables is not
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Thanks for your help:
dd
ps: in my prev. mail I asked this too, but in another context...
possible
On Fri, Jun 26, 2009 at 3:37 PM, arta...@comcast.net wrote:
I completely agree w/ HArald. Its not something we'd want to see in an open
source product. That said, I saw yesterday that the latest version of
EnterpriseDB has this feature. So if you want to protect your own IP, then
you've
In response to durumdara :
Hi!
Can I check with something that I'm in in-transaction or in autocommit
mode?
I wanna avoid the notices I got when I'm also in mode I need...
For example:
begin
begin --- error notice...
Warning, not error.
In psql, you can set the PROMPT:
\set PROMPT1
On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead scott.li...@enterprisedb.comwrote:
It is important to note (as many people have already pointed out) that
both EnterpriseDB and Oracle's wrap functionality is declared as a 100%
guarantee that nobody can read your code. As with many different
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris jonah.har...@gmail.comwrote:
On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
scott.li...@enterprisedb.comwrote:
It is important to note (as many people have already pointed out) that
both EnterpriseDB and Oracle's wrap functionality is
BJ Freeman bjf...@free-man.net writes:
sorry about the post did not do a reply all and sent a personal replay
yes in the chain I have
ACCEPT all -- anywhere anywherestate
RELATED,ESTABLISHED
it is the next to last rule.
You sure that works? This notation for
Pedro Doria Meunier pdo...@netmadeira.com writes:
When configuring a Slony cluster I get the infamous 'ERROR: invalid
input syntax for type timestamp: Mon Jun 29 13:00:36.628805 2009 WEST'
You need to make the timezone_abbreviations configuration on the slave
match that on the master.
On Mon, Jun 29, 2009 at 09:02:30AM +0300, Sim Zacks wrote:
The first is easy; simply configure data sources pointed at the PostgreSQL
database. Note that the JDBC drivers that ship with Pentaho are, in my
experience, of inconsistent version, and you might want to update them to
the
On Mon, Jun 29, 2009 at 07:11:43PM +0800, Craig Ringer wrote:
On Sun, 2009-06-28 at 09:01 -0700, David Fetter wrote:
Are there any rules of thumb to consider for making an application
easier to work with a general replication solution?
The applications I mostly deal with are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks Tom for your thoughts :)
I tried what you suggested to no avail :-(
Looking at this more closely I see this format when the error arises:
Mon Jun 29 15:28:10.952151 2009 WEST
Curiously enough this is what the following command throws out of
To migrate the site, you can use an open source ETL tool.
Talend Open Studio is an open source ETL tool for data integration and
migration experts. It's easy to learn for a non-technical user. What
distinguishes Talend, when it comes to business users, is the tMap
component. It allows the user
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris jonah.har...@gmail.comwrote:
On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
scott.li...@enterprisedb.comwrote:
It is important to note (as many people have already pointed out) that
both EnterpriseDB and Oracle's wrap functionality is
Jasen Betts schrieb:
I've wrote a PLPGSQL stored procedure for a DB I've to delivery to my
customer. The problem is that I want to hide the code of the stored
procedure. I don't want that my customer is able to read the code of the my
sp.
Do exist a way to mask the code of the store procedure
Le samedi 27 juin 2009, Merlin Moncure a écrit :
I've noticed over a wide variety of operating systems that when you
paste from an application into psql through a terminal (currently
using the default gnome terminal in ubuntu), large pastes tend to get
garbled with some of the input getting
On Sat, Jun 27, 2009 at 5:12 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
I'm starting to feel like my problems start appearing at a very fixed
size (like you, a few hundred or so). Do you see this in other
programs (bash, vim, etc)? or only psql?
I've
On Fri, Jun 26, 2009 at 4:36 PM, Brian
Troutwinegoofyheadedp...@gmail.com wrote:
*) use indexes to optimize where and join conditions. for example,
update yadda set yadda where foo = bar, make sure that there is an
index on foo. As alan noted this is almost definitely your problem.
To my
Pedro Doria Meunier pdo...@netmadeira.com writes:
This is what's defined in postgresql.conf
datestyle = 'iso, ymd'
timezone = 'Atlantic/Madeira'
Hmm. WET/WEST are the zone abbreviations for that zone, all right,
but I don't understand why they're being emitted if you have that
datestyle
--- On Mon, 6/29/09, Tguru g...@talend.com wrote:
From: Tguru g...@talend.com
Subject: Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql
function
To: pgsql-general@postgresql.org
Date: Monday, June 29, 2009, 1:33 PM
To migrate the site, you can use an open source
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom,
This is what I have in '/usr/share/pgsql/timezonesets/Atlantic.txt':
WEST 3600 D # Western Europe Summer Time
# (Atlantic/Canary)
# (Atlantic/Faeroe)
# (Atlantic/Madeira)
Hi everybody,
actually I am wondering if anybody can give me some links to a more in depth info
concerning the GIN and GiST index. After having read the docu and searching the web for
more info, I am still not satisfied with the knowledge I have.
For sure I had a look to Oleg Bartunov' s and
On 29/06/2009 16:39, Pedro Doria Meunier wrote:
btw: do you happen to know of a Slony mailing list?
Here you go:
http://lists.slony.info/mailman/listinfo
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
On Mon, 2009-06-29 at 13:36 +0200, durumdara wrote:
I wanna ask something. I came from IB/FB world.
InterBase / FireBird ?
In this world I was everytime in transaction, because of reads are
also working under transactions.
Just like PostgreSQL. You can't run a query without a transaction in
For sure I had a look to Oleg Bartunov' s and Teodor Sigaev's
website at http://www.sai.msu.su/~megera/wiki/ but for me
it's still not clear how to describe the differences between
the indexes and the usage scenarios when to use GIN or GiST.
As far as I understand it's a matter of usage
On Mon, Jun 29, 2009 at 10:49 AM, Cédric Villemain
cedric.villem...@dalibo.com wrote:
Le samedi 27 juin 2009, Merlin Moncure a écrit :
Interestingly, the one platform that tends not to suffer from this is
windows so I'm guessing this is a readline problem. Has anybody else
noticed
This idea is meant as an alternative to MySQL-style GRANT ... * or
other similar permissions schemes.
I posted a similar message on -hackers here:
http://archives.postgresql.org/pgsql-hackers/2009-06/msg01393.php
I'm posting on -general now to get some feedback from potential users to
see if it
On Mon, Jun 29, 2009 at 1:01 PM, Jeff Davis pg...@j-davis.com wrote:
CREATE USER read_only_user
GRANT (SELECT ON TABLE, USAGE ON SCHEMA) FROM admin_user;
read_only_user would automatically have SELECT privileges on any table
that admin_user has SELECT privileges on, and automatically have
On Sat, Jun 27, 2009 at 08:23:26PM -0400, APseudoUtopia wrote:
- Hey list,
-
- I'm migrating my site away from MySQL to PostgreSQL. So far, it's been
- going great. However, there's one problem I've been having trouble
- solving.
-
- I have a query which allows users to Catch up on read posts on
On Jun 28, 2009, at 11:45 AM, Whit Armstrong wrote:
Thanks, Tom.
Let me give a little more detail on my actual data rather than the
simple example I sent.
I have a 60GB table of loan balances, which I've partitioned into 26
tables.
The loan id's are a sequence of 6 characters, so the
Hi Volk,
at first sorry for my English. I use postgresql very often and I really
love it but the syntax for outer join make me sick.
Oracle short notation (+) is also not a best choice at this place but I
recall me, that the Informix have a really good and clear syntax:
select * from a, outer
On Mon, Jun 29, 2009 at 2:08 PM, littlesuspenselittlesuspe...@web.de wrote:
Hi Volk,
at first sorry for my English. I use postgresql very often and I really
love it but the syntax for outer join make me sick.
Oracle short notation (+) is also not a best choice at this place but I
recall me,
On Mon, Jun 29, 2009 at 5:11 PM, Scott Marlowescott.marl...@gmail.com wrote:
On Mon, Jun 29, 2009 at 2:08 PM, littlesuspenselittlesuspe...@web.de wrote:
Hi Volk,
at first sorry for my English. I use postgresql very often and I really
love it but the syntax for outer join make me sick.
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By schema, I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd really like something that could work for other databases too,
fe...@crowfix.com wrote on 30.06.2009 00:08:
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By schema, I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd really like
On Mon, Jun 29, 2009 at 4:08 PM, fe...@crowfix.com wrote:
I'd like to dump a database schema to a file, probably XML but
anything reasonable is good enough. By schema, I don't mean the
narrow postgres keyword, but rather the table names, columns,
foreignkeys, triggers, constraints, etc.
I'd
On Mon, Jun 29, 2009 at 04:32:46PM -0600, Scott Marlowe wrote:
Have you tried pg_dump -s yet?
We I know I said the format is immaterial, and I know I could
write something to convert it into something more useful, but it is on
the low end of what I was looking for, and is very much
On Tue, Jun 30, 2009 at 12:21:22AM +0200, Thomas Kellerer wrote:
Take a look at my SQL Workbench/J, especially the WbReport command:
http://www.sql-workbench.net/index.html
http://www.sql-workbench.net/manual/wb-commands.html#command-schema-report
That just may do the trick. I'll explore
Hi all
I have a software developed in Delphi as a Windows Service, but, i don't
know why, it consumns an unexpected large system memory (515m).
The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400) and it
consist simply of a loop calling a procedure PL/PGSQL. How to discover what
is
Is there anyway to connect to postgre using a 64 bit Windows OS?
I am having problems connecting to a local DB since i have upgraded my
computer.
I would like to connect using C#.NET
Any help would be appreciated.
Drew
use the .net provider
http://npgsql.projects.postgresql.org/
I'm not sure of a 64bit build. although a 32bit version should run on 64 bit
windows without any problems.
Message from mailto:drewtimm...@gmail.com Andrew Timmins
drewtimm...@gmail.com at 06-29-2009 05:36:58 PM --
Is
On Mon, Jun 29, 2009 at 2:31 PM, Scott Meadscott.li...@enterprisedb.com wrote:
As with many different types of security (i.e. the 3 foot high fence) this
is really just a deterrent to most people who either aren't capable of
reverse engineering or are just not interested in the first place.
On Mon, Jun 29, 2009 at 6:14 PM, Anderson Valadaresanderva...@gmail.com wrote:
Hi all
I have a software developed in Delphi as a Windows Service, but, i don't
know why, it consumns an unexpected large system memory (515m).
The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400)
53 matches
Mail list logo