On Wed, Jul 17, 2013 at 6:25 AM, Robert James wrote:
> Is there any way to set a variable or parameter for a query?
>
> I have a long query where a certain variable needs to be easy to
> change. I'd like to do something like:
>
> threshold = 10.3
>
> SELECT... WHERE x > $threshold... AND y * 1.3
On Wed, Jul 17, 2013 at 1:25 PM, Robert James wrote:
> Is there any way to set a variable or parameter for a query?
>
> I have a long query where a certain variable needs to be easy to
> change. I'd like to do something like:
>
> threshold = 10.3
>
> SELECT... WHERE x > $threshold... AND y * 1.3
Is there any way to set a variable or parameter for a query?
I have a long query where a certain variable needs to be easy to
change. I'd like to do something like:
threshold = 10.3
SELECT... WHERE x > $threshold... AND y * 1.3 > $threshold...
Currently, I need to do this in a scripting langua
On Wed, Jul 17, 2013 at 10:49 AM, John R Pierce wrote:
> On 7/16/2013 6:21 PM, David B Harris wrote:
>>
>> Actually though (if any PostgreSQL developers are paying attention), it
>> might be useful to have a new WAL segment-managing behaviour. With the
>> advent of the replication functionality (w
On 7/16/2013 6:21 PM, David B Harris wrote:
Actually though (if any PostgreSQL developers are paying attention), it
might be useful to have a new WAL segment-managing behaviour. With the
advent of the replication functionality (which is amazing stuff, thanks
so much), I'd expect fewer and fewer i
Yep, my tests were broken :)
Thanks :)
Though it's still possible that the backup would be fine if
wal_keep_segments is high enough - might be good if section 24.3
explicitly mentioned as much.
Actually though (if any PostgreSQL developers are paying attention), it
might be useful to have a new
On Wed Jul 17, 09:16am +0900, Michael Paquier wrote:
> On Wed, Jul 17, 2013 at 8:24 AM, David B Harris
> wrote:
> > On Wed Jul 17, 08:12am +0900, Michael Paquier wrote:
> > 4. In parallel, WAL archiving has copied all the logs from the
> > start of pg_start_backup() through to the en
On Wed, Jul 17, 2013 at 8:24 AM, David B Harris wrote:
> On Wed Jul 17, 08:12am +0900, Michael Paquier wrote:
>> On Tue, Jul 16, 2013 at 11:10 PM, David B Harris
>> wrote:
>> > 4. Copy all logs from start of pg_start_backup() through to when
>> >pg_stop_backup() finished (using the b
On Wed Jul 17, 08:12am +0900, Michael Paquier wrote:
> On Tue, Jul 16, 2013 at 11:10 PM, David B Harris
> wrote:
> > 4. Copy all logs from start of pg_start_backup() through to when
> >pg_stop_backup() finished (using the backup history file, I
> >guess, which I haven't actual
On Tue, Jul 16, 2013 at 11:10 PM, David B Harris wrote:
> Good afternoon all,
>
> I'm trying to use pg_start_backup() and pg_stop_backup() to create
> point-in-time backups. More specifically, I'm trying to use filesystem
> tools (notably rsync or an rsync-like tool) since the production machine
>
@ Gavin: Thank you ...
victoria:Programming$ sudo su postgres
postgres@victoria:/home/victoria/Programming$ psql
psql (9.2.4)
Type "help" for help.
postgres=#
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgresQL-9-2-table-query-underscores-tp5763975p5763983.html
"Victoria S." <1...@victoriasjourney.com> writes:
> IN the following example,
> development=# SELECT created_at, username FROM tweets;
> created_at | username
> ---+---
> created_at| username
On 7/16/2013 3:04 PM, Victoria S. wrote:
Hello: My first post; a Postgres newbie ...
I am teaching myself PostgresQL using a trial database, and I am having trouble
with underscores:
IN the following example,
development=# SELECT created_at, username FROM tweets;
created_at
On Wed, Jul 17, 2013 at 12:04 AM, Victoria S. <1...@victoriasjourney.com> wrote:
> Hello: My first post; a Postgres newbie ...
>
> I am teaching myself PostgresQL using a trial database, and I am having
> trouble with underscores:
>
> IN the following example,
>
> development=# SELECT created_at,
On 17/07/13 10:04, Victoria S. wrote:
Hello: My first post; a Postgres newbie ...
I am teaching myself PostgresQL using a trial database, and I am having trouble
with underscores:
IN the following example,
development=# SELECT created_at, username FROM tweets;
created_at
Hello: My first post; a Postgres newbie ...
I am teaching myself PostgresQL using a trial database, and I am having trouble
with underscores:
IN the following example,
development=# SELECT created_at, username FROM tweets;
created_at | username
Hello,
There are many ways to to upgrade postgres; but, it is not on the fly process
for major releases i.e 9.1 to 9.2, and you need to pick what suits you. Ubuntu
is using debian packages and when you use it you will have another instance
with another point as you have mentioned.
What you
On Tue, Jul 16, 2013 at 3:22 PM, AI Rumman wrote:
> Yes, I am sure that I am looking for the same table.
>
What if you analyze the table? Does the column on the stats get updated?
Have you tested such behavior against another (even dummy) table?
Luca
--
Sent via pgsql-general mailing list (pg
On Tue, Jul 16, 2013 at 5:20 PM, salah jubeh wrote:
> Have a look on
> http://www.postgresql.org/docs/9.1/static/upgrading.html
> and
> http://www.postgresql.org/docs/9.1/static/pgupgrade.html
The manual pages doesn't talk about install Postgresql from Linux
repository for example it doens't men
Hello all:
My first official message so please be gentle with me.
I'm attempting to make a new JDBC Connection Profile via my Eclipse IDE.
Apparently it's looking for the following jar in the driver wizard:
postgresql-8.1-404.jdbc2.jar.
However when I burrow down to locate the driver in my Jbo
Hello,
Have a look on
http://www.postgresql.org/docs/9.1/static/upgrading.html
and
http://www.postgresql.org/docs/9.1/static/pgupgrade.html
Regards
From: Muhammad Bashir Al-Noimi
To: "pgsql-general@postgresql.org"
Sent: Tuesday, July 16, 2013 5:08 PM
Sub
Howdy,
I want to upgrade my Postgresql server from 9.1 to 9.2 on ubuntu 12.04
but when I did the following ubuntu created a new server (on new port)
instead of upgrading Postgresql & migrating the old data!
sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install po
Good afternoon all,
I'm trying to use pg_start_backup() and pg_stop_backup() to create
point-in-time backups. More specifically, I'm trying to use filesystem
tools (notably rsync or an rsync-like tool) since the production machine
is on the other end of a (narrow, expensive) pipe. pg_dump is too
e
Yes, I am sure that I am looking for the same table.
On Tue, Jul 16, 2013 at 4:34 AM, Luca Ferrari wrote:
> On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
> wrote:
>
> > Are you sure you are the table's owner?
>
> It should not be a permission problem: it works even after a revoke
> all on
On Mon, Jul 15, 2013 at 6:43 PM, Giuseppe Broccolo
wrote:
> Are you sure you are the table's owner?
It should not be a permission problem: it works even after a revoke
all on 9.2.4. Interestingly also the autovacuum is really old. Have
you tried to do a simple vacuum? From the documentation
(ht
On Mon, Jul 15, 2013 at 7:10 PM, guxiaobo1982 wrote:
> It works with ActivePython 3.2.2.3,
>
Thanks for notifying.
> but not ActivePython 2.7.2.5.
>
>
No idea... :), I tried AP 3.2 with PG 9.2 & PG 9.3B it went fine for me.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://ragha
26 matches
Mail list logo
