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
Hello,
I am trying to pass a dynamic interval to generate_series() with date range.
This works as expected, and generates a series with an interval of 1 month:
SELECT generate_series(
date_trunc('month', current_date),
date_trunc('month', current_date + interval '7 month'),
interval
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
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_insensitive(
provider=icu, locale='en-US-x-icu', deterministic=false
);
selec
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
Brent,
On Tue, May 7, 2019 at 12:42 PM Brent Wood wrote:
> I have not used SS for spatial data, but I don't have a Postgres database
> without Postgis installed. The OSGEO ecosystem and synergies with other
> FOSS GIS tools is fantastic.
>
> And it does not stop with the Postgis extension. For t
Tony,
On Mon, May 6, 2019 at 10:35 PM Tony Shelver wrote:
> I have to agree on the geospatial (GIS) features.
> I converted from SQL Server to Postgresql for our extended tracking
> database. The SS geospatial feature set doesn't seem nearly as robust or
> complete or perfoirmant as that suppli
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 different back-end spatial
> databa
Ravi,
On Mon, May 6, 2019 at 12:28 PM Ravi Krishna wrote:
> > I was wondering if anyone has any tips that are specific for SQL Server
> users? Best features? Known issues? Common rebuttals?
>
> Are you talking about SS to PG migration.
>
> Generally SQLServer shops use SS specific functions a
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
Right. I managed to start up Postgres by symlinking the following
directories to a new mount: pg_logical, pg_subtrans, pg_wal, pg_xact.
I then created a new tablespace on the new mount, set it to be the default
tablespace, and moved some of the smaller (about 30GB) tables to it. That
allowed me
nk) for the
> base but I don't recall if that works or not.
>
> On Wed, May 1, 2019 at 18:07 Igal Sapir wrote:
>
>> I have Postgres running in a Docker container with PGDATA mounted from
>> the host. Postgres consume all of the disk space, 130GB [1], and can not
>>
I have Postgres running in a Docker container with PGDATA mounted from the
host. Postgres consume all of the disk space, 130GB [1], and can not be
started [2]. The database has a lot of bloat due to much many deletions.
The problem is that now I can not start Postgres at all.
I mounted an additi
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
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 running inside a Docker container, with the data
mounted as a volume from a partition on the host's file system.
When I try to run `VACUUM FULL`, the disk usage
Hi everybody,
I published a tool that makes it easy to migrate a database from other
DBMSs to Postgres:
https://github.com/isapir/Migrate2Postgres
Currently it supports migrations from MS SQL Server, but it is written in a
way that will make it easy to migrate from other DBMSs as well.
I also pu
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
Hello,
I want to use the "UPSERT" syntax for returning an ID if it exists, or
inserting a record and returning the new ID if it does not exist.
INSERT INTO users(email, name)
VALUES('u...@domain.tld', 'User')
ON CONFLICT (email) DO NOTHING
RETURNING user_id, (xmax::text::int > 0) as existed
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 <
linux4miche...@tamay-
33 matches
Mail list logo
