RES: [GENERAL] Table partition - parent table use

or these partitioned data. One of our current problems is exactly the time it takes for backup and restore operations. I did not mentioned it before because of the size of the original message. Luiz Hugo Ronqui -Mensagem original- De: pgsql-general-owner+m233282=lronqui=tce.sp.gov...

[GENERAL] Table partition - parent table use

am affraid of doing something that could stop because it wasnt designed to work like that to begin with... Thanks for your time and sorry for such a big bunch of words Luiz Hugo Ronqui -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Thousands of schemas and ANALYZE goes out of memory

et me know if you have ideas. Thanks again! Hugo -- View this message in context: http://postgresql.1045698.n5.nabble.com/Thousands-of-schemas-and-ANALYZE-goes-out-of-memory-tp5726198p5726657.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-ge

Re: [GENERAL] Thousands of schemas and ANALYZE goes out of memory

Is there any difference running the ANALYZE in the whole database or running it per schema, table by table? Thanks for all the help, Hugo -- View this message in context: http://postgresql.1045698.n5.nabble.com/Thousands-of-schemas-and-ANALYZE-goes-out-of-memory-tp5726198p5726351.html Sent from th

Re: [GENERAL] Thousands of schemas and ANALYZE goes out of memory

> I doubt that the number of *schemas* is a big deal here, but the number > of *tables* might well be. How many? Also, 9.0.what? Each schema has 22 tables, so we can count at least 22 x 10,000 = 220,000 tables. The postgresql version is 9.0.7-1. Regards, Hugo -- View this mess

[GENERAL] Thousands of schemas and ANALYZE goes out of memory

transaction? Maybe this should be improved for the future releases. Please let me know what you guys think. Thanks in advance, Hugo -- View this message in context: http://postgresql.1045698.n5.nabble.com/Thousands-of-schemas-and-ANALYZE-goes-out-of-memory-tp5726198.html Sent from the PostgreSQL

[GENERAL] variable table names in trigger functions

ON data.users FOR EACH ROW EXECUTE PROCEDURE log(); CREATE TRIGGER log BEFORE INSERT OR UPDATE ON data.posts FOR EACH ROW EXECUTE PROCEDURE log(); But this doesn't work. Any ideas on how to do this? Thanks, Hugo ---(end of broadcast)--

[GENERAL] Working with one live and one development database

and then. The development database will be on a separate machine. What is the best way to do this? Kind regards Hugo Wetterberg ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Fwd: [GENERAL] how to check SQLSTATE

Hi,Is there a way to check how many records where affected by a delete or update sentence in a trigger function ??thanksHugo On 10/6/06, Hugo <[EMAIL PROTECTED]> wrote: OK, thanks, I'm porting a lot of sybase storedprocedures, and there are lots of "if sqlstate.." stat

[GENERAL] column refernce question

Hi, how can I know all the foreign key constrainst that references a particular pk ?this is on postgres 8.1.4 on susethanks for any adviceHugo

Re: [GENERAL] how to check SQLSTATE

Hi again, thanks for your guidance, this is the error I got trying to save my fuction:ERROR:  unrecognized exception condition "no_data"CONTEXT:  compile of PL/pgSQL function "fn_verificar_aportes_socio" near line 36 the symbol is correct , i checked it in the appendix A postgres error codes and co

Re: [GENERAL] how to check SQLSTATE

sorry, forgot to mention psql8.1.4 on fedora core 4On 10/6/06, A. Kretschmer <[EMAIL PROTECTED] > wrote:am  Thu, dem 05.10.2006, um 17:45:36 -0300 mailte Hugo folgendes:> Hi, >> is it possible to check for sqlstate inside a function , something like:>>

[GENERAL] how to check SQLSTATE

Hi,is it possible to check for sqlstate inside a function , something like:      loop  fetch bla.  if sqlstate = '02000' then    exit;  end if;     end loop;  if I try to save the above I get a :  sqlstate not defined errorThen I tried this with no success:    ..

Fwd: [GENERAL] performance tips please

I assume the the task takes longer than 5 seconds to complete? Are you running the same OS? Can pgsql distribute the load on both Xeon processors? Is pgsql custom compiled for a specific architecture(Pentium III, for example)? How do you measure the response time? Arethere other apps involved?t.n.a

[GENERAL] performance tips please

Hi, I am testing my application and DB (postgres 8.1.4 ) on a :    DELL-Power Edge 1800 with 2 Xeon 3.2ghz,  2 Gb RAM and 2 SCSI 149 Gb  each.trouble is that the same application and DB(postgres 8.0.4) runs on a: DELL pentium 3 with 526MB of RAM and an IDE 20 GB and comparing the performance

Re: [GENERAL] psql command and file size

sorry again, the psql I am running from a Windows clientOn 6/8/06, Hugo <[EMAIL PROTECTED]> wrote: Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10 On 6/8/06, Hugo < [EMAIL PROTECTED]> wrote: Hello list,If I feed psql with a file with sql sentences, what is the size limit

Re: [GENERAL] psql command and file size

Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10 On 6/8/06, Hugo <[EMAIL PROTECTED]> wrote: Hello list,If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 390

[GENERAL] psql command and file size

Hello list,If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 3900 rows, what can I do to "see" what insert sentences are failing ? thanks for any advicebest regardsHugo

[GENERAL] trigger firing order

Hi, how can I tell in which order are triggered different triggers on the same table, let me explain , I have three triggers for table A, all of then are intended for "before insert" on the table, in ASA I can tell the Db in which order I want the triggers to fire, is there an equivalent for postg

[GENERAL] who is connected to the database ??

hello , is there a way to answer that question ?thanks in advanceHugoPd.Postgres 8.1 on FC4 and WinXP Pro

Re: [GENERAL] help with utf8

encoding for Postgres on windows spanish version. Yes, the problem is in that point , it shoud read "ALEJO GARCIA Nº 367".thanks for you helpHugoOn 01/12/05, Richard Huxton <dev@archonet.com> wrote: Hugo wrote:> don't know if this is the best solution but I dropped the databas

Re: [GENERAL] help with utf8

don't know if this is the best solution but I dropped the database and recreated it with SQL_ASCII instead of UTF-8 and everything worked as expectedHugoOn 01/12/05, Hugo <[EMAIL PROTECTED]> wrote:Hi can anybody help with this error, I attatched an imagethanksPosgtrest 8.1.0 on WinXP Pro SP1

[GENERAL] help with utf8

Hican anybody help with this error, I attatched an imagethanksPosgtrest 8.1.0 on WinXP Pro SP1 error.PNG Description: PNG image ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail co

[GENERAL] odbc and psql 8.1.0

appreciate any hint on this thanks in advance Hugo below is the query, this query should return rows with D's  and P's , but it returns only rows with D's, the problem is that if I count the rows I realize that it returns all the rows it should (642), but it returns all of them with

[GENERAL] strings

e function with the 'c:\file.csv' parameter and make it work ?? thanks for any help Hugo

[GENERAL] run vacuum from within a function

hi everybody, Is it possible tu run vacuum from a plpgsql function ? I have a process that copies a lot of data from a csv file with the copy command and at the end of the function I would like to force a vacuun, is that possible. thanks in advance Hugo

[GENERAL] Postgres + CentOS

Hi, is anybody using psql and CentOS, I just wanted to know your experience thanks Hugo

[GENERAL] vacuum

hi everybody , is it possible to schedule vacuum in the server ( postgres 8.0.3 on Windows XP SP2) ? I want to vacuum the DB everyday at 22:00 and I want to automate the process thanks in advance Hugo

Re: [GENERAL] question : postgres + Powerbuilder

sorry, forgot to mention that the server is 8.0.3 and is running on a fedora core 3 serverOn 10/08/05, Hugo <[EMAIL PROTECTED] > wrote:Hi everybody, is there anybody developing apps with powerbuilder and postgres as the db server ? my problem is that I have a function in postgres to impor

[GENERAL] question : postgres + Powerbuilder

to do, i call the function this way in pgadmin interactive sql : select my_echema.fn_function_import_dataxx() any help is welcome thanks in advance Hugo

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

hi,  if the client machine is another linux ,  what is the correct way to configure ODBC thanks Hugo  Hi,All you need is the Windows ODBC driver, which you install on the client machine, and then configure it to talk to the Linux server onport 5432 (set by default).--Ray.>> Most

[GENERAL] psql newby question, help to port Sybase ASA StoredProcedure

),0);   set v_monto=mod(v_monto,5)     when 11 then   set v_1=truncnum((v_monto/1),0);   set v_monto=mod(v_monto,1)     end case     ;     set i=i+1   end loop;   select v_100mil,v_50mil,v_10mil,v_5mil,v_1000,v_500,v_100,v_50,v_10,v_5,v_1 end thanks in advance for any help you could provide. Hugo

Re: [GENERAL] how to return a result set from a stored procedure

you advice me on this ?? thanks Hugo On 11/06/05, Petar Jovanovic <[EMAIL PROTECTED]> wrote: Hugo wrote:> Hi everybody>> I am trying to write a stored procedure that returns a result set but> it is not working> this is the function:&g

[GENERAL] how to return a result set from a stored procedure

use I need to use it in a Datawindow definition in an Powerbuilder app. thanks in advance Hugo

[GENERAL] how to return a result set from a stored procedure

eed to use it in a Datawindow definition in an Powerbuilder app. thanks in advance Hugo

Re: [GENERAL] Newbie question

thanks all for your help, I'll try your suggestions regards Hugo 2005/5/18, Kaloyan Iliev Iliev <[EMAIL PROTECTED]>: > Hi Hugo, > > Yes, it is possible. Just write an outer perl script(in example), which > to call this stored procedure. Then put in the cron to call whi

[GENERAL] Newbie question

hi, is it possible to schedule the execution of an sql stored procedure in postgress on linux? thanks Hugo ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] grant all privileges to all tables in a database

is it possible to have nested groups in postgres like in Adaptive server anywhare , I couldn't find anything about it in the help thanks Hugo ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an approp

Re: [GENERAL] Restoring db objects , help needed

is it possible to restore the object to a different schema in the same database? thanks Hugo On Mon, 7 Mar 2005 09:54:04 -0800, Lonni J Friedman <[EMAIL PROTECTED]> wrote: > On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <[EMAIL PROTECTED]> wrote: > > hello, > > &g

[GENERAL] Restoring db objects , help needed

hello, Is it possible to restore a DB Schema in a different schema but in the same Database? or restore the schema with a different name? or restore a set of objects into a different schema from where they were backed-up? thanks in advance Hugo ---(end of broadcast

[GENERAL] change user password

hi, is it possible to change the user's password from a stored procedure or a funcion? I mean , is there a system function/stored procedure that can do it? like the dbo.sp_password found in Adaptive server anywhare? thanks in advance Hugo ---(end of broa

[GENERAL] change user password

hi, is it possible to change the current user's password from a function/stored procedure , I mean, is there a system function/stored procedure to do it? like the dbo.sp_password found in adaptive server anywhere. thanks in advance Hugo ---(end of broa

[GENERAL] Re: [ANNOUNCE] Revamp'd Web Site...

t, but if you want to go look > at it now, check out: > > http://www.postgresql.org/index.html Can you also clean up the announce mailinglist? Over 50% of the messages are SPAM! Unless you do something about it I have no option but to declar