On Wed, Jul 10, 2024 at 6:37 PM Han Tang wrote:
> I am using range_agg() function, it works fine with original table value
>
> But when I try to do some update for range value, it will give back an empty
> list
>
> Select range_agg(b.r)
> From (
> Select int8range(lower(bin_range)+1,
On Thu, Jul 11, 2024 at 2:52 AM Adrian Klaver
wrote:
>
> https://www.postgresql.org/docs/current/sql-altertable.html
>
> "The DROP COLUMN form does not physically remove the column, but simply
> makes it invisible to SQL operations. Subsequent insert and update
> operations in the table will
On Thu, 11 Jul 2024 at 13:19, Dimitrios Apostolou wrote:
> I have a table with 1000 partitions on PostgreSQL 16.
> I notice that a fairly complicated query of the form:
>
> SELECT ... GROUP BY ... LIMIT ...
>
> causes the postgres backend process to grow insanely very fast, and the
> kernel OOM
Hello list,
I have a table with 1000 partitions on PostgreSQL 16.
I notice that a fairly complicated query of the form:
SELECT ... GROUP BY ... LIMIT ...
causes the postgres backend process to grow insanely very fast, and the
kernel OOM killer to kill it rather soon.
It seems it tries to
On 7/10/24 13:13, sud wrote:
Hi All,
It's postgres database version 15.4. We have a table which is daily and
is approx. ~2TB in size having a total ~90 partitions. We have a
requirement to drop columns and add new columns to this table.
I Want to understand, If this can be done online? what
Great tip!!! Thx
El mié, 10 de jul de 2024, 16:17, Ron Johnson
escribió:
> On Tue, Jul 9, 2024 at 8:58 PM Krishnakant Mane
> wrote:
>
>> Hello.
>>
>> I have a straight forward question, but I am just trying to analyze the
>> specifics.
>>
>> So I have a set of queries depending on each other
On Tue, Jul 9, 2024 at 8:58 PM Krishnakant Mane wrote:
> Hello.
>
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to
> compute some results for generating financial report.
>
> It involves
Hi All,
It's postgres database version 15.4. We have a table which is daily and is
approx. ~2TB in size having a total ~90 partitions. We have a requirement
to drop columns and add new columns to this table.
I Want to understand, If this can be done online? what is the fastest way
to drop/add
Hi Krishnkant,
On Wed, Jul 10, 2024 at 2:58 AM Krishnakant Mane
wrote:
> Hello.
>
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to
> compute some results for generating financial
On Wed, 10 Jul 2024, Rob Sargent wrote:
I'm an emacs user too. Do you have show-paren enabled? This would show
that your file was ill-formed. M-p and M-n go previous/next matching
parentheses of all types.
Rob,
No, I haven't enabled show-paren.
Thanks for the tip,
Rich
Windows somehow aggregates the permissions allowed for all the Server
Principals (logins) associated with global groups of which your account is
a member. It’s a disaster. We would shortcut that disaster by making a
single group a PostgreSQL login.
It would be bad, but not as awful as SQL Server.
On Wed, Jul 10, 2024 at 11:11 AM Pavel Stehule wrote:
>
> Hi
>
> st 10. 7. 2024 v 18:07 odesílatel Igor Korot napsal:
>>
>> Hi, ALL,
>> Is there an explicit autotools macro that can tell
>> the presence of PostgreSQL client library?
>> And that can be used with "configure" script.
>>
>> Or I
Hi
st 10. 7. 2024 v 18:07 odesílatel Igor Korot napsal:
> Hi, ALL,
> Is there an explicit autotools macro that can tell
> the presence of PostgreSQL client library?
> And that can be used with "configure" script.
>
> Or I should be using AC_CHECK_MODULE() one?
>
I use
I use
Hi, ALL,
Is there an explicit autotools macro that can tell
the presence of PostgreSQL client library?
And that can be used with "configure" script.
Or I should be using AC_CHECK_MODULE() one?
Thank you.
On Wed, 10 Jul 2024, David G. Johnston wrote:
My first easy look for this setup is for any single quotes not adjacent to
either a comma or a parenthesis. Syntax highlighting should ideally have
caught this but I’d look anyway.
David,
I found an error on line 21 that I missed seeing every
On Wednesday, July 10, 2024, Rich Shepard wrote:
> On Wed, 10 Jul 2024, David G. Johnston wrote:
>
> And what are the first few lines of the file? Use text, not screenshots.
>>
>
> David,
>
> insert into locations (company_nbr,loc_nbr,loc_name,
> addr1,city,state_code,postcode) values
>
On 7/10/24 05:30, Rich Shepard wrote:
On Tue, 9 Jul 2024, Adrian Klaver wrote:
The error:
LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636')
is giving you the line number and the data:
a) Navigate to that line number using whatever method Joe has for that.
b) Search for
On 2024-07-10 07:27:29 -0700, Ian Harding wrote:
>
>
> On Wed, Jul 10, 2024 at 7:10 AM Peter J. Holzer wrote:
>
> On 2024-07-09 03:35:33 +, Buoro, John wrote:
> > I've dusted off my C books and coded a solution.
> [...]
> > When using SSPI you can grant access to a user by
On 2024-07-10 06:28:46 +0530, Krishnakant Mane wrote:
> I have a straight forward question, but I am just trying to analyze the
> specifics.
>
> So I have a set of queries depending on each other in a sequence to compute
> some results for generating financial report.
I am assuming that you
On Wed, Jul 10, 2024 at 7:10 AM Peter J. Holzer wrote:
> On 2024-07-09 03:35:33 +, Buoro, John wrote:
> > I've dusted off my C books and coded a solution.
> [...]
> > When using SSPI you can grant access to a user by giving the login name
> as
> > firstname.lastname@SOMEDOMAIN for example.
>
On 2024-07-09 03:35:33 +, Buoro, John wrote:
> I've dusted off my C books and coded a solution.
[...]
> When using SSPI you can grant access to a user by giving the login name as
> firstname.lastname@SOMEDOMAIN for example.
> PostgresSQL has no concept of groups, just roles.
> The code
On Wed, 10 Jul 2024, Hans Schou wrote:
If the file has these line breaks you show, then can make it to multiple
'INSERT INTO' instead.
Hans,
I thought of that, but forgot it. This makes more sense than dividing the
file in small chunks.
Thanks,
Rich
On Wed, 10 Jul 2024, David G. Johnston wrote:
And what are the first few lines of the file? Use text, not screenshots.
David,
insert into locations
(company_nbr,loc_nbr,loc_name,addr1,city,state_code,postcode) values
(2564,1,default,'4250 Hopkins Rd','Ontario','OR','97914'),
> On Jul 9, 2024, at 7:21 PM, Krishnakant Mane wrote:
>
>
>> On 7/10/24 06:44, Guyren Howe wrote:
>>> On Jul 9, 2024, at 17:58, Krishnakant Mane wrote:
>>> Hello.
>>>
>>> I have a straight forward question, but I am just trying to analyze the
>>> specifics.
>>>
>>> So I have a set of
On Wed, Jul 10, 2024 at 2:59 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
>
> And what are the first few lines of the file? Use text, not screenshots.
>
Yes the line with 'INSERT'
grep -ni 'INSERT INTO' scripts/insert-addrs.sql
--
핳햆햓햘 핾했햍햔햚
☏ ➁➁ ➅➃ ➇⓪ ➁⓪
If the file has these line breaks you show, then can make it to multiple
'INSERT INTO' instead.
Search for lines starting with parentese begin '(' and replace it with the
correct INSERT and last comma to semi-colon:
cat i.sql | sed -e 's/^(/INSERT INTO foo VALUES(/' -e 's/,$/;/'
Does the file
On Wednesday, July 10, 2024, Rich Shepard wrote:
>
> Partial screenshot attached.
And what are the first few lines of the file? Use text, not screenshots.
David J.
On Tue, 9 Jul 2024, Craig McIlwee wrote:
The input file is 488 lines (presumably, since Rich said the file should
insert 488 rows). It seems like too much of a coincidence that the last
character of the last line is really the error. My guess is that there is
an unmatched character, perhaps a
On Tue, 9 Jul 2024, Adrian Klaver wrote:
The error:
LINE 488: ...2832,1,default,'85250 Red House Rd','Paisley','OR','97636')
is giving you the line number and the data:
a) Navigate to that line number using whatever method Joe has for that.
b) Search for '85250 Red House Rd'.
Adrian,
With
El día miércoles, julio 10, 2024 a las 01:18:06 +0530, vimal va escribió:
> Dear team ,
>
> This is Vimal from WIpro. We are using Postgres 14 , while connecting
> postgres from application we are getting "*Could not open R2DBC Connection
> for transaction;" error in pod . *We have increased
Hi
Can you check the following.
1. The machine 10.0.202.121 is accessible.
2. Check the firewall settings.
3. Check the pg_hha.conf Settings.
Regards
Kashif Zeeshan
On Wed, Jul 10, 2024 at 12:48 PM vimal va wrote:
> Dear team ,
>
> This is Vimal from WIpro. We are using Postgres 14 , while
Dear team ,
This is Vimal from WIpro. We are using Postgres 14 , while connecting
postgres from application we are getting "*Could not open R2DBC Connection
for transaction;" error in pod . *We have increased the max number of
connections in postgres from 100 to 1000 , still we are facing the
> On 10 Jul 2024, at 06:58, Adrian Klaver wrote:
>
> On 7/9/24 17:46, Craig McIlwee wrote:
>> Full error message from earlier in the thread:
>> > psql:scripts/insert-addrs.sql:488: ERROR: syntax error at or near ";"
>> > LINE 488: ...2832,1,default,'85250 Red House
33 matches
Mail list logo