Re: default values

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: default values
Date: 2002-11-19 17:11:19
Message-ID: 1037725879.8876.158.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(dot)Wall(at)Yozons(dot)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(at)zapata(dot)org>
> >>
> >>
> >>-------------------------------------------------
> >>This mail sent through IMP: http://horde.org/imp/
> >
>
>
>
--

Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303328

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Stephenson 2002-11-19 17:38:50 Re: TEXT Data Type
Previous Message Sagine E.Ferrus 2002-11-19 17:00:28 TEXT Data Type