[SQL] Function Dependency

2006-02-01 Thread Padam J Singh
Hello, I am maintaining an application that has over 400 procedures and functions written in plsql, and around 100 tables. I want to generate a function dependency chart to depict the following: 1. Inter function/procedure dependencies 2. function-tables dependencies 3. function-sequences dep

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Daniel CAUNE
> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de Alvaro Herrera > Envoyé : mercredi 1 février 2006 19:28 > À : Daniel Caune > Cc : Owen Jacobson; pgsql-sql@postgresql.org > Objet : Re: [SQL] Does PostgreSQL support job? > > Daniel Caune

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Alvaro Herrera
Daniel Caune wrote: > Yes, that's it. A job is a task, i.e. set of statements, which is > scheduled to run against a RDBMS at periodical times. Some RDBMS, > such as SQL Server ..., the current alpha MySQL, ... > and Oracle, support that feature, even if such a > feature is managed differently

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Daniel Caune
> -Message d'origine- > De : Owen Jacobson [mailto:[EMAIL PROTECTED] > Envoyé : mercredi, février 01, 2006 18:00 > À : Daniel Caune; pgsql-sql@postgresql.org > Objet : RE: [SQL] Does PostgreSQL support job? > > Daniel Caune wrote: > > Hi, > > > > I try to find in the documentation whethe

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Andrew Sullivan
On Wed, Feb 01, 2006 at 05:53:52PM -0500, Daniel Caune wrote: > I try to find in the documentation whether PostgreSQL supports job, but > I miserably failed. Does PostgreSQL support job? If not, what is the I don't know what "job" is, but it sounds like you want "cron" (since you mention it). Y

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Daniel Caune
> -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-sql- > [EMAIL PROTECTED] De la part de Bruce Momjian > Envoyé : mercredi, février 01, 2006 17:57 > À : Daniel Caune > Cc : pgsql-sql@postgresql.org > Objet : Re: [SQL] Does PostgreSQL support job? > > Daniel Caune wrote: > > Hi

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Owen Jacobson
Daniel Caune wrote: > Hi, > > I try to find in the documentation whether PostgreSQL supports job, > but I miserably failed. Does PostgreSQL support job? If not, what > is the mechanism mostly adopted by PostgreSQL administrators for > running jobs against PostgreSQL? I was thinking about usi

Re: [SQL] Does PostgreSQL support job?

2006-02-01 Thread Bruce Momjian
Daniel Caune wrote: > Hi, > > > > I try to find in the documentation whether PostgreSQL supports job, but > I miserably failed. Does PostgreSQL support job? If not, what is the > mechanism mostly adopted by PostgreSQL administrators for running jobs > against PostgreSQL? I was thinking about

[SQL] Does PostgreSQL support job?

2006-02-01 Thread Daniel Caune
Hi,   I try to find in the documentation whether PostgreSQL supports job, but I miserably failed.  Does PostgreSQL support job?  If not, what is the mechanism mostly adopted by PostgreSQL administrators for running jobs against PostgreSQL?  I was thinking about using cron/plsql/sql-script

Re: [SQL] executing dynamic commands

2006-02-01 Thread Stephan Szabo
On Wed, 1 Feb 2006 [EMAIL PROTECTED] wrote: > Hi, > > I user PostgreSQl 8.0.4 on Win2003 Server and write a function to copy rows > from one table into another table with the same column definition. > My first approach was to use something like: > > query_value := 'INSERT INTO ' || tabledest ||

Re: [SQL] executing dynamic commands

2006-02-01 Thread christian . michels
Thanx for the quick response ! Sorry for asking a bit confusing question ... Using the View is a good idea but does not fully solve my problem. To make it a bit more clear: I want to copy all records from table1 to table2 assuming that the two tables have exactly the same column definition and c

Re: [SQL] CREATE INDEX with order clause

2006-02-01 Thread Tom Lane
"Daniel Caune" <[EMAIL PROTECTED]> writes: > I would like to create an index on a table, specifying an order clause > for one of the columns. Search the archives for discussions of reverse-sort operator classes (you might also get hits on the shorthand "opclass"). regards,

[SQL] CREATE INDEX with order clause

2006-02-01 Thread Daniel Caune
Hi,   I would like to create an index on a table, specifying an order clause for one of the columns.   CREATE INDEX IDX_GSLOG_EVENT_PLAYER_EVENT_TIME_DESC   ON GSLOG_EVENT(PLAYER_USERNAME, EVENT_NAME, EVENT_DATE_CREATED DESC);   which is not a vali

Re: [SQL] executing dynamic commands

2006-02-01 Thread codeWarrior
Talk about obfuscated Are you trying to retrieve the table structure / schema from the PG System Catalogs ? If so -- you are better off using a VIEW instead of a manual procedure because it will automatically kepp up with the current schema definition... Try this: -- DROP VIEW sys_table_sc

[SQL] executing dynamic commands

2006-02-01 Thread christian . michels
Hi, I user PostgreSQl 8.0.4 on Win2003 Server and write a function to copy rows from one table into another table with the same column definition. My first approach was to use something like: query_value := 'INSERT INTO ' || tabledest || ' SELECT * FROM ' || tablesrc; EXECUTE query_value; Thi