Grokbase › Groups › PostgreSQL › pgsql-novice › February 2001
FAQ
A couple of general question about postgresql.

1) Does postgresql support unsigned datatypes?
2) Is there a maximum number of simultaneous connection to postgresql via
JDBC?

Mike

Search Discussions

  • ERIC Lawson - x52010 at Feb 21, 2001 at 7:49 pm ⇧

    On Wed, 21 Feb 2001, Mike Friesen wrote:

    1) Does postgresql support unsigned datatypes? Yes.
    2) Is there a maximum number of simultaneous connection to postgresql via
    JDBC?
    I can't speak to JDBC limitations; see

    http://www.postgresql.org/docs/faq-english.html

    FAQ Number 3.9 for a discussion of PostgreSQL maximum number of backend
    limitations.

    --

    James Eric Lawson
    Research Publications Editor III
    National Simulation Resource

    eric@bioeng.washington.edu

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Everyday language is a part of the human organism and is no less
    complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus
    Logico-Philosophicus, 1921]
  • Tom Lane at Feb 21, 2001 at 9:00 pm ⇧

    ERIC Lawson - x52010 writes:
    On Wed, 21 Feb 2001, Mike Friesen wrote:
    1) Does postgresql support unsigned datatypes?
    Yes.
    We *could* support unsigned-integer datatypes, if anyone actually
    bothered to write one; which TTBOMK no one has done. Do you really
    need an unsigned-int type, as opposed to a plain vanilla integer
    with a constraint "foo >= 0" ?
    2) Is there a maximum number of simultaneous connection to postgresql via
    JDBC?
    Should be whatever you've set as the max number of backends in the
    postmaster parameters.

    regards, tom lane
  • Mike Friesen at Feb 21, 2001 at 8:40 pm ⇧
    Thank you for your response, in regards to my first question how would you
    define an unsigned int2? I haven't beeen able to find anything in the
    postgresql documents?

    Mike

    On Wed, 21 Feb 2001, Mike Friesen wrote:

    1) Does postgresql support unsigned datatypes? Yes.
    2) Is there a maximum number of simultaneous connection to postgresql via
    JDBC?
    I can't speak to JDBC limitations; see

    http://www.postgresql.org/docs/faq-english.html

    FAQ Number 3.9 for a discussion of PostgreSQL maximum number of backend
    limitations.

    --

    James Eric Lawson
    Research Publications Editor III
    National Simulation Resource

    eric@bioeng.washington.edu

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Everyday language is a part of the human organism and is no less
    complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus
    Logico-Philosophicus, 1921]
  • ERIC Lawson - x52010 at Feb 21, 2001 at 9:18 pm ⇧

    On Wed, 21 Feb 2001, Mike Friesen wrote:


    Thank you for your response, in regards to my first question how would you
    define an unsigned int2? I haven't beeen able to find anything in the
    postgresql documents?

    Mike
    My yes response to the question posited that, even though I haven't seen
    such a beast, the CREATE TYPE statement supports (creation and use) of
    the unsigned data type.

    Tom Lane's response is more to the point than mine.

    --

    James Eric Lawson
    Research Publications Editor III
    National Simulation Resource

    eric@bioeng.washington.edu

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Everyday language is a part of the human organism and is no less
    complicated than it. - Ludwig Wittgenstein (1889-1951) [Tractatus
    Logico-Philosophicus, 1921]

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedFeb 21, '01 at 7:19p
activeFeb 21, '01 at 9:18p
posts5
users3
websitepostgresql.org
irc#postgresql

3 users in discussion

ERIC Lawson - x52010: 2 posts Mike Friesen: 2 posts Tom Lane: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase