not find any
hint in the documentation or in
https://wiki.postgresql.org/wiki/Development_information.
Kind regards
Thiemo
Adrian Klaver escribió:
Even if there where plans, any changes would happen in the future
and would not be help the now problem.
Yes and no. I can live without the partitioning, as I do not intend to
load data from more than one source. Other might. But until others
want to load data f
Adrian Klaver escribió:
Changing that would count as a major change. Even if you where to
convince the developers to make the change the earliest it would
released would be with the next major release in Fall of 2025. That
assumes you can convince then early enough or at all.
I was not
Thanks, I shall have a look into it. I was under the assumption the
the create table like would create no more than a structural copy.
Torsten F��rtsch escribi��:
Thiemo, ��
it looks to me like you are using inheritance just to make sure
your SOURCES and TOPO_FILES tables have
Adrian Klaver escribió:
On 11/1/24 13:47, Thiemo Kellner wrote:
It looks to me basically to be a "create table A as select * from B
where false".
No it more capable then that.
Yes, I wrote basically, not exactly.
CREATE TABLE LIKE has like_option which
allows to tra
TANCE-MAINTENANCE misses out on a sentence not to forget to adapt the
triggers/rules.
Kind regards
Thiemo
Maybe tools like DBeaver can help? It has a free trial period.
Andy Hartman escribió:
could it be done using Powershell?
Just out of curiosity, not suggestion this is the solution. Why save
json in PostgreSQL and not in a DB specialised on JSON like MongoDB?
Divyansh Gupta JNsThMAudy escribió:
Thank you everyone for giving your valuable responses, I am glad
that everyone understands my concern. I got some go
time... maybe PostgreSQL wants to
get a head start on this.
Kind regards
Thiemo
Zitat von ?ukasz Jarych :
Hi Guys,
I have idea already for creating this complex solution.
Please give your notes and tips if you have.
1. Keep all changes within table including:
-adding rows
-deleting
I attached what I have got so far. I will setup a shared repository
these days.
Zitat von Thiemo Kellner :
Hi Lukasz
I am working on a generic (reading the information schema and other
database metadata), trigger based solution for SCD tables, i. e.
tables that keep (or not according to
You can access code with
git clone ssh://@git.code.sf.net/p/pg-scd/code
pg-scd-code
and browse it at
https://sourceforge.net/p/pg-scd/code/
On 02/27/18 08:43, Thiemo Kellner wrote:
I attached what I have got so far. I will setup a shared repository
these days.
Zitat von Thiemo Kellner
Hi all
In a function I would like to log the caller. Is there a way to get
its name in pgplsql?
Kind regards
Thiemo
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
. However, pg_background_launch mentioned in the blog is not
available on my vanilla installation of Debian 10.3-2 from the
PostgreSQL repositories.
CHapter 47 makes me believe I need to code some C functions to use
background workers.
How are things actually?
Kind regards Thiemo
--
+49 (0)1578-772
so I'll go the dblink way. The docs write that
fdw provides a more modern architecture for more ore less the same.
However, I do not think the execution of arbiträry stuff is possible by fdw.
Kind regards Thiemo
--
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.ed
Hi all
I try to use dblink to create a asynchronous logging facility. I have
the following code
-- open the dblink if it does not yet exist
V_DBLINK_CONNECTION_NAME :=
GET_PROPERTY_VALUE_STRING(
I_PROPERTY_NAME => 'DBLINK_CONNECTION_NAME'
On 03/30/18 07:39, Laurenz Albe wrote:
psql:testing/test.pg_sql:41: NOTICE: Connection busy: 1
psql:testing/test.pg_sql:41: NOTICE: Last error: OK
psql:testing/test.pg_sql:41: NOTICE: Cancel query: OK
psql:testing/test.pg_sql:41: NOTICE: Connection busy: 0
psql:testing/test.pg_sql:41: NOT
On 03/30/18 11:14, Laurenz Albe wrote:
You have to consume the result before you can send the next query.
I changed implementation but still get the same error but now different
context. I tried to retrieve the result but I failed
I committed the last code to its project repository at Source
On 04/03/18 11:28, Laurenz Albe wrote:
[...]
psql:testing/test.pg_sql:42: ERROR: function
WRITE_MESSAGE_TO_TABLE(i_function => text, i_message => text, i_level =>
text, i_present_user => name, i_session_user => name,
i_transaction_timestamp => timestamp with time zone, i_transaction_id =>
bigi
.
Function Schema: logger
Database: act
User: act
User Default Schema: act
Kind regards
Thiemo
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
This message was sent using IMP, the Inte
text := :SCHEMA_NAME;
begin
but as the plpgsql code is within quotes, it Fails.
Kind regards
Thiemo
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
This message was sent using
Zitat von Pavel Stehule :
no. The :xxx is not evaluated inside string. The workaround is using GUC
variables and related functions. Can be used from psql and from plpgsql too.
Hi Pavel, thanks for pointing this out. However, I implemented another
solution with dedicated PostgreSQL user where
.
I would be grateful about a bit shed light.
Kind regards Thiemo
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC
<>
order of the parameter is important, I should use a statement that
returns the properly ordered list of parameters. Maybe I did take a
wrong turn and one can achieve this simpler.
Suggestions are very welcome.
Kind regards Thiemo
with PRO_UNNESTED_TYPES as(
select
oid as PROOID
Zitat von Paul Jungwirth :
I think you are looking for `WITH ORDINALITY` (in pg 9.4+). For
instance you could rewrite your first CTE like so:
Thanks for the hint.
Kind regards
--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF
-
Zitat von Achilleas Mantzios :
Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :)
I am sticking to sourceforge still. I never understood what people
made leave it. I was investigating a bit if I should move on to github
too but I do not remember what prevented me from d
. e. maybe
it is time to overhaul the security concept.
Cheer, Thiemo
This message was sent using IMP, the Internet Messaging Program.
ame_b) as filename
from BASE
where recordingdate_b > recordingdate_a
group by registration_a
Kind regards Thiemo
This message was sent using IMP, the Internet Messaging Program.
to Kind of function?
Kind regards Thiemo
This message was sent using IMP, the Internet Messaging Program.
Hi
I am quite happy to announce the first release package of pglogger for
structured logging to table and/or standard out. I crafted it inspired
by log4j in the hope I could give back the community a bit. You find
details at https://sourceforge.net/p/pglogger/wiki/Home/
Kind regards
Thiemo
Zitat von haman...@t-online.de:
a) I am running some select query
select ... order by
Now, I would like to preserver the ordering through further
processing by adding a sequence number
Of course I can do:
create temp sequence mseq;
select xx.*, nextval('mseq') as ord from (select ... ord
t and PostgreSQL would work through.
Is there a scheduler within PostgreSQL? I read the documentation and
searched the web but could not find a hint. But before going another
road or implementing something myself, I ask. Maybe this design is no
good at all.
Kind regards
Thiemo
I have seen pg_cron but it is not what I am looking for. It schedules
tasks only by time. I am looking for a fifo queue. pg_cron neither
prevents from simultaneous runs I believe.
Quoting Thomas Kellerer :
There is no built-in scheduler, but there is an extension that supplies that
https:/
This is a queue but if I am not mistaken, it is outside PostgreSQL
where to go I am very reluctant. I will look at it in more depth.
Thanks!
Quoting Ron :
Maybe https://github.com/chanks/que is what you need.
On 09/05/2018 02:35 PM, Thiemo Kellner wrote:
I have seen pg_cron but it is not
Because I am looking for a fifo queue and not for time schedule.
Thanks anyway.
Quoting Tim Clarke :
Why not just call your "do a scheduled run" code from cron?
Tim Clarke
Thanks for the hint. Your solution seems to be good. However, I am
designing my framework for fun, to give back something to the
community and because I think it's time that historisation is not
reinvented and reimplemented again and again.
Having that said, I think I can get rid of the nee
Hi all
I installed pglogger (https://sourceforge.net/projects/pglogger/) and
try to insert into the "level" table as user "act" but it fails
claiming insufficient privileges even though insert is granted to
public (see below). What am I missing?
Kind regards Thiem
privilege.
I would be grateful I some could shed some more light for me.
Kind regards Thiemo
Quoting "David G. Johnston" :
Layers of security. But yes it is generally sufficient enough to
simply allow usage on scheme without much
thought while ensuring contained objects are sufficiently secured.
Thanks :-)
In your place I would double check whether the table structure on the
database is what you expect. Without knowing the code of mentioned
function there seem only two numbers in the call. It quite misty in
the crystal fortune telling ball to me.
Quoting Igor Korot :
Does anybody have an id
-- highest timestamps on 64bit lubuntu vanilla PostgreSQL 11.3
return '294277-01-01 00:59:59.99'::timestamptz;
end;
$body$;
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Hand
Hi Tom
Thanks for replying so fast. You are absolutely right.
I changed the code file but failed to install it. :-( I am sorry for
not checking the obvious.
Kind regards
Thiemo
Quoting Tom Lane :
Thiemo Kellner writes:
I created a function that ought to return a timestamptz (another
Hi Karsten
Thanks for the infinitly good hint. I remembered the infinity
blurredly somewhen this morning, looked it up in the docs and already
dumped my functions in favour of the infinity solution. :-) Great,
that PostgreSQL has the infinity concept! Thanks
Kind regards
Thiemo
Quoting
update in preparation
in 0.92 which should. You may want to givi it a try.
Actually, this is a known problem:
https://github.com/pgmodeler/pgmodeler/issues/1281
Maybe you want to give the beta a shot: https://pgmodeler.io/download
Kind regards
Thiemo
S/MIME Public Key:
https://oc
I suppose at least major Linux distributions provide a
package of a more or less recent version of it. Ubuntu does anyway. I
am not aware of an other binary distributor but Raphael for Windows or
Mac, but then again those are not my turf.
Kind regards Thiemo
--
S/MIME Public
set PROPERTY_VALUE_STRING = I_LEVEL
where PROPERTY_NAME = C_LOGGING_LEVEL_PROPERTY_NAME;
get current diagnostics V_ROW_COUNT = ROW_COUNT;
I did not find the error I am making.
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than W
Hi Andrew
Paste sites are for IRC, on the mailing list you should always attach
the necessary details to your message.
Ok, I was under the impression that paste site were preferable to
attachments which generates traffic not everyone is interested in.
Thiemo> the following except
k does not include the error place in
dynamic SQL executed by the "execute" command. Maybe I am missing
something again.
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78
pgutilsL are small but it is a beginning after all. :-)
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id
https://www.sqlinform.com/
Quoting stan :
I have a presentation later in the week, and i plan on printing out some
files containing SQL commands. I have used some "pretty printers" in the
past for things like Perl scripts. What I am thinking of s something that
bolds keywords, handles page brea
gly feel this is a bug, at least no intention at all from my
side. However, before filing a bug, I wanted to get your opinion on
that. Maybe it is just a problem of the openSUSE Tumbleweed repository.
I would appreciate your two dimes. Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelasse
end if;
insert into TG_TABLE_SCHEMA.TG_TABLE_NAME values (NEW.*);
return NULL;
end;
$body$;
Running this version, I get another proof that the term was literalised:
psql:common_calculation_method_insert.pg_sql:59: ERROR: Schema
"current_schema" could not be foun
Quoting Rob Sargent :
The function definition doesn’t name any parameters?
Nope, trigger functions cannot, according to documentation. Parameters
can be passed as list/array of values though. I have no clue about why
this needs to be so awful/awesome.
--
S/MIME Public Key: https:
Quoting Tom Lane :
Thiemo Kellner writes:
create trigger CALCULATION_METHOD_BR_IU
before insert on CALCULATION_METHOD
for each row
execute function METHOD_CHECK(current_schema);
Executing such, the string "current_schema" gets literalised, i.e.
single quoted:
Yu
Quoting Adrian Klaver :
Well, I guess, I can put the correct schema at installation, but
would have liked to have a more general approach. Furthermore, I
think this also implies that installation can only be done by psql.
:-s
Why not grab the CURRENT_SCHEMA in the function?:
DECLARE
Quoting Adrian Klaver :
Can you provide an outline form of what you are trying to accomplish?
Hm, making myself understood. ;-) So from the very beginning.
There is the concept of growing degree days
(https://en.wikipedia.org/wiki/Growing_degree-day). It is a measure
for energy an organis
Quoting Adrian Klaver :
Familiar with it, I have worked in farming(outdoor and
indoor(greenhouse)) industries.
Cool
(https://en.wikipedia.org/wiki/Growing_degree-day). It is a measure
for energy an organism can consume in a specific day for its
development.
Also used to anticipate pe
Quoting Adrian Klaver :
On 1/3/21 1:44 PM, Thiemo Kellner wrote:
So is the below still only going to fire on INSERT?
If so it will not deal with functions that disappear after the
INSERT, which in the end makes it similar to my suggestion:) The
point being you are taking a snapshot in
Quoting Michael Lewis :
Still, no feedback on the effect that a truncate call is having on
the DB and may be doing more than intended fairly easily. I am not
in the hackers group so I couldn't say this feature would not be
implemented. It just seems unlikely given the philosophies of that
comparison to using something
like pastebin.com? I only found very coarse instructions on what to do
on the lists. Have I been missing a link to a netiquette page?
Cheers Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49
I’ve got a materialized view as a source for my ETL-process, and the
materialized view takes several hours to refresh. During which it
is locked for queries.
Would it be an option to split the process into a cascade of
materialized views to minimize the actual time of lock?
So I’m lookin
.
Kind regards
Thiemo
Am 04.06.22 um 10:18 schrieb Robert Stanford:
Hi,
I have time series data from multiple inputs with start and
end timestamps.
Can anyone suggest an elegant way to coalesce consecutive rows so only
the
first start time and last end time for each group of events (by input)
is
sets end it is
not always easy to get ones head around thinking in sets. I hope you
could follow my suggestions. It might not be the most efficient way but
should work.
Kind regards
Thiemo
Am 05.11.22 um 16:10 schrieb Rafal Pietrak:
Hi Everybody,
I was wondering if anybody here could help
with portable
PostgreSQL 10.4 provided by PortableApps.
You can find test case script and log at https://pastebin.com/W2HsTBwi
I would appreciate your two dimes.
Kind regards
Thiemo
--
Signal: +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
T
impolite. Is there a policy?
Kind regards
Thiemo
--
Signal: +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id:
B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B
Hi HP
Thanks for your reply.
Quoting "Peter J. Holzer" :
On 2018-12-25 11:54:11 +0000, Thiemo Kellner wrote:
[three different but functionally equivalent queries]
Explain analyze verbose showed for:
A (cost=264.72..626.97 rows=31 width=90) (actual time=1.117..1.117 rows=0
loops=
Hi David
Thanks for your revision.
Quoting David Rowley :
On Wed, 26 Dec 2018 at 00:54, Thiemo Kellner
wrote:
Explain analyze verbose showed for:
A (cost=264.72..626.97 rows=31 width=90) (actual time=1.117..1.117
rows=0 loops=1)
B (cost=264.72..974.25 rows=31 width=58) (actual time=1.508
Hi Fabio
Quoting Fabio Pardi :
The cost is not a range. The 2 numbers you see are:
*
Estimated start-up cost. This is the time expended before the
output phase can begin, e.g., time to do the sorting in a sort node.
*Estimated total cost. This is stated on the assumption that
to overhaul your application.
Kind two dimes
Thiemo
--
Signal: +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id:
B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B
denied for schema scd
Even though I granted all privileges to IL.
What am I missing or is it just not possible what I want to do?
Kind regards
Thiemo
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947
Quoting Achilleas Mantzios :
as of 10 (same with 11) you (IL) must be the owner of relation SCD.TEMPL_BK .
Create your tables with a user who has correct privileges on both
tables/schemas.
Not what I hope for but was afraid of. thank you for the answer.
--
Achilleas Mantzios
IT DEV Lead
I
Hi Karl
I did not double check with the doc whether the SQL you posted is
valid (I guess it could by applying the defaults) however I do not see
how sequences would govern the sending of data to users.
Kind regards
Thiemo
Quoting Karl Martin Skoldebrand :
Hi,
I'm tryi
You also could try out DBVisualizer (https://www.dbvis.com/). It is
available in a feature reduced free version. Feautre comaprison is at
https://www.dbvis.com/features/feature-list/. I personally bought the
pro to support development. I rarely use a pro feature.
Quoting Zahir Lalani :
Nav
hardly ever a modelling tool involved.
Kind regards
Thiemo
advantage that you could, if you wanted, also implement logic to tell
you precisely in which columns the difference is encountered.
Kind regards
Thiemo
Am 27.10.2023 um 10:56 schrieb Y_esteembsv-forum:
Hi
Need SQL logic/different approach method's to find out way's
a) to Implement ch
ode = 'AG';
c) I noticed that, even though the rules define logic for the other
attributes, those do not get changed if not present in an update. While
this is actually good, but surprises me nonetheless.
Did I miss some reading in the doc? Must I use trig
se new.XYZ
end;
And what about the where condition... hm, guess I am a bit confused.
Kind regards
Thiemo
Thanks for the reply. I confirm the behaviour. Your explanation makes
sense if I consider having read that with an update the is a complete
new record version written.
Am 10.11.2023 um 14:35 schrieb David G. Johnston:
On Friday, November 10, 2023, Thiemo Kellner
wrote:
Hi all
I
ts of single statements. I suppose it is sort of a
preprocessor that removes the code part from $IF until $END if the
condition is not met.
Kind regards
Thiemo
checks for every and each logging statement put (as the check has been
done on installation already).
begin
do_something;
$if check_if_env_is_dev $then
do_some_logging;
$end
do_more_stuff;
end;
Am 12.11.2023 um 16:58 schrieb Tom Lane:
Ron writes:
On 11/12/23 09:
Hi Dick
Out of curiosity, what is the reason there is this zoo of versions. Is
it impossible to align them to one version?
Cheers
Thiemo
Am 21.11.2023 um 13:18 schrieb Dick Visser:
It is possible, it's just that there is no real need to at the moment,
ao we have not spent that much effort on the topic.
At any time there will always be newer upstream versions.
Ok, fair enough, but it puzzles me that the effort shall be put int
_TYPE⠒NAME text;
Please find attached script files of objects directly involved in the
trigger function.
Is there something, I am doing wrongly?
Kind Regards
Thiemo@echo Set up function NODE_GOOD⠒TR_B_IU_R;
set search_path = snowrunner, public;
create or replace function NODE_GOOD⠒TR_B_IU_R()
Oh, I totally forgot to mention that I ran the scripts with DbVisualizer
against a 16.1 (Debian 16.1-1.pgdg110+1) server using PostgreSQL JDBC
Driver 42.6.0 .
Am 26.02.2024 um 16:51 schrieb Thiemo Kellner:
Hi
My names can contain a special character (⠒), e.g. to separate the
donator object
Thanks for the hint and care. The install script has a set statement
already and I now added the search_path clause to no avail. Please find
the entire code attached and a screenshot from the error.
Am 26.02.2024 um 17:35 schrieb Tom Lane:
Thiemo Kellner writes:
However, I want to create a
Shame on me. My bad. It was the order of installation that did not work.
Sorry for that. I was mislead by the error message. If an object is
missing I would not expect an invalid type name message.
Thanks
Am 26.02.2024 um 17:53 schrieb Thiemo Kellner:
Thanks for the hint and care. The install
output of the important part of the install script is listed at the end.
Please find attached my code.
Kind regards
Thiemo
insert data into NODE_GOOD⠒V
psql:insert_data/NODE_GOOD⠒V.pg_sql:27: INFO: new.NODE⠒ID:
1107cb8d-c1f1-4368-ac7b-72ac3031555a
psql:insert_data/NODE_GOOD⠒V.pg_sql:27: INFO: n
Thanks.
27.02.2024 19:09:50 Adrian Klaver :
>
> On 2/27/24 9:49 AM, Thiemo Kellner wrote:
>> Hi
>>
>> I am surprised that my before insert trigger function does not insert any
>> rows into NODE_GOOD.
>>
>> I was under the impression that the trigger
Am 27.02.2024 um 21:42 schrieb Adrian Klaver:
Also not sure what this:
select NODE_TYPE⠒NAME into V⠒NODE_TYPE⠒NAME
from NODE⠒V
where 1 = 1
and ID = new.NODE⠒ID
and 1 = 1;
is supposed to be doing especially the 1 = 1 tests?
The selec
Am 27.02.2024 um 23:20 schrieb Adrian Klaver:
On 2/27/24 14:11, Thiemo Kellner wrote:
It is a habit of mine to pad conditions in the where clause. This way,
it is easy to comment/uncomment parts of the clause for testing
purposes. Coming from Oracle, I missed that using "true&quo
es,
listed what is in the database one connects to - https://ibb.co/dbbJVbJ.
template1=> select count(*)
from PG_CLASS
where RELNAME = 'umsaetze';
count
---
0
(1 row)
template1=> \q
C:\Users\thiemo\AppData\Roaming\MOBAXT~1\home>psql -h hp-slimline-260 -p
5436 -U
Thanks for the enlightenment. A pity. I suppose, there is no working
around this?
Am 14.03.2024 um 18:01 schrieb Adrian Klaver:
On 3/14/24 09:41, Thiemo Kellner wrote:
Hi
I am trying to access PostgreSQL meta data, possibly in a vane attempt
to get size data.
I use DbVis with a connection
Am 14.03.2024 um 21:03 schrieb David Rowley:
Yeah, maybe dblink and a LATERAL join might be an easy way. Something like:
create extension dblink;
select d.datname,c.relname from pg_database d, lateral (select * from
dblink('dbname='||d.datname,$$select relname from pg_class where
relname = 'p
You solve a problem that no one has. Data belonging together may still be
divided into schemas in a database. Thus, the metadata is also reported and
archived individually per database.
I am not sure, we are taking about the same problem, but would be
surprised to be the only one having exper
You could also create a PostgreSQL foreign server for each of the other
databases, which would let you issue a query to UNION together the results of a
query on all of the catalogs. This would require creating a foreign table for
pg_class in the other databases.
Thanks. So many possibilit
https://wiki.postgresql.org/wiki/Monitoring
Thanks for the URL. I am not too keen to re-invent the wheel. Although
it teaches me on PostgreSQL.
Am 22.03.2024 um 14:15 schrieb Fred Habash:
We developed a home-grown queue system using Postgres, but its
performance was largely hindered by que tables bloating and the need to
continuously vacuum them. It did not scale whatsoever. With some
workarounds, we ended up designing three sets of
correct, is not too concise. I wished, that
PG issued a warning about a definition conflict. In PostgreSQL, a PK
must always be not nullable, so explicitly defining on of a PK's columns
as nullable is contradictory, one should get notified of.
The two dimes of Thiemo
Am 24.03.2024 um 16:17 schrieb Tom Lane:
To do that, we'd have to remember that you'd said NULL, which we
don't: the word is just discarded as a noise clause. Considering
that this usage of NULL isn't even permitted by the SQL standard,
that seems like a bit too much work.
If I understood c
Am 24.03.2024 um 16:36 schrieb Andreas Kretschmer:
the null-able constraint addition to a column is pointless because by
default all columns are nullable. definition as a primary key adds the
not null constraint.
While this is certainly true, I do not see why the information that a
not nul
Am 24.03.2024 um 16:39 schrieb Erik Wienhold:
And that's also possible in Postgres with UNIQUE constraints if you're
looking for that behavior.
Sort of the distinction between PK and UQ.
1 - 100 of 178 matches
Mail list logo
