Re: [GENERAL] Problems with plpgsql and FOR loops

rser is getting confused between a FOR IN SELECT loop and a FOR integer loop. If its not top secret we would like to see the code -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: [EMAIL PROTECTED] ICQ :

Re: [GENERAL] boolean to int

Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: [EMAIL PROTECTED] ICQ : 264360076 Yahoo IM: [EMAIL PROTECTED] --- You yourself, as much as anybody in the entire univer

Re: [GENERAL] select statement against pg_stats returns inconsistent

for any kinda answers. -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: [EMAIL PROTECTED] ICQ : 264360076 --- You yourself, as much as anybody in the entire

Re: [GENERAL] embeding postgre

Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: [EMAIL PROTECTED] ICQ : 264360076 --- You yourself, as much as anybody in the entire universe, deserve your love and affection. - Buddha --- I am usually called

Re: [GENERAL] backup and restore questions

elp. -- Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com ~*~*~*~*~*~*~* You Guys start coding I will take care of what this customers needs. ~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add [EMAIL PROTECTED]

Re: [GENERAL] insertion with trigger failed unexpectedly

Dear Anton Nikiforov, The problem: From the very beginning everything was fine and all records that i was getting from routers were calculated just right. I spent a weeks monitoring and testing my software. Now i have 10.000.000 records in raw table and when i'm inserting data alot of records are

Re: [GENERAL] OIDS and its limitations

Hi Amir Khawaja , I have a rather trivial (I hope) question about OID types and PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default, I'm wondering if it is bad practice to allow the default behaviour. For example, if I have a database with 60+ tables (all tables have their own P

Re: [GENERAL] Parser does not like %ROWTYPE in the RETURNS clause of a

Dear ezra epstein ; Using Postgres 7.4, the function "test" gets this: psql:temp3.sql:10: ERROR: syntax error at or near "%" at character 135 the function "test2" gets this: psql:temp3.sql:10: ERROR: syntax error at or near "ROWTYPE" at character 141 Very odd. The first doesn't even like t

[GENERAL] Unix 2038 And PostgreSQL

Dear all, Before reading all this let me assure you nothing is out of control just DONT PANIC I was just going through the pages of http://www.2038.org and was concerned by the fact my computer using Linux will rollover to Fri Dec 13 20:45:52 1901 after Tue Jan 19 03:14:07 2038 Now thi

Re: [GENERAL] Excel, OpenOffice and Postgres

Hello javier garcia, Hello Bob; Some time ago I were using Postrges along with Excel via Microsoft Query and ODBC. I just remember that there was a problem when trying to see views but it worked with single tables. Perhaps you can experiment with that. This problem can be over come by

Re: [GENERAL] dump and sequence initilizing

Dear Markus Rebbert , what happens with sequences if i dump a database and i want to reload it? The pg_dump command also dumps the index value of sequences and you do not have to do any thing Just make sure your pg_restore and pg_dump with option --disable-tiggers Regards, Vishal kashyap ---

Re: [GENERAL] Shell access & send email from PLPGSQL?

Dear Philippe Lang, For e-mail from PgSQL function you need is http://pgmail.sourceforge.net/ Tell me if it help's n one of my project its a great help Regards, V Kashyap ---(end of broadcast)--- TIP 8: explain analyze is your friend