Re: sequence in schema -- broken default

>
>
>
> By the way... should the way you wrote it work?
>
No. I did not complete the syntax.

> # INSERT INTO one.foo VALUES ();
> ERROR: syntax error at or near ")" at character 29
>
> Seems like maybe it should work with the default, but I don't know.
>
No, the reason the below works is version() is a function where values
() is not.
I don't think you are going to have any choice but to hardcode the
sequence value
unless you want to bounce in between search paths based on who is
connecting.

>
> # select version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.4.1 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL