[GENERAL] PostgreSQL 7.1 and ORACLE 8.x

Hello everybody out there, does anybody of you have experience with PostgreSQL 7.1 and ORACLE 8.x running simultaneously on the same server (Linux: Kernel 2.2.16), and could they be connected in any way to share some data ? As a beginner in client-server achitectured databases ( I only have a

Re: [GENERAL] bug?: java won't read timestamps

Hi Dave, Thanks for your hint. It was indeed a problem with an older postgresql.jar sneaking into my classpath. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de ---(e

[GENERAL] Can not pg_dumpall

Can anyone help me with this error message I get when I attempt to dump my database? [dfunct@localhost dfunct]$ pg_dumpall > /home/dfunct/OnEd_backups/OnEd_Wednesday.sql getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exitin

Re: [GENERAL] Text data type doesn't accept newlines?

Not sure, but the syntax is as I described below. Try checking the perl DBD::Pg documentation. I think that's where I read about it originally, many moons ago. > Just checked the Pg docs, don't see a quote function. What is it part of? > > > > Are you using the "quote" function? You have to use i

Re: [GENERAL] PostgreSQL Replication Server?

Or try: http://pgreplicator.sourceforge.net/ Haven't used it myself yet, but it looks pretty good... > > Now, erserver seems to work, but it needs a bit hacking around that I > > hadn't done yet. Maybe when I get it working I'll see to writing > > something. In the mean time, source code is the

[GENERAL] Accessing two differents database in a SELECT

Hi, How and is it possible to access to two differents tables which are stored in two differents database ? Will it be possible one day ? Thanks for your answers, -- Hervé ---(end of broadcast)--- TIP 6: Have you searched our list archives? htt

[GENERAL] postgresql on SuSE 7.1 with reiserfs

Hello community, anyone experienced problems using postgresql distribution on SuSE 7.1 with reiserfs??? I noticed the following problem: When creating a table 'tableA' as User A I can not insert in this table with User A. The error message is always: ERROR: tableA: Permission denied. The on

Re: [GENERAL] postgresql on SuSE 7.1 with reiserfs

On Thu, 7 Jun 2001, Jose Manuel Lorenzo Lopez wrote: > Hello community, > > anyone experienced problems using postgresql distribution > on SuSE 7.1 with reiserfs??? Yes without any problems. > > I noticed the following problem: > > When creating a table 'tableA' as User A I can not insert in th

RE: [GENERAL] Accessing two differents database in a SELECT

If you use Perl, I think there is a DBI proxy driver. It works as a DBI driver for the script that uses the DB, but in fact redirects queries as a proxy, to whatever you want. Maybe it can redirect queries to many DB's ? You will just have problem with joins... NH > -Message d'origine-

[GENERAL] the use of expressions instead of simple values in array insertion?

Hi, I encounter a problem whene I wanted use expressions to inset values in column whose values are of array type. the following example illustrates this problem: CREATE TABLE address (Num INT4, street VARCHAR, city VARCHAR, contry VARCHAR); CREATE TABLE person (name VARCHAR, add OID[]); CREATE F

Re: [GENERAL] Accessing two differents database in a SELECT

I use MS Access as a front-end to PostgreSQL. Not only can I link tables from different PostgreSQL databases, but I can link tables from different ODBC compliant database products such as MySQL, MS Access, PostgreSQL, and Sybase. I hope this helps, Andrew Gould --- Hervé Piedvache <[EMAIL PROT