On Sun, Jun 30, 2024 at 3:51 PM Tom Lane wrote:
> Igal Sapir writes:
> > But this throws an error (SQL Error [42601]: ERROR: syntax error at or
> near
> > "'1 '"):
>
> > SELECT generate_series(
> > date_trunc('month', curren
;month', current_date),
date_trunc('month', current_date + interval '7 month'),
(interval '1 ' || 'month')::interval
)
Because this returns an interval of 1 second:
SELECT (interval '1 ' || 'month')::interval;
Is that a bug?
I am able to work around the issue using a CASE statement, but shouldn't it
work simply by concatenating the string with the || operator?
Thank you,
Igal
On Fri, Oct 11, 2019 at 1:09 AM stan wrote:
> On Thu, Oct 10, 2019 at 05:41:47AM -0700, Igal @ Lucee.org wrote:
> > On 10/9/2019 12:34 AM, Laurenz Albe wrote:
> > > Igal Sapir wrote:
> > > > I am trying to test a simple case insensitive comparison. Most
> li
Thomas,
On 10/10/2019 6:22 AM, Thomas Kellerer wrote:
Igal @ Lucee.org schrieb am 10.10.2019 um 14:41:
Thank you all for replying. I tried to use the locale suggested by
both Laurenz and Pavel, en-US-u-ks-level2, but I'm still getting
false for a simple comparison of 'Abc' =
On 10/9/2019 12:34 AM, Laurenz Albe wrote:
Igal Sapir wrote:
I am trying to test a simple case insensitive comparison. Most likely the
collation that I chose is wrong, but I'm not sure how to choose the correct
one (for English/US?). Here is my snippet:
create collation case_insens
rministic=false
);
select 'Abc' = 'abc' collate case_insensitive;
I expected true but am getting false.
Any thoughts?
Thanks,
Igal
On 8/22/2019 9:15 PM, Tom Lane wrote:
Adrian Klaver writes:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
How can I start up the Cluster?
Is version 201906161 beta 2?
Yes:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/include/catalog/catversion.h;h
On 8/22/2019 5:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought
beta 3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to
set the
Adrian,
On 8/22/2019 5:08 PM, Adrian Klaver wrote:
On 8/22/19 4:52 PM, Igal @ Lucee.org wrote:
I have a data directory that was created by Postgres 12 (I thought
beta 3 but now am not sure anymore) running in Docker.
I have installed Postgres 12b3 as a Systemd service and am trying to
set
r was
compiled with CATALOG_VERSION_NO 201907221.
How can I start up the Cluster?
Is version 201906161 beta 2?
Would running PG12 beta 2 work?
Would running initdb destroy the data?
Thank you,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
86_64.rpm
# yum install
https://download.postgresql.org/pub/repos/yum/testing/12/redhat/rhel-7.6-x86_64/postgresql12-server-12beta3-1PGDG.rhel7.x86_64.rpm
Thanks for your help,
Igal
Adrian,
On 8/22/2019 12:22 PM, Adrian Klaver wrote:
On 8/22/19 11:29 AM, Igal @ Lucee.org wrote:
I have installed the CentOS 7 PGDG file from
https://yum.postgresql.org/repopackages.php
If I `cat /etc/yum.repos.d/pgdg-redhat-all.repo` I see:
# PGDG Red Hat Enterprise Linux / CentOS
Any ideas?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
Any ideas?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
x27;s more performant too.
Best,
Igal
ower(new.email)"
PL/pgSQL function on_record_modified() line 26 at assignment
I have seen some hacks suggesting TRY/CATCH or converting to a JSON and
checking if the field exists, but I would think that there's a better
way to check if the field is in the NEW record, no?
Any ideas? Thank
Thank you, David.
I should get more sleep...
Igal
On 7/31/2019 11:52 AM, David G. Johnston wrote:
On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org <mailto:i...@lucee.org>> wrote:
alter table some_table
rename column amount_num to amount_text;
al
the column?
Thanks,
Igal
On 7/9/2019 10:45 AM, Adrian Klaver wrote:
On 7/9/19 7:41 AM, Igal @ Lucee.org wrote:
On 7/9/2019 7:02 AM, Adrian Klaver wrote:
On 7/8/19 11:48 PM, Igal @ Lucee.org wrote:
I have a custom search_path:
# show search_path;
search_path
--
"st
David,
On 7/9/2019 7:49 AM, David G. Johnston wrote:
On Tue, Jul 9, 2019 at 7:41 AM Igal @ Lucee.org <mailto:i...@lucee.org>> wrote:
search_path is not set int he config, but rather with ALTER
DATABASE SET
search_path TO ... but I have executed that prior to the RESTORE
On 7/9/2019 7:02 AM, Adrian Klaver wrote:
On 7/8/19 11:48 PM, Igal @ Lucee.org wrote:
I have a custom search_path:
# show search_path;
search_path
--
"staging, transient, pg_catalog"
(1 row)
I ran `pg_dump --schema-only` and the only re
On 7/8/2019 11:48 PM, Igal @ Lucee.org wrote:
I have a custom search_path:
# show search_path;
search_path
--
"staging, transient, pg_catalog"
(1 row)
I ran `pg_dump --schema-only` and the only reference in the output to
search_path is:
ath', '', false);
Then one of my functions which does not reference the full name of a
table with its schema fails with "relation [rel-name] does not exist".
Is that a bug? I have seen some old posts about this issue but am not
sure if there is a ticket or why it still
On 6/28/2019 8:07 PM, David Rowley wrote:
On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org wrote:
create trigger tr_on_table_modified after insert or delete or update
on some_table for each row execute procedure on_table_modified();
I can see in the output the notices with the
gt; --|
> i...@lucee.org|
Any ideas?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
On 6/24/2019 7:38 PM, David G. Johnston wrote:
On Mon, Jun 24, 2019 at 7:31 PM Igal @ Lucee.org <mailto:i...@lucee.org>> wrote:
If a function select data from a table, and the rows in the table may
change, would that function qualify for Immutable or does it have
to be
e
results given the same arguments forever".
So for the same arguments, the result would change only if the data in
the table changes. Does that mean that it violates the "forever" clause
and therefore can be only marked as Stable and not Immutable?
Thanks,
Igal
On Tue, Jun 11, 2019 at 2:11 PM Chris Travers
wrote:
> At Adjust GmbH we have 5-10 PB data in Postgres.
>
>
> On Tue, Jun 11, 2019 at 9:28 PM Ireneusz Pluta/wp.pl wrote:
>
>> W dniu 2019-06-11 o 19:45, Igal Sapir pisze:
>> > I'm doing a presentation abou
I'm doing a presentation about Postgres to SQL Server users this weekend,
and I want to showcase some of the big names that use Postgres, e.g.
MasterCard, Government agencies, Banks, etc.
There used to be a Wiki page of Featured Users but that link is broken now.
I also "found" a page about Maste
- FOSS or not -
> can provide. I have had limited exposure to Oracle, SQL Server, Sybase,
> Empress, Teradata, Netezza, DB2, Sqlite/Spatialite, Interbase & Informix.
> Of these, Postgres & Sqlite3 (which one depends on use cases) are all I use
> these days.
>
Yep. agreed.
Th
l than SQL Server. I found
> installing the GIS featureset in SS to be a bit of a pain back oin the
> day..
>
GIS is a good feature but it's a niche feature, so while I'll mention it
with extensions I am looking for more general-purpose comparisons and areas
where Postgres is as-good or better than SQL Server.
Thanks,
Igal
Ron,
On Mon, May 6, 2019 at 12:54 PM Ron wrote:
> On 5/6/19 2:47 PM, Igal Sapir wrote:
> > but I want to instill confidence in them that anything they do with SQL
> > Server can be done with Postgres.
>
> Right off the top of my head, here are some things you can't (
Brent,
On Mon, May 6, 2019 at 1:44 PM Brent Wood wrote:
> Hi Igal,
>
> One relevant comment I found interesting a couple of years ago...
>
> A New Zealand Govt agency was installing an institutional GIS system
> (several thousand potential users). It supported differen
, scalability,
etc.
I want to get them interested in giving Postgres a try instead of SQL
Server. Surely the savings on licenses can be substantial (I have no idea
how much, TBH), but I want to instill confidence in them that anything they
do with SQL Server can be done with Postgres.
Igal
Next month I'll be making a presentation about Postgres to a SQL Server
crowd in L.A. at their SQL Saturday event.
I was wondering if anyone has any tips that are specific for SQL Server
users? Best features? Known issues? Common rebuttals?
Thanks,
Igal
Jeff,
On Sat, May 4, 2019 at 2:10 PM Jeff Janes wrote:
> On Sat, May 4, 2019 at 3:04 PM Igal Sapir wrote:
>
>> Jeff,
>>
>> On Sat, May 4, 2019 at 11:34 AM Jeff Janes wrote:
>>
>>> On Sat, May 4, 2019 at 1:49 PM Igal Sapir wrote:
>>>
>>&g
Jeff,
On Sat, May 4, 2019 at 11:34 AM Jeff Janes wrote:
> On Sat, May 4, 2019 at 1:49 PM Igal Sapir wrote:
>
>> Christoph,
>>
>> On Sat, May 4, 2019 at 10:44 AM Christoph Moench-Tegeder <
>> c...@burggraben.net> wrote:
>>
>>> ## Igal Sapir
Christoph,
On Sat, May 4, 2019 at 10:44 AM Christoph Moench-Tegeder
wrote:
> ## Igal Sapir (i...@lucee.org):
>
> > My main "issue" is that the official pgjdbc driver does not support the
> > notifications with listen and I was trying to figure out why.
>
Thank you both (Michel replied off-list it seems),
On Fri, May 3, 2019 at 1:10 PM Andres Freund wrote:
> Hi,
>
> On 2019-05-03 11:06:09 -0700, Igal Sapir wrote:
> > Is it possible to connect to Postgres for notifications via telnet? This
> > is obviously more for l
Is it possible to connect to Postgres for notifications via telnet? This
is obviously more for learning/experimenting purposes.
I expected a simple way to connect and consume notifications but can not
find any example or documentation on how to do that.
Any ideas?
Thanks,
Igal
r-- 1 root root 640M May 3 12:42 e76fc603ffe2c977c826.tmp
-rw-r--r-- 1 root root 640M May 3 12:42 fed72361b202f9492d7f.tmp
Best,
Igal
On Fri, May 3, 2019 at 9:09 AM Igal Sapir wrote:
> Jeff,
>
> On Fri, May 3, 2019 at 6:56 AM Jeff Janes wrote:
>
>> On Wed, May 1, 2019 at 10:25
Jeff,
On Fri, May 3, 2019 at 6:56 AM Jeff Janes wrote:
> On Wed, May 1, 2019 at 10:25 PM Igal Sapir wrote:
>
>>
>> I have a scheduled process that runs daily to delete old data and do full
>> vacuum. Not sure why this happened (again).
>>
>
> If you are
TimeScaleDB.
Thank you for your help,
Igal
On Wed, May 1, 2019 at 11:08 PM Michael Nolan wrote:
>
>
> Assuming you get the database back online, I would suggest you put a
> procedure in place to monitor disk space and alert you when it starts to
> get low.
> --
> Mike Nolan
>
make more room.
I have a scheduled process that runs daily to delete old data and do full
vacuum. Not sure why this happened (again).
Thanks,
Igal
On Wed, May 1, 2019 at 6:02 PM Michael Loftis wrote:
> Best optionCopy/move the entire pgdata to a larger space. It may also
> be eno
maybe run Postgres
and disable the WAL so that no new disk space will be required.
Surely, I'm not the first one to experience this issue. How can I fix this?
Thank you,
Igal
[1]
root@ff818ff7550a:/# du -h --max-depth=1 /pgdata
625M/pgdata/pg_wal
608K/pgdata/global
0 /pgdata
Pavel,
On Mon, Apr 8, 2019 at 8:29 AM Pavel Stehule
wrote:
>
>
> po 8. 4. 2019 v 17:22 odesílatel Igal Sapir napsal:
>
>> Pavel,
>>
>> On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule
>> wrote:
>>
>>>
>>> po 8. 4. 2019 v 7:57 odesílatel
Pavel,
On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule
wrote:
>
> po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal:
>
>> David,
>>
>> On Sun, Apr 7, 2019 at 8:11 PM David Rowley
>> wrote:
>>
>>> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote:
>
David,
On Sun, Apr 7, 2019 at 8:11 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote:
> > However, I have now deleted about 50,000 rows more and the table has
> only 119,688 rows. The pg_relation_size() still shows 31MB and
> pg_total_relation_size() s
David,
On Sun, Apr 7, 2019 at 7:28 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 14:19, Igal Sapir wrote:
> >
> > On Sun, Apr 7, 2019 at 6:20 PM David Rowley <
> david.row...@2ndquadrant.com> wrote:
> >>
> >> On Mon, 8 Apr 2019 at 10:09, Igal Sapi
David,
On Sun, Apr 7, 2019 at 6:20 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote:
> >
> > I have a table for which pg_relation_size() shows only 31MB, but
> pg_total_relation_size() shows a whopping 84GB.
> >
> > The database engine is run
usage goes up until it reaches
the full capacity of the partition (about 27GB of free space), at which
point it fails.
How can I reclaim the disk space here other than write the data to a new
table and drop the old one?
Thank you,
Igal
On 7/11/2018 11:02 AM, David G. Johnston wrote:
On Wed, Jul 11, 2018 at 10:54 AM, Igal @ Lucee.org <mailto:i...@lucee.org>>wrote:
On 7/11/2018 10:38 AM, Adrian Klaver wrote:
On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote:
How can I tell inside the trigger fu
On 7/11/2018 10:38 AM, Adrian Klaver wrote:
On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote:
How can I tell inside the trigger function if the event was DELETE or
INSERT/UPDATE?
https://www.postgresql.org/docs/10/static/plpgsql-trigger.html
This looks like it have all of the information that
thinking that maybe a
DELETE will have a NULL value in NEW.id? Will that work? Is there a
better way?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
On 03/04/2018 09:57 PM, Tom Lane wrote:
Igal writes:
On 03/04/2018 07:24 PM, Adrian Klaver wrote:
On 03/04/2018 05:53 PM, Igal wrote:
I am trying to connect to http://momjian.us/ but I get connection
timeout (from Firefox):
Dunno if it's related, but large parts of the US Northeast
On 03/04/2018 07:24 PM, Adrian Klaver wrote:
On 03/04/2018 05:53 PM, Igal wrote:
I am trying to connect to http://momjian.us/ but I get connection
timeout (from Firefox):
Works for me from FF. Maybe a caching issue? Have you tried:
Ctrl + Shift + R
Thanks, I'm not sure if something
Igal
https://youtu.be/5eF9_UB73TI
For the impatient, this is the point in the video where I start using the
tool (so you can watch that first and then later watch the overview and the
configuration options from the beginning);
https://youtu.be/5eF9_UB73TI?t=9m51s
Feedback welcome! Thank you,
Igal
Is there a rational reason why Day of the Week is 0-based, i.e. Sunday
(0) to Saturday (6) instead of the more intuitive Sunday (1) to Saturday
(7)?
SELECT date_part('dow', current_date);
https://www.postgresql.org/docs/current/static/functions-datetime.html
Thanks,
Igal S
four" is more similar to "one two three" than to
"three two one".
Any thoughts?
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
time: 163.174 ms |
How can I improve the performance here?
Thank you,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
On 1/28/2018 12:35 PM, Tom Lane wrote:
"Igal @ Lucee.org" writes:
I am trying to run a query which was working a few weeks ago, and it
utilizes the <<-> operator but I am getting an error: operator does not
exist text <<-> text.
If I try to install the pg_trgm exte
y(text, text) does not exist.
If I try to install the pg_trgm extension with `CREATE EXTENSION
pg_trgm;` I get an error: extension "pg_trgm" already exists.
Running PostgreSQL 10.1, compiled by Visual C++ build 1800, 64-bit
Any ideas? Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
update will return values while do nothing will not.
>
That explains it, thank you.
>
> 2018-01-02 15:43 GMT+08:00 Igal Sapir :
>
>> It seems that if I do a simple update it resolves my issue:
>>
>> INSERT INTO users(email, name)
>> VALUES('u...@domain.
x::text::int > 0) as existed;
But if anyone has a better solution then I'd love to hear it.
Thanks,
Igal
On Mon, Jan 1, 2018 at 11:07 PM, Igal Sapir wrote:
> Hello,
>
> I want to use the "UPSERT" syntax for returning an ID if it exists, or
> inserting a re
r_id, (xmax::text::int > 0) as existed;
When an email address does not exist then it works fine and I get the new
user_id, but when it does exist, I get no results at all.
How can I get the results in case of a CONFLICT?
Thanks,
Igal
I don't think that it's possible, but why don't you open a free gmail
account or another web-based email service that's available in your
region/language and subscribe to all of the mailing lists through that
account?
Igal
On Mon, Dec 25, 2017 at 2:49 AM, Michelle Konzack &l
Michelle,
On 12/24/2017 1:20 PM, Michelle Konzack wrote:
Hello Igal
Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten:
I am doing a similar thing migrating from SQL Server, and I am
considering to publish an open source Migrator.
Can you tell me about some of the data types that you had to
thing migrating from SQL Server, and I am
considering to publish an open source Migrator.
Can you tell me about some of the data types that you had to change
moving from MySQL to Postgres?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
role_rawd;
GRANT role_ra TO role_rawd;
GRANT INSERT ON ALL TABLES IN SCHEMA TO role_rawd;
ALTER DEFAULT PRIVILEGES IN SCHEMA
GRANT UPDATE, DELETE ON TABLES TO role_rawd;
Thank you,
Igal Sapir
Lucee Core Developer
Lucee.org
70 matches
Mail list logo
