On 06/17/2018 12:19 PM, Rv02 wrote:
psql
I have two tables , table A and Table b. Table A has list of about 6
customers ID with all their details and Table B had customer is and age for
over 50 rows of customers.
I going to assume you meant Table B has customer ID and age above.
Does
psql
I have two tables , table A and Table b. Table A has list of about 6
customers ID with all their details and Table B had customer is and age for
over 50 rows of customers.
I need a query that will take a customer from table a and if that customer
exists in table B then insert a yes
On Thu, Jun 14, 2018 at 23:04:24 -0500,
Bruno Wolff III wrote:
I have a perl after insert trigger for a table with a non-null column
element and I am getting an occasional error when the trigger executes
for printing a null value which is $TD->{new}{element}. However, I do
the insert with a
> "Amit" == Amit Kapila writes:
>> Presumably the problem is that the standby isn't authorized to change
>> the btree index's "entry is dead" bits,
Amit> I don't see anything like that in the code. We use _bt_killitems
Amit> to mark the items as dead and neither that function or any of i
On 17 June 2018 at 10:26, Vik Fearing wrote:
> On 17/06/18 10:05, Benjie Gillam wrote:
> > Greetings!
> >
> > How can I tell, using the system catalog or information schema, if a
> > function/procedure was created by an extension as opposed to by the user
> > (i.e. would be dropped if you perform
On 17/06/18 10:05, Benjie Gillam wrote:
> Greetings!
>
> How can I tell, using the system catalog or information schema, if a
> function/procedure was created by an extension as opposed to by the user
> (i.e. would be dropped if you performed "DROP EXTENSION")? So far I've
> looked at the `pg_exte
Greetings!
How can I tell, using the system catalog or information schema, if a
function/procedure was created by an extension as opposed to by the user
(i.e. would be dropped if you performed "DROP EXTENSION")? So far I've
looked at the `pg_extension` table, which lists the class IDs of
configura
