So it's an optimization to reuse existing but currently unused temp
schemas, correct?
On Mon, Jul 10, 2023 at 11:22 AM David G. Johnston
wrote:
>
> On Mon, Jul 10, 2023 at 9:20 AM Ted Toth wrote:
>>
>> I don't see that the schema is removed when the session is over
on, Jul 10, 2023 at 7:18 AM Ted Toth wrote:
>>
>> When a temp table is created I see a pg_temp_NNN (for example
>> pg_temp_3, pg_toast_temp_3) schemas created when/why are additional
>> temp schemas created( pg_temp_4/pg_toast_temp_4)?
>>
>
> Temporary schemas are
When a temp table is created I see a pg_temp_NNN (for example
pg_temp_3, pg_toast_temp_3) schemas created when/why are additional
temp schemas created( pg_temp_4/pg_toast_temp_4)?
Ted
seems to me that sepgsql_schema_post_create should be doing a
selabel_lookup and using that default label if one exists instead of
computing the label ... hmm I'll have to think about it
On Fri, Jul 7, 2023 at 10:44 AM Ted Toth wrote:
>
> I see it now sepgsql_schema_post_create
I see it now sepgsql_schema_post_create is doing it ... it's just not
doing what I think it should :(
On Fri, Jul 7, 2023 at 8:05 AM Ted Toth wrote:
>
> Also AFAICT the schema created for the temp table does not get deleted
> at the end of the session which also causes issues.
>
Also AFAICT the schema created for the temp table does not get deleted
at the end of the session which also causes issues.
On Fri, Jul 7, 2023 at 7:43 AM Ted Toth wrote:
>
> I'm seeing security labels set on db objects when a temporary table is
> created but they don't ma
I'm seeing security labels set on db objects when a temporary table is
created but they don't match the labels I've configured in my
sepgsql_contexts file. Our code doesn't actually execute a "SECURITY
LABEL ..." command for the temp tables but something else must be
doing so because I see pg_temp_
I'm creating partition tables on the fly following the technique described
in https://minervadb.com/index.php/postgresql-dynamic-partitioning/ .
Regardless of whether a partition table is created or already exists all I
really want to do is change the destination table (TG_TABLE_NAME?) of the
inser
, 2022 at 8:13 PM David Rowley wrote:
> On Thu, 24 Nov 2022 at 11:34, Ted Toth wrote:
> >
> > On Wed, Nov 23, 2022 at 4:01 PM Tom Lane wrote:
> >> Then you're stuck managing it manually. But ATTACH PARTITION is
> >> not relevant to INHERITS-style partitionin
On Wed, Nov 23, 2022 at 4:01 PM Tom Lane wrote:
> Ted Toth writes:
> > On Wed, Nov 23, 2022 at 1:24 PM Ron wrote:
> >> Out of curiosity, why INHERITS in v13 instead of PARTITION BY?
>
> > Because none of the declarative partition types do what I want.
>
> Then
Because none of the declarative partition types do what I want.
On Wed, Nov 23, 2022 at 1:24 PM Ron wrote:
> Out of curiosity, why INHERITS in v13 instead of PARTITION BY?
>
> On 11/23/22 09:31, Ted Toth wrote:
> > I've created a table with a number of indexes and then c
I've created a table with a number of indexes and then created a partition
table that inherits from it using "CREATE TABLE... INHERITS..." . I've then
queried pg_indexes on the parent for its indexes and tried creating
matching indexes on the child and attaching them to the parent table
indexes. Ho
I noticed that the 'security label' sql command does not include indexes as
objects that can be labeled, why is that? What sepgsql security class are
indexes, db_table?
Ted
When I create a table that inherits from another table what all is
inherited i.e. ownership, security policy, ...?
Ted
esn't then inserts into it and returns 'SKIP'
(plpython3u).
On Wed, Sep 28, 2022 at 2:49 PM Tom Lane wrote:
>
> Ted Toth writes:
> > I'm dynamically creating tables that inherit from another table but
> > they don't inherit the access privileges. Is there
I'm dynamically creating tables that inherit from another table but
they don't inherit the access privileges. Is there a way to have the
new tables inherit their parent tables access privileges?
Ted
I've just started playing with plpython but ran into a issue when I
was trying to use standard python string formatting to generate a SQL
string for example:
s = "EXECUTE format('CREATE INDEX %s ON %s USING (column_name)' %
(index_name, table_name))"
but plpython then tried to run the EXECUTE inst
Is this the right list to ask questions about plpython? If not what
would be the best list or git repo to ask questions related to
plpython?
Ted
I've looked for information on leakproofness of operators but haven't found
anything can you direct me to a source of this information?
On Fri, Jul 24, 2020 at 3:40 PM Ted Toth wrote:
>
> On Fri, Jul 24, 2020 at 3:15 PM Tom Lane wrote:
>
>> Ted Toth writes:
>>
On Fri, Jul 24, 2020 at 3:15 PM Tom Lane wrote:
> Ted Toth writes:
> > I'm trying to understand when RLS select policy is applied so I created
> the
> > follow to test but I don't understand why the query filter order is
> > different for the 2 queries can a
I'm trying to understand when RLS select policy is applied so I created the
follow to test but I don't understand why the query filter order is
different for the 2 queries can anyone explain?
CREATE USER bob NOSUPERUSER;
CREATE TABLE t_service (service_type text, service text);
INSERT INTO t_servi
Will RLS be applied to data being retrieved via a FDW?
Ted
I was able to create a unique index, thanks.
On Tue, May 5, 2020 at 10:38 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, May 5, 2020 at 8:33 AM Ted Toth wrote:
>
>> Can you have unique constraints on jsonb columns keys? I've looked for
>> exampl
Can you have unique constraints on jsonb columns keys? I've looked for
examples but haven't found any what is the proper syntax? Here's what I
tried:
CREATE TABLE report_json (
recnum int,
id integer,
report jsonb,
PRIMARY KEY (recnum),
CONSTRAINT report_json_unique_constraint
On Fri, Apr 17, 2020 at 8:28 AM Ted Toth wrote:
>
>
> On Thu, Apr 16, 2020 at 8:09 PM Rob Sargent wrote:
>
>> On 4/16/20 6:15 PM, Adrian Klaver wrote:
>> > On 4/16/20 4:59 PM, Ted Toth wrote:
>> >>
>> >>
>> >> On Thu, Apr 16,
On Thu, Apr 16, 2020 at 8:09 PM Rob Sargent wrote:
> On 4/16/20 6:15 PM, Adrian Klaver wrote:
> > On 4/16/20 4:59 PM, Ted Toth wrote:
> >>
> >>
> >> On Thu, Apr 16, 2020 at 6:29 PM Ted Toth >> <mailto:txt...@gmail.com>> wrote:
> >>
>
On Thu, Apr 16, 2020 at 6:29 PM Ted Toth wrote:
> I've noticed that the first exec of an INSERT prepared statement takes ~5
> time longer (I'm using libpq in C and wrapping the calls to time them) then
> subsequent exec's is this the expected behavior and if so is there
I've noticed that the first exec of an INSERT prepared statement takes ~5
time longer (I'm using libpq in C and wrapping the calls to time them) then
subsequent exec's is this the expected behavior and if so is there any
thing I can do to mitigate this affect?
Ted
I tries setting the parameter for the foreign NULL:
params[i] = NULL;
and I get a 'Key not present in table ...' error. How do I insert a record
where I don't have a foreign key yet?
Ted
I've got so C code that interacting with a table containing a field of type
text[]. Strings I've got to put in the array may be unicode and or contain
single or double quotes etc ... What's the best way to escape these
strings?
Ted
On Thu, Feb 20, 2020 at 2:32 PM Adrian Klaver
wrote:
> On 2/20/20 12:17 PM, Ted Toth wrote:
> > I'm a little confused why the before insert trigger fires al all but
> > since it does is there a way to know that an update will occur?
>
> Because ON CONFLICT DO UPDATE is
I'm a little confused why the before insert trigger fires al all but since
it does is there a way to know that an update will occur? Basically I
don't want the trigger affect the row on update.
Ted
On Thu, Nov 30, 2017 at 11:40 AM, Peter J. Holzer wrote:
> On 2017-11-30 08:43:32 -0600, Ted Toth wrote:
>> Date: Thu, 30 Nov 2017 08:43:32 -0600
>> From: Ted Toth
>> To: "Peter J. Holzer"
>> Cc: pgsql-general@lists.postgresql.org
>> Subject: Re: larg
On Thu, Nov 30, 2017 at 4:22 AM, Peter J. Holzer wrote:
> On 2017-11-29 08:32:02 -0600, Ted Toth wrote:
>> Yes I did generate 1 large DO block:
>>
>> DO $$
>> DECLARE thingid bigint; thingrec bigint; thingdataid bigint;
>> BEGIN
>> INSERT INTO thing
>&
On Tue, Nov 28, 2017 at 9:59 PM, Tom Lane wrote:
> Brian Crowell writes:
>> On Tue, Nov 28, 2017 at 12:38 PM, Tomas Vondra >> wrote:
>>> So what does the script actually do? Because psql certainly is not
>>> running pl/pgsql procedures on it's own. We need to understand why
>>> you're getting OOM
On Tue, Nov 28, 2017 at 12:01 PM, Tomas Vondra
wrote:
>
>
> On 11/28/2017 06:54 PM, Ted Toth wrote:
>> On Tue, Nov 28, 2017 at 11:22 AM, Tomas Vondra
>> wrote:
>>> Hi,
>>>
>>> On 11/28/2017 06:17 PM, Ted Toth wrote:
>>>> I&#x
On Tue, Nov 28, 2017 at 12:04 PM, Steven Lembark wrote:
> On Tue, 28 Nov 2017 11:17:07 -0600
> Ted Toth wrote:
>
>> I'm writing a migration utility to move data from non-rdbms data
>> source to a postgres db. Currently I'm generating SQL INSERT
>> statement
On Tue, Nov 28, 2017 at 11:22 AM, Tomas Vondra
wrote:
> Hi,
>
> On 11/28/2017 06:17 PM, Ted Toth wrote:
>> I'm writing a migration utility to move data from non-rdbms data
>> source to a postgres db. Currently I'm generating SQL INSERT
>> statements invol
On Tue, Nov 28, 2017 at 11:19 AM, Rob Sargent wrote:
>
>> On Nov 28, 2017, at 10:17 AM, Ted Toth wrote:
>>
>> I'm writing a migration utility to move data from non-rdbms data
>> source to a postgres db. Currently I'm generating SQL INSERT
>> statements
I'm writing a migration utility to move data from non-rdbms data
source to a postgres db. Currently I'm generating SQL INSERT
statements involving 6 related tables for each 'thing'. With 100k or
more 'things' to migrate I'm generating a lot of statements and when I
try to import using psql postgres
40 matches
Mail list logo
