Description:
PGSQL Relational Database Management System.
|
|
|
Column naming standard – general opinions
|
| |
Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use lower-case letters with words separated for emphasis using the underscore character, for example: customer_num, employee_id, invoice_line, transaction_code... more »
|
|
|
Blob with OIDs and trigger
|
| |
Hi, I have create a table with this structur CREATE TABLE import ( id1 integer NOT NULL, id2 integer NOT NULL, dataset oid NOT NULL, CONSTRAINT import_pk PRIMARY KEY (id1, id2), CONSTRAINT import_fk FOREIGN KEY (id1, id1) REFERENCES ... MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE... more »
|
|
|
postgres novice list
|
| |
I asked a simple question and yet my post is not showing, it is pending approval by the list moderators. Is that list intentionally designed to be as useless as humanly possible or is that a result of somebody's valiant efforts toward that noble goal?
|
|
|
JDBS setArray
|
| |
Hello, i try to use the setArray method of postgres (8.3) JDBC driver to send data to a function. I hope I'm not off topic here with this problem. In my code I have some java.lang.Double-Arrays whitch I must convert in that way, that I can use them in the prepare-statement context with setArray. I found some information that I can convert the double Array to a... more »
|
|
|
Update on Insert
|
| |
Hi Everyone, Given a table "Items" with a PK "item1" and "Qty" - a numeric column I'd like to define a way in Postgres to insert when item11 doesn't exist already in "Items" and update the Qty by adding the new quantity to the existent when the item11 exists. What is a good approach and where should I be looking for details. Thanks.... more »
|
|
|
Can someone explain ALTER TABLE SET STATISTICS?
|
| |
The documentation of this command is extremely unclear and vague? What does the integer argument taken by this command represent? My guess is that it is determining the percentage of the table to inspect for calculating the statistics? If that is so, why is it integer?
|
|
|
disable trigger temporary
|
| |
Hello, i had written a stored procedure that works as trigger for upate and delete statements. The trigger raises an error if there is a not allowd change on the row, that's the normal way. But now I have a special stored procedure with must be update the value but the trigger needn't be called. Can I suppress on Postgres 8.3.5 for exactly one statement the... more »
|
|
|
Execution plan
|
| |
I have an unusual execution plan below. I am executing a query using the primary key and am getting sequential scan. How can I force the use of the unique index? scott=> explain analyze scott-> select ename,job from emp where empno=8000; QUERY PLAN... more »
|
|
|
can we issue an http get request from inside a pl/pgsql function?
|
| |
I've been looking for something like Oracle's utl_http.request (analagous to the unix curl ) in postresql; but there doesnt seem to be any such animal. That would be a "built in" function which, given a url, goes out the internet, fetches the response and returns it to the caller as text or a clob or an xmlType or something.... more »
|
|
|
Slony question
|
| |
I am about to start playing with Slony. For one, I have a stupid question: where does one usually install Slony? On the master or on the slave?
|
|
|
|
