sequences - Search results in mailing lists
Mailing lists >> pgsql-novice >> Thread
2025-03-06 17:05:06 | Re: Subqueries (Bzzzz)
consequences could be terrible if you don't know exactly what you are doing and why, so avoid
Mailing lists >> pgsql-novice >> Thread
2024-12-03 00:32:13 | Re: Command Line option misunderstanding (Ken Dibble)
sequence. command must be either a command string that is completely parsable by the server
Mailing lists >> pgsql-novice >> Thread
2023-03-20 05:27:44 | Re: PgAdmin Lapse (Laurenz Albe)
sequence of commands that got you into trouble. On the other hand, you could try a different
Mailing lists >> pgsql-novice >> Thread
2022-03-24 05:31:47 | Re: SELECT FOR UPDATE on rows that don't exist (Joe)
sequence of events for the two SELECT FOR UPDATE transactions makes sense. To apply it to my pseudo
Mailing lists >> pgsql-novice >> Thread >> Search in thread (5)
2021-10-22 23:01:14 | Re: Strange sequences - how to construct? (TIM CHILD)
sequence table: drop table if exists my_sequence cascade; -- a new table to hold the sequence
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2020-05-22 15:49:08 | decode, base64 problem (gmail Vladimir Koković)
sequence LOCATION: b64_decode, encode.c:327 3. ------------------------------------------------------- select substring(encode(lice,'base64'), 110, 5) as Lokal0
Mailing lists >> pgsql-novice >> Thread
2020-04-30 17:27:04 | ON CONFLlCT DO UPDATE command cannot affect row a second time (cryptodactyl)
sequence', False): add_sequence(to_tbl, job) cur.execute(upsert) conn.commit() logging.info(upsert
Mailing lists >> pgsql-novice >> Thread
2020-03-01 11:25:25 | Returning a default value from an INSTEAD Of trigger (David Roper)
sequence, but I’m leaning heavily towards UUIDs. I also don’t think it's a good
Mailing lists >> pgsql-novice >> Thread
2020-01-22 15:05:29 | RE: postgresql rookie needs help with system catalog (Vianello, Dan A)
sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'table' WHEN
Mailing lists >> pgsql-novice >> Thread >> Search in thread (12)
2019-12-18 06:08:04 | Fwd: Renaming sequences (Zahid Rahman)
sequence name then any code using that sequence by name will fail. That's from
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2019-01-23 00:43:10 | Getting Sequence Value (JORGE MALDONADO)
sequence value of a table before inserting a new record, so I am using *currval
Mailing lists >> pgsql-novice >> Thread
2018-06-01 11:46:32 | Re: does postgresql 10 have something similar to sql server's setidentity_insert (Thomas Kellerer)
sequence after you do that: select setval(pg_get_serial_sequence('the_table', 'id'), (select
Mailing lists >> pgsql-novice >> Thread
2018-05-10 01:22:04 | Re: Query plan when using currval (David Rowley)
sequence value. https:///docs/10/static/sql-insert.html -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training
Mailing lists >> pgsql-novice >> Thread >> Search in thread (2)
2018-03-15 16:55:18 | Re: convert legacy self-managed primary keys to postgresql's identity or serial pk's (Tom Lane)
sequence nextval() is not transactional. In the scheme you've got, you do not (I imagine
Mailing lists >> pgsql-novice >> Thread
2018-02-14 15:33:02 | WAL settings (J B)
sequence_numbers = on #syslog_split_messages = on # This is only relevant when logging to eventlog