Re: type "xxxxxxx" does not exist

From: Micky Hulse <mickyhulse(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: type "xxxxxxx" does not exist
Date: 2017-05-20 18:46:48
Message-ID: CAKzdcN=BKPBTunq7-wB9cA7J42Vrhn5o6oYRULos5syw5u1Xig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Adrian,

On Fri, May 19, 2017 at 3:02 PM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)com> wrote:
> FYI, 9.3 is now up to 9.3.17:
> At some point, once you have gotten a handle on using Postgres, you should
> probably update. Read the Release Notes for each of the minor releases to
> see what has been fixed.

Ah, good to know! Thank you for tip! :)

> you where connecting using local, which is the socket connection.
> If you had done:
> psql -U otherusername -d database -h localhost
> it would have asked for a password(md5 auth method). If otherusername does
> not have the LOGIN attribute you would not been able to log in anyway. For
> more detailed information see:
> https://www.postgresql.org/docs/9.3/static/sql-createrole.html

Ahhh, that makes sense! Thank you for clarifying and for the linkage,
I really appreciate it!

Thanks to everyone for all of the help!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-05-21 20:56:58 Re: Call for users to talk about table partitioning
Previous Message Tom Lane 2017-05-20 16:52:38 Re: Partitioned Data and Locking