Re: Adding SHOW CREATE TABLE

On Sat, May 13, 2023 at 1:03 AM Ron wrote: > On 5/12/23 18:00, Kirk Wolak wrote: > > [snip] > > Where do we draw the lines? > > > At other tables. > > Does Table DDL include all indexes? > > > Absolutely! > > It should include constraints, clearly. I would not think it should have > triggers. >

Re: PG_Cron - Error Message Connection failed

Le ven. 12 mai 2023 à 20:21, Adrian Klaver a écrit : > On 5/12/23 09:41, FOUTE K. Jaurès wrote: > > Understand @Adrian Klaver . > > the log show: > > 2023-05-12 17:30:19.327 WAT [46190] LOG: cron job 8 starting: SELECT 1 > > 2023-05-12 17:30:19.339 WAT [46190]

Re: Adding SHOW CREATE TABLE

On Fri, May 12, 2023 at 8:37 PM Stephen Frost wrote: > Greetings, > .. > I mean ... it's already in postgres_fdw, just not in a way that can be > returned to the user. I don't think I'd want this functionality to > depend on postgres_fdw or generally on an extension though, it should > be part o

Re: Window function for get the last value to extend missing rows

On Sat, May 13, 2023 at 2:18 AM Andrew Gierth wrote: > > "Durumdara" == Durumdara writes: > > create table tmp_test_table(mmin,val) >as select o, v > from unnest(array[1,5,NULL,3,NULL,NULL,10,7,NULL,NULL,NULL,4]) >with ordinality as u(v,o); > select * from tmp_te

Re: PG_Cron - Error Message Connection failed

On 5/13/23 00:54, FOUTE K. Jaurès wrote: In your original post in the image under the database column it looks like, to my old eyes, there is a list of database names. Is that the case? Copy and paste that content in your reply. Hello @Adrian Klaver

Re: order by

On Thu, May 11, 2023 at 11:08 PM Ron wrote: > On 5/11/23 09:55, Marc Millas wrote: > > Thanks, > > I do know about index options. > > that table have NO (zero) indexes. > > > If the table has no indices, then why did you write "it looks like there > is something different within the *b-tree opera

Re: Window function for get the last value to extend missing rows

Am 12.05.23 um 13:04 schrieb Durumdara: [...] The LAG function seems to be ok, but how to handle if more than two periods are missing? 03:00 10 03:01 NULL 03:02 NULL 03:03 NULL 03:04 11 03:05 13 [...] and how do you think about NULL in first(and second/third) row?

Re: Adding SHOW CREATE TABLE

On 5/13/23 02:25, Kirk Wolak wrote: On Sat, May 13, 2023 at 1:03 AM Ron wrote: On 5/12/23 18:00, Kirk Wolak wrote: [snip] Where do we draw the lines? At other tables. Does Table DDL include all indexes? Absolutely! It should include constraints, clearly.  I

Re: Adding SHOW CREATE TABLE

On Sat, May 13, 2023, 3:25 AM Kirk Wolak wrote: > Does this imply SQL SYNTAX like: > > SHOW CREATE TABLE > [ INCLUDING { ALL | INDEXES | SEQUENCES | ??? }] > [EXCLUDING { PK | FK | COMMENTS | STORAGE | } ] > [FOR {V11 | V12 | V13 | V14 | V15 }] ?? > ? > Personally, I would expect a funct

Re: Adding SHOW CREATE TABLE

On Sat, May 13, 2023 at 3:34 PM Jeremy Smith wrote: > > > On Sat, May 13, 2023, 3:25 AM Kirk Wolak wrote: > >> Does this imply SQL SYNTAX like: >> >> SHOW CREATE TABLE >> [ INCLUDING { ALL | INDEXES | SEQUENCES | ??? }] >> [EXCLUDING { PK | FK | COMMENTS | STORAGE | } ] >> [FOR {V11 | V1

stop

unsub