Hi there,
I have dozens of tables where I need to rename one column in each of these. Is
there any generic way to do that?
I am not really familiar with the scripting possibilities of Postgres.
Thanks a lot for your help!
Stefan
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Hello,
Yes, gzip compression can be used for compressing WAL traffic during
streaming replication Following tools can be used in this regard.
SSL compression-SSL support is built in PostgreSQL. You need to ensure
you have OpenSSL library support in your PostgreSQL installation.
Also, you can comp
On Tue, Dec 17, 2013 at 1:29 PM, Stefan Schwarzer wrote:
> Hi there,
>
> I have dozens of tables where I need to rename one column in each of
> these. Is there any generic way to do that?
>
I am not really familiar with the scripting possibilities of Postgres.
>
> Thanks a lot for your help!
>
>
On Tue, Dec 17, 2013 at 2:23 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Tue, Dec 17, 2013 at 1:29 PM, Stefan Schwarzer <
> stefan.schwar...@unep.org> wrote:
>
>> Hi there,
>>
>> I have dozens of tables where I need to rename one column in each of
>> these. Is there any generic
> Hi there,
>
> I have dozens of tables where I need to rename one column in each of these.
> Is there any generic way to do that?
> I am not really familiar with the scripting possibilities of Postgres.
>
> Thanks a lot for your help!
>
> Stefan
>
>
> You can do with script. I made one on fl
Thanks Jeff, Magnus
Thanks for the suggestions.
This morning the same issue occurred, but this time it also complained that
it failed to write to pg_clog (previous days, the only failure was in
writing to pg_stat_tmp)
2013-12-17 07:13:04 GMT DETAIL: Could not write to file "pg_clog/0004" at
o
I'm using pgAgent you mentioned before. You can easily schedule recurring
tasks from within pgAdmin.
regards
mk
2013/12/11 Dev Kumkar
> Resending...
>
> On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar wrote:
>
>> Yes actually that's one alternate solution to use cron or windows
>> scheduled tasks.
> It looks like it's been morphed into TED, the TransLattice Elastic
> Database. From their FAQ[1]:
>
> TransLattice Elastic Database (TED)
>
> What’s the basis of TED? Did you write it from scratch?
>
> We started TED from PostgreSQL, a very robust, open-source,
> ACID-compliant, fully transac
Hi,
I have a really old database (5+ years old) that was backed up stored
away for a while. Now I want some data out of it.
I originally thought that if I made a backup and kept around the
original database install.exe file, I could reinstall the db & restore
the data. It looks like that i
Hi, i have a function that receives a parameter which represents days:
FUNCTION aaa_recharge_account(expdays integer)
i want to add those days to the CURRENT_DATE, but i do not know how to do
it, i have tried several ways to replace that in an expresion like:
newexpdate := CURRENT_TIMESTAMP + in
Hello,
I found some semi-recent messages related to this in 9.0.x, but wanted to
confirm for anybody searching that the same issue exists in 9.2.x. It
crashes for me with a similar backtrace as [Laurentius Purba’s][1]. The
same fix/workaround applies as well: Compile libxml2 without the “threads”
Hello all
We have a postgres server on Windows 2008 R2 used by tree services. This worked
quite for a long time (several years) but lately the Postgres service regularly
crashes
2013-12-11 14:03:10 CET LOG: Serverprozess (PID 3576) wurde durch Ausnahme
0xC043 beendet (sorry German)
I res
On Mon, Dec 16, 2013 at 3:24 AM, Hungerbühler Philipp (hune)
wrote:
>
> Hello all
>
>
>
> We have a postgres server on Windows 2008 R2 used by tree services. This
> worked quite for a long time (several years) but lately the Postgres service
> regularly crashes
>
>
>
> 2013-12-11 14:03:10 CET LO
On 12/15/2013 11:00 AM, Steve Knott wrote:
Hi,
I have a really old database (5+ years old) that was backed up stored
away for a while. Now I want some data out of it.
Not sure what you mean here? Do you mean you stored the database data
directory or did a dump and stored that?
I origina
On Tue, Dec 17, 2013 at 3:25 AM, Tim Kane wrote:
>
> Thanks Jeff, Magnus
>
> Thanks for the suggestions.
> This morning the same issue occurred, but this time it also complained
> that it failed to write to pg_clog (previous days, the only failure was in
> writing to pg_stat_tmp)
>
>
...
> 201
Hi. I've got a simple table unit_hold, with grant numbers, buildings and
counts of unit types, which I need to summarize, along with a table listing
unit types:
\d unit_hold
Table "public.unit_hold"
Column| Type | Modifiers
--+
O
n Tue, 2013-12-17 at 15:31 -0800, Ken Tanzer wrote:
>
> \d unit_hold
> Table "public.unit_hold"
> Column| Type | Modifiers
> --+---+---
> grant_number_code| character varying(10) |
> housi
On Tue, Dec 17, 2013 at 3:47 PM, rob stone wrote:
> SELECT UH.grant_number_code, UH.housing_project_code, UH. count,
> UT.description
> FROM l_unit_type UT, unit_hold UH
> WHERE UH.unit_type_code = UT.unit_type_code;
>
>
> Easier to create a view.
>
>
Thanks Rob, but that doesn't get the data in
Ken Tanzer wrote
> 1) Is there a simpler way? I'm hoping I made this unnecessarily
> cumbersome and complicated.
> 2) AFAICT, if a new unit type were to be added, I'd have to rewrite this
> query. Is there any way to avoid that?
> 3) It seems like everything after the first query, except for t
On Tue, Dec 17, 2013 at 5:11 PM, David Johnston wrote:
> 3) Limitation of SQL - explained below:
>
> The function call string that you pass in is just that, a string, the SQL
> construct within which it resides has no knowledge of its contents.
>
> SQL has the hard requirement that at the time yo
On Tue, Dec 17, 2013 at 10:42 PM, Ken Tanzer wrote:
>
> On Tue, Dec 17, 2013 at 5:11 PM, David Johnston wrote:
>>
>> 3) Limitation of SQL - explained below:
>>
>> The function call string that you pass in is just that, a string, the SQL
>> construct within which it resides has no knowledge of its
21 matches
Mail list logo
