Description:
PGSQL Relational Database Management System.
|
|
|
"name order was judged to be more convenient" (multiple triggers)
|
| |
...I have to say that this seems wrong to me. One of the basic rules in programming/coding is that name of class/ variable/function/etc. should describe its purpose/function/use. Being forced to adjust name of object to manage its position within some kind of stack is against this concept. :( Obviously I can't tell what _exactly_ was meant by "more convenient"... more »
|
|
|
How to disable trigger within itself? (to prevent recursion/loop)
|
| |
Hello I have this trigger which ON INSERT inserts more rows into the very same table it "sits" on. To avoid an INSERT-recursion I would like to disable all triggers on that table from within my trigger-function. But what I get is an ERROR saying that I can not alter table because it is being used. Is there something I can do about this?... more »
|
|
|
default postgres user password on CentOS?
|
| |
Hello, I'm new to postgresql and have installed it on CentOS 5.3 via yum. I am attempting to install an application that uses postgresql as its database, and am running application-supplied scripts to create the ah3 user and database structure, e.g: su -c "createuser -h localhost --createdb --no-createrole --no-superuser... more »
|
|
|
Any decent tutorials for PlPerl?
|
| |
I have problems with installing DBD::PgSPI. The module is old and is looking for $POSTGRES_HOME/include. There is no such thing on either Red Hat or Ubuntu 9.04. Postgres version is 8.3.8. I'd like to learn how can I use modules like Date::Simple or MIME::Lite from plgperl. I would be very grateful if someone knows a good tutorial for plpgperl. The documentation... more »
|
|
|
Vacuum utility
|
| |
I was wondering where does Postgres put the undo information. Oracle has a special place called "undo tablespace" where the copies of old data are kept, for the sake of transaction consistency. Postgres doesn't appear to have such a special place, it keeps the copies of the old data in the table itself, having to "vacuum" the transactional tables every now and... more »
|
|
|
Constraints are triggers???
|
| |
I just created my first trigger in Postgres and went to check the catalog schema: scott=> select tgname,tgtype,tgenabled,tgisco nstraint,tgconstrname,tgconstr relid from pg_trigger; tgname | tgtype | tgenabled | tgisconstraint ...--------------------------- -+--------+-----------+------- ---------... more »
|
|
|
Are there any big companies using Postgres
|
| |
After the recent events with Oracle licenses, my boss decided to do a pilot project with moving an application to Postgres. So far, my experiences are that we're talking a hippie scene here. EnterpriseDB doesn't return calls, there are no major league companies using it and NYC user group is lead by an EFF supporter who wants to "fight the big... more »
|
|
|
Postgres in NYC
|
| |
Is there an active Postgres group in NYC? Are there commercial companies using PgSQL in and around the NYC area?
|
|
|
"transfering" indexes to other table
|
| |
Hi, since version 8.3 we can do following query: create table newtable ( like oldtable INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES ); I would prefer first create table without including index, because of inserting big amount of data into newtable. And then I'd like "transfer" all constraints and indexes and defaults to newtable.... more »
|
|
|
|
