Tagged Questions
-2
votes
0answers
6 views
Postgresql implementation of data model
I am trying to understand the Postgresql implementation of the relational data model. Could anyone provide a high-level explaination of how its primitives (schemas, attributes, tuples) and operations ...
0
votes
1answer
489 views
Execute triggers function of another schema on the actual chema
my problem is easy to explain with an example: I have a 'common' schema (the public one?) where I store common data between a clustered application.
For every instance of my application, I have a ...
-2
votes
2answers
55 views
how to have a unique calendar entity for each user entity?
I am writing an application which will extensively use calendar for storing the daily information on various things, for each entity. Now how do I make a new calendar for each entity. Do I make a ...
0
votes
2answers
45 views
A better database model for holding postage prices
I wanted to create a Postage_costs table to hold postages costs, each postage_cost has a name, e.g Large Item, which has different costs(standard price and express postage price) depending on ...
2
votes
2answers
328 views
“ERROR: extra data after last expected column” when using PostgreSQL COPY
Please bear with me as this is my first post.
I'm trying to run the COPY command in PostgreSQL-9.2 to add a tab delimited table from a .txt file to a PostgreSQL database such as:
COPY raw_data FROM ...
0
votes
2answers
22 views
How to revoke right to a usergroup on a certain date in postgresql?
I'm currently creating a DB with Postgresql. First time, be gentle. ;)
I have a table project that stores submission date among other things.
I have 2 groups of users. One can only consult the ...
-2
votes
1answer
26 views
Insert User in localhost in PostgreSQL [closed]
I am creating databases in MySQL and PostgreSQL. When I am going to create a user that only can work in localhost (like MySQL with: create user 'X'@'localhost'), I can't do it. Is there any way to ...
1
vote
3answers
447 views
How to prevent inserts in a table?
There is a table t which has inherited children. I want that only the children can receive inserts. What is the best way to force that the parent table rejects inserts?
create table t (c int);
create ...
-1
votes
0answers
37 views
Where Actually the MONGO DB suite in a project? [closed]
Is MongoDB is better for Unstructured data when compared to Postgresql ??
If so How MOngo DB is plus ??
In which aspects should we use Mongo DB and Postgresql ??
0
votes
1answer
31 views
PostgreSQL - set a default cell value according to another cell value
If i have a column say column a of any given values, and i want another column column b to have a default value according to the value of column a
In another words:
if column a = 'peter' then column ...
1
vote
1answer
40 views
Converting an logical model to a physical model. Trouble understanding ERD
I'm working with an ERD. It is supposedly a logical model and I am supposed to make a physical model from it. I should be formatting in UML and our DBMS is PostgreSQL.
Some of my research ...
1
vote
2answers
25 views
Rails Database Design with Similar models with different attributes
I am designing an application that has many types of "requests" the requests are to be handled in a very similar nature to one another but they contain different data.
They each have about 1/3 of the ...
0
votes
1answer
39 views
Database Design - Party Object Model and Relating Index's correctly [closed]
Im a developer by trade and I am currently dabbling in database design.
I have been advised on StackOverflow to use the Party Model to achieve the ability to relate customers that may be people or ...
3
votes
3answers
1k views
Design Relational Database - Use hierarchical datamodels or avoid them?
I'm designing a Database and I have some doubts on using Hierarchical datamodels in relational databases.
If I want to deal with categories, subcategories and parent categories it is possible not to ...
3
votes
4answers
58 views
Is it possible to use a PG sequence on a per record label?
Does PostgreSQL 9.2+ provide any functionality to make it possible to generate a sequence that is namespaced to a particular value? For example:
.. | user_id | seq_id | body | ...
...
