Re: default values - Mailing list pgsql-jdbc

Well, the only way this is going to work is if you cast it into a
postgres resultset.

I don't have any particular objection to this extension.

Dave
On Tue, 2002-11-19 at 18:44, Stuart Robinson wrote:
> I think Felipe has a point here. I don't see any good reason why the driver's
> methods can't be a SUPERSET of those specified in the JDBC standard. As long
> as there's nothing forcing you to use the non-standard methods, it should be
> fine. So, for those who wish to stick to the standard for portability, there
> is predictable behavior; and for those who want some of the extra goodies
> provided by Postgres, there are options.
>
> -Stuart
>
> Quoting Felipe Schnack <felipes@ritterdosreis.br>:
>
> >   So why setUseServerSidePrepare() was implemented? This is not potable,
> > not standard, not anything.
> >
> > On Mon, 2002-11-18 at 22:48, Barry Lind wrote:
> > >
> > >
> > > Felipe Schnack wrote:
> > > >
> > > >   2- This feature is avaliable in pgsql. Why not implement it?
> > > >
> > > Since default column capability isn't part of the jdbc standard yet (but
> > > since it is part of the SQL standard, I would expect it to be added
> > > someday to the jdbc spec), adding support for it would require the user
> > > to write non-portable jdbc code.  Since there is a portable way to
> > > accomplish the same thing (i.e. not include the column in the insert), I
> > > don't see a compelling reason to add this functionality.
> > >
> > > thanks,
> > > --Barry
> > >
> > >
> > >
> > > > On Mon, 2002-11-18 at 17:16, Stuart Robinson wrote:
> > > >
> > > >>Hi, Felipe.
> > > >>
> > > >>I'm been trying to follow the discussion about default values and I'm a
> > little
> > > >>confused. I think David's reply is sensible. Unless I'm missing
> > something, I
> > > >>don't think there's an issue for inserts. All you have to do is not
> > specify the
> > > >>default column in the insert and it will automatically get the default
> > value. I
> > > >>think the issue only arises when you do updates, if you want to revert to
> > the
> > > >>default for a column that has been changed since it was originally
> > inserted.
> > > >>
> > > >>Ate mais,
> > > >>Stuart
> > > >>
> > > >>Quoting David Wall <David.Wall@Yozons.com>:
> > > >>
> > > >>
> > > >>>Why not simply remove varcharfield2 from the INSERT statement and let
> > the
> > > >>>database insert that value with the default value?  Isn't the purpose of
> > a
> > > >>>default value to have the DB put that value in when none is specified?
> > > >>
> > > >>--
> > > >>Stuart Robinson <stuart@zapata.org>
> > > >>
> > > >>
> > > >>-------------------------------------------------
> > > >>This mail sent through IMP: http://horde.org/imp/
> > > >
> > >
> > >
> > >
> > --
> >
> > Felipe Schnack
> > Analista de Sistemas
> > felipes@ritterdosreis.br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Faculdade Ritter dos Reis
> > www.ritterdosreis.br
> > felipes@ritterdosreis.br
> > Fone/Fax.: (51)32303328
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
>
> --
> Stuart Robinson <stuart@zapata.org>
>
>
> -------------------------------------------------
> This mail sent through IMP: http://horde.org/imp/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>