On Wed, May 23, 2018 at 2:05 PM, a <372660...@qq.com> wrote:
> Hi suppose I have composite type and table
>
> create type A as(
> x float8,
> y float8
> );
>
> create table B(
> Ay A[]
> );
>
> insert into B
> values(array[
> (1,2)::A,
> (3,4)::B]
> );
>
> Now I would like to ex
On Fri, Jul 13, 2018, 7:35 PM Daniel Westermann <
daniel.westerm...@dbi-services.com> wrote:
> Hi,
>
> given this setup:
>
> create table part2 ( a int, list varchar(10) ) partition by hash (a);
> create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3,
> REMAINDER 0);
> create table pa
Do you have following entry as well?
# IPv6 local connections:
hostall all ::1/128 trust
I hope "listen_addresses " in postgresql.conf is on default setting.
Regards,
Amul Sul
On Fri, Sep 7, 2018 at 4:08 PM Sonam Sharma wrote:
>
> get
On Fri, Sep 7, 2018 at 5:10 PM amul sul wrote:
>
> Do you have following entry as well?
>
> # IPv6 local connections:
> hostall all ::1/128 trust
>
> I hope "listen_addresses " in postgresql.conf is on default setting.
&g
On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram
wrote:
> Hi Team,
>
>
>
> Can we have multiple tablespaces with in a database in postgres?
>
> Yes.
> Can we have a table on different tablespace same as Oracle?
>
Yes -- specify TABLESPACE option while creating that table.
Regards,
Amul
On Fri, Feb 21, 2020 at 11:31 AM Daulat Ram
wrote:
> Hi Amul ,
>
> Please share the examples how we can create no. of tablespaces for a
> single database and how we can use them.
>
> As I know we can create database on tablespace
>
>1. CREATE TABLESPACE conn_tbs OWNER enterprisedb LOCATION
>
On Fri, Feb 21, 2020 at 11:53 AM Daulat Ram
wrote:
> That will be great if you share any doc where it’s mentioned that we
> can’t use multiple tablespace for a single database. I have to assist my
> Dev team regarding tablespaces.
>
>
>
> Also , what are the differences between Oracle and Postgr
On Fri, Feb 21, 2020 at 12:48 PM Daulat Ram
wrote:
> What are the differences between Oracle and Postgres tablespace.
>
> I hope this[1] wiki page will help you.
> Can we assign tablespace during Postgres schema creation . As I know in
> Oracle we assign the tablespace during user/schema creati
On Thu, Jun 18, 2020 at 12:00 PM Srinivasa T N wrote:
>
> Hi,
>Partitioning of a table with sequence id as one of its fields is supported
> in postgresql12?
>
Could you please elaborate on your case a bit more?
Regards,
Amul
On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N wrote:
>
> Hi,
>I have a parent table with one of the field as ""gid" int4 DEFAULT
> nextval('"ami_smart_new".aoi_boundary_gid_seq'::regclass)".
>
>I create child tables which inherit parent and use hash partition. When I
> directly insert
On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote:
>
> On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe
> wrote:
>>
>> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote:
>> > On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote:
>> > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote:
>> >
On Fri, Jun 19, 2020 at 3:50 PM Srinivasa T N wrote:
>
>
>
> On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote:
>>
>> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote:
>> >
>> > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe
>> > wrote:
>&
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
might help.
Regards,
Amul
On Tue, Aug 11, 2020 at 9:49 PM Samarendra Sahoo
wrote:
>
> Dear all,
> We are getting ready to install in production and would like to know what are
> key considerations and how do we use them to provisi
On Tue, May 17, 2022 at 9:12 AM Rama Krishnan wrote:
>
> Hi All,
>
> How to install pg_repack and use?
Check this: https://reorg.github.io/pg_repack/
Regards,
Amul
On Mon, Dec 6, 2021 at 6:11 AM James Sewell wrote:
>>
>> Agreed with both points. What about we add, subxid count and overflow
>> status in LocalPgBackendStatus and through that, we can show in
>> pg_stat_activity. That way we don't have to report it ever and
>> whenever the user is running pg_s
On Tue, Dec 14, 2021 at 5:30 PM Dennis wrote:
>
> Hi,
>
> Can I add custom sqls for regression tests (pg_regress) ?
> If it can be added how?
>
Check this: https://wiki.postgresql.org/wiki/Regression_test_authoring
Regards,
Amul
See prepare statement : https://www.postgresql.org/docs/current/sql-prepare.html
On Thu, Jan 6, 2022 at 12:10 PM Igor Korot wrote:
>
> Hi, ALL,
> In SQLite you can write:
>
> SELECT a, b, c FROM foo WHERE id = :id;
>
> where ":id" is the named parameter.
>
> The query above is similar to
>
> SELE
Firstly, anonymous procedures are not supported in PostgreSQL, you need to
embed this block in a plpgsql function[1] body & call that function if you want
reset sequence value manually, or you could use CYCLE option[2] of a
sequence to auto reset.
1] https://www.postgresql.org/docs/9.6/static/plp
How about storing timestamp without timezone[1]?
1] https://www.postgresql.org/docs/current/static/datatype-datetime.html
Regards,
Amul
On Thu, Dec 14, 2017 at 10:19 AM, Venkata B Nagothi wrote:
> Hi All,
>
> I have a question regarding PostgreSQL time zones and daylight savings -
>
> We have b
On Tue, Apr 22, 2025 at 5:56 PM Karsten Hilbert wrote:
>
> Am Mon, Apr 21, 2025 at 10:23:30PM +0530 schrieb Abhishek Hatgine:
>
> >*deleting* a value is conceptually different from *updating* it to NULL.
>
> In what way ?
>
> In other words, you'll have to much better define what you
> mean be
20 matches
Mail list logo
