Re: [GENERAL] permission denied for schema topology

- I think it will help me communicate with them to resolve the problem now fully. Cheers, Iain Em Qui, 2014-09-11 às 10:05 -0400, Tom Lane escreveu: > Iain Mott writes: > > Here's what happens (the important error messages are in English): > > > [~]# pg_dump mydat

Re: [GENERAL] permission denied for schema topology

y have been installed without using postgres > CREAtE EXTENSION (old version of postgis). > > > > Cheers, > Rémi-C > > > 2014-09-11 13:12 GMT+02:00 Iain Mott : > Thanks Rémi-C for the quick reply. By coincidence my site does > in

Re: [GENERAL] permission denied for schema topology

4-09-11 às 12:53 +0200, Rémi Cura escreveu: > Hey, > > if you are using postgis and postgis_topology, > there are specific backup/restore process. > Cheers, > Rémi-C > > > 2014-09-11 12:49 GMT+02:00 Iain Mott : > Hello, > > The server fo

[GENERAL] permission denied for schema topology

Hello, The server for my websites was recently changed and upgraded. I have ssh access to the server and since the upgrade I am no longer able to use "pg_dump" to perform scripted backups. I've written to the site's support services, but until now, they've not been able to help (they've responded

Re: [GENERAL] pg_upgrade only to 9.0 ?

On 10 May 2011, at 01:16, Scott Marlowe wrote: > On Mon, May 9, 2011 at 6:10 PM, Iain Barnett wrote: >> Hi, >> >> I'm currently running 8.4.4. I downloaded the source for 9.0.4 and installed >> it, and then installed pg_upgrade and ran it, and got the followi

[GENERAL] pg_upgrade only to 9.0 ?

4 patch points above, but still, so I go to the source directory to download 9.0 and it isn't listed. Could anyone tell me how I'm supposed to get this to work please? I'd be really grateful. Regards, Iain -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Locale and UTF8 for template1 in 8.4.4

On 6 May 2011, at 16:19, Alan Hodgson wrote: > On May 6, 2011, Iain Barnett wrote: > > Would anyone be able to point out to me how I can get the template1 > > database to be utf8 and en_GB? (or US, I'm not *that* fussed) > Use the --encoding and --locale options to initd

[GENERAL] Locale and UTF8 for template1 in 8.4.4

8 Ok, so I can't change the template1 database that way, but I'm concerned that it says the locale name is invalid. I got the list of locales from here http://www.postgresql.org/docs/8.4/static/multibyte.html Would anyone be able to point out to me how I can get the template1 database

[GENERAL] how to create a new composite type using already existing composite types

price numeric, sizeinteger ); but it would be handy if I could reuse inventory_item instead of having to retype the whole lot. I can't work out or find the right syntax, can anyone show me how? Any help would be much appreciated. Regards Iain

[GENERAL] How to call SETOF function?

values ( 'row a' ); insert into anything ( second ) values ( 'row b' ); insert into anything ( second ) values ( 'row c' ); CREATE OR REPLACE FUNCTION anything_all_udf( ) RETURNS setof anything AS $$ BEGIN select * from anything; END; $$ LANGUAGE plpgsql; select * from anything_all_udf( ); Regards, Iain

Re: [GENERAL] variables in ad hoc queries

then that's ok, I'll just write full blown test functions from the start. Regards, Iain -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] variables in ad hoc queries

If I have a function that returns an integer, how can I use the following code outside of a function block? declare _myint int; begin _myint := myfunction( ); end; or is it just not possible? Iain -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] INSERT... RETURNING with a function

-STATEMENTS-SQL-ONEROW -- Adrian Klaver akla...@comcast.net Thankyou, that worked. Much appreciated. regards Iain

[GENERAL] INSERT... RETURNING with a function

ement I'm not sure what I need to do to catch the return value as I've tried a few different combinations and nothing has worked for me so far. The Insert statement as it is below but outside of a function works and returns the id. Any input is much appreciated. I'm runn

Re: [GENERAL] Mass Update

ERROR: more than one row returned by a subquery used as an expression. Dont quite know what is going wrong. Thanks alot Iain ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail c

[GENERAL] Mass Update

table column id with the id held in temp where the geom_id column matches the old_id column. I would really appreciate some help on this. I just cant seem to get it right. Thanks Iain ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [GENERAL] [PERFORM] HELP speed up my Postgres

SQL: update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select mobile_num from LOADED_MOBILE_NUMBERS) Could you try using UPDATE ... FROM (SELECT ) AS .. style syntax? About 20 minutes ago, I changed a 8 minute update to an most instant by doing that. re