[GENERAL] is possible to read oracle tables from PostgresSQL

I need to know if is possible to read oracle tables from PostgresSQL (and vice versa). Can someone give me some help? Thanks a lot ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] maximum number of client connections?

We have the situation where it would be convenient if we could support a large number (>1024, possibly in the 2000-3000 range) of client connections. What are our options for this? Many TIA, Mark -- Mark Harrison Pixar Animation Studios Emeryville, CA ---(end of broadcast)-

[GENERAL] problem with function to report how many records were changed

Hi, I intend to get some answer from postgres concerning if an update command has altered some records in the database. To do this I coded this function: create or replace function upd_ok(text,text,text,text) returns integer as ' declare table alias for $1; field alias fo

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

In article <[EMAIL PROTECTED]>, John Wells <[EMAIL PROTECTED]> wrote: >Here's an interesting response from mysql.com sales. Frankly, I don't see >how using it on multiple internal servers violates the GPL?!?: You're talking to a sales droid, a suit, someone whose brain cells have died off because

Re: [GENERAL] VACUUM degrades performance significantly. Database

Scott, I dropped the 5 way unique index and the VACUUM improved slightly. I ran VACUUM, ANALYZE, VACUUM and queries repeatedly. The max response time seem to have reduced to 1700 msec from 2300 msec. The higher load and vmstat during VACUUM remained the same. It's still not enough to justify dropp

Re: [GENERAL] easy way to insert same value into 2 columns

On Thu, Oct 16, 2003 at 13:53:27 +0200, Sebastian Boeck <[EMAIL PROTECTED]> wrote: > Csaba Nagy wrote: > >I can't 100% say it's safe to use, but no, other inserts will not > >influence the value, because currval will return the last sequence value > >used by the current session (i.e. the current

Re: [GENERAL] Damaged table

Dagoberto wrote: can somebody tell me how can I get old data from a recently damaged table? What does mean damaged? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Remote updating

Dennis, This may not be much help, but you might want to take a look into The eRserver Project http://gborg.postgresql.org/project/erserver/projdisplay.php Jordan S. Jones -- I am nothing but a poor boy. Please Donate.. https://www.paypal.com/xclick/business=list%40racistnames.com&no_note=1&tax

Re: [GENERAL] is possible to read oracle tables from PostgresSQL

Wel, If you use Plperl I supposed or perl!! From: "Marco" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [GENERAL] is possible to read oracle tables from PostgresSQL Date: Wed, 15 Oct 2003 19:10:42 GMT I need to know if is possible to read oracle tables from PostgresSQL (and vice versa). Can s

Re: [GENERAL] VACUUM degrades performance significantly. Database becomes

> "S" == Stephen <[EMAIL PROTECTED]> writes: S> The system is actually idling when I ran the tests (load average: 0.01, S> 0.02, 0.00). When VACUUM runs, load average increases quickly (load average: S> 1.77, 0.60, 0.21) just by running psql on command line and issuing 2 S> queries. I've been

Re: [GENERAL] maximum number of client connections?

On Thursday 16 October 2003 11:47 am, Mark Harrison wrote: > We have the situation where it would be convenient if we > could support a large number (>1024, possibly in the 2000-3000 > range) of client connections. > > What are our options for this? I suspect your best bet is some sort of connecti

Re: [GENERAL] VACUUM degrades performance significantly. Database

If you are always looking for exact matches, I would suggest experimenting with a hashed index. The character fields of your index are very long, and it may be beneficial to try hashing as an alternative. Of course, if you need to do greater than, less than, between sorts of queries, the hashed i

Re: [GENERAL] pg_atoi

never mind, it was the wrong type. sorry, > X-Original-To: [EMAIL PROTECTED] > Date: Thu, 16 Oct 2003 21:21:41 -0600 (MDT) > From: Kathy Zhu <[EMAIL PROTECTED]> > Subject: [GENERAL] pg_atoi > To: [EMAIL PROTECTED] > X-Virus-Scanned: by amavisd-new at postgresql.org > X-Spam-Status: No, hits=0.1 ta

Re: [GENERAL] pg_atoi

On Thu, 16 Oct 2003, Kathy Zhu wrote: > Hi, > > I got this message. Is that because the string id too long ?? Are you sure testid is defined as a string type and not an integer? That'd be the most likely reason for pg_atoi to be called. > insert into test (testid) > values('FAKEJOBMGRNAMEJOBNAME

[GENERAL] Disabling referential integrity

Hi, my problem is this: I have a table called faps_key the unique identifier being key_code: taupo=# \d faps_key Table "faps_key" Column | Type | Modifiers -+---+--- key_code| character varying(6) |

Re: [GENERAL] "slicing" records

Jan Wieck wrote: > Oh, it's one of these _don't ask me why_ things ... well, then "what is > the target legacy system?" ... hehe. > Of course, "don't ask me why" is my own way of saying "I don't know why!" :-) > If there is a total upper maximum for the object length and it's not way > too obscene

[GENERAL] pg_atoi

Hi, I got this message. Is that because the string id too long ?? Where is the String length defined ?? thanks, Kathy insert into test (testid) values('FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16 21:13:24 MDT 2003'); ERROR: pg_atoi: error in "FAKEJOBMGRNAMEJOBNAM

Re: [GENERAL] Alias-Error

Jost Richstein <[EMAIL PROTECTED]> writes: > I am running a query with alias (a self join) against > version 7.3.4 on Suse Linux 7.3 and on FreeBSD (v5?). > It runs fine on Linux, but produces an error on > FreeBSD: "unknown alias C2". The string "unknown alias" appears nowhere in the 7.3 sources.