Postgres Pro
Downloads
Home   >   mailing lists

Thread: Getting default values from PostgreSQL

Getting default values from PostgreSQL

From
Jason Davies
Date:
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/

OpenACS

From
"Edmar Wiggers"
Date:
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.

Re: [SQL] OpenACS

From
Roberto Mello
Date:
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