Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

Would this be a relatively easy patch for a beginning contributor? If so, I wouldn't mind having a go. /Colin On 9 August 2017 at 21:37, Melvin Davidson wrote: > > > On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wed, Aug

[GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

Hi, Why does ALTER EXTENSION name OWNER TO new_owner; not exist? I have a bunch of extensions that were installed by a role that I want to drop. So I thought I would do like I do for other object types: ALTER name OWNER TO new_owner; But that doesn't exist for extensions. I also can't drop the

[GENERAL] Grants where grantor = grantee?

Hi, Looking through our database I find some cases of grants where grantor = grantee. Is this ever a useful thing to do? I can't imagine why. Thanks, Colin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] to_date conversion semantics?

Hi, I can't find in the Postgresql documentation the semantics that explains the following: co...@ruby:~/workspace/eyedb$ psql psql (8.4.4) Type help for help. colin= select to_date('731332', 'YYMMDD'); to_date 1974-02-01 (1 row) colin= Thanks, Colin

Re: [GENERAL] to_date conversion semantics?

I must be blind, I can see the syntax but I can't see where it explains the wrapping phenomenon that I'm seeing. Cheers, Colin On 20 September 2010 16:36, Adrian Klaver adrian.kla...@gmail.com wrote: On Monday 20 September 2010 7:20:29 am Colin 't Hart wrote: Hi, I can't find

Re: [GENERAL] to_date conversion semantics?

The 32nd of Undecember (!) turning into the 1st of February of the next year... instead of throwing an exception like I expect. On 20 September 2010 21:02, Adrian Klaver adrian.kla...@gmail.com wrote: On 09/20/2010 07:50 AM, Colin 't Hart wrote: I must be blind, I can see the syntax but I

[GENERAL] Monitoring object usage?

Hi, I'm trying to get a grip on a new body of code and a Postgres database that I'm working with. In particular I've been tasked with cleaning up the database. Is there a way in Postgres to enable monitoring on tables and columns to determine what's not actively being used? This would then form

Re: [GENERAL] [HACKERS] Case sensitive file names

Peter Bierman: While checking out TOT pgsql today onto an HFS+ file system (case-preserving, case-insensitive), I hit the following CVS conflict: pgsql/src/backend/utils/mb/Unicode/utf8_to_alt.map pgsql/src/backend/utils/mb/Unicode/utf8_to_ALT.map HFS+ can not store two differerent files in

Re: [GENERAL] How to make a REALLY FAST db server?

Shaun Thomas [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... - Disk: SCSI Raid 1+0 To really eek out as much speed as possible here, you'll want 10k RPM Ultra-160 Fibre Channel SCSI drives with a dedicated hardware raid controller. If have more reads than

Re: [GENERAL] MySQL's (false?) claims... (was: Re: PL/java?)

Null asks: Would you elaborate on the alternatives that you see to cross-db queries? Are you saying that it would better to duplicate the same data in several databases or put everything in one huge database or what ...? Jan Wieck [EMAIL PROTECTED] wrote in message [EMAIL

[GENERAL] Re: Help Problem mysql ????

I am having a problem activating my copy of mysql in Redhat .7.1 I get the following error message Can not connect to local Mysql server through socket /var/lib/mysql/mysql.sock I am only running a simple computer with a router firewall. Your problem is that you are using MySQL. You

[GENERAL] Re: Finding database names for overnight vacuum

Quoting Stephen Davies: I have a cron job which vacuums etc all of my databases but it does not work with 7.1.2 because of the change in structure of .../data/base. It currently says: for q in /usr/local/pgsql/data/base/*; do blaa blaa done How does one get an equivalent list of all

[GENERAL] Re: Roll Back dont roll back counters

If I design a table with SERIAL type and then try to insert few rows, but some of the rows are rolled back the roll back process does not roll back the counter status. Is there a way to do a roll back to the counter ? And I suppose if I deleted some rows you'd want all rows with higher