Getting default values from PostgreSQL

Started by Jason Daviesover 25 years ago3 messagesgeneral
Jump to latest
#1Jason Davies
jason_ddavies@yahoo.com

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/

#2Edmar Wiggers
edmar@brasmap.com
In reply to: Jason Davies (#1)
OpenACS

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.

#3Roberto Mello
rmello@cc.usu.edu
In reply to: Edmar Wiggers (#2)
Re: [SQL] OpenACS

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