Re: [GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
- From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com] Sent: Wednesday, January 27, 2010 11:57 AM To: Aycock, Jeff R. Subject: Re: [GENERAL] syntax error during function call 2010/1/27 Aycock, Jeff R. : > Hello, > > > > I have a function with three parameters that would populate

Re: [GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
Thanks for the catch. However, this did not fix the syntax error. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, January 27, 2010 11:47 AM To: Aycock, Jeff R. Cc: Pavel Stehule; pgsql-general@postgresql.org Subject: Re: [GENERAL] syntax error

Re: [GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
Adrian, I tried that as well and got the same error result. Regards, Jeff Aycock -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Wednesday, January 27, 2010 11:33 AM To: Aycock, Jeff R. Cc: Pavel Stehule; pgsql-general@postgresql.org Subject: Re: [GENERAL

Re: [GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
s still giving me the same syntax error as before. I must be missing something here though. Thanks for the suggestion, however. Regards, Jeff Aycock -Original Message- From: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: Wednesday, January 27, 2010 11:13 AM To: Aycock, Jeff R

Re: [GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
010 11:00 AM To: Aycock, Jeff R. Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] syntax error during function call On 27/01/2010 15:40, Aycock, Jeff R. wrote: > BEGIN > > FOR r IN SELECT * FROM schema_1.snapshot_table > > LOOP > > > > DE

[GENERAL] syntax error during function call

2010-01-27 Thread Aycock, Jeff R.
Hello, I have a function with three parameters that would populate a table in one schema from another table of the same name in another schema. The tables are dynamically selected at execution time. CREATE OR REPLACE FUNCTION schema_1.getAllSnapShot(user_id text, begin_dt date, end_dt date

[GENERAL] postgresql_autodoc tool

2009-12-10 Thread Aycock, Jeff R.
Hello, I'm using postgresql_autodoc tool (v. 1.40) to document Postgresql 8.4 databases and have a couple of questions. This tool works great in documenting all of the database objects with the exception of triggers and permissions. I can see in the Perl script where permissions information a