)
Regards
Venki
---Original Message---
From: Martijn van Oosterhout
Date: 11/02/05 17:47:26
To: Venki
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disappearing Records
On Wed, Nov 02, 2005 at 05:00:35PM +0530, Venki wrote:
> >The really nasty thing about it is that becau
Am I wrong in this?
regards
Venki
---Original Message---
From: Martijn van Oosterhout
Date: 11/02/05 17:09:45
To: John Sidney-Woollett
Cc: Venki; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disappearing Records
On Wed, Nov 02, 2005 at 07:40:29AM +, John Sidney-Woolle
disappearinf records.
regards
Venki
---Original Message---
From: Tom Lane
Date: 11/01/05 20:30:51
To: Rory Browne
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Disappearing Records
Rory Browne <[EMAIL PROTECTED]> writes:
> What is the first thing you would do, when you
helpful as we are new to postgres and might be doing something wrong when restoring the database.
Regards
venki
---Original Message---
From: Csaba Nagy
Date: 10/26/05 18:24:48
To: Venki
Cc: Postgres general mailing list
Subject: Re: [GENERAL] How to get the value in the lastvalue
r an insert. I don't want to use nextval as this increases the lastvalue value.
Thanks in advance
Kind Regards,Venki
it. We are currently running
the postgresql in a linux box with 1 GB ram and 2GHZ xeon processor.
4. is it advisable to upgrade postgresql to 8.0?? will it solve this error
once and for all.
Thanks in advance
regards
venki
---(end of broadcast)---
Dear Mr. Richard Huxton & Michael Fuhr,
Thanks for your prompt replies, it has helped me a lot. The problem was solved by using this line
SELECT INTO new_id currval(''mydata_id_seq'');
Thanks again for your valuable suggestions
Regards,
venki
---Origina
wing error message
"ERROR: syntax error at or near "mydata_id_seq" at character 39"
can anyone help me in solving the above problem. Am I missing something here? How should I run the function to insert data?
I am using postgresql version 7.4.6 in a linux box and running pgadmin from a Winxp PC.
Kind Regards,Venki
