On Wed, May 6, 2015 at 10:51 AM, Steve Kehlet
wrote:
> On Wed, May 6, 2015 at 9:46 AM Jeff Janes wrote:
>
>> vacuum_freeze_table_age controls when it promotes a vacuum *which is
>> already going to occur* so that it scans the whole table. It doesn't
>> specially schedule a vacuum to occur. Whe
Although not a PostgreSQL utility, in Linux, you can use screen or tmux to
establish a connection and then disconnect.
On Wed, May 6, 2015 at 6:48 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman wrote:
>
>>
>> On 9.3, is there any way to
On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman wrote:
>
> On 9.3, is there any way to start a query, detach from the server and have
> the
> query keep going (long query that updates tables, but nothing is returned)?
>
No. Sessions require an external client to maintain its connection.
David J
On 9.3, is there any way to start a query, detach from the server and have the
query keep going (long query that updates tables, but nothing is returned)?
Thanks.
--
http://yves.zioup.com
gpg: 4096R/32B0F416
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On Wed, May 6, 2015 at 9:46 AM Jeff Janes wrote:
> vacuum_freeze_table_age controls when it promotes a vacuum *which is
> already going to occur* so that it scans the whole table. It doesn't
> specially schedule a vacuum to occur. When those tables see enough
> activity to pass autovacuum_vacuu
On Tue, May 5, 2015 at 6:40 PM, Steve Kehlet wrote:
> Hello, recently one of my tables needed a vacuum (to prevent wraparound)
> and of course it happened at a really bad time, so since then I've been
> learning about how Transaction ID Wraparound works and its associated
> parameters.
>
> I'm tr
On 4/30/15 3:13 AM, Meel Velliste wrote:
My goal is to select rows that are new or have been modified since a
given snapshot. I am doing it like this:
SELECT * FROM my_table WHERE NOT
txid_visible_in_snapshot(xmin::TEXT::BIGINT,
'123456:123456:'::TXID_SNAPSHOT);
On one hand, it seems to me that
Joshua D. Drake wrote:
>
> On 05/06/2015 08:11 AM, Sujit K M wrote:
> >
> >On Wed, May 6, 2015 at 8:35 PM, Jason May wrote:
> >>You find the description offensive? That’s interesting. You're very
> >>easily offended. I think it reads more like an Engineer than a DBA
> >
> >lol, you are cribbin
On 05/06/2015 08:11 AM, Sujit K M wrote:
On Wed, May 6, 2015 at 8:35 PM, Jason May wrote:
You find the description offensive? That’s interesting. You're very easily
offended. I think it reads more like an Engineer than a DBA
lol, you are cribbing like a third graders looking for some fr
On Wed, May 6, 2015 at 8:35 PM, Jason May wrote:
> You find the description offensive? That’s interesting. You're very easily
> offended. I think it reads more like an Engineer than a DBA
lol, you are cribbing like a third graders looking for some freshman.
I am not offended, I found it offen
On Wed, May 06, 2015 at 08:29:06PM +0530, Sujit K M wrote:
> experts on this. I find this particular job ad to be very offensive in
> terms of an expectancy from
> any person looking for job.
In that case, I suggest you not apply for the job. I can't see how
taking up the community's time with cr
FYI, I was told this needs to be posted in
pgsql-general(at)postgresql(dot)org simply because
the jobs mailing list does not let you reply keeping the mailing list
in loop. I expect a answer from
experts on this. I find this particular job ad to be very offensive in
terms of an expectancy from
any
I just use sql tables. But if I represent them outside of pg I usually use
migration files which are part of ruby on rails. But sqitch looks good too.
Steve
On May 6, 2015 7:31 AM, "Suresh Raja" wrote:
> Thanks Melvin, Joshua, PT and Steve!
>
> your information is good. Im looking for creating
On 05/06/2015 07:31 AM, Suresh Raja wrote:
Thanks Melvin, Joshua, PT and Steve!
your information is good. Im looking for creating a catalog for my
application schema. Do you have anything that you use for catalog of
your schema. Maybe using excel.
Yes Mercurial(mercurial.selenic.com) with S
I just use sql tables. But if I represent them outside of pg I usually use
migration files which are part of ruby on rails. But sqitch looks good too.
Steve
On May 6, 2015 7:31 AM, "Suresh Raja" wrote:
> Thanks Melvin, Joshua, PT and Steve!
>
> your information is good. Im looking for creating
Thanks Melvin, Joshua, PT and Steve!
your information is good. Im looking for creating a catalog for my
application schema. Do you have anything that you use for catalog of your
schema. Maybe using excel.
Thanks,
SR
On Tue, May 5, 2015 at 4:42 PM, Melvin Davidson
wrote:
> Try this query and
On Wed, May 6, 2015 at 1:56 AM, Mitu Verma wrote:
> Thank you so much all of you.
>
> Table audittraillogentry have PRIMARY KEY and FOREIGN KEY defined, below is
> the detail of existing table audittraillogentry.
>
> As you can see ., it is referenced by 2 tables , "cdrdetails" and
> "cdrlogentr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 06.05.2015 um 09:57 schrieb David G. Johnston:
Ooops, accidentaly replied to David directly...
> Wednesday, May 6, 2015, Gunnar "Nick" Bluth
> mailto:gunnar.bl...@pro-open.de>>
> wrote:
>
> -BEGIN PGP SIGNED MESSAGE- CREATE OR REPLACE FUN
On 06/05/15 11:04, Gavin Flower wrote:
> See comments at bottom,
>
> On 06/05/15 20:47, Tim Clarke wrote:
>> We keep the DDL statements for any tables in our subversion code
>> repository just like any other programming code. Takes only a moment
>> then all history or changes is available and compa
See comments at bottom,
On 06/05/15 20:47, Tim Clarke wrote:
We keep the DDL statements for any tables in our subversion code
repository just like any other programming code. Takes only a moment
then all history or changes is available and comparable. svnserve on
our linux server, svn workbenc
On 05/05/15 18:41, Marc Fournier wrote:
>
> Fixed .. .let me know if there are any other issues …
>
>
<3
Tim Clarke
We keep the DDL statements for any tables in our subversion code
repository just like any other programming code. Takes only a moment
then all history or changes is available and comparable. svnserve on our
linux server, svn workbench on my ubuntu laptop, all open source :)
Tim Clarke
On 05/05/15
Wednesday, May 6, 2015, Gunnar "Nick" Bluth
wrote:
> -BEGIN PGP SIGNED MESSAGE-
> CREATE OR REPLACE FUNCTION
> public.get_current_tac(userid bigint, sessionid uuid, locale character
> varying, OUT current_tac json)
> RETURNS json
> LANGUAGE sql
> IMMUTABLE STRICT SECURITY DEFINER
> AS
On Wednesday, May 6, 2015, Gunnar "Nick" Bluth
wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello,
>
> I'm experiencing odd behaviour with a function I wrote yesterday.
>
> Background: function is supposed to deliver some "terms and
> conditions" from a table; when the "locale" is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I'm experiencing odd behaviour with a function I wrote yesterday.
Background: function is supposed to deliver some "terms and
conditions" from a table; when the "locale" is found, deliver the
highest version of that, otherwise, deliver the hig
25 matches
Mail list logo