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 9, 2017 at 12:26 PM, M
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
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:
http://www.postgresql.org/ma
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 wrote:
> On 09/20/2010 07:50 AM, Colin 't Hart wrote:
>>
>> I must be blind, I can see the syntax but
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 wrote:
> On Monday 20 September 2010 7:20:29 am Colin 't Hart wrote:
> > Hi,
> >
>
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
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
August Zajonc:
> I tend to follow the mailing list through news.postgresql.org, and it
seems
> like all the -hackers messages are ending up in the .general group rather
> than .hackers.
I also follow the mailing list(s) through news.postgresql.org and now that
you mention it ...
It hasn't alway
Tatsuo Ishii:
> As you can see, psql reconnect as any user if the password is same as
> foo. Of course this is due to the careless password setting, but I
> think it's better to prompt ANY TIME the user tries to switch to
> another user. Comments?
Does postgres have a concept of a 'root' user? T
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 file
"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 rea
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 PROTEC
> 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.
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 lis
> 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
15 matches
Mail list logo
