initial stab at the ALTER TABLE lasted 14 hours or so before I cancelled
suggests that it was working on the child tables?
On Sat, Apr 14, 2012 at 6:29 AM, Alban Hertroys haram...@gmail.com wrote:
On 13 Apr 2012, at 18:43, Jeff Adams wrote:
Thanks for the ideas Steve. I am actually working
Greetings,
I have a very large table (approximately 1 billion records). I need to
change a field's data type from integer to bigint. I started up an ALTER
TABLE approach yesterday and it is still running (trying to rewrite the
whole table?). I remember seeing mention of being able to do this in
so i can? if so, how do i go about? i should mention that, while i dabble
in postgres dba activity, it is not my day job...
On Fri, Apr 13, 2012 at 11:27 AM, Tom Lane t...@sss.pgh.pa.us wrote:
I wrote:
No, that is an actual on-disk change (making the field physically
wider), so it's going
tables is inherited, so I figured I needed to alter the column in the
parent table. Does this information point towards an optimal solution?
Thanks again...
On Fri, Apr 13, 2012 at 12:31 PM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
On 04/13/2012 08:30 AM, Jeff Adams wrote:
so i can
[mailto:adam.corn...@gmail.com]
Sent: Wednesday, October 19, 2011 6:51 PM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Date Range Using Months and Days Only
On Wed, Oct 19, 2011 at 12:40 PM, Jeff Adams jeff.ad...@noaa.gov wrote:
Greetings,
I have to write a query on a fairly large
:37 AM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Date Range Using Months and Days Only
On Thu, Oct 20, 2011 at 8:42 AM, Jeff Adams jeff.ad...@noaa.gov wrote:
Thanks for the reply and assistance. I share your concern that the approach
may be slow. I am not adverse
Greetings,
I have to write a query on a fairly large table of data (100 million rows)
where I need to check to see if a date (epoch) falls between a range of
values. The catch is that the range is defined only by month and day values.
For example the record containing the epoch value will be
...@gmail.com] On Behalf Of Chris Curvey
Sent: Saturday, October 01, 2011 10:55 PM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] SQL Help - Finding Next Lowest Value of Current Row
Value
On Sat, Oct 1, 2011 at 5:30 PM, Jeff Adams jeff.ad...@noaa.gov wrote:
Greetings,
I have
Greetings,
I have a large table (~19 million records). Records contains a field
identifying a vessel and a field containing an time (epoch). Using the
current rows vessel and time values, I need to be able to find the next
lowest time value for the vessel and use it to compute how much time has
Thanks for the response Laurenz. I will give it a go...
Jeff
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Monday, September 26, 2011 7:50 AM
To: Jeff Adams *EXTERN*; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Sending Results From One Function
Greetings,
I need to send the results (SETOF RECORDS) from one function into another
function, to produce another result (SETOF RECORDS). I am not quite sure how
to do get this done. The first function filters a large table down a more
manageable dataset. I want to send the results of this first
Thanks Guillaume and Richard. I removed the server from the host name field and
entered only the IP address. I then edited my pg_hba.conf, adding the IP
address and it worked! I appreciate all of your help.
Jeff
Thanks for the response Richard. I have tried to connect via pgAdminIII.
When
I am trying to connect to a workstation running postgres from another
computer on the network. I have postgres installed on both machines. When I
go to connect to the workstation, everything appears to happen correctly,
however, the server connection shows the databases on the localhost, not the
) 713-0376
email: jeff.ad...@noaa.gov
-Original Message-
From: Richard Huxton [mailto:d...@archonet.com]
Sent: Thursday, September 15, 2011 2:50 PM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Remote connection shows localhost databases
On 15/09/11 17:30, Jeff
14 matches
Mail list logo
