Re: [GENERAL] Question about permissions on database.

2012-09-23 Thread Condor
On 2012-09-22 23:47, Ryan Kelly wrote: On Sat, Sep 22, 2012 at 11:35:00PM +0300, Condor wrote: Hello, I wanna ask: is there a short way to giver permission to one user to select/insert (all privileges) on whole database ? Im create a user and try to give him all permission on existing database,

Re: [GENERAL] Using psql -f to load a UTF8 file

2012-09-23 Thread Jasen Betts
On 2012-09-21, Craig Ringer ring...@ringerc.id.au wrote: I strongly disagree. The BOM provides a useful and standard way to differentiate UTF-8 encoded text files what is stopping non utf8 files from starting with something that looks like a BOM? -- ⚂⚃ 100% natural -- Sent via

Re: [GENERAL] RFE: Column aliases in WHERE clauses

2012-09-23 Thread Rafal Pietrak
On Sat, 2012-09-22 at 20:00 -0700, Chris Travers wrote: On Sat, Sep 22, 2012 at 12:23 AM, Jasen Betts ja...@xnet.co.nz wrote: On 2012-09-18, Rafal Pietrak ra...@zorro.isa-geek.com wrote: [-] could be written by user as (3): SELECT 1/x AS inverse

[GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread a...@hsk.hk
Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) below, a) * Restarting PostgreSQL 9.2 database server ...done. b) psql (8.4.13) Type help

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread Condor
On 2012-09-23 14:47, a...@hsk.hk wrote: Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) below, a) * Restarting PostgreSQL 9.2 database server

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread Adrian Klaver
On 09/23/2012 04:47 AM, a...@hsk.hk wrote: Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) below, a) * Restarting PostgreSQL 9.2 database

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread Martin Collins
On 23/09/12 11:48, Adrian Klaver wrote: On 09/23/2012 04:47 AM, a...@hsk.hk wrote: Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) below, My

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread Raymond O'Donnell
On 23/09/2012 19:31, Martin Collins wrote: On 23/09/12 11:48, Adrian Klaver wrote: On 09/23/2012 04:47 AM, a...@hsk.hk wrote: Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version,

[GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
Hi all, I just migrated to 9.2 and observing stange thing. While restoring 9.2 database to another server's empty database I'm getting several errors while restoring views: pg_restore: creating RULE _RETURN pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)]

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
On Mon, Sep 24, 2012 at 12:44 AM, Paul Ramsey pram...@opengeo.org wrote: Try just loading the 1.5 dump directly into the 2.0 database without the filtering step. It will be immensely noisy with lots of errors and warnings, but with luck you should find your data is there waiting for you when

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

2012-09-23 Thread a...@hsk.hk
Hi thanks, I ran ps and found there were TWO postgresql postgres 1124 0.0 0.1 45116 5480 ?SSep23 0:01 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf postgres 1133 0.0 0.0 45116 1984 ?

[GENERAL] Fetching json: best way to do this?

2012-09-23 Thread Joe Van Dyk
Say I want output similar to this: { id:73, name:LolShirt 1, uuid:afe3526818, thumbnails:[ { filename:file.png, width:200, height:199, id:79 }, { filename:file.png, width:200, height:199, id:79

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Tom Lane
=?UTF-8?Q?Gra=C5=BEvydas_Valeika?= gvale...@gmail.com writes: I just migrated to 9.2 and observing stange thing. While restoring 9.2 database to another server's empty database I'm getting several errors while restoring views: pg_restore: creating RULE _RETURN pg_restore: [archiver (db)]

Re: [GENERAL] foreign key from array element

2012-09-23 Thread Rafal Pietrak
On Tue, 2012-09-18 at 09:37 +0200, Albe Laurenz wrote: Rafal Pietrak wrote: On Mon, 2012-09-17 at 14:31 -0500, Merlin Moncure wrote: On Mon, Sep 17, 2012 at 7:24 AM, Rafal Pietrak ra...@zorro.isa-geek.com wrote: [] Who can review that patch? You :^) I did what I