El 11/11/17 a las 0:48, DrakoRod escribió:
Oh!!
Jose Maria TJ wrote
You're wrong, that are gcc versions, not OS versions.
For example in my CentOS 6 Box
cat /etc/redhat-release
CentOS release 6.9 (Final)
gcc -v
[...trimmed...]
gcc versión 4.4.7 20120313 (Red Hat 4.4.7-18) (GCC)
You're righ
El 8/11/17 a las 20:28, DrakoRod escribió:
> Hi everyone!
>
> I want to develop a installer for many purposes, but i have a question, when
> I review the currently PostgreSQL versions, I see Ubuntu 5 or RHEL 4 , when
> currently we have Ubuntu 16 or RHEL 7. for example:
>
> /PostgreSQL 9.6.0 on x
You have the open source version installed. Now where it was installed from
is a different story.
EnterpriseDB Advanced Server will look like:
EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-16), 64-bit
T
On Fri, Jul 7, 2017 at 7:04 AM, Krithika
Certainly Postgres is capable of handling this volume just fine. Throw in
some partition rotation handling and you have a solution.
If you want to play with something different, check out Graylog, which is
backed by Elasticsearch. A bit more work to set up than a single Postgres
table, but it has b
El 7/7/16 a las 0:14, Devrim Gündüz escribió:
Hi,
Fedora packages have an executable (not sure about its name, but check
a package called postgresql-upgrade or so). That will help you to
finish the upgrade process.
Regards, Devrim
Hello
Yes, the package is called postgresql-upgrade, and
El 13/06/15 a las 10:58, Mephysto escribió:
Thank you Holger,
any suggestions?
I'm using the same settings used for ssh connection to vm, and these
work correctly
Bye.
Meph
Hello
Are PosgreSQL listening in the IP of the machine with (for example):
listen_addresses = '*'# wh
I can't offer a whole lot of detail at this point, but I experienced a
pretty bad caching issue about 2 years ago using XFS.
We were migrating a 1TB+ Oracle database to EDB's Advanced server 9.1
(Close enough for this discussion). I normally use ext4, but decided to try
XFS for this build-out.
Thi
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
El 27/08/2011, a las 02:40, John Moran escribió:
> I'm wondering how it's possible to upgrade my fedora system's pg to
> the latest minor release. I'm using the PGDG RPMs. A "yum update"
> leaves me on version 9.0.2. I'd expect it to put me on 9.0.4. What am
> I doing wrong? I installed from pgdg
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
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
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
something like
a "user area" in the underlying tables that define a column that could be
safely utilized for this purpose?
I'm using PostgreSQL 8.3 on Red Hat.
TIA
--
Terry Tucker
Office: 336-372-6812
I have no idea what type of storage that you are using, but we utilize
NetApp storage and use Flexclones to create multiple read-only copies of a
"master" database. The flexclone takes seconds to configure and essentially
only consume delta space. Works great so far.
Terry
On Wed, Ma
thing
RETURN NEXT v_row;
END LOOP;
END;
$$ LANGUAGE plpgsql;
-- so I would like the call to be something like
select * from myanalyze(select * funct1());
or
select * from myanalyze(select * funct2());
______
Terry Kop
Database Developer
Clear Capital
o
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
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
Thanks Tom. I wasn't aware - I did do a quick search at the beginning but
didn't turn this up. I'll post over on the hackers list.
Terry
On Sat, Oct 16, 2010 at 7:44 AM, Tom Lane wrote:
> Terry Laurenzo writes:
> > I'm a long-time postgres user but have never
(http://bsonspec.org/) as
defined for MongoDB. I've architected it so that it should play naturally
with the postgres type system, but there are still some cast functions that
need to be implemented.
Anyway, feedback is appreciated - good, bad or otherwise.
Thanks.
Terry
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)
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
,
Sergey Konoplev escribió:
Hi,
Just wrap your expression with another SELECT and operate with the aliases like
SELECT *, min_caudal + max_caudal AS diferencia FROM (
...your expression...
)
2010/8/9 José María Terry Jiménez :
Hello
Yesterday a list user solved me a problem with a sententence
Hello
Yesterday a list user solved me a problem with a sententence with two
subqueries. The solution was this:
SELECT remota_id,min(hora),max(hora), (SELECT caudal FROM historicos
WHERE remota_id=ooo.remota_id AND hora=min(ooo.hora)) as min_caudal,
(SELECT caudal FROM historicos WHERE remota
El 08/08/10 21:49, Edoardo Panfili escribió:
On 08/08/10 20.47, Jose Maria Terry wrote:
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I
Hello all,
I need to run a query on a table that holds logged data from several
water flow meters.
I need the first and last values (with their associated time) for every
logger in a time range.
I've tried this that returns the min and max time in the desired range
for every logger, but i
will give you a measurement of your expected performance that
is much more meaningful then my ramble above. :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bill Thoen wrote:
I
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
On Thu, Mar 4, 2010 at 1:44 PM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
>> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>>> On 4 March 2010 17:26, Terry wrote:
>>>>
>>>> I have 4 tables: dsclient_logs,backup_sets,dsbox,custo
On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe wrote:
> On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote:
>> Terry writes:
>>> I am somewhat confused. My app is detecting it as a serial data type
>>> but describing the table shows that its an integer. What am I
&
On Thu, Mar 4, 2010 at 11:43 AM, Terry wrote:
> On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
>> On 4 March 2010 17:26, Terry wrote:
>>>
>>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>>> query that will return all rows fr
On Thu, Mar 4, 2010 at 11:33 AM, Thom Brown wrote:
> On 4 March 2010 17:26, Terry wrote:
>>
>> I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
>> query that will return all rows from dsclient_logs, insert two columns
>> from the customer
I have 4 tables: dsclient_logs,backup_sets,dsbox,customer. I want a
query that will return all rows from dsclient_logs, insert two columns
from the customer table, and one column from backup_sets. The
relation is this:
dsclient_logs.userid = dsbox.dsbox_snum AND backup_sets.box_id =
dsbox.box_id
2010/3/3 Terry :
> 2010/3/3 Grzegorz Jaśkiewicz :
>> select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY
>> error, ev_text;
>>
>> you can add 'HAVING count(*) > X'; , if you want to see only those with
>> count above X, etc.
>
2010/3/3 Grzegorz Jaśkiewicz :
> select count(*) AS count, error, ev_text FROM clients_event_log GROUP BY
> error, ev_text;
>
> you can add 'HAVING count(*) > X'; , if you want to see only those with
> count above X, etc.
>
>
> --
> GJ
>
I was just about to reply to the group. Would this work too
Hello all,
I am trying to do the following query but I would like to know how
many rows were deduplicated in the process:
psql -d foo -c 'SELECT DISTINCT ON (error) error,ev_text FROM
clients_event_log' -o fullfoo
For example, I would want the output to be the following where count
is the numbe
On Sun, Feb 28, 2010 at 10:23 PM, Terry wrote:
> On Sun, Feb 28, 2010 at 7:12 PM, John R Pierce wrote:
>> Terry wrote:
>>>
>>> One more question. This is a pretty decent sized table. It is
>>> estimated to be 19,038,200 rows. That said, should I see resu
On Sun, Feb 28, 2010 at 7:12 PM, John R Pierce wrote:
> Terry wrote:
>>
>> One more question. This is a pretty decent sized table. It is
>> estimated to be 19,038,200 rows. That said, should I see results
>> immediately pouring into the destination table while
On Sun, Feb 28, 2010 at 6:29 PM, John R Pierce wrote:
> Szymon Guz wrote:
>>
>> Different doesn't mean that the id should be greater or lower, rather
>> should be different. I'd rather do something like:
>
> indeed, my code assumed that records were only INSERT'd into table1 and
> never UPDATE or
On Sun, Feb 28, 2010 at 6:29 PM, John R Pierce wrote:
> Szymon Guz wrote:
>>
>> Different doesn't mean that the id should be greater or lower, rather
>> should be different. I'd rather do something like:
>
> indeed, my code assumed that records were only INSERT'd into table1 and
> never UPDATE or
Hello,
I am looking for a way to copy all the data from one table to another
on a regular basis, every 5 minutes let's say.
INSERT INTO table2 SELECT * FROM table1;
The above will copy all the data as is and insert it into the other
table. What happens if I rerun it again? Will it just append
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe wrote:
> On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote:
>> On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
>>> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
>>> wrote:
>>>> On Wed, Feb 24, 2010 at 8:50 PM, T
On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote:
> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe
> wrote:
>> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>>> Hello,
>>>
>>> I have an application that is doing something stupid in that it is
>>> t
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe wrote:
> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote:
>> Hello,
>>
>> I have an application that is doing something stupid in that it is
>> tacking on its own order clause at the end of the statement I am
>> p
Hello,
I have an application that is doing something stupid in that it is
tacking on its own order clause at the end of the statement I am
providing.
For example, I am putting this statement in:
select
ev_id,type,ev_time,category,error,ev_text,userid,ex_long,client_ex_long,ex_text
from clients_e
On Tue, Jan 19, 2010 at 12:06 AM, Johan Nel wrote:
> Terry wrote:
>>
>> Hello,
>>
>> Sorry for the poor subject. Not sure how to describe what I need
>> here. I have an application that logs to a single table in pgsql.
>> In order for me to get into ou
On Mon, Jan 18, 2010 at 5:07 PM, Terry wrote:
> On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
>> On 1/18/2010 4:08 PM, Terry wrote:
>>>
>>> Hello,
>>>
>>> Sorry for the poor subject. Not sure how to describe what I need
>>> here. I ha
On Mon, Jan 18, 2010 at 4:48 PM, Andy Colson wrote:
> On 1/18/2010 4:08 PM, Terry wrote:
>>
>> Hello,
>>
>> Sorry for the poor subject. Not sure how to describe what I need
>> here. I have an application that logs to a single table in pgsql.
>> In order f
Hello,
Sorry for the poor subject. Not sure how to describe what I need
here. I have an application that logs to a single table in pgsql.
In order for me to get into our log management, I need to dump it out
to a file on a periodic basis to get new logs. I am not sure how to
tackle this. I tho
glaucomag escribió:
Hi, I've a problem with pgadmin. If I access to database with user X
and I save password, when I access to database from shell (psql)
password is not required. Of course pg_hba.conf is:
local database X md5
If I don't save password in pgadmin, it's ok (psql required password
Alban Hertroys escribió:
On 6 Dec 2009, at 4:13, Scott Marlowe wrote:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncati
Scott Marlowe escribió:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to minutes
this works for me:
select distinct date_
Richard Broersma escribió:
On Sat, Dec 5, 2009 at 11:11 AM, Jose Maria Terry Jimenez
wrote:
select distinct date_trunc('minute',"timestamp") as "timestamp" from
historico order by "timestamp";
Notice the example from the documentation:
http:/
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to
minutes this works for me:
select distinct date_trunc('minute',"timestamp") as "timestamp" from
historico order by "timestamp";
Getting times "norm
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
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
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
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
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
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
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
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
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
the above O/S requirement.
Geoff M
Running 3 RHEL4 boxes in an Oracle RAC cluster, with web interfaces
(RHEL5/Apache/php) on separate VMWare ESX gear.
Sybase ASE should be on your list too.
Terry Dykstra
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
and then kill a specific bad query?
Maybe this is not missing functionality, it can do it and I just don't
know how. Anybody want to wisen me up? :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Home
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
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
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
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:
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
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
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have
Raymond O'Donnell escribió:
On 12/06/2008 18:21, Terry Yapt wrote:
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.
Today I have tried to install 8.3.3 and I have
I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success several
times on the same workstation.
Today I have tried to install 8.3.3 and I have stuck on the same error:
===
Service 'PostgreSQL Database Server
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
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
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
; 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,
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
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
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
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
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
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
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
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
" 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
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
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
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
> 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
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
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
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
#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
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
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
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
give you what you want
if you want to see all SQL statements.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Dave Potts wrote:
I am using a 3rd front end to generate postgres requests
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
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
1 - 100 of 305 matches
Mail list logo