Re: [GENERAL] Need to run a job in PgAdmin-III

2012-09-23 Thread John R Pierce
On 09/23/12 11:24 PM, pavithra wrote: I have pgAdmin-III. It has version 1.12.3. I would like to run a job. I have schedule an SQL Job. But when i run there is no output. Can anybody let me know what needs to be done?. Also, Can any one tell, where i need to look for the errors, when i run a jo

[GENERAL] Need to run a job in PgAdmin-III

2012-09-23 Thread pavithra
I have pgAdmin-III.It has version 1.12.3.I would like to run a job. I have schedule an SQL Job. But when i run there is no output.Can anybody let me know what needs to be done?.Also, Can any one tell, where i need to look for the errors, when i run a job?. -- View this message in context: http:

Re: [GENERAL] foreign key from array element

2012-09-23 Thread Gabriele Bartolini
Hi Rafal, Il 24/09/12 07:54, Rafal Pietrak ha scritto: I did what I could - the review is on the hackers list. Thanks! That's much appreciated. Should I do anything else to finilize this review, like "linking" it to the pending patch? somehow? -R You should update the commitfest.postgresq

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 > > > wrote: [] > > > > Who can review that patch? > > You :^) > I did what I could - the r

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Tom Lane
=?UTF-8?Q?Gra=C5=BEvydas_Valeika?= 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)] Error while PROC

[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, "h

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 ?S

Re: [GENERAL] Strange dump/restore effect

2012-09-23 Thread Gražvydas Valeika
On Mon, Sep 24, 2012 at 12:44 AM, Paul Ramsey 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 it's done. > > I

[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)] Error

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 >>> postgresq

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 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 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 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 .

[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] 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 > wrote: > On 2012-09-18, Rafal Pietrak wrote: [-] > > could be written by user as (3): > > SELECT 1/x AS inverse FROM data WHERE x <> 0 AND >

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

2012-09-23 Thread Jasen Betts
On 2012-09-21, Craig Ringer 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 pgsql-general mailing list