Would this be a relatively easy patch for a beginning contributor?
If so, I wouldn't mind having a go.
/Colin
On 9 August 2017 at 21:37, Melvin Davidson wrote:
>
>
> On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Wed, Aug 9, 2017 at 12:26 PM, M
Hi,
Why does
ALTER EXTENSION name OWNER TO new_owner;
not exist?
I have a bunch of extensions that were installed by a role that I want
to drop. So I thought I would do like I do for other object types:
ALTER name OWNER TO new_owner;
But that doesn't exist for extensions. I also can't drop the
wrote:
> On 6/21/17 22:04, Maeldron T. wrote:
> > * Logical replication is in 10.0 Beta 1. I might be oldschool but I
> > would install 10.1 or maybe 10.0.2 into production
>
> There are also other logical replication options such as pglogical and
> londiste.
>
> --
> P
On Tue, Jun 20, 2017 at 3:06 AM, Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> wrote:
>
> Not easily. You could play around with pg_xlogdump to see what's going
> on in the WAL. But even if you figure it out, there is not much you can
> do about it.
>
I could do a lot. For example, if I
Hello,
tl;dr
Streaming replication generates too much traffic to set it up between
different regions for financial reasons. The streaming replication would
cost more than every other hosting expense altogether (including every the
traffic, even though it’s web and huge amount of emails).
Is ther
Hello Thomas,
> > (Maybe database clusters should have a header that wouldn’t allow
> > incompatible server versions to process the existing data. I wonder if it
> > would take more than 8 bytes per server. But I guess it was not know to
> be
> > incompatible. Even my two CIs didn’t show it.)
>
>
I forgot to add that when I turned off index scan, select lower() still
didn’t find some existing rows.
On Sat, Dec 3, 2016 at 2:52 AM, Maeldron T. wrote:
> Hello,
>
> I’ll be as short as I can as I have broken my arm and I’m not supposed to
> type. This isn’t a joke.
>
> Howe
Hello,
I’ll be as short as I can as I have broken my arm and I’m not supposed to
type. This isn’t a joke.
However, I learned the following the hard way and I want to save you from
the same.
Upgrading FreeBSD from 10 to 11 might break your database. It probably
won’t be corrupted but it will be u
Hello,
I’m considering moving my servers to Google. The main reason is the
transparent encryption they offer. This means I should either move all
or none. The former would include PostreSQL, specifially: FreeBSD + ZFS
+ PostgreSQL.
Do you have any pros or cons based on experience? (Would fsy
On Wed, 26 Oct 2016 13:59:02 +0200
Thomas Kellerer wrote:
> Bjørn T Johansen schrieb am 26.10.2016 um 13:17:
> > I have a database that I would like to replicate in case of hardware
> > failure on this server. So I gather I just need a streaming replication
> > (warm
>
get a working master - slave replication? (It
just looks too easy... :) )
Do I need to enable archive mode for this to work or?
Never done this before, so just trying to be sure I understand this right... :)
Regards,
BTJ
--
--
On Thu, 20 Oct 2016 15:16:20 +0200
Francisco Olarte wrote:
> On Thu, Oct 20, 2016 at 1:51 PM, Bjørn T Johansen wrote:
> > I have the following SQL:
> > SELECT * from table WHERE date BETWEEN to_timestamp('20.10.2016
> > 00:00:00','DD.MM. HH24:MI:SS'
On Thu, 20 Oct 2016 14:04:51 +0200
vinny wrote:
> On 2016-10-20 13:51, Bjørn T Johansen wrote:
> > I have the following SQL:
> >
> > SELECT * from table WHERE date BETWEEN to_timestamp('20.10.2016
> > 00:00:00','DD.MM. HH24:MI:SS') AND to_
Yes, that's what I am doing now but I was just wondering why the other way did
not work...
BTJ
On Thu, 20 Oct 2016 12:02:14 +
William Ivanski wrote:
> You could try:
>
> select * from table where date = '2016/10/20'::date
>
> Em qui, 20 de out de 2
rds that had datepart = 20.10.2016 but I am
not getting that..
What am I missing?
Regards,
BTJ
--
---
Bjørn T Johansen
b...@havleik.no
---
On 26/07/16 19:39, Guyren Howe wrote:
Honestly, I've never heard of anyone doing that. But it sounds like they had
good reasons.
https://eng.uber.com/mysql-migration/
Thoughts?
1. Open the page
2. Press Cmd-F on Mac, Ctrl-F on Linux/Windows. (Find on page)
3. Type "transaction" in the sear
On 19/07/16 23:45, Adrian Klaver wrote:
To be more complete it would nice to see the schema definition for the
table messages.
Also maybe some idea of what you the code is supposed to do. If I
understand it correctly:
1) Check if a message is a draft.
2) Check if there is a uniqueness con
Hello Adrian,
On 19/07/16 21:27, Adrian Klaver wrote:
On 07/19/2016 11:56 AM, Maeldron T. wrote:
By returning NULL in your function you are skipping the original INSERT.
I know that, I wrote it.
I am sure exactly what you are trying to achieve,
In general, there are the
Hello,
I’m trying to rewrite inserts to upserts on a table when a certain
column has a certain value. Reason: the inserts are coming from an ORM.
It’s possible to send upsert from the ORM, however, in this case I find
it more elegant and future-proof to deal with it at the DB level
On Tue, 12 Jul 2016 14:34:50 +0200
hubert depesz lubaczewski wrote:
> On Tue, Jul 12, 2016 at 10:23:24AM +0200, Bjørn T Johansen wrote:
> > I am trying to move a small system from Oracle to PostgreSQL and
> > I have come upon a sql that runs really slow compared to on the Oracle
&
On Tue, 12 Jul 2016 09:12:23 +
Albe Laurenz wrote:
> haman...@t-online.de wrote:
> Bjørn T Johansen wrote:
> >> I am trying to move a small system from Oracle to PostgreSQL and I have
> >> come upon a sql that runs
> >> really slow compared to on the Ora
Appreciate any pointers on where to look... :)
Regards,
BTJ
--
---
Bjørn T Johansen
b...@havleik.no
--
Hello,
the ICU patch isn’t ready for PostgreSQL on FreeBSD.
Is there any risk (more than 0) in executing the initdb without ICU
support and recompiling PostgreSQL later when the ICU patch is ready? I
mean any risk without making a dump and import before the switch.
If this is okay for su
appreactiated !
On Thu, Nov 26, 2015 at 12:04 AM, Adrian Klaver
wrote:
> On 11/25/2015 07:46 AM, Ramesh T wrote:
>
> First, please take a look at this:
>
> https://en.wikipedia.org/wiki/Posting_style
>
>
>> Hi All,
>> 9.3 version using pgadmin3
>>
>> Que
random_page_cost = 5.0
effective_cache_size = 1024MB
On Wed, Nov 18, 2015 at 11:12 PM, Adrian Klaver
wrote:
> On 11/17/2015 04:18 AM, Ramesh T wrote:
>
>> the query is big it's selecting 20 rows from two table like i mentioned
>> above exaplain analyze
>>
>> what shou
the query is big it's selecting 20 rows from two table like i mentioned
above exaplain analyze
what should i do..?any help
On Wed, Nov 4, 2015 at 4:27 AM, Adrian Klaver
wrote:
> On 11/03/2015 06:42 AM, Ramesh T wrote:
>
>> I have a Query it taking a lot of time to fetch resu
Correct .. this is the windows one.
If I reload the software, I'm good until the next day.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, November 11, 2015 2:40 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GE
Postgresql 9.3
Windows 2008 R2
When I install the software, I can access the databases via pgadmin with no
problems.
However, after a windows GPO push, I receive the fatal error.
error connecting to the server: fatal :could not open file "base/12029/11801"
permission denied
Any suggestions?
ated.
make: *** [src/tds_fdw.o] Error 1
[root@scsblnx-994457 tds_fdw-master]#
Any ideas?
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Wednesday, November 11, 2015 3:53 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: RE: attempting to inst
The following postgresql rpm is installed ..
rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64
on redhat 7
Red Hat Enterprise Linux Server release 7.1 (Maipo)
Currently following the instructions at the following link in attempt to create
the extension:
https://github.com/GeoffMontee/tds_fdw/
Are there any type of 'pgadmin' like interfaces for the linux side?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, November 10, 2015 2:12 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to
Sent: Tuesday, November 10, 2015 1:49 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to pull from mssql
On 11/10/2015 10:26 AM, Mammarelli, Joanne T wrote:
> Continuously syncing .. we have database in mssql. Ideally we'd like to
> conn
esday, November 10, 2015 1:26 PM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Best tool to pull from mssql
On 11/10/2015 10:21 AM, Mammarelli, Joanne T wrote:
> Hi .. we're on a hunt to locate either pgloader or the tds_fdw
> extension to assist us with pul
Hi .. we're on a hunt to locate either pgloader or the tds_fdw extension to
assist us with pulling data FROM a Microsoft sql server (we're a windows-based
postgres installation).
Is this the proper way to handle the process?
m Nasby
Cc: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
I would also like to add that I am very suspicious of a table with 80 columns.
Offhand, it sounds like poor database design where someone was trying to put
all the eggs in
connector) it
takes 3 minutes for the data to come back.
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 11:08 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Slow response if pulling through pgadmin
O
Hi - same rookie user as before.
We have one table
100,000 rows
80 columns
When we try to retrieve the data (select * from table) using pgadmin, we get a
193456 ms retrieve time.
When I ran a query analyze in the command prompt, we get a 316ms retrieve time.
.. and finally. When we retrieve
Are there any options for linking a Microsoft sql database to a postgresql
database?
(I want the postgresql database to be the "puller")
-Original Message-
From: Jim Nasby [mailto:jim.na...@bluetreble.com]
Sent: Tuesday, November 10, 2015 10:21 AM
To: Mammarelli, Joann
Hi - rookie user here.
I'd like to access data on my Microsoft sql database from my postgres database.
I stumbled upon the tds_fdw extension and it reads as if it it's *nix only.
Would acquiring tds_fdw.control from one of the repos possibly work on a
windows-based postgres installed database?
I have a Query it taking a lot of time to fetch results
so,explain query gave
"Hash Join (cost=55078.00..202405.95 rows=728275 width=418)"
" Hash Cond: (itd.tran_id = iad._adj__id)"
" -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029
width=95)"
"Filter: (event_type = ANY
;-',4) >0
then 1 else 0 end
it's return error like integer need...
On Thu, Oct 15, 2015 at 8:50 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Oct 15, 2015 at 10:05 AM, Ramesh T
> wrote:
>
>> '123-987-123' it is not fixed some t
select position('-' in '123-987-123')
position
---
4
But I want second occurrence,
position
-
8
plz any help..?
On Thu, Oct 15, 2015 at 12:54 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Oct 14, 2015 at 9:38 AM, R
end with -
i.e ,
i need to find second postition of the variable between the '-'
On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T
> wrote:
>
>> select position('-' in &#
Hi All,
Do we have function like regexp_substr in postgres..?
in oracle this function seach the - from 1 to 2 and return result,
regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)
Nice, thank you.
On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver
wrote:
> On 09/29/2015 06:13 AM, Ramesh T wrote:
>
>>
>>
>> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > <mailto:rameshparnandit...@gmail.com>> wrote:
>>
>> in my mind to be be
On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T
wrote:
> in my mind to be beautiful ,avoid confusion to understand sql query code
>
> like
>
> select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ;
>
> if some one written, then newer or code reader understand
Hi All,
How to change sql format to look beautiful and understandable
using pgadmin3 or else ther tools for postgres.
any help appreciated..
CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y'
then load_id else null end );
how can i convert case expressed to postgres..above it is oracle.
any help appreciated...
Hi,
i created extension pgcrypto on public with postgres user.But while
trying to use from my own schma suppose qa.
when i run digest in function in my qa
CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$
SELECT encode(digest($1, 'sha1'), 'hex')
$$ LANGUAGE SQL STRICT
I have one database and two schemas in that public,preview and role preview
automatically i want to connect preview schema with preview role.
set search_path to preview.
show search_path;
..
preview.
when disconnect and connect database it's showing $user$:public schema not
showing preview.
wha
with out hanging how to open data script of the oracle schema to change the
name.
On Thu, Sep 17, 2015 at 6:31 PM, Ramesh T
wrote:
> Actually ,oracle have the *qa *schema i have to import to this schema to
> postgres database.But in postgres database already have the *qa *schema.My
>
right.manullay is not possible change name of schema in qa is have 2 gb
data when i try to change name of the data scipt is hanged.
On Thu, Sep 17, 2015 at 11:54 AM, Venkata Balaji N
wrote:
>
> On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T
> wrote:
>
>> Hi All,
>>
Hi All,
I'm using or2pg tool ,I exported data but I have to change the
schema import to postgres database.exported data more than gb.
Can you please let me know, how to do the change the name in data script..?
HI ,
I have view .when i try to select view ,it had return
select * from art;
ERROR: permission denied for relation sub_item
SQL state: 42501
on on port 5432.
any help to start server..
On Fri, Aug 7, 2015 at 2:26 PM, Ramesh T
wrote:
> any help
>
> On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T
> wrote:
>
>> Hi all,
>> I got a problem when i start postgres server.
>> like'
>&g
any help
On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T
wrote:
> Hi all,
> I got a problem when i start postgres server.
> like'
>could not connect to the server: connection refused on host
> 2.3.421.1 and accepting tcp/ip connection on port 5432.
>
> any help appreciated..
>
Hi all,
I got a problem when i start postgres server.
like'
could not connect to the server: connection refused on host
2.3.421.1 and accepting tcp/ip connection on port 5432.
any help appreciated..
Hi All,
I changed in pg_hba.conf like,in postgres 9.3 under linux
host replication base_backup_user 127.0.0.1/32 trust
after above changes ,restarted it .
when i try pgbasebackp getting error like,
pg_basebackup: could not connect to server: FATAL: no pg_hba.conf en
I changed archive_command in postgresql.conf and restarted it.postgres 3
installed on linux.connected from putty.
after restarted it
getting message like
-bash-4.1$ service postgres-9.3 start
postgres-9.3: unrecognized service
but files available at server side..
any help..?
here is the example tks help..
http://stackoverflow.com/questions/2965655/how-to-find-the-first-and-last-occurrences-of-a-specific-character-inside-a-stri
On Thu, Jul 30, 2015 at 7:38 PM, Ramesh T
wrote:
> select position('.' in '.T.homas')
> result
>
>
select position('.' in '.T.homas')
result
1
it returns first postion.but I need last occurence of ' . ' .
actual result
--
3
any help..?appreciated.
On Thu, Jul 30, 2015 at 5:00 AM, Tom Lane wrote:
> Melvin Davidson writes:
> > Based om the definition of Oracle instr(), the equiva
Hi All,
is instr available in postgres 9.3..?
in oracle instr('12.32.42','.',-1) ,any help appreciated
it from server commmand mean
from putty is it possible..?
i want commands to execute the set to the server without open the
postgres.conf...?
On Mon, Jul 20, 2015 at 6:23 PM, Michael Paquier
wrote:
> On Mon, Jul 20, 2015 at 7:00 PM, Ramesh T
> wrote:
> > Hi All,
> > W
Hi All,
What i need to know for postgres recovery..?let me know in detail.
,'-MM-DD HH24'|| ' '||'MI'||'
'||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names
WHERE name=changed_dttimezone), '-MM-DD HH24'||' '||'MI'||'
'||'SS')::timestampt
Yes,But i need to display last digits also
[image: Inline image 1]
like 1500 08-09-10.738901
On Mon, Jul 13, 2015 at 8:18 PM, Francisco Olarte
wrote:
> Hi Ramesh:
>
> On Sun, Jul 12, 2015 at 8:21 AM, Ramesh T
> wrote:
>
>> postgres query
>> select current_timesta
i got function
select regexp_split_to_table('2,1', E',')::bigint
thanks
On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T
wrote:
> WITH idtable AS (
> SELECT '2342,8766' id
> )
>
> select * from inv where id in(
> SELECT id
> FROM idtable)
&g
y row from temp table?
On Sun, Jul 12, 2015 at 5:38 PM, Ramesh T
wrote:
> xml table is the oracle function ..thank you sir
>
> On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver > wrote:
>
>> On 07/11/2015 08:32 AM, Ramesh T wrote:
>>
>>> Hi,
>>>
any help..?
On Sun, Jul 12, 2015 at 11:51 AM, Ramesh T
wrote:
> postgres query
> select current_timestamp-
> TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||'
> '||(SELECT utc_offset FROM pg_cat
xml table is the oracle function ..thank you sir
On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver
wrote:
> On 07/11/2015 08:32 AM, Ramesh T wrote:
>
>> Hi,
>>is xmltable available in postgres..?,if not please give me a
>> advice to replace the xmtable in po
okay,i'm executing a query from pgadmin3.
i want display time with timezone.But above query displaying date and time
not timezone...
On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T
> wrot
gres query..i thnk something wrong. is
it..?
any help apprictiated.
On Sat, Jul 11, 2015 at 11:12 PM, Adrian Klaver
wrote:
> On 07/10/2015 05:54 AM, Ramesh T wrote:
>
>>
>> select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD
>> HH24'||'
Hi,
is xmltable available in postgres..?,if not please give me a advice
to replace the xmtable in postgres..?
select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD
HH24'||':'||'MI'||':'||'SS')||' '||(SELECT utc_offset FROM
pg_catalog.pg_timezone_names
WHERE name='US/Eastern'),'-MM-DD
HH24'||':'||'MI'||':'||'SS')::timestamptz;
it's not displaying timezone..any help..?
nice i'm looking for this,i thought digit don't work in postgres..
thanks
On Thu, Jul 9, 2015 at 10:21 PM, Chris Mair wrote:
> > Hi,
> > in oracle regexp_like(entered
> > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
> >
> > for postgres i have regexp_matches ,But i need how
Hi,
in oracle regexp_like(entered
date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i')
for postgres i have regexp_matches ,But i need how to match [:digit:] in
postgres when we pass date..?
any help
thank you it's helpfull
On Fri, May 8, 2015 at 7:43 PM, Adrian Klaver
wrote:
> On 05/08/2015 01:56 AM, Ramesh T wrote:
>
>> Hi All,
>>I want move functions from onedatabase to other database in same host
>> on windows 7 and installed postgres version is 9
Hi All,
I want move functions from onedatabase to other database in same host on
windows 7 and installed postgres version is 9.4.I'm using pgadmin3 tool.
any help..?
Hi all,
as i mentioned above i have function called delete parts
can i mention select deleteparts();
or
c:\programfiles\9.4\pgagent\check.sql in this path check.sql contain to
delete parts.i placed query select deleteparts();
when click run now job,it returns statistics failed and etc/
On Sun, 26 Apr 2015 12:43:57 +0200
Oliver Elphick wrote:
> On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote:
> >
> > CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8)
> >
> > But then I get this:
> >
> > ERROR: could not create locale &quo
On Sun, 26 Apr 2015 11:48:37 +0200
Oliver Elphick wrote:
> On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote:
> > Ok, tried to run:
> >
> > alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8
> >
> > But I just get:
> >
> &
On Sun, 26 Apr 2015 10:59:10 +0200
Bjørn T Johansen wrote:
> On Sun, 26 Apr 2015 10:31:37 +0200
> "Gunnar \"Nick\" Bluth" wrote:
>
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Am 26.04.2015 um 10:02 schrieb
On Sun, 26 Apr 2015 10:31:37 +0200
"Gunnar \"Nick\" Bluth" wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
> > My databases looks like this...:
> >
> >
> > List of
databases or initialize PGSQL?
Regards,
BTJ
--
---
Bjørn T Johansen
b...@havleik.no
---
Someone wrote:
&q
ian Klaver
wrote:
> On 04/13/2015 07:22 AM, Ramesh T wrote:
>
>> Hi,
>> in steps>definition->
>> do
>> $body$
>> begin
>> perform delete_empty_parts();
>> end;
>> $body$
>>
>> delete_empty_parts is the function
>>
>&
Hi all,
i have a function to delete data from table.Where i need to place
function in pgagent.in definition section can i select SQL or BATCH ..?
or else any other method.?
Any Help..
7;m running function on particular database and selected today dates..
but function wasn't executed.
let me know how to set it function in pgagent..
On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver
wrote:
> On 04/13/2015 06:53 AM, Ramesh T wrote:
>
>> Hi all,
>> i h
..?
On Fri, Apr 3, 2015 at 3:50 PM, wrote:
> Your message to pgsql-general has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> The author (Ramesh T )
> is not a member of any of the restrict_post groups.
>
> If you do not wish t
nd-schedules-programatically-with-pgagent
>
> regards
>
> Pavel Stehule
>
> 2015-04-03 11:27 GMT+02:00 Ramesh T :
>
>> Hi ,
>> How to create job in pgAgent.Where I need to place script in
>> pgAgent..any help
>>
>> Advanced thanks...
>>
>>
>
Hi ,
How to create job in pgAgent.Where I need to place script in
pgAgent..any help
Advanced thanks...
I had installed on Linux.re-install postgres for stack builder ..?
cron is their ,but I am new to this cron and is this method for job
schedulers in postgres.
On Wed, Apr 1, 2015 at 8:39 PM, Adrian Klaver
wrote:
> On 04/01/2015 07:59 AM, Ramesh T wrote:
>
>>Hi,
>>
Hi all,
I didn't selected stack builder at the time of installation of
postgres.Any help how to add* application stack builder* to existed
postgres.
Hi,
I had installed pgadmin3 but not selected stackbuilder ,let me
know how to add stackbuilder to pgadmin3 for additional addons.
On Wed, Apr 1, 2015 at 7:15 PM, Adrian Klaver
wrote:
> On 04/01/2015 06:22 AM, Ramesh T wrote:
>
>> Hi all,
>>
Hi all,
SELECT xmlagg(xmlelement(
name actor, xmlattributes(first_name)
)ORDER BY actor_id,',')from actor;
the above code return following result,
[image: Inline image 1]
Question :
i want retrieve result from above XML result like
hi all,
I am using postgres 9.4 on windows 7.
i want import that backup sql file into postgres schema.
i googled i got copy, but when i ran in windows
COPY actor FROM 'c:\users\venu\downloads\sakila-data.sql';
ERROR: invalid input syntax for integer: ""
CONTEXT: COPY actor, line 1,
it is in postgres i need to convert into oracle
CREATE RULE payment_insert_p2007_04 AS ON INSERT TO payment WHERE
(new.payment_date >= '2007-04-01'::timestamp without time zone) DO INSTEAD
INSERT INTO payment_p2007_04 (payment_id)VALUES (1);
in oracle format i used google
i got
BEGIN
DBMS_MACAD
CREATE AGGREGATE group_concat(text) (
SFUNC = _group_concat,
STYPE = text
);
is it availabe in oracle..?
scheduler. If you need it, you can use a
> EnterpriseDB - commercial fork with Oracle migration tools. There it is.
>
> You can use a scheduler pgAgent - https://github.com/postgres/pgagent
> http://www.pgadmin.org/docs/dev/pgagent.html
>
> Regards
>
> Pavel
>
> 2015-02-03 14:16 GMT
convert
oracle function into postgres format
any help..?
thanks in advance,
On Mon, Feb 9, 2015 at 11:39 AM, Pavel Stehule
wrote:
>
>
> 2015-02-03 13:49 GMT+01:00 Ramesh T :
>
>> Hi ,
>> i created type on postgres
>> CREAT
i solved my problem using string_agg in tab_to_string
ex:-
select string_agg(s.Rnumber ::text,',' )AS number
On Fri, Feb 13, 2015 at 10:40 PM, Raymond O'Donnell wrote:
> On 13/02/2015 13:13, Ramesh T wrote:
> > cast(COLLECT (r_id) as num) in oracle..
> >
>
1 - 100 of 553 matches
Mail list logo
