On Sun, Feb 15, 2015 at 7:11 PM, Eugene Dzhurinsky
wrote:
> On Sun, Feb 15, 2015 at 06:48:36PM +0100, Francisco Olarte wrote:
> > One thing that strikes me is you are either at the beginning of your
> usage
> > of this or you have A LOT of already present lines in the path ( I mean,
> > path has
exactly what I am trying convert oracle to postgres ,
following
1)first i am creating type in oracle
CREATE TYPE suborder_list AS (suborder_id int);
2)second creating table type in oracle
create or replace type suborder_list_table as table of suborder_list;
3)i am using above 1 and 2 created ty
dbms_scheduler.create_job(
job_name => 'DELETE_EMPTY_PART_NUMS'
,job_type => 'PLSQL_BLOCK')
without pgagent or cron is not possible..?
On Mon, Feb 9, 2015 at 11:35 AM, Pavel Stehule
wrote:
> Hi
>
> PostgreSQL doesn't have a dbms_scheduler. If you need it, you can use a
> EnterpriseDB
Hello!
I have a huge dictionary table with series data generated by a third-party
service. The table consists of 2 columns
- id : serial, primary key
- series : varchar, not null, indexed
From time to time I need to apply a "patch" to the dictionary, the patch file
consists of "series" data, one
Hello,
sorry for posting to second list, but as I've received no reply
there, I'm trying my luck here.
Thanks
Petr
-- Forwarded message --
From: Novák, Petr
Date: Tue, Feb 10, 2015 at 12:49 PM
Subject: Data corruption after restarting replica
To: pgsql-b...@postgresql.org
Hi
Dear listers,
I want to move a cluster from one machine to another. I used pg_basebackup
to create an archive and copied/extracted it over the old PGDATA location
on the new machine (the server was stopped). If I start pgsql I get these
messages in my log file:
2015-02-16 14:29:12 EST LOG: datab
On 02/16/2015 11:31 AM, Guillaume Drolet wrote:
Dear listers,
I want to move a cluster from one machine to another. I used
pg_basebackup to create an archive and copied/extracted it over the old
PGDATA location on the new machine (the server was stopped). If I start
pgsql I get these messages in
According to the PG 9.1 doc (
http://www.postgresql.org/docs/current/static/sql-altertable.html), this is
a valid flavor of ALTER TABLE:
ALTER TABLE [ IF EXISTS ] name
RENAME TO new_name
But when I try to execute such a command, I get:
ERROR: syntax error at or near "EXISTS"
LINE 1: ALTER T
On 02/16/2015 01:33 PM, Ken Winter wrote:
According to the PG 9.1 doc
(http://www.postgresql.org/docs/current/static/sql-altertable.html),
The above is the 9.4 version of the page, note the "current" in the URL.
This is the 9.1 version of the page:
http://www.postgresql.org/docs/9.1/static/sq
