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
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 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
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
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
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
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
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
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
