Hello,
Is it possible in postgres to write a trigger that is fired at a certain
pre-defined time? ie I want to write a trigger that checks if the current
time is one of a certain list of dates, and if yes, it should be executed.
(I want it to execute only once on a matching date.)
I'm using Ent
On Mon, Nov 16, 2009 at 2:42 PM, Shruthi A wrote:
> Is it possible in postgres to write a trigger that is fired at a certain
> pre-defined time? ie I want to write a trigger that checks if the current
> time is one of a certain list of dates, and if yes, it should be executed.
> (I want it to e
Shruthi A написа:
> Hello,
>
> Is it possible in postgres to write a trigger that is fired at a certain
> pre-defined time? ie I want to write a trigger that checks if the current
> time is one of a certain list of dates, and if yes, it should be executed.
> (I want it to execute only once on a
Hi everybody,
I wanted to duplicate a database, but wound up with nothing,
It seems. I am using 8.3.7 on redhat linux. Here's what I
did (as user postgres):
bash-3.00$ createdb musket
bash-3.00$
bash-3.00$ df /pgsql
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/m
Hi,
I mentioned in the previous posting that the file 20091114.6.gz
was made by:
pg_dumpall | gzip > 20091114.6.gz
At which point, there was only one databasae (named canon) and
no database named musket existed.
Now that I am thinking, maybe the file made by pg_dumpall has
"canon" encoded and t
Tena Sakai writes:
> Now that I am thinking, maybe the file made by pg_dumpall has
> "canon" encoded and therefore what I did logically did not copy
> any canon tables into musket? Could this be the case?
Yup, exactly. It would have created canon and restored into that.
> If so, how would I du
Hello Postgres Gurus,
I have a feeling that I might be posting the following question to the wrong
site but just in case I will ask it here first.
I am comparing different postgres installation packages for Postgres 8.3.8:
On windows: the msi vs. the one-click-installer
On linux: the rpms vs. the
On Mon, 2009-11-16 at 16:59 -0800, Kasia Tuszynska wrote:
>
> On Linux
> -rpms do not install the xml type by default
You need to install postgresql-contrib package.
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.g
Hi Tom,
Many thanks for your assistance.
I am on my way. Here's what I am doing:
dropdb musket
createdb musket
pg_dump canon > canon.dump
psql -d musket -f canon.dump
I am on the 4th step. But I could achieve the same with:
dropdb musket
createdb musket
pg_dump canon | psql -d