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
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
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)---
r an insert. I don't want to use nextval as this increases the lastvalue value.
Thanks in advance
Kind Regards,Venki
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
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
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
)
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
