Related
Martin K We have a large table in a Postgres production database and we want to start "sharding" using external tables and inheritance. The required architecture would be to have 1 (empty) table (defining the schema) and several external tables that inherit fr
Jeff G I have a partitioned table (call it A) with a serial primary key that is referenced by another table (call it B). I know that I can't actually create foreign keys from one to the other (since I don't know on which partition the data is actually stored),
Jeff G I have a partitioned table (call it A) with a serial primary key that is referenced by another table (call it B). I know that I can't actually create foreign keys from one to the other (since I don't know on which partition the data is actually stored),
Jeff G I have a partitioned table (call it A) with a serial primary key that is referenced by another table (call it B). I know that I can't actually create foreign keys from one to the other (since I don't know on which partition the data is actually stored),
Jeff G I have a partitioned table (call it A) with a serial primary key that is referenced by another table (call it B). I know that I can't actually create foreign keys from one to the other (since I don't know on which partition the data is actually stored),
Dopma I want to do bulk inserts in my postgreSQL database. Database not yet online PostgreSQL 13 I have a temporary temp table where I can bulk insert data TABLE public.temp_inverter_location
(
id integer ,
inverter_num_in_sld integer,
lift_require
Jeff G I have a partitioned table (call it A) with a serial primary key that is referenced by another table (call it B). I know that I can't actually create foreign keys from one to the other (since I don't know on which partition the data is actually stored),
Anthony Horne I'm having trouble getting the correct set of DIVs for the content in the table. Apparently the table version cannot be "scaled" or resized. I'm a developer and old school, so I use Tables (the working part of the brain that knows how to format t
Anthony Horne I'm having trouble getting the correct set of DIVs for the content in the table. Apparently the table version cannot be "scaled" or resized. I'm a developer and old school, so I use Tables (the working part of the brain that knows how to format t
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
plunder A has two model tables that contain data. class A(models.Model):
id = models.PositiveIntegerField(primary_key=True)
#some other fields
other_id = models.IntegerField(default=0, null=True)
and the second shift class B(models.Model):
id
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
amir_70 I have two tables "teams" and "matches". Each team can play in a different game, and each game contains two or more teams, so it's a many-to-many relationship. Here is my contest model: class Match(models.Model):
result = models.CharField(max_lengt
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Junius Brutus I have a reference table that says it OrderTypecollects different types of orders: CREATE TABLE IF NOT EXISTS OrderType (name VARCHAR);
ALTER TABLE OrderType ADD PRIMARY KEY (name);
INSERT INTO OrderType(name) VALUES('sale-order-type-1');
INSERT
dye I have 2 tables: Product (prod_id, prod_name, vendor_id) Vendor (vend_id, vend_name, vend_state) I'm trying to make a query that will give me a list vend_nameof every supplier that offers only one product . vend_idis a foreign key Productand I want to see
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Sean Wilson Other fields of my Access database MainTableinclude Event Description. I get event description from another table EventTablewith two fields , EventIDandEvent Description My form has a combo box that lets the user select an "event description" and i
Mr. Lister I am trying to create two foreign keys in a mysql (SQLLITE) table and I am getting the following error: 'SQL logic error or missing database near "id_value": syntax error'
This is the error creating the table sql string: 'Exception in 'Create_T
Avartiai I am following the Postgres documentation https://www.postgresql.org/docs/8.2/xfunc-c.html to write a C function and create an extension (for hierarchical clustering) and I am confused. So I can do this by usingHeapTupleHeader t = PG_GETARG_HEAPTUPLEH
Avartiai I am following the Postgres documentation https://www.postgresql.org/docs/8.2/xfunc-c.html to write a C function and create an extension (for hierarchical clustering) and I am confused. So I can do this by usingHeapTupleHeader t = PG_GETARG_HEAPTUPLEH
Avartiai I am following the Postgres documentation https://www.postgresql.org/docs/8.2/xfunc-c.html to write a C function and create an extension (for hierarchical clustering) and I am confused. So I can do this by usingHeapTupleHeader t = PG_GETARG_HEAPTUPLEH