SEO

#1 (**permalink**) 04-15-2008, 11:40 PM

I am trying to use PostgreSQL and while trying to do a
prototype, I am getting an error.
In the TODO list (INSERT section), it is mentioned
that
"This is useful for returning the auto-generated key
for an INSERT. One complication is how to handle rules
that run as part of the insert."

Does it mean PostgreSQL does not support returning
autogenerated keys? I am using 803 version.

I am getting the following error:

org.postgresql.util.PSQLException: Returning
autogenerated keys is not supported.
at
org.postgresql.jdbc3.AbstractJdbc3Statement.execut eUpdate(AbstractJdbc3Statement.java:138)

Thanks In Advance

Srinivas Tata

__________________________________________________ ____
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-15-2008, 11:40 PM

On Thu, 6 Oct 2005, Srinivas Tata wrote:

> I am trying to use PostgreSQL and while trying to do a
> prototype, I am getting an error.
> In the TODO list (INSERT section), it is mentioned
> that
> "This is useful for returning the auto-generated key
> for an INSERT. One complication is how to handle rules
> that run as part of the insert."
>
> Does it mean PostgreSQL does not support returning
> autogenerated keys? I am using 803 version.
>

That is correct, we don't support returning autogenerated keys at the
present time.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

(NONE)