Re: type SERIAL in C host-struct

El día sábado, noviembre 09, 2019 a las 07:45:31p. m. +0100, Matthias Apitz escribió: > Thanks for the feedback. Client and server run both on the same Linux > host. I found also the debug log of ESQL/C i.e. how to enable it with > > ECPGdebug(int on, FILE *stream); > > The resulting log is

Re: here does postgres take its timezone information from?

On Wed, Nov 13, 2019 at 3:40 AM Palle Girgensohn wrote: > The decision to use postgresql's tzdata is quite old. It was based on the > assumption that postgres is updated more frequently than the operating > system, and that for that reason it was better to use postgresql's tzdata, > since it

Sv: DELETE Query Hang

På tirsdag 12. november 2019 kl. 23:47:18, skrev DrakoRod < drakofla...@hotmail.com >: Hi folks! I Have a question, in a database are a table with many files (bytea) stored (I support this database a don't design it), but we need delete many rows (38000 rows

Re: DELETE Query Hang

> On Nov 12, 2019, at 4:01 PM, DrakoRod wrote: > > I understand, yep is a 9.5 version, Can I use query like this to execute > smaller batches?: > > DELETE FROM my_table > WHERE id IN ( >SELECT id >FROM logtable >LIMIT 10 > ); > > Thanks > I think you still want to qualify as

Re: DELETE Query Hang

> On Nov 12, 2019, at 3:47 PM, DrakoRod wrote: > > Hi folks! > > I Have a question, in a database are a table with many files (bytea) stored > (I support this database a don't design it), but we need delete many rows > (38000 rows approx), but I when execute query: > > BEGIN; > ALTER

DELETE Query Hang

Hi folks! I Have a question, in a database are a table with many files (bytea) stored (I support this database a don't design it), but we need delete many rows (38000 rows approx), but I when execute query: BEGIN; ALTER TABLE my_file_table DISABLE TRIGGER ALL; DELETE FROM my_file_table WHERE

Re: here does postgres take its timezone information from?

> 6 nov. 2019 kl. 03:03 skrev Thomas Munro : > > On Wed, Nov 6, 2019 at 2:20 PM Tom Lane wrote: >> Thomas Munro writes: >>> On Wed, Nov 6, 2019 at 12:02 PM Adrian Klaver >>> wrote: On 11/5/19 3:00 PM, Chris Withers wrote: > Hmm. Is there any option to use the system timezone