[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 couple of years experience in programming PARADOX ACCES databases), I also have the question, where are the main differences - except there is an open source software on the one hand and a commercial on the other - between these two databases? What does make ORACLE to be the first choice ? Under what kind of circumstances could be PostgreSQL the first choice ? After all: What are the main missing functions in PostgreSQL to put it to the same level as ORACLE - or does it still be ? If not: Will there be a chance in the near future, that I can supersede an ORACLE- database with a PostgreSQL one, under any circumstances ? I really don't want to start a database flame; all I want to get is a general overview based upon your experience - and yes, I have read the manuals allready, but maybe not everything in detail :-). Thank´s for care and for helping me along Kind regards Axel In a world without walls and fences, who needs windows and gates? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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, exiting Andy Koch. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
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 it if you are to guarantee that the data will be acceptable as input. $myVar = $myDB - quote ($myVar) I'm using the Pg perl interface. But, think my problem was that I had unescaped single quotes in the string. Added the following to my code to escape them and it works now: $self-{errors} =~ s'\\'g;# escape single quotes ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Randy Perry sysTame Mac Consulting/Sales phn 561.589.6449 mobile email[EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
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 only thing that can help you. I forgot to explain: erserver works well out of the box for one master / one slave setup. If you need more than one slave, you need some hacking around. If you need more than one master, I doubt it'll work in its current form. -- Alvaro Herrera (alvherre[@]atentus.com) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[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? http://www.postgresql.org/search.mpl
[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 only way to insert data in the created table is to insert with admin user postgres. SuSE 7.1 ships with postgresql 7.0.2 Thanks in advance for your help! Best Regards José Manuel Lorenzo López ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 this table with User A. The error message is always: ERROR: tableA: Permission denied. Seems to be a grant problem or the user is not known to the database. Have you created the user with createuser? Regards Herbie -- Herbert Liechti E-Mail: [EMAIL PROTECTED] ThinX networked business services Adlergasse 5, 4500 Solothurn ~~~ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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- De: Hervé Piedvache [SMTP:[EMAIL PROTECTED]] Date: jeudi 7 juin 2001 11:20 À:[EMAIL PROTECTED] Objet:[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? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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 FUNCTION address_oid (VARCHAR) returns OID AS' SELECT OID from address s where s.city = $' LANGUAGE 'SQL'; INSERT INTO address VALUES (5, 'bd Les Champs Elizy', 'Paris' , 'France'); INSERT INTO address VALUES (10, 'Place Leclerc', 'Poitiers' , 'France'); the question is : how we can insert values in person table by using address_oid function. the solution I find is to make this in several steps : INSERT INTO person VALUES ('Dupont', '{}'); Update person set add[1] = address_oid ('Poitiers'); Update person set add[1] = address_oid ('Paris'); can someone know how we can make this in one step without using update commad. thanks for your help, Mourad. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
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 PROTECTED] wrote: 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? http://www.postgresql.org/search.mpl __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster