On 8/2/19 12:45 PM, Julie Nishimura wrote:
Thanks for your replies.
1) We use streaming replication, and due to hardware limitation, we
cannot add more drives to the existing host. That is why we thought by
breaking the existing streaming replication (from a->b), instead of
currently identica
Thanks Tom!
> "Vladimir" == Vladimir Soldatov writes:
Vladimir> Hi guys,
Vladimir> I am new to PostgreSQL, so sorry for maybe stupid question. I
Vladimir> am working on some application implementing Frontend/Backend
Vladimir> PG protocol and one of the goals - having only "admin" users
Vladimir> cr
Thanks for your replies.
1) We use streaming replication, and due to hardware limitation, we cannot add
more drives to the existing host. That is why we thought by breaking the
existing streaming replication (from a->b), instead of currently identical
standby (b), we can introduce twice larger
Bharanee Rathna writes:
> I'm encountering an issue altering multiple column types in a single ALTER
> TABLE
Yeah, this is a regression in the May batch of minor releases :-(.
It's fixed for next week's releases.
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=f946a4091
Thanks for confirming, so I know I'm not going crazy :)
FWIW, it works on 10.3 to 10.8 (I think) and looks like a regression.
psql (10.3 (Debian 10.3-2))
Type "help" for help.
test=# create table users(id serial primary key, name varchar(255), email
varchar(255), age int);
CREATE TABLE
Time: 26.
Hi guys,
I am new to PostgreSQL, so sorry for maybe stupid question. I am working on
some application implementing Frontend/Backend PG protocol and one of the
goals - having only "admin" users credentials (like postgres user) be able
to retrieve enough information from PG server (for example, from
Dear Members!
Many times I need to type same expressions in SQL queries.
select [exprs] from anytable
where [exprs] > 0
order by [exprs]
Sometimes I solve this with subquery, or "WITH" query, because it is easier
to define value once, and use it more times...
select * from (
select [exprs] as e
On Fri, Aug 2, 2019 at 10:06 AM Bharanee Rathna wrote:
>
> Hi Luca,
>
> testing this using docker images. I can replicate it with 10.9-alpine
>
> bash-5.0# psql -h127.0.0.1 -Upostgres test
> psql (10.9)
> Type "help" for help.
>
> test=# \d users
> Table "public
> >> What repo are you getting the packages from?
>
> Repo looks like PostgreSQL apt repository https://apt.postgresql.org.
.../bionic-pgdg.main
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>
Hi Luca,
testing this using docker images. I can replicate it with 10.9-alpine
bash-5.0# psql -h127.0.0.1 -Upostgres test
psql (10.9)
Type "help" for help.
test=# \d users
Table "public.users"
Column | Type | Collation | Nullable |
Default
On Fri, Aug 2, 2019 at 9:39 AM Bharanee Rathna wrote:
>
> Hi Luca,
>
> I've tried it with a different client and Postgres 10.9, no luck
>
> psql (10.3, server 10.9)
I've fired up a 12beta2 and it works, either with psql 12 or psql 11.4 on linux.
What if you run the statements within another clien
12 matches
Mail list logo
