PostgreSQL currval()

2001-04-25 Thread K Old
Hello all, I'm trying to do the following insert statement and can't seem to get it to work: INSERT INTO domains (dname, user, pass) VALUES('currval('cust_seq')', bob, something); I am getting the error that says it that cust_seq.currval is not defined. I do have cust_seq defined as a

Re: PostgreSQL currval()

2001-04-25 Thread Jeff Waugh
in the current session. Your error sounds like nextval has not been called yet in the current session. HTH, -Jeff - Original Message - From: K Old [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 11:30 AM Subject: PostgreSQL currval() Hello all, I'm trying to do