Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
comp . databases . postgresql
This is a Usenet group - learn more
Find or start a Google Group about postgresql.
Group info
Group categories: Not categorized
More group info »
Related Groups
General Discussions about PostgreSQL
High activity, Usenet
PostgreSQL from an Administrative Perspective
Low activity, Usenet
How to Speed up SQL Queries and the PostgreSQL Server
Low activity, Usenet
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 462  Older »
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 »
By gargoyle60  - Nov 20 - 5 new of 5 messages    

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 »
By Philipp Kraus  - Nov 18 - 11 new of 11 messages    

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?
By Mladen Gogala  - Nov 17 - 3 new of 3 messages    

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 »
By Philipp Kraus  - Nov 17 - 3 new of 3 messages    

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 »
By SebiF  - Nov 16 - 2 new of 2 messages    

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?
By Mladen Gogala  - Nov 16 - 3 new of 3 messages    

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 »
By Philipp Kraus  - Nov 15 - 4 new of 4 messages    

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 »
By Mladen Gogala  - Nov 13 - 6 new of 6 messages    

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 »
By Lee  - Nov 12 - 3 new of 3 messages    

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?
By Mladen Gogala  - Nov 12 - 6 new of 6 messages    

1 - 10 of 462   « Newer | Older »

XML      
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google