Goodnight,
I would like to ask the following question:
As some of you may recall, I was doing my university thesis as a
modification of Gurjeet Singh's Index Adviser.
Now I have finished the programming part.
But I have the following problem:
Gurjeet Singh's Index Adviser readme describes how to u
Joe Abbate writes:
> On 28/9/20 17:25, Tom Lane wrote:
>> Domain-over-composite might be a slightly simpler answer than your first
>> one. It's only available in relatively late-model PG, and I'm not sure
>> about its performance relative to your other design, but it is an
>> alternative to think
On 9/28/20 2:58 PM, Joe Abbate wrote:
Hello Tom,
On 28/9/20 17:25, Tom Lane wrote:
Domain-over-composite might be a slightly simpler answer than your first
one. It's only available in relatively late-model PG, and I'm not sure
about its performance relative to your other design, but it is an
a
Hello Gavan,
On 28/9/20 17:52, Gavan Schneider wrote:
Consider expressing all the component fields as a range. This allows you
the ability to be a precise as you need and still have the benefits of
well defined comparison functions.
I did consider that, but it's a tradeoff between 80% of the
Hello Tom,
On 28/9/20 17:25, Tom Lane wrote:
Domain-over-composite might be a slightly simpler answer than your first
one. It's only available in relatively late-model PG, and I'm not sure
about its performance relative to your other design, but it is an
alternative to think about.
"Domain-ov
On 29 Sep 2020, at 7:31, Joe Abbate wrote:
Hello Rob,
On 28/9/20 17:17, Rob Sargent wrote:
just record all three fields (day, month, year) with nulls and do the
to-date as needed.
That is not sufficient. An earlier implementation had something like
a CHAR(8) to record MMDD, but how can
On 9/28/20 4:31 PM, Joe Abbate wrote:
Hello Rob,
On 28/9/20 17:17, Rob Sargent wrote:
just record all three fields (day, month, year) with nulls and do the
to-date as needed.
That is not sufficient. An earlier implementation had something like a
CHAR(8) to record MMDD, but how can you i
Hello Rob,
On 28/9/20 17:17, Rob Sargent wrote:
just record all three fields (day, month, year) with nulls and do the to-date
as needed.
That is not sufficient. An earlier implementation had something like a
CHAR(8) to record MMDD, but how can you indicate, for example, an
issue date o
Joe Abbate writes:
> I'm considering creating a TYPE for what may be called a "possibly
> imprecise date" (pidate).
> The first option I explored was creating a composite type with the two
> attributes, but that doesn't allow specification of DEFAULTs, NOT NULL
> or CHECK expressions on the pr
> On Sep 28, 2020, at 3:14 PM, Joe Abbate wrote:
>
> Hello,
>
> I'm considering creating a TYPE for what may be called a "possibly imprecise
> date" (pidate). The most obvious use is for recording dates such as births
> or deaths of historical individuals, where we may know that someone di
Hello,
I'm considering creating a TYPE for what may be called a "possibly
imprecise date" (pidate). The most obvious use is for recording dates
such as births or deaths of historical individuals, where we may know
that someone died precisely on a given year-month-day, but the birth may
only
On Mon, 28 Sep 2020, Tom Lane wrote:
No part-timers in your universe? (My friends in the restaurant business
would surely find the above pretty laughable.)
Tom,
Not in the markets I serve; at least, not at the environmental manager
level. I don't work for retail businesses; primarily natural
Rich Shepard writes:
> On Mon, 28 Sep 2020, Adam Scott wrote:
>> What if a person is a member of more than one Org? Consider a person_org
>> table.
> Not applicable. An individual is employed by a single organization.
No part-timers in your universe? (My friends in the restaurant business
woul
On Mon, 28 Sep 2020, Adam Scott wrote:
What if a person is a member of more than one Org? Consider a person_org
table.
Adam,
Not applicable. An individual is employed by a single organization.
I see mention of a site in the person table. It may also be the case that
you need a site table.
Reid Thompson writes:
> On Mon, 2020-09-28 at 12:15 -0400, Tom Lane wrote:
>> I'm a bit dubious that that'd actually help, but it's perfectly safe
>> if you want to try it. pg_internal.init is just a cache file that
>> will be rebuilt if it's missing.
> appears to allow to vacuum to complete...
What if a person is a member of more than one Org? Consider a person_org
table.
I see mention of a site in the person table. It may also be the case that
you need a site table.
Often, you want a table for the Person and a Contact (or Address) table
separately. This allows for having more than
On Mon, 2020-09-28 at 12:15 -0400, Tom Lane wrote:
> Reid Thompson writes:
> > We have a planned upgrade that would permanentlty remedy this.
> > regarding the below errors on our PG 9.6.x instance.
>
> > 2020-09-28 09:08:15.741 EDT,,,26212,,5f71e03f.6664,1,,2020-09-28 09:08:15
> > EDT,250/91361
On Mon, 28 Sep 2020, Adrian Klaver wrote:
You could use INSERT INTO location(new_fields,) SELECT the_fields FROM
the_table(s).
Well, duh! I could have thought of that. That's exactly what I'll do:
Create the new table, move data from the old table into it, then drop
columns in the old table .
On 9/28/20 10:15 AM, Rich Shepard wrote:
I've been developing a business tracking application for my own use and
it's
worked well up to now. But, I need to modify it by adding a table with
attributes from two other tables. I've not drawn a E-R diagram so I show
the
two existing tables here:
C
I've been developing a business tracking application for my own use and it's
worked well up to now. But, I need to modify it by adding a table with
attributes from two other tables. I've not drawn a E-R diagram so I show the
two existing tables here:
CREATE TABLE Organizations (
org_id serial P
Reid Thompson writes:
> We have a planned upgrade that would permanentlty remedy this.
> regarding the below errors on our PG 9.6.x instance.
> 2020-09-28 09:08:15.741 EDT,,,26212,,5f71e03f.6664,1,,2020-09-28 09:08:15
> EDT,250/9136136,0,ERROR,XX001,"found xmin 2675436435 from before relfrozenxi
Hi Adrian,
> On 28. Sep, 2020, at 16:30, Adrian Klaver wrote:
> Not necessarily, if it is installing plpythonu functions.
I'll have to check that anyway. I'm already logged out of work, so I won't do
that now. 😇
Cheers,
Paul
On 9/28/20 7:22 AM, Paul Förster wrote:
Hi Adrian,
On 28. Sep, 2020, at 16:03, Adrian Klaver wrote:
So pgwatch2 installs functions that use plpythonu?
How does that work if there is no plpython language installed?
at work, the extension is installed everywhere. But it seems we have an old
Hi Adrian,
> On 28. Sep, 2020, at 16:03, Adrian Klaver wrote:
>
> So pgwatch2 installs functions that use plpythonu?
> How does that work if there is no plpython language installed?
at work, the extension is installed everywhere. But it seems we have an old
version. The current version seems t
We have a planned upgrade that would permanentlty remedy this.
regarding the below errors on our PG 9.6.x instance.
2020-09-28 09:08:15.741 EDT,,,26212,,5f71e03f.6664,1,,2020-09-28 09:08:15
EDT,250/9136136,0,ERROR,XX001,"found xmin 2675436435 from before relfrozenxid
321165377","automatic v
On 9/28/20 6:37 AM, Paul Förster wrote:
Hi Adrian,
On 28. Sep, 2020, at 15:34, Adrian Klaver wrote:
Well I'm out of ideas. That means circling back to having Python 2 installed,
should the powers that be agree.
they don't. But fortunately, it seems that the number of applications which use
Hi Adrian,
> On 28. Sep, 2020, at 15:34, Adrian Klaver wrote:
>
> Well I'm out of ideas. That means circling back to having Python 2 installed,
> should the powers that be agree.
they don't. But fortunately, it seems that the number of applications which use
Python code inside a database, see
On 9/28/20 12:46 AM, Paul Förster wrote:
Hi Adrian,
On 27. Sep, 2020, at 19:30, Adrian Klaver wrote:
Does:
SELECT
lanname, proname, probin
FROM
pg_proc
JOIN
pg_language
ON
pg_language.oid = pg_proc.prolang
WHERE
pg_language.lanname='plpythonu'
AND
probin IS NOT NULL;
Can we upgrade the 9.6version open source postgresql db directly to
12.3version ?
Thanks and Regards,
Singh
Hi Laurenz,
> On 28. Sep, 2020, at 13:13, Laurenz Albe wrote:
>>
>> but then I'd have to do a reindex anyway, right? My goal was to avoid the
>> reindex altogether, if possible.
>
> That couldn't be avoided anyway if you change the collation no matter
> if you do it on the database or on the c
W dniu 2020-09-28 o 13:39, Matthias Apitz pisze:
El día lunes, septiembre 28, 2020 a las 12:17:26p. m. +0200, Paul Förster
escribió:
$ psql -Usisis -dsisis
SET
psql (11.4, server 13.0)
WARNING: psql major version 11, server major version 13.
Some psql features might not work.
Type "he
On 2020/09/28 19:06, Matthias Apitz wrote:
Hello,
Maybe it's a FAQ, but I haven't seen the answer. I want to switch of the
warning (because I know the fact of version not matching):
$ psql -Usisis -dsisis
SET
psql (11.4, server 13.0)
WARNING: psql major version 11, server major version 13.
El día lunes, septiembre 28, 2020 a las 12:17:26p. m. +0200, Paul Förster
escribió:
> > $ psql -Usisis -dsisis
> > SET
> > psql (11.4, server 13.0)
> > WARNING: psql major version 11, server major version 13.
> > Some psql features might not work.
> > Type "help" for help.
> >
> > sisis=
On Mon, 2020-09-28 at 11:45 +0200, Paul Förster wrote:
> > Your best bet is to manually change the definition of all columns to use
> > the new collation.
> > psql's \gexec may help.
>
> but then I'd have to do a reindex anyway, right? My goal was to avoid the
> reindex altogether, if possible.
Hi Matthias,
> On 28. Sep, 2020, at 12:06, Matthias Apitz wrote:
>
>
> Hello,
>
> Maybe it's a FAQ, but I haven't seen the answer. I want to switch of the
> warning (because I know the fact of version not matching):
>
> $ psql -Usisis -dsisis
> SET
> psql (11.4, server 13.0)
> WARNING: psql m
Hello,
Maybe it's a FAQ, but I haven't seen the answer. I want to switch of the
warning (because I know the fact of version not matching):
$ psql -Usisis -dsisis
SET
psql (11.4, server 13.0)
WARNING: psql major version 11, server major version 13.
Some psql features might not work.
Typ
Hi Laurenz,
> On 28. Sep, 2020, at 11:04, Laurenz Albe wrote:
>
> There have been efforts to add this functionality:
> https://www.postgresql.org/message-id/flat/5e756dd6-0e91-d778-96fd-b1bcb06c161a%402ndquadrant.com
> but it didn't get done.
seems to be a rather complex thing according to the
On Sun, 2020-09-27 at 17:16 -0400, aNullValue (Drew Stemen) wrote:
> I've attempted to obtain help with this problem from several other places,
> but numerous
> individuals recommended I ask this mailing list.
>
> What I need is for the ability to return a timestamp with timezone, using the
> U
On Mon, 2020-09-28 at 10:02 +0200, Paul Förster wrote:
> I have a general question about the use of ICU. Currently, we have PostgreSQL
> compiled
> from source (Linux) without ICU support. All database clusters and databases
> are UTF8
> and of course relying on glibc.
>
> With the sooner or l
Hi,
I have a general question about the use of ICU. Currently, we have PostgreSQL
compiled from source (Linux) without ICU support. All database clusters and
databases are UTF8 and of course relying on glibc.
With the sooner or later upcoming glibc release 2.28, there will probably a big
reind
Hi Adrian,
> On 27. Sep, 2020, at 19:30, Adrian Klaver wrote:
>
> Does:
>
> SELECT
>lanname, proname, probin
> FROM
>pg_proc
> JOIN
>pg_language
> ON
>pg_language.oid = pg_proc.prolang
> WHERE
>pg_language.lanname='plpythonu'
> AND
> probin IS NOT NULL;
>
> show anything?
41 matches
Mail list logo
