[SQL] Numbers

2006-11-24 Thread Ezequias Rodrigues da Rocha
Hi list, Does anybody have numbers of PostgreSQL in action ? Numbers like the biggest insert in mileseconds, the larger database etc ? Regards... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Atenciosamente (Sincerely)

Re: [SQL] Numbers

2006-11-24 Thread Achilleas Mantzios
Στις Παρασκευή 24 Νοέμβριος 2006 15:07, ο/η Ezequias Rodrigues da Rocha έγραψε: > Hi list, > > Does anybody have numbers of PostgreSQL in action ? > > Numbers like the biggest insert in mileseconds, what do you mean here? LOCK TABLE in ACCESS EXCLUSIVE MODE; and the insert will take forever. >

Re: [SQL] Numbers

2006-11-24 Thread Joe
On Fri, 2006-11-24 at 11:07 -0200, Ezequias Rodrigues da Rocha wrote: > Does anybody have numbers of PostgreSQL in action ? > > Numbers like the biggest insert in mileseconds, the larger database etc ? First, you may want to post this in the GENERAL or in the PERFORMANCE lists since this isn't re

Re: [SQL] select into

2006-11-24 Thread Adrian Klaver
On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: > Mulham freshcode <[EMAIL PROTECTED]> writes: > > execute sql_str1 into svc_data_rec ; > > > > svc_data_rec is a RECORD, which is supposed to be dynamic. > > This should work --- in PG 8.1 or later. In older versions you'd have > to fool arou

Re: [SQL] select into

2006-11-24 Thread Andreas Kretschmer
Adrian Klaver <[EMAIL PROTECTED]> schrieb: > On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: > > Mulham freshcode <[EMAIL PROTECTED]> writes: > > > execute sql_str1 into svc_data_rec ; > > > > > > svc_data_rec is a RECORD, which is supposed to be dynamic. > > > > This should work --- in PG

[SQL] PgAgent [where is it?]

2006-11-24 Thread Ezequias Rodrigues da Rocha
Hi lists, I need to create some jobs on my database but I can't find out the pgagent (executable). Can someone help me in this challenger ? I am using : PostgreSQL 8.1.3 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2) Regards ... -- =-=-=-=-=-=-=-=-=-=-=-=

Re: [SQL] select into

2006-11-24 Thread Adrian Klaver
On Friday 24 November 2006 06:55 am, Andreas Kretschmer wrote: > Adrian Klaver <[EMAIL PROTECTED]> schrieb: > > On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: > > > Mulham freshcode <[EMAIL PROTECTED]> writes: > > > > execute sql_str1 into svc_data_rec ; > > > > > > > > svc_data_rec is a RE

Re: [SQL] select into

2006-11-24 Thread Adrian Klaver
On Thursday 23 November 2006 10:54 pm, Mulham freshcode wrote: > Hi Tom, > > Thanks for the help. Am using version 8.0 and it seems like RECORD is not > that dynamic still. I tried with the FOR ... IN EXECUTE ... LOOP and it > does the trick. But am still finding it hard to move forward with this.

Re: [SQL] select into

2006-11-24 Thread Tom Lane
Adrian Klaver <[EMAIL PROTECTED]> writes: > On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: >> This should work --- in PG 8.1 or later. > The documentation for pl/pgsql in 8.1 and higher says different. > http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STAT

Re: [SQL] select into

2006-11-24 Thread Mulham freshcode
Hi Adrian, I have number of similar tables that have different number of fields (similar in functionality). An in my stored procedure am trying to select a row from one of these tables (that i don't know in advance, hence the use of record) and return the data in the form of a table that has c