Обсуждение: Getting default values from PostgreSQL

Hi,

Could someone help with getting default values for different columns in
PostgreSQL? All I need is the SQL query.

Thanks,
Jason Davies.

=====
Jason Davies,

 _  _ _|_ _ _  _  _| _    | www.netspade.com
| |(/_ | _\|_)(_|(_|(/_   | programming tutorials
           |              | programming community
-----------------------   | programming news

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Is there any PostgreSQL developer working on the OpenACS (PG version of the
ArsDigita Community Sytem) project?

I have installed it and I am very much interested. There are a lot of small
bugs though, mostly related to Oracle->Postgres migration, and some which
are Postgres specific (queries that should work but don't).

I know C programming, and could start hacking in both OpenACS and Postgres
to make things work. Some directions from someone who has already dealed
with those projects would be VERY appreciated.

Edmar Wiggers wrote:
>
> Is there any PostgreSQL developer working on the OpenACS (PG version of the
> ArsDigita Community Sytem) project?
>
> I have installed it and I am very much interested. There are a lot of small
> bugs though, mostly related to Oracle->Postgres migration, and some which
> are Postgres specific (queries that should work but don't).

    Hi Edmars,

    I am in the OpenACS team. Have you posted the bugs to our Software
Development Manager (SDM) (http://openacs.org/sdm)? When we were doing
the porting some queries might have slipped, and they're not found
unless someone really uses the module, finds and reports them.
    OpenACS 4 is what we are actively working on right now. It's a much
better piece of software than the 3.x series, but it does not have all
the modules that 3.x series does, but we'll get there eventually.

    -Roberto
--
Computer Science            Utah State University
Space Dynamics Laboratory        Web Developer
USU Free Software & GNU/Linux Club     http://fslc.usu.edu
My home page - http://www.brasileiro.net/roberto