On 05/05/15 18:41, Marc Fournier wrote:
Fixed .. .let me know if there are any other issues …
3
Tim Clarke
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
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
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 comparable.
On Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de
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
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 cdrlogentry
. cdrdetails table do not have the index whereas cdrlogentry
Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de
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
-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
On Wed, May 6, 2015 at 1:56 AM, Mitu Verma mitu.ve...@ericsson.com 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
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 melvin6...@gmail.com
wrote:
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
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 suresh.raja...@gmail.com wrote:
Thanks Melvin, Joshua, PT and Steve!
your information is good. Im
-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
gunnar.bl...@pro-open.de mailto:gunnar.bl...@pro-open.de
wrote:
-BEGIN PGP SIGNED MESSAGE-
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
On Wed, May 6, 2015 at 3:37 PM, Yves Dorfsman y...@zioup.com 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
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
On Tue, May 5, 2015 at 6:40 PM, Steve Kehlet steve.keh...@gmail.com 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
On Wed, May 6, 2015 at 9:46 AM Jeff Janes jeff.ja...@gmail.com 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
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 y...@zioup.com wrote:
On 9.3, is there any
On Wed, May 6, 2015 at 10:51 AM, Steve Kehlet steve.keh...@gmail.com
wrote:
On Wed, May 6, 2015 at 9:46 AM Jeff Janes jeff.ja...@gmail.com 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
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 j...@ionicsecurity.com 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
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 suresh.raja...@gmail.com wrote:
Thanks Melvin, Joshua, PT and Steve!
your information is good. Im
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
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
On Wed, May 6, 2015 at 8:35 PM, Jason May j...@ionicsecurity.com 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
On 05/06/2015 08:11 AM, Sujit K M wrote:
On Wed, May 6, 2015 at 8:35 PM, Jason May j...@ionicsecurity.com 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
26 matches
Mail list logo