.com/s/bpAU :- PG16
<https://explain.depesz.com/s/bpAU>
On Tue 27 Aug, 2024, 3:40 AM Adrian Klaver,
wrote:
> On 8/26/24 14:49, nikhil raj wrote:
> > Hi All,
> >
> > I've encountered a noticeable difference in execution time and query
> > execution plan row co
HI All,
This for the help plpgsql and rest everything just move under declare and
now everything works fine. Thanks for the help.
On Tue, Feb 28, 2023 at 2:10 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Feb 27, 2023 at 1:17 PM nikhil raj wrote:
>
&g
create statment or not storing the temp table.
On Tue, 28 Feb, 2023, 1:34 am Tom Lane, wrote:
> nikhil raj writes:
> > This is the Function I have created successfully but while executing it
> > throughs an error temp table doesn't exist.
>
> You won't be able to do
HI Team,
This is the Function I have created successfully but while executing it
throughs an error temp table doesn't exist.
But the same when I execute it not inside the function from **drop temp
table to end insert select ** it work fine
Please can any one help me why in the function i am not
Ok, thanks for the clarification.
On Fri, Mar 6, 2020 at 12:31 AM Adrian Klaver
wrote:
> On 3/5/20 10:48 AM, nikhil raj wrote:
> > Hi Adrian,
> >
> > On that table nothing was happening just created the table and later o
> > was creating the index and i was getting
Hi Adrian,
On that table nothing was happening just created the table and later o was
creating the index and i was getting this error.
Please can you tell me is this the draw back of that in 12.2 version.
On Fri, 6 Mar 2020, 12:04 am Adrian Klaver,
wrote:
> On 3/5/20 10:04 AM, nikhil
HI ALL,
While creating the index on the partition table i am getting error on it
saying
*ERROR: cannot specify default tablespace for partitioned relations SQL
state: 0A00.*
Query is
* CREATE INDEX t_e20so1_doi_c_doid_idxON public.t_e20so1_doi USING
btree(i_doid ASC NULLS LAST)TA
when client from
GST time zone i am getting 21:41:39 GST
[image: image.png]
but which i insert into the databases is showing empty column.
On Fri, Jan 24, 2020 at 11:09 PM Adrian Klaver
wrote:
> On 1/24/20 9:19 AM, Adrian Klaver wrote:
> > On 1/24/20 8:59 AM, nikhil raj wrote:
&g
Hi ALL,
Required help with the time zone. i am getting error on the GST time line.
is tht a bug or postgres doesn't support the GST time zone.
select CURRENT_TIMESTAMP AT TIME ZONE 'GST'
ERROR: time zone "GST" not recognized SQL state: 22023
Postgres -:11.2
Ubuntu:-18.04
Hi Rich Shepard,
Step 1-: Stop the postgres services and change the path of the
data directory in postgres.conf file.
Step 2-: rsync the flie to new path. And start the service.
Step 3-: connect to postgres and check command output from psql shell SHOW
data_directory; should see now data path.
uot; TO
cpupdate"
only in the grant its taking space rest in -d its perfectly all right.
On Mon, Sep 9, 2019 at 8:04 PM Adrian Klaver
wrote:
> On 9/9/19 7:30 AM, nikhil raj wrote:
> > Hi All,
> >
> > just did few modification of the shell command still having the same
&g
ra command-line argument "ASD_100_1313 TO cpupdate"
ignored
ERROR: syntax error at end of input
LINE 1: GRANT CONNECT ON DATABASE
^
On Mon, Sep 9, 2019 at 7:47 PM Tom Lane wrote:
> > On Sep 9, 2019, at 7:16 AM, nikhil raj wrote:
> >>
=CTc/cpuser
CDF_History | cpuser | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
cpuser=CTc/cpuser
CDF_100_1313 | cpuser | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
cpuser=CTc/cpuser
On Mon, Sep 9, 2019 at 6:58 PM Rob Sargent wrote:
>
>
> On Sep 9, 2019, at 7:16 AM, nikhil raj wrot
in ('tempdb')")
> /usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d $DBLIST -c "GRANT
> CONNECT ON DATABASE $DBLIST TO dbuser1"
>
>
>
>
>
> On Mon, Sep 9, 2019 at 5:58 AM nikhil raj wrote:
>
>> Hi Karsten,
>>
>> yup you are ri
Hi Karsten,
yup you are right can you help in i tried by removing quotion and also
adding extra having same issue.
On Mon, Sep 9, 2019 at 5:25 PM Karsten Hilbert
wrote:
> On Mon, Sep 09, 2019 at 05:16:20PM +0530, nikhil raj wrote:
>
> >
> > The DB is already there and gettin
Hi All,
The DB is already there and getting the error of the DB does not exist
where I execute it via shell.
DBLIST=/usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d postgres -q
-t -c "SELECT datname from pg_database where datname in
('CDF_100_1313')"/usr/lib/postgresql/11/bin/psql
-p 5432 -U
Hi ALL,
I have recently migrated to windows postgres server to linux postgres
server.
while i run this query in windows PG server
SELECT *
FROM (VALUES ('a'), ('___b1'), ('_a1'),('a2'),('a3'),('a5'), ('a2')) t
(val) order by val
I am getting the out put in this sort order
[image: 10.250.200.184
Hello
I am using postgres 10.3 version current facing an issue related query
tracking whenever I run SELECT * FROM pg_stat_statements in the query
column I am not getting the exact query with values with variable but
instead I am getting $1, $2 in the query
example- "update ss set number=$1 where
Klaver
wrote:
> On 05/10/2018 04:42 AM, nikhil raj wrote:
>
>> 1) What OS and version?
>>
>> ans: windows 2012R2
>>
>> 2) System memory size is ?
>>
>> ans: 32GB
>>
>> 3) What is session_start_timestamp tracking? In other words wha
agent if any processing is going on the front
end some of the query will run
On Thu, May 10, 2018 at 5:10 AM, Adrian Klaver
wrote:
> On 05/09/2018 11:31 AM, nikhil raj wrote:
>
>> Hi Team,
>>
>> I dont have any idea why did my Postgres server crash and it says
>>
Hi Team,
I dont have any idea why did my Postgres server crash and it says
timestamp=2018-05-07 00:34:11.209 EDT,user=,db=,app=,client=,
transaction-ID=0,session_start_timestamp=2018-04-26 10:08:19
EDT,SQL_state=0LOG: worker process: parallel worker for PID 2864 (PID
4476) exited with exit c
.
now currently prepared a scripts for that which goes and does for DB butr
after that i have much manually work with it so is there any third party
tool for that
Thanks,
On Fri, May 4, 2018 at 6:51 PM, Adrian Klaver
wrote:
> On 05/04/2018 04:44 AM, nikhil raj wrote:
>
>> Hi,
>>
Hi,
Any one can please help me out
How to monitor the Hits on database and how many hits on each user tables
Through query.
Is there any other tools for that so it can full fill my requirement for it
.
Thanks,
Hi guys ,
when check the task manager I see these many postgres.exe are running. How
to identify which pid is running for which process please any one can help
me out.
or Why these many postgres.exe are running on the server
[image: Inline image 1]
Thanks ,
Nikhil
Hi
I am Nikhil currently working as a MS SQL DBA . Currently my company is
shifting from MS SQL to postgres
check the roles of user I want to give user roles only select, insert,
update, execute and create database to all users Permission
The users should not have these permission
drop databa
25 matches
Mail list logo
