You can build PG based on the source code of the latest release. Or you can install PG9.2.1 via the installer. All you need do is build it or download it and install.See:installer: http://www.enterprisedb.com/products-services-training/pgdownload#windowssourcecode: http://www.postgresql.org/ftp/so
On 3 November 2012 23:10, Thalis Kalfigkopoulos wrote:
> How is that three levels and not two? Read Uncommitted and Read Commited are
> the same. And Repeatable Reads don't allow phantom reads thus making them
> effectively the same as Serializable. No?
They're only equivalent to the extent that
On 04/11/12 12:08, Bob Pawley wrote:
Hi
I have an unused computer which I am considering turning into a server
to run my Postgresql database.
Is this even possible to do?
If so, can someone suggest an open source server that is relatively
easy to set up? Windows based would be ideal.
Bob
If y
On Sat, Nov 3, 2012 at 8:08 PM, Bob Pawley wrote:
> Hi
>
> I have an unused computer which I am considering turning into a server to
> run my Postgresql database.
>
> Is this even possible to do?
>
> If so, can someone suggest an open source server that is relatively easy
> to set up? Windows b
Hi all.
>From the current docs (Ch.13 on Concurreny Control):
"In PostgreSQL, you can request any of the four standard transaction
isolation levels. But internally, there are only three distinct isolation
levels, which correspond to the levels Read Committed, Repeatable Read, and
Serializable. Wh
Hi
I have an unused computer which I am considering turning into a server to run
my Postgresql database.
Is this even possible to do?
If so, can someone suggest an open source server that is relatively easy to set
up? Windows based would be ideal.
Bob
On Thursday, November 01, 2012 05:40:23 PM Alban Hertroys wrote:
> On 1 November 2012 17:19, Shaun Thomas wrote:
> > On 11/01/2012 10:28 AM, Kevin Grittner wrote:
> > Based on my past experience with 8.2, and my understanding of 9.1, I
> > moved autovacuum_freeze_max_age up to 650M so we'd never g
Hello,
try something like
WITH lastreceipt as
(SELECT DISTINCT ON (acc.cname) acc.cname, acc.date, acc.amount
FROM accounts acc
ORDER BY acc.date DESC)
UPDATE customer_master
SET lastreceiptdate = lr.date
lastreceiptamt = lr.amount
FROM lastreceipt lr
WHERE cname = lr.cname
(Haven't tested
Fine, thanks for your answer, I'll then use a subnet IP in my pg_hba.conf.
Because, as far as i understand well your answer, the address terminating
with 18cf might change after a computer restart...
Also on the linux side i had to do something to fix IPV6 address otherwise
it was changing at ever
On Sat, Nov 03, 2012 at 09:11:51AM +0100, Yvon Thoraval wrote:
> I'm using to computers :
> - a laptop under Xubuntu 12.04 with PostgreSQL 9.1
> - a desktop under Mac OS X Mountain Lion with PostgreSQL 9.2
>
> After the switch to Mountain Lion, i had a small prob connecting to a
> database on my l
I'm using to computers :
- a laptop under Xubuntu 12.04 with PostgreSQL 9.1
- a desktop under Mac OS X Mountain Lion with PostgreSQL 9.2
After the switch to Mountain Lion, i had a small prob connecting to a
database on my laptop.
Usually when, from the laptop, i connect to the deskop which arn't
hello,
i have two tables
customer_master
> cname
> lastreceiptdate
> lastreceiptamt
accounts
> cname
> date
> amount
i need help in constructing a single update query. where the customer_master
table is updated with the latest receipt date and receipt amount for a single
customer code (cnam
12 matches
Mail list logo
