[graylog2] source field from central rsyslog server using log server hostname rather than host from message after upgrade from 2.01 to 2.1.1

2016-09-30 Thread Terry Lee
Familiar problem, logs from central rsyslog server show up in Graylog with logserver hostname rather than hostname from syslog message. I had this corrected in a Graylog 2.0.1 appliance, but I cannot get it working on Graylog 2.1.1 installed from packages. The rsyslog server remains the sa

[graylog2] Best way to get tomcat logs including exception and stacktraces into graylog2? using tomcat and log4j 1.2.17

2016-06-10 Thread Terry Lee
I am wondering if there is any "best method" to get tomcat logs including exception and stacktraces into graylog2? We are using tomcat and log4j 1.2.17 Is any available GELF appender clearly better than others? Is filebeats/collector-sidecar a viable solution? Anythign else? All suggestion

[graylog2] How to use filebeats with collector-sidecar

2016-06-10 Thread Terry Lee
I cannot seem to to find docs on how to use filebeats with collector-sidecar. Can someone point me in the right direction? -- You received this message because you are subscribed to the Google Groups "Graylog Users" group. To unsubscribe from this group and stop receiving emails from it, send

CS>Help Un-Subscribing

2015-02-10 Thread Terry Lee Gonzalez
ot been removed, I couldn't find your name on the list. You are now being unsubscribed from the silver-list." * I emailed Mike Devour requesting help. No reply. Maybe he's busy. Busy or not, the digests keep coming. Regards, Terry Lee Gonzalez --- This email is free fr

CS>Re: silver-digest Digest V2014 #283

2014-11-29 Thread Terry Lee Gonzalez
Harsha, I take 1 teaspoon of MSM (5g) in a cup of coffee and don't notice the taste one way or the other. My husband insists that I NOT add MSM to his coffee because he doesn't like the taste. He can tell, I can't. A few things (amino acids in particular, proteases (protein-digesting enzyme

CS>Re: silver-digest Digest V2014 #283

2014-11-29 Thread Terry Lee Gonzalez
Sol, try taking your MSM with food. Doing so is supposed to reduce the gastrointestinal side effects that some people experience. You could start with 1/2 gram (or even less!) three times a day. MSM is just a highly bioavailable form of sulfur. Protein, eggs, and veggies in the allium famil

CS>Re: silver-digest Digest V2014 #281

2014-11-29 Thread Terry Lee Gonzalez
Re CS>MSM rids Parasites Harsha, I take my MSM with my morning coffee because unlike a lot of supplements/nutrients it crosses the blood brain barrier and has an energizing effect (at about 5g). In fact, I usually recommend to people that they NOT take MSM before they go to bed, because your

[Bug 1056802] Re: installing Ubuntu onto this computer

2012-09-26 Thread Terry Lee Chandler
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1056802 Title: installing Ubuntu onto this computer To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/ubiquity/+bu

[Bug 1056802] [NEW] installing Ubuntu onto this computer

2012-09-26 Thread Terry Lee Chandler
Public bug reported: Trying to install on an old Dell Optiplex w/200Gig hard drives and got ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: ubiquity 2.10.16 ProcVersionSignature: Ubuntu 3.2.0-23.36-generic-pae 3.2.14 Uname: Linux 3.2.0-23-generic-pae i686 ApportVersion: 2.0.1-0ubuntu5 Archi

Re: [Openlp-core] [Bug 1054837] Re: There is no "Name" window in the Theme Creator

2012-09-24 Thread Terry Lee
I have repeated it. It happens when I am editing a stock theme. I am trying to edit "Blue Frilly" and when I get to the last window there is no place to put a name, because it already has name, but it is not registering with the editor. Happens when I try to edit any of the stock themes. On Sun

Re: [Openlp-core] [Bug 1054837] Re: There is no "Name" window in the Theme Creator

2012-09-24 Thread Terry Lee
Fixed. Had to reinstall OpenLP. Works fine now. Thanks. Terry On Mon, Sep 24, 2012 at 10:38 AM, Andreas Preikschat < 1054...@bugs.launchpad.net> wrote: > Please check John's and phill's comment. If you still experience a bug, > then let us know (and attach a screenshot please). > Regards > > **

[Openlp-core] [Bug 1054837] [NEW] There is no "Name" window in the Theme Creator

2012-09-22 Thread Terry Lee
Public bug reported: Windows 7 64 bit Home Premium OpenLP Version 1.9.12 When I am creating a new theme in the Theme Creator/Editor, there is no place to enter a name for the theme. When I click on "Finish" at the end, itgives me an error message to enter a name. No where in the creation proce

Use Dia to view Visio files

2012-03-22 Thread Terry Lee
Hi My company was used to use MS Visio to make diagrams but the license is no longer available. Therefore, we would like to change to open source alternative, like Dia. However, we can't use Dia to open old .vsd files. >From the internet, I find this one: http://sdteffen.blogspot.com/search/lab

Fwd: Use Dia to view Visio files

2012-03-22 Thread Terry Lee
Hi My company was used to use MS Visio to make diagrams but the license is no longer available. Therefore, we would like to change to open source alternative, like Dia. However, we can't use Dia to open old .vsd files. >From the internet, I find this one: http://sdteffen.blogspot.com/search/lab

Re: [GENERAL] question on trigger

2012-02-11 Thread Terry Lee Tucker
se performance; however, it seems to me that you would waste more cycles checking if things changed than simply forcing upper case for all to which this criteria applies. The whole record is going to be written to the database anyway. Terry Lee Tucker Office: 336-372-6812

Re: [GENERAL] running out of oids

2011-08-03 Thread Terry Lee Tucker
On Wednesday, August 03, 2011 04:24:32 PM Joshua D. Drake wrote: > On 08/03/2011 12:41 PM, Geoffrey Myers wrote: > > Am I correct in assuming that the 'running out of oids' issue was > > resolved with a design change within Postgresql? > > Yes, many, many, many years ago. The only way to encounter

[Bug 810331] Re: Video is Crashing Mint 11 must reboot

2011-07-16 Thread Terry Lee Chandler
What can I do too fix this? ** Also affects: ubuntu Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/810331 Title: Video is Crashing Mint 11 must reboot To

Re: [GENERAL] Marking a Column for Special Use

2011-07-12 Thread Terry Lee Tucker
On Tuesday, July 12, 2011 11:33:34 AM David Johnston wrote: > Can you make use of "COMMENT ON ."? > > > > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Terry Lee Tucker > Sent: Tuesday, July 12, 20

Re: [GENERAL] Marking a Column for Special Use

2011-07-12 Thread Terry Lee Tucker
On Tuesday, July 12, 2011 11:47:33 AM Andrew Sullivan wrote: > On Tue, Jul 12, 2011 at 11:25:24AM -0400, Terry Lee Tucker wrote: > > Greetings: > > > > I have a scenario in which it would be quite convenient to mark about 20 > > existing columns in a table such tha

[GENERAL] Marking a Column for Special Use

2011-07-12 Thread Terry Lee Tucker
Greetings: I have a scenario in which it would be quite convenient to mark about 20 existing columns in a table such that I can select those fields programatically, based on my flag, for some specialized processing. What I am trying to avoid is storing a list of columns somehere. Is there somet

Re: [Meego-kernel] How to install meego in OT5 platform

2011-07-03 Thread Terry Lee
Dear Jacky Support 1. Ilitek i2c multi touch driver 2. Wifi / bluetooth driver 3. Thermal sensor driver Best Regards, ELITEGROUP COMPUTER SYSTEMS CO., LTD. Software Department , Protable Device Business Unit 李明華 TERRY LEE Tel : 886-2-2162-1177 Ext. 23685 Fax :886-2

[Meego-kernel] Do meego support rotation screen ?

2011-06-09 Thread Terry Lee
Dear meego team Do meego support rotation screen ? I saw new tablet oakrail image had included ST-sensor devices. I know these are supporting rotation function. Best Regards, ELITEGROUP COMPUTER SYSTEMS CO., LTD. Software Department , Protable Device Business Unit 李明華 TERRY LEE Tel

Re: [Ubuntu-zh] 新手问题:ubuntu安装时卡死

2011-02-10 Thread terry lee
同意断网安装 2011/1/21 Qi Guai > 断网试试。 > > 2011/1/21 Jiahua Huang : > > 上海是时区,不用改 > > > > 2011/1/21 lten : > >> 安装的时候,进行到“Where are > you?”这一步时,默认值是Shanghai,我点击文本框,按退格键想删除修改,结果一按就卡死了,等了1个小时还是没反应。 > >> 我本来有3系统,win xp/7/2008,想装第四个系统ubuntu的,我觉得这应该和原本的系统没关系吧,我用wubi和cd都是这样。 > >> > > -- > > ubuntu-zh mailin

Re: [Ubuntu-zh] 关于Chrome OS和Ubuntu

2011-02-10 Thread terry lee
说得有理 2011/1/22 Lanpice Lio > Chrome OS在天朝是注定会悲剧的,就天朝这破网络,简直是受罪。 > 很多Google服务被墙,而且Chrome OS的离线操作功能太弱了。一旦断网就变成了一个废物。我个人还是更喜欢用Ubuntu > > 在 2011年1月22日 下午1:43,孙锡麟 写道: > > > 看来以后chrome os也要破解咯 > > -- 下一部分 -- > > 一个HTML附件被移除... > > URL: < > > > https://lists.ubuntu.com/archives/

Re: [Ubuntu-zh] ubuntu 和 儿童

2011-02-10 Thread terry lee
哦,还有这好东西呢 2011/2/11 jack.feng.冯国瑞 > ubuntu有儿童的衍生版 > > 就是只在中间有几个按钮的那种,和小霸王也差不多 > > > > On Fri, Feb 11, 2011 at 11:10 AM, znetor wrote: > > > 长期玩电脑可能会有资本主义思想 > > > > 在 2011年2月11日 上午10:58,OxFAN 写道: > > > > > 还要注意颈椎,腰椎,眼睛 > > &

Re: [Ubuntu-zh] ubuntu 和 儿童

2011-02-10 Thread terry lee
太早用电脑得注意手腕 2011/2/11 柳东原 > 我们正在做一个衍生自 LOGO 的专门用于小孩(或初学者)的语言,如果大家感兴趣,做好以后发过来分享分享~ > > 在 2011年2月11日 上午8:26,daniel.zhy 写道: > > > > > 是吗? 我搜搜看。有一天教女儿Python,孩子高兴坏了。但是后来就是不知道该怎么教了。 > > > > 于 2011-2-11 0:55, Xilin Sun 写道: > > > > 教小孩python吧。国外有本书是小孩写的python教程,你可以参考一下试试…… > >> > >> 不过这个得再等五年。至少等小孩字母能认全

Re: [google-appengine] How to make this

2010-11-15 Thread terry lee
Thanks for your advice, but I'm in fact just interested in that if there exists a way to make this by a software or some pieces of code, you know, we may do this by simulate HTTP requests or things like that, so I just want to find out a correct way to realize this. 2010/11/15 Barry Hunter > You

Re: [GENERAL] Views - Under the Hood

2010-11-04 Thread Terry Lee Tucker
On Thursday, November 04, 2010 15:03:49 Scott Marlowe wrote: > On Thu, Nov 4, 2010 at 12:43 PM, Terry Lee Tucker wrote: > > Greetings: > > > > Lately, I've begun using views quite often especially when queries for > > various reports, etc. become complicated

[GENERAL] Views - Under the Hood

2010-11-04 Thread Terry Lee Tucker
any of the attributes of a table, but is it a table? Is the data pulled together when one selects from the view or is it maintained as a table all along. Guidance to the ignorant appreciated... -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 te...@chosen-ones.org -- Sent via pgs

Re: [GENERAL] varchar lengths

2010-09-21 Thread Terry Lee Tucker
on the length of the text, you can use a trigger for this and when the constraint changes, and it will, you simply modify the trigger. -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 te...@chosen-ones.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Question on trigger data visibility

2010-08-30 Thread Terry Lee Tucker
see" rows recently inserted into the tablex? > > Thanks, > Maurice They do "see" those rows. Are you sure that the inner join with tab_Y is not causing the problem? Just a guess... -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 te...@chosen-ones.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Locking Down a Database

2010-07-15 Thread Terry Lee Tucker
working at that time is limited to five or six. Is there some easy way of doing this without having people log out of the application? TIA... -- Terry Lee Tucker tel: (336) 372-5432; cell: (336) 404-6897 te...@chosen-ones.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] What does "INSERT 0 1" mean?

2009-10-14 Thread Terry Lee Tucker
On Wednesday 14 October 2009 11:05, [.::MDT::.] wrote: > Hi, > I can't find what does > INSERT 0 1 > mean. > > "1" stands for the number of the records added to the table, as far as I > understood, but what about the "0"? > > Thank you very much. > -- > View this message in context: > http://www.na

Re: [GENERAL] Configuration Question

2009-08-18 Thread Terry Lee Tucker
On Tuesday 18 August 2009 09:28, Martin Gainty wrote: > v8.3 FAQ_Solaris > > To point it to the right location, set the > LD_LIBRARY_PATH environment variable, e.g., > > LD_LIBRARY_PATH=/usr/sfw/lib:/opt/sfw/lib:/usr/local/lib > export LD_LIBRARY_PATH > > and restart configure. You will al

[GENERAL] Configuration Question

2009-08-18 Thread Terry Lee Tucker
Greetings: Is there a way to get hold of an environment variable such that it can be referenced in postgresql.conf? In particular, I'd like to be able to point dynamic_library_path to an environment variable defined at the system level as in dynamic_library_path = '$SOURCE:$libdir'. master=# s

Re: [GENERAL] C Function Question

2009-07-28 Thread Terry Lee Tucker
On Tuesday 28 July 2009 03:22, Albe Laurenz wrote: > Terry Lee Tucker wrote: > > Does anyone know if a function written in C and linked into the backend > > in a shared library with a statically declared structure, maintain that > > data for the life of the backend proces

[GENERAL] C Function Question

2009-07-27 Thread Terry Lee Tucker
Greetings: Does anyone know if a function written in C and linked into the backend in a shared library with a statically declared structure, maintain that data for the life of the backend process such that, when the function is called again, the structure data is intact? Thanks for any insight

Re: [GENERAL] warm standby with WAL shipping

2009-06-03 Thread Terry Lee Tucker
On Wednesday 03 June 2009 17:11, Joshua D. Drake wrote: > On Wed, 2009-06-03 at 16:45 -0400, Terry Lee Tucker wrote: > > > -- > > > * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, > > > MD > > > > Our circumstance here is that

Re: [GENERAL] warm standby with WAL shipping

2009-06-03 Thread Terry Lee Tucker
On Wednesday 03 June 2009 15:26, Greg Smith wrote: > On Wed, 3 Jun 2009, Geoffrey wrote: > > My assumption was that since pg_standby does not have the scp/rsync > > functionality, I would have to either modify it, change the way we do > > things, or 'reinvent' a little different wheel. > > There ar

Re: [GENERAL] Two Questions Re: Warm Backup

2009-05-02 Thread Terry Lee Tucker
On Saturday 02 May 2009 13:08, Daniel Verite wrote: > Terry Lee Tucker writes > > > Q1: Can we set up a scenario where there is more that one > > warm standby? > > Yes. But you'll have to consider what you want to happen when one > standby is correctly receiv

[GENERAL] Two Questions Re: Warm Backup

2009-05-01 Thread Terry Lee Tucker
Greetings: We are researching implementing a warm backup solution for our existing databases. We have a two node cluster running RH which are connected to a SAN. There is a total of 11 database clusters with the two node linux cluster balancing the load. At the moment, we are not doing any WAL

Re: [GENERAL] open transaction?

2008-12-29 Thread Terry Lee Tucker
Did postgres handle this for me? How do I see if the > transaction is still open? > > Thanks! If you don't commit, it is rolled back when you exit. -- Terry Lee Tucker Turbo's IT Manager Turbo, division of OHL 2251 Jesse Jewell Pkwy Gainesville, GA 30501 tel: (33

Re: [GENERAL] Trigger disable for table

2008-10-02 Thread Terry Lee Tucker
istence of a record matching the trigger name and some other criteria. If we find it, we simply return from the trigger at that point. The trigger on table B would be responsible for inserting the record into override and then deleting the record after the update is done. We've build wrapper

Re: [GENERAL] Dumping/Restoring with constraints?

2008-08-27 Thread Terry Lee Tucker
On Wednesday 27 August 2008 09:36, Phoenix Kiula wrote: > On Wed, Aug 27, 2008 at 9:29 PM, Terry Lee Tucker <[EMAIL PROTECTED]> wrote: > > We have all sorts of constraints and foreign keys and we have never had > > any problem with pg_restore related to dumping such

Re: [GENERAL] Dumping/Restoring with constraints?

2008-08-27 Thread Terry Lee Tucker
then the data using --disable-triggers. I'm assuming you are doing a binary dump. See the man page for pg_restore. HTH -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax:

Re: [GENERAL] ENABLE / DISABLE ALL TRIGGERS IN DATABASE

2008-08-27 Thread Terry Lee Tucker
by manipulating the run time parameter, session_replication_role. For example, from within your psql session: SET SESSION session_replication_role = replica; This will prevent all triggers from firing for the entire session except those defined as "replica". We use this all the time. HTH... -- Terry

Re: [GENERAL] Script to export all privileges to csv or similar

2008-08-22 Thread Terry Lee Tucker
Cheers > Anton > > -- > echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc > This will help you for 99.9% of your problems ... Have you looked at pg_dumpall -g ? -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse J

Re: [SQL] Case Insensitive searches

2008-08-06 Thread Terry Lee Tucker
that approach. I have never done this but I have read about it. I'm sure it can be done. > > CREATE INDEX indtest_01 ON table_01 > ((SUBSTRING(month_year, 3, 4) || SUBSTRING(month_year, 1, 2)) > > 2008/8/4 Terry Lee Tucker <[EMAIL PROTECTED]> > > > On Monday 04 A

Re: [SQL] Case Insensitive searches

2008-08-04 Thread Terry Lee Tucker
On Monday 04 August 2008 11:09, Frank Bax wrote: > Terry Lee Tucker wrote: > > On Monday 04 August 2008 10:05, Richard Broersma wrote: > >> On Mon, Aug 4, 2008 at 6:54 AM, Mike Gould <[EMAIL PROTECTED]> wrote: > >>> In some db's if you > >>>

Re: [SQL] Case Insensitive searches

2008-08-04 Thread Terry Lee Tucker
can. > > > -- What about using the operator, ~* ? Does that cause a table scan as well? -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 40

Re: [GENERAL] Generate SQL Statements

2008-06-03 Thread Terry Lee Tucker
On Tuesday 03 June 2008 20:10, Steve Crawford wrote: > Terry Lee Tucker wrote: > > Greetings: > > > > I was wondering if anyone knows of a third party product that will > > generate SQL statements for creating existing tables. We have to provide > > table def

[GENERAL] Generate SQL Statements

2008-06-03 Thread Terry Lee Tucker
Greetings: I was wondering if anyone knows of a third party product that will generate SQL statements for creating existing tables. We have to provide table definition statements for out parent company. Any ideas? -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-H

Re: [SQL] First day of month, last day of month

2008-04-24 Thread Terry Lee Tucker
On Thursday 24 April 2008 10:47, Bart Degryse wrote: > Well, that's what it does afaikt. And what does afaikt mean? -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 3

Re: [GENERAL] Backup setup

2008-04-23 Thread Terry Lee Tucker
e files there every hour or so. > Your suggestions are much appreciated! > -Gabor I would use pg_dump. It will ensure that you get a complete set of data and not something half written. -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewel

Re: [GENERAL] Deny creation of tables for a user

2008-04-23 Thread Terry Lee Tucker
; I mean she could insert, update delete rows but not create tables. > > I did not find a way to revoke such thing. Is it possible ? > > Thanks! Have you looked at GRANT? http://www.postgresql.org/docs/8.3/interactive/sql-grant.html -- Terry Lee Tucker Turbo's IT Manager Turbo,

Re: [BUGS] Request

2008-04-18 Thread Terry Lee Tucker
p://www.postgresql.org/docs/8.3/interactive/index.html You should post a question like this to a different list like "general" or "novice". -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501

Re: [GENERAL] How to retore a pg_dumpall dump?

2008-04-18 Thread Terry Lee Tucker
On Wednesday 16 April 2008 13:38, wasenbr wrote: > Hello, > > how can I restore a pg_dumpall dump? > > Cleiton http://www.postgresql.org/docs/8.3/interactive/backup.html -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell

Re: [GENERAL] Duplicate Symbols - Compiler Warnings

2008-04-17 Thread Terry Lee Tucker
On Thursday 17 April 2008 19:32, Tom Lane wrote: > Terry Lee Tucker <[EMAIL PROTECTED]> writes: > > Didn't get any nibbles on this one. Can anybody provide any insight on > > this? > > You're complaining in the wrong place ... I dunno what perlAPI.c is, but

Re: [GENERAL] Duplicate Symbols - Compiler Warnings

2008-04-17 Thread Terry Lee Tucker
Didn't get any nibbles on this one. Can anybody provide any insight on this? Thanks... On Thursday 17 April 2008 10:03, Terry Lee Tucker wrote: > Greetings: > > We are converting from 7.4.19 to 8.3. While compiling our application using > version 8.3, I have noticed the follo

[GENERAL] Duplicate Symbols - Compiler Warnings

2008-04-17 Thread Terry Lee Tucker
pplication into production and it concerns me greatly. So, my question is, do you see this as a serious problem and, if so, what shall I do to resolve it? By the way, this problem does not exist when compiling with 7.4.19. TIA -- Terry Lee Tucker Turbo's IT Manager Turbo, division o

Re: [GENERAL] session_replication_role

2008-04-15 Thread Terry Lee Tucker
On Tuesday 15 April 2008 14:26, Chris Browne wrote: > [EMAIL PROTECTED] (Terry Lee Tucker) writes: > > Is there a distinction between "ORIGIN" and "LOCAL" as related to > > session_replication_role, and if so, what is it? I am unable to > > understand from

[GENERAL] session_replication_role

2008-04-15 Thread Terry Lee Tucker
Version 8.3.1: Is there a distinction between "ORIGIN" and "LOCAL" as related to session_replication_role, and if so, what is it? I am unable to understand from the documentation any distinction between the two settings. TIA -- Terry Lee Tucker Turbo's IT Manager

Re: [GENERAL] Disable Triggers

2008-04-10 Thread Terry Lee Tucker
e yields: > > CREATE TRIGGER > psql:trig.example:53: NOTICE: I am trigger one > psql:trig.example:53: NOTICE: I am trigger two > psql:trig.example:53: NOTICE: I am trigger three > UPDATE 1 > ALTER TABLE > ALTER TABLE > psql:trig.example:59: NOTICE: I am trigger one > ps

Re: [GENERAL] Disable Triggers

2008-04-09 Thread Terry Lee Tucker
On Wednesday 09 April 2008 13:12, Tom Lane wrote: > Terry Lee Tucker <[EMAIL PROTECTED]> writes: > > My question is: When tgenabled is set to "D", how does that setting > > interact with session_replication_role and, is there a way to use > > tgenabled with a s

Re: [GENERAL] Disable Triggers

2008-04-09 Thread Terry Lee Tucker
" to prevent a particular trigger from firing. Using ALTER TABLE to disable the trigger won't work because the whole table is locked during the transaction and I only want the disabled trigger to apply to the current transaction in the current session. TIA -- Terry Lee Tucker Turbo's

Re: [GENERAL] Disable Triggers

2008-04-09 Thread Terry Lee Tucker
quot;origin", when the process is complete? > > -- > Greg Sabino Mullane [EMAIL PROTECTED] > PGP Key: 0x14964AC8 200804091058 > http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey

[GENERAL] Disable Triggers

2008-04-09 Thread Terry Lee Tucker
rigger records associated with the cust table, and tgenabled is set to "D", but the triggers still fire. session_replication_role is set to "origin". I thought this was supposed to be fixed in later versions of Postgres (I'm converting from 7.4.19 to 8.3.1), so apparently I

[GENERAL] Subtracting Two Intervals

2008-04-07 Thread Terry Lee Tucker
tes' - interval '29 hours'; ?column? @ 1 day -13 hours -30 mins (1 row) Is that right? I mean if you take 1 day (24 hours) and add -13 hours and -30 minutes, you get 10 hours and 30 minutes, but is it supposed to display that way? TIA -- Terry Lee Tuck

Re: [GENERAL] Conversion to 8.3

2008-04-07 Thread Terry Lee Tucker
> assuming... > >regards, tom lane Well, I didn't realize that "ago" was only applicable to a certain date style setting. I don't recall ever reading that anywhere but maybe I missed it. Now I know how to do it correctly. Thanks to all who responded... -- Terry L

Re: [GENERAL] Conversion to 8.3

2008-04-05 Thread Terry Lee Tucker
On Friday 04 April 2008 16:36, Tom Lane wrote: > Terry Lee Tucker <[EMAIL PROTECTED]> writes: > > I am converting our application from 7.4.19 to 8.3.1. In the old scheme > > of things, I was generating an interval between two timestamps and > > evaluating the interv

Re: [GENERAL] Conversion to 8.3

2008-04-04 Thread Terry Lee Tucker
On Friday 04 April 2008 16:36, Tom Lane wrote: > Terry Lee Tucker <[EMAIL PROTECTED]> writes: > > I am converting our application from 7.4.19 to 8.3.1. In the old scheme > > of things, I was generating an interval between two timestamps and > > evaluating the interv

Re: [GENERAL] Conversion to 8.3

2008-04-04 Thread Terry Lee Tucker
On Friday 04 April 2008 15:01, Craig Ringer wrote: > Terry Lee Tucker wrote: > > Greetings: > > > > I am converting our application from 7.4.19 to 8.3.1. In the old scheme > > of things, I was generating an interval between two timestamps and > > evaluating the

[GENERAL] Conversion to 8.3

2008-04-04 Thread Terry Lee Tucker
#x27; THEN . . END IF; With the new casting rules, this doesn't work. How can I determine if this on-time value is "ago", that is, the shipment is late? Thanks for any help you can give... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logis

[GENERAL] Proper Way to Disable Triggers

2008-04-02 Thread Terry Lee Tucker
ble. Should I simply alter disable_triggers to set tgenabled in pg_trigger to "D" for all the triggers I want to disable for a given operation, and then code enable_triggers to restore the value to "O" for said triggers? Thanks in advance for any insight you can give... -- T

Re: [GENERAL] Escaping \n

2008-03-28 Thread Terry Lee Tucker
On Friday 28 March 2008 17:21, Sam Mason wrote: > On Fri, Mar 28, 2008 at 05:06:10PM -0400, Terry Lee Tucker wrote: > > HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. > > > > The problem is a line like 'UPDATE bill SET notes = 'blah, bla

[GENERAL] Escaping \n

2008-03-28 Thread Terry Lee Tucker
ll SET notes = 'blah, blah, yea\nmore stuff'; How to I escape the newline embeded in the string? I've tried the advice from HINT, but have been unable to get it to work. Thanks... Thanks... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2

[GENERAL] LIMIT Question

2008-02-28 Thread Terry Lee Tucker
20060404 (Red Hat 3.4.6-9) Thanks... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 [EMAIL PROTECTED] www.turbocor

Re: [GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
n April. We needed to get replication going now. You've been a big help. Thanks... -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6987 [EMA

Re: [GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
rs oids will all have changed and you'll get errors to > that effect. Also, are there these triggers on the slony replicas? You > really need to be doing DROP TRIGGER/STORE TRIGGER operations if so. > Otherwise, very surprising things may happen. > Gee, I hadn't thought about that.

Re: [GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
On Thursday 21 February 2008 12:56, Scott Marlowe wrote: > On Thu, Feb 21, 2008 at 9:20 AM, Terry Lee Tucker <[EMAIL PROTECTED]> wrote: > > Greetings: > > > > We have been working diligently toward integrating Slony into our > > production databases. We've b

Re: [GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
Unless I get a better idea, I'm going to change the disable_triggers function to duplicate all the records in pg_trigger belonging to a given table, delete the records except for the Slony trigger, update pg_class setting reltriggers to 1, do the work, and then restore everything with

Re: [GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
On Thursday 21 February 2008 11:26, A.M. wrote: > On Feb 21, 2008, at 10:20 AM, Terry Lee Tucker wrote: > > Greetings: > > > > We have been working diligently toward integrating Slony into our > > production > > databases. We've been having trouble w

[GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
reSQL 7.4.19 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9) -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6

[GENERAL] Disable Triggers

2008-02-21 Thread Terry Lee Tucker
reSQL 7.4.19 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9) -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 404-6

Re: [sword-devel] Merry Christmas Everyone

2007-12-25 Thread Terry Lee Tucker
ibe/change your settings at above page Thanks and the same to you. Indeed, somebody should have, and indeed, you did say it. -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 3

Re: [GENERAL] Trigger Question

2007-03-14 Thread Terry Lee Tucker
ROCEDURE public.update_unit_spec_changed_date(); > > Thanks for the help. :) > > - > Jason Lee, SCJP > Senior Software Engineer > http://www.iec-okc.com <http://www.iec-okc.com/> Your trigger needs to be a BEFORE UPDATE trigger and you simply set the value of the fie

Re: [GENERAL] upgrading pl/pgsql triggers from 7.4 to 8.2

2007-01-25 Thread Terry Lee Tucker
een these two version? > > Thanks, > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster We have to do this as well so your question is of great interest to me. I hope you/we get lots of answers. -- Ter

Re: [GENERAL] printf-like format strings

2007-01-22 Thread Terry Lee Tucker
I understand the question correctly, couldn't you use pop @_ in the Perl function? -- Terry Lee Tucker Turbo's IT Manager Turbo, division of Ozburn-Hessey Logistics 2251 Jesse Jewell Pkwy NE Gainesville, GA 30501 Tel: (336) 372-6812 Fax: (336) 372-6812 Cell: (336) 363-4719 [EMAIL P

[Hplip-help] Package installation problem

2007-01-17 Thread Terry Lee
repositories was successful howver installation failed with following message- error:python-devel conflicts with python<2.4.4-1.fc6 Any suggestions would be appreciated. Terry Lee - Take Surveys. Earn Cash. Influence the Future of

Re: [GENERAL] After Trigger

2006-09-21 Thread Terry Lee Tucker
On Thursday 21 September 2006 12:44 pm, Bob Pawley <[EMAIL PROTECTED]> thus communicated: --> I am seeking wording for a procedure that will initiate a trigger only after another trigger has completed its function. In this case I want to drop a table that is created and used by the first trigger

Re: [GENERAL] Postgres Team: Thank You All

2006-09-21 Thread Terry Lee Tucker
On Wednesday 20 September 2006 09:59 pm, "Brian Maguire" <[EMAIL PROTECTED]> thus communicated: --> To all involved in this project, --> --> I justed wanted to let you know how impressed and pleased I have been with postgres over the past 5 years . The timeliness and quality of the releases ar

Re: [GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Terry Lee Tucker
Thanks for the reponse Jeff. See comments below. On Wednesday 20 September 2006 05:09 pm, Jeff Davis <[EMAIL PROTECTED]> thus communicated: --> On Wed, 2006-09-20 at 16:51 -0400, Terry Lee Tucker wrote: --> > Greetings: --> > --> > I have have a plpgsql function that c

[GENERAL] Question Regarding a Temporary Table

2006-09-20 Thread Terry Lee Tucker
Greetings: I have have a plpgsql function that creates a temporary table to facilitate some processing. Here is the code: CREATE TEMP TABLE tmp (code VARCHAR, booked INTEGER, availINTEGER, c

[GENERAL] Sharing News

2006-09-01 Thread Terry Lee Tucker
Greetings List: I just want to share with my Open Source commrads a success story. We have been working on converting a rather large and complex Logistics application from a Commercial database engine and 4GL supplied Progress Software Corp. We wrote the user interface in native X-Windows using

Re: [GENERAL] Newbie "Copy From" not working

2006-08-17 Thread Terry Lee Tucker
On Thursday 17 August 2006 03:27 pm, Walter Vaughan <[EMAIL PROTECTED]> thus communicated: > The problem is I need to load a field that is allowed to be null with > nothing and it work The above statement is not the problem you are having. We dumped and loaded a 4 gig Progress database with

Re: [GENERAL] PostgreSQL on Embeded Systems

2006-07-18 Thread Terry Lee Tucker
On Tuesday 18 July 2006 05:50 am, Adem HUR <[EMAIL PROTECTED]> thus communicated: --> Hi, --> --> I am sory for my bad English :) --> --> --> We try to use PostgreSQL on an Embeded System. --> --> Plan to use this PC/104 Module --> http://www.icop.com.tw/products_detail.asp?ProductID=106 --> --> -

Re: [GENERAL] Performance Question

2006-06-14 Thread Terry Lee Tucker
On Wednesday 14 June 2006 03:57 pm, Terry Lee Tucker <[EMAIL PROTECTED]> thus communicated: --> Hello List: --> --> I've been told that an update to a record is equivalent to a delete and insert --> operation. We have a utility written in Perl that brings into sync cer

[GENERAL] Performance Question

2006-06-14 Thread Terry Lee Tucker
Hello List: I've been told that an update to a record is equivalent to a delete and insert operation. We have a utility written in Perl that brings into sync certain elements of 50 thousand records on 8 structurally identical databases. We threw together the script and decided to just delete th

Re: [SQL] About sequences that works BAD !!!!

2006-06-14 Thread Terry Lee Tucker
On Wednesday 14 June 2006 02:02 pm, "Alexis Palma Espinosa" <[EMAIL PROTECTED]> thus communicated: --> Hello everyone: --> --> --> --> We are working with serials fields and we found a problem with then: When we insert in a table that has e unique restrict, and this makes insert fails, the seque

Re: [GENERAL] are there static variables in pgsql?

2006-06-10 Thread Terry Lee Tucker
On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <[EMAIL PROTECTED]> thus communicated: --> i am writing a recursive procedure in pl/pgsql. --> i need to check whether a condition is true in any step of recursive calls. --> --> if i get a true response in one call, i wont make other recursive cal

  1   2   3   >