Hi
Try Mogwai ERDesignerNG. it can reverse engineer databases like
Postgres, Oracle, MySQL, MSSQL, stores its model as XML files and can
also generate DDL from it.
Supporting schema comparison, schema evolution and data dictionaries.
Regards
Mirko
fe...@crowfix.com schrieb:
I'd like to dump
On Mon, Jun 29, 2009 at 6:14 PM, Anderson Valadares 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) and it
> consist si
On Mon, Jun 29, 2009 at 2:31 PM, Scott Mead 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.
Someone I know used to work
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 ther
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
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
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 exp
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 Pos
On Mon, Jun 29, 2009 at 4:08 PM, 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 really li
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 so
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
On Mon, Jun 29, 2009 at 5:11 PM, Scott Marlowe wrote:
> On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense 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
On Mon, Jun 29, 2009 at 2:08 PM, littlesuspense 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, that the Inform
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 b
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 part
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 o
On Mon, Jun 29, 2009 at 1:01 PM, Jeff Davis 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 USAGE
>
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 i
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
> >
> 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, 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
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
r
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
-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)
--- On Mon, 6/29/09, Tguru wrote:
> From: Tguru
> 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 ETL tool.
>
> Talend Open
Pedro Doria Meunier 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 setting. Maybe somethi
On Fri, Jun 26, 2009 at 4:36 PM, Brian
Troutwine 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 knowledge, I have. a
On Sat, Jun 27, 2009 at 5:12 PM, Tom Lane wrote:
> Merlin Moncure 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 only noticed it in psql, but t
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
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 s
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote:
> On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
> wrote:
>
>>
>>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
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 to
-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
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 wit
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
> >
Pedro Doria Meunier 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. Alternatively, set datest
BJ Freeman 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 iptables isn't fa
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote:
> On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
> wrote:
>
>>
>>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
On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead wrote:
>
>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 types of
> security (i.e. t
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:
On Fri, Jun 26, 2009 at 3:37 PM, 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 got to purchase
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...
pos
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
On Mon, 29 Jun 2009 19:11:43 +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 wi
-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'
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
r
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 solut
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 2009-06-24, Philippe Amelant wrote:
> Le mercredi 24 juin 2009 à 12:45 +, Jasen Betts a écrit :
>> On 2009-06-24, Philippe Amelant wrote:
>> > Ok but if I work with hours or whatever the problem is still there
>> >
>> > SELECT (EXTRACT(EPOCH FROM TIMESTAMP '2009-06-23 18:36:05.064066+02')
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 functi
On 2009-06-27, Merlin Moncure 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 getting truncated.
On 2009-06-26, 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 exist a way to mas
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
> 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
54 matches
Mail list logo
