On Wed, 2006-03-01 at 16:00 -0700, Roy Souther wrote:
> I need an Open Source SQL command line tool for Windows that will let
> me script queries to a database over an ODBC connection. It must use
> ODBC because it may or may not be PostgreSQL. Some times it will but
> the rest of the time I have n
On Thu, 2005-05-05 at 14:16 -0400, Jeff - wrote:
> One of the biggest things for Slony is that you can install slony,
> set things up and it will bring the slave(s) "up to speed". You
> don't need to do an initial data dump (I think you still need to load
> the schema on the slaves, but not
On Fri, 2005-03-18 at 08:39 +0800, S Ram wrote:
> Hello,
>
> PostgreSQL is distributed as .RPM files. How do I
> install this in Debian?
As others have said, apt-get will install PostgreSQL from the standard
Debian repositories. However, if you're running Debian stable, you
might want to use a m
On Tue, 2005-02-15 at 15:01 +, Jeff Amiel wrote:
> I'm looking specifically for a tool to help compare 2 database schemas
> (nominally, production and development) and generate the appropriate SQL
> (that can be later executed) to bring the to schema's into sync.
[snip]
> What does the rest o
On Sun, 2004-11-07 at 16:32, Eric wrote:
> Is there a visual designer (open source) in linux for database? I would
> like to developp my data model on the computer...
'Druid' is a Java app that does schema diagrams and point and click
table management stuff:
http://druid.sourceforge.net/
I h
On Wed, 2004-07-28 at 23:41, Janning Vygen wrote:
> Hi,
>
> EXPLAIN on delete stamements works, but doesn't show me all the subsequent
> deletes or checks which has to be done because of foreign keys
> cascading/restricting.
>
> Is there a solution to show up which tables are checked and which
On Fri, 2004-07-02 at 04:35, Rune Froysa wrote:
> I have one table with columns that are used as foreign-keys from
> several other tables. Sometimes deletion from this table takes +5
> seconds for a single row.
Do you have indexes on the foreign key columns in the child tables?
For example, sa
