Hi,
Please find a question that didn't get an answer in the pgsql-sql &
pgsql-hackers lists. I hope I'll get an answer here.
Thanks,
Olivier
De : Olivier Leprêtre [ <mailto:o.lepre...@gmail.com>
mailto:o.lepre...@gmail.com]
Envoyé : mercredi 29 août 2
wrote:
>
>
> Am 01.09.2018 um 17:50 schrieb Olivier Leprêtre:
>> I notice that a new constraint "table1_col2_fkeyxxx" is created each
>> time the previous ALTER TABLE ADD COLUMN is called
>
> smells like a bug.
>
> Regards, Andreas
>
Forgot to include P
/01/2018 09:47 AM, Olivier Leprêtre wrote:
>> Mine is 9.6
>
> I would submit a bug report here:
>
> https://www.postgresql.org/account/login/?next=/account/submitbug/
Olivier, please do that!
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
Hi,
I would like to generate a serie of serie and didnt find how. With
generate_series. I can generate a serie
1
1
1
2
2
2
3
3
3
But how can I repeat this serie several times ?
1
1
1
2
2
2
3
3
3
1
1
1
2
2
2
3
3
3
1
1
1
2
2
2
3
3
3
Thanks for any help,
Hi,
I have a rather long pgsql procedure and I would like to detect which step
is currently executing (subscript 1,2,3
). Due to transaction isolation,
its not possible to make it write in a table or get nexval from a sequence
because values become available only after the complete end of the
p
.
Olivier
-Message d'origine-
De : Julien Rouhaud
Envoyé : jeudi 30 juillet 2020 12:19
À : Adrian Klaver
Cc : Olivier Leprêtre ; pgsql-general
Objet : Re: Track pgsql steps
On Wed, Jul 29, 2020 at 7:58 PM Adrian Klaver wrote:
>
> On 7/29/20 8:44 AM, Olivier Leprêtre wrote:
>
Hi,
We have a database which is getting very slow. Pgadmin 3 is alos very slow,
requiring more than 2 minutes to refresh the list of schemas
Machine is a windows server 2016 with Intel Xeon 2,4Ghz, 24 Go Ram. Postgres
9.6/32 bits
Database contains 4000 schemas, each having 164 tables, 48 ind
Hi,
Im surprised by this behavior I noticed in pgadmin3 and postgresql 9.6
Suppose those two tables
create table test1 (v1 text)
create table test2 (v2 text)
insert into test1 (v1) values ('A')
insert into test2 (v2) values ('B')
query select v1 from test2 return v2 column doesnt exi
