Re: [GENERAL] stored proc

On 29/09/2011 02:34, J.V. wrote: Is it possible to group a bunch of methods and functions into a single file (stored procedures functions) and have a main method that can be called to orchestrate the methods, pass in params, get back results, log to a file? I know this can be done with Oracle

Re: [GENERAL] Oracle to Postgres migration open source tool

On 07/07/2011 15:21, salah jubeh wrote: Hello, I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. But as an initial solution give it a shot.

Re: [GENERAL] Understanding Schema's

On 15/12/2010 00:20, Carlos Mennens wrote: Why would anyone in a random scenario want to have independent schema's to cross query? I'm just trying to see how this would be useful in any scenario. One very real example :-) When migrating from say mysql to PgSQL it is possible to populate a

Re: [GENERAL] Re: Modfying source code to read tuples before and after UPDATE...how to?

rmd22 wrote: Do you think it's possible? replied offlist suggesting he have a chat with his prof and find the reason behind this task... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] create table as select VS create table; insert as select

I have inherited an application that populates a number of temp.y tables using create table ... as select ... This is taking roughly five to ten minutes to run As this process hammers the database, I can only run benchmarks at night so am asking here if anyone know if create table ...; then

[GENERAL] SPI high level abstraction?

Is there any C libs out there that will abstract the SPI interface? I have a number of functions that do input process output and they are all almost identical (tablename fields, change) I could abstract the code but would prefer to re-use an exissting abstraction layer as the less code I

Re: [GENERAL] pgtune

Greg Smith wrote: Set -c 300 when you run pgtune and it will do the right thing here. regarding tuning a database we had a rather neat tool for oracle some years ago that would connect to a live database and monitor the QEP (query execution plan) cache for badly indexed queries etc. It would

Re: [GENERAL] MySQL versus Postgres

Randal L. Schwartz wrote: Do not overemphasize the example mode at the cost of presenting concepts or structure. You need all three. Hmm I recently had to find out the various options to get values from a tuple via SPI - referred by docs to the contrib examples :-( Docs did not help and the

Re: [GENERAL] How Big is Too Big for Tables?

P Kishor wrote: On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost sfr...@snowman.net wrote: * P Kishor (punk.k...@gmail.com) wrote: Three. At least, in my case, the overhead is too much. My data are single bytes, but the smallest data type in Pg is smallint (2 bytes). That, plus the per row

Re: [GENERAL] Migrating from MySQL

John R Pierce wrote: On 06/26/10 11:22 PM, RP Khare wrote: I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition? thats entirely up to your preferences and needs.Personally, I think that the

[GENERAL] subscribe

subscribe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general