Search Discussions

47 discussions - 193 posts

  • Hi list, I'm asking myself what solution for storing pictures is the best: * using a BYTEA column type, and having no intrinsic compression gain because a picture it almost every time already ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Nov 26, 2009 at 2:45 pm
    Nov 29, 2009 at 2:31 pm
  • Here is record of my attempt to do the install! I've used several sets of instructions for installing from src, mainly http://zanshin.net/2009/09/07/installing-postgresql-on-mac-10-6-snow-leopard/ ...
    Don FoxDon Fox
    Nov 1, 2009 at 5:18 pm
    Nov 4, 2009 at 9:18 am
  • How do I use the functions to get data from sequence objects? For example, I need to know what is the value of a serial field after inserting a new record; the one assigned to the record just ...
    Nov 2, 2009 at 7:16 pm
    Nov 4, 2009 at 12:03 am
  • Hi, I've got some questions: 1)- I'd like to keep a table in one piece, but it'll be huge (several millions rows and growing); can a segmentation of indexes (all indexes that are used for searching) ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Nov 26, 2009 at 10:19 pm
    Nov 27, 2009 at 3:05 pm
  • I'm confused about permissions to use lo_import/export: Docs say this: test= CREATE TABLE fruit (name CHAR(30), image OID); CREATE test= INSERT INTO fruit test- VALUES ('peach', ...
    Richard terryRichard terry
    Nov 23, 2009 at 11:14 am
    Nov 25, 2009 at 3:53 am
  • Hi, I have a PostgreSQL DB created by a Django model, with a field 'id' that is automatically created by Django as a primary key, type integer. I would like to create a new row by doing something ...
    Ken MacDonaldKen MacDonald
    Nov 19, 2009 at 5:02 pm
    Feb 23, 2011 at 10:43 am
  • I'd like to use an integer column (16 bits will suffice) to hold a bit-field. I'd like to be able to efficiently count the number of bits set in this field. Is there a built-in function call I can ...
    Nathaniel TrelliceNathaniel Trellice
    Nov 24, 2009 at 3:53 pm
    Nov 26, 2009 at 2:27 pm
  • I have a table with values similiar to this (I have reduced the number of rows from the actual table): played | stats_exists --------+-------------- t | t t | f t | t t | t f | t t | t t | f What I ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 20, 2009 at 2:18 pm
    Nov 20, 2009 at 4:18 pm
  • Would anyone know if 8.38 - 8.5 is anticipated to be ok - or will it be recommended to 8.38 - 8.41 - 8.5 (when available). Thanks -- Mike Ellsworth
    Mike EllsworthMike Ellsworth
    Nov 17, 2009 at 1:35 pm
    Nov 17, 2009 at 11:54 pm
  • I have the following table: CREATE TABLE penalty_codes ( penalty_code varchar(10), penalty_name varchar(32), penalty_name_sv varchar(40), penalty_id serial PRIMARY KEY ); which I have been using for ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 12, 2009 at 11:53 am
    Nov 16, 2009 at 7:48 am
  • I recently installed PostgreSQL 8.2.11-1 on my Windows machine for use with my java application. I need to get a list of the databases available so that the user can choose one. Issuing a query of ...
    Christopher FrankChristopher Frank
    Nov 2, 2009 at 7:13 pm
    Nov 2, 2009 at 9:11 pm
  • Does postgresql have any kind of internal time stamps for a table entry? I can create a field that is 'timestamp' and store it there, I was just wondering if it was already done internally. I'd hate ...
    Nov 24, 2009 at 6:26 pm
    Nov 26, 2009 at 3:51 am
  • I verified that the DatabaseMetaData.getCatalogs() only returns a ResultSet with the currently connect database rather than all of the databases in the PostgreSQL cluster. I see there was a previous ...
    Richard BroersmaRichard Broersma
    Nov 3, 2009 at 5:37 pm
    Nov 3, 2009 at 6:40 pm
  • Hello, I'd appreciate advice anyone can offer on this simple, newbie question. It really is a straightforward question, so please bare with me if I don't explain it succinctly below. I want to search ...
    Nathaniel TrelliceNathaniel Trellice
    Nov 27, 2009 at 11:04 am
    Nov 27, 2009 at 3:16 pm
  • (Postgres version 8.2.4) Trying to understand GROUP BY, I'm reading on <http://www.postgresql.org/docs/8.4/interactive/queries-table-expressions.html . Consider this query: = select x, sum(y) from ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 25, 2009 at 7:20 pm
    Nov 26, 2009 at 1:14 am
  • Hi list, I can't solve what should be a trivial problem: I don't want users to have direct access to tables (no direct inserts, updates & deletes), so I use views and functions for that. My PB is I ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Nov 21, 2009 at 4:08 pm
    Nov 21, 2009 at 11:35 pm
  • Hey all, http://pastebin.com/f1015226d The above function appears to be doing exactly what I want: Fetch the users data and update the visits column, if the supplied credentials match a user. My ...
    Thomas LøckeThomas Løcke
    Nov 18, 2009 at 3:52 pm
    Nov 20, 2009 at 9:48 am
  • Hi. If I use the following snippet EXTRACT (hour FROM timestamp) || ':' || EXTRACT (minute FROM timestamp) AS this_time I get single digit figures returned for minutes less than 10, resulting in the ...
    Mark KellyMark Kelly
    Nov 19, 2009 at 12:22 am
    Nov 19, 2009 at 1:14 am
  • Hey all, I'm in the process of building a web-application, where some basic user management is necessary. This is not the first time I've done this, but those I've made earlier have all been for ...
    Thomas LøckeThomas Løcke
    Nov 6, 2009 at 8:53 am
    Nov 10, 2009 at 10:15 am
  • Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 I am hoping that I am posting this question to the properlist. I inherited a team of programmers that have theresponsibility ...
    Bob VanslobigBob Vanslobig
    Nov 5, 2009 at 6:14 pm
    Nov 7, 2009 at 8:36 am
  • I have a case where I want to forbid a race condition. Basically, I have this: $q = "CREATE VIEW foo AS ( SELECT * FROM foo WHERE [...different conditions every call ...] )"; @pg_query($db, $q); $q = ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 30, 2009 at 9:32 am
    Nov 30, 2009 at 8:07 pm
  • Dear List, I just installed postgis and am trying to work through the Introduction to Postgis workhop at http://2007.foss4g.org/workshops/W-04/PostGIS%20Workshop.doc#_Toc177458966 I have postgis and ...
    Tim ClarkTim Clark
    Nov 29, 2009 at 4:57 am
    Nov 29, 2009 at 7:24 am
  • Consider these two separate queries that returns the amount of shots - periodwise - for a hockey team over a season: gik=# SELECT period_num, sum(shots_teama) AS shots_home gik-# FROM periods gik-# ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 26, 2009 at 1:22 am
    Nov 26, 2009 at 5:00 am
  • Greetings. I am having a problem dividing a sum by a count and end up with zero, however I am able to multiply, subtract and add. Here are samples of the two views: View that groups individuals into ...
    Dara OlsonDara Olson
    Nov 25, 2009 at 7:56 am
    Nov 25, 2009 at 1:51 pm
  • I was trying to find the packaged version of pljava for postgresql 8.4.1, no luck. Compilation from the source code is also a problem, there is no "configure" utility, it's a manual process. Does ...
    Mladen GogalaMladen Gogala
    Nov 24, 2009 at 4:28 pm
    Nov 24, 2009 at 5:31 pm
  • Hey all, First I'd like to thank Jasen Betts and Michael Wood for the advice they gave me regarding my user management table design. Next I'd like some feedback on my first PL/pgSQL function: ...
    Thomas LøckeThomas Løcke
    Nov 17, 2009 at 2:55 pm
    Nov 18, 2009 at 4:45 pm
  • I'm having a simple table for managing hit counts on WWW. The table was setup some year ago using this: CREATE TABLE hit_counts ( page varchar(255), hits integer, last_visit timestamp, id serial ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 10, 2009 at 11:29 am
    Nov 11, 2009 at 12:26 am
  • Hi, Many times after I start the db (/etc/init.d/postgresql), the second I access it I get *"FATAL: the database system is starting up"* Is there a natural way (any cli command or other) to check ...
    Victor JasonVictor Jason
    Nov 1, 2009 at 11:01 am
    Nov 9, 2009 at 9:58 am
  • I am having problems installing Postgre 8.1.11 into Windows 7 64-bit. I can not get the service to start properly. I was successful installing this version if Vista 64-bit and Windows 7 32-bit. Are ...
    Nov 4, 2009 at 3:56 pm
    Nov 4, 2009 at 8:39 pm
  • Reading through 'Anonymous Code Blocks' and DO statement to be in 8.5 & it isn't clear to me if user expressions could take advantage of it - or not. If I wanted to use this new feature in user ...
    Mike EllsworthMike Ellsworth
    Nov 23, 2009 at 3:02 pm
    Nov 25, 2009 at 11:42 pm
  • Hello, My name is Zsolt and I would like to ask for some advice, because I'm novice in this topic. We would like to install our webpage based on postgresql to our server. We have the following ...
    Démi ZsoltDémi Zsolt
    Nov 20, 2009 at 8:50 pm
    Nov 21, 2009 at 12:12 am
  • Hi All, Is it possible possible to use a file's data as an argument to one of PostgreSQL's functions via the psql command line? For example - I know I can do this: select ...
    Mazen Abdel-RahmanMazen Abdel-Rahman
    Nov 19, 2009 at 4:14 am
    Nov 19, 2009 at 10:45 am
  • I am new to the list, it is my turn to introduce myself. My company decided to do a pilot project with Postgres and here I am. I have approximately 4 weeks of experience with PgSQL and 20 years of ...
    Mladen GogalaMladen Gogala
    Nov 18, 2009 at 8:23 pm
    Nov 18, 2009 at 8:33 pm
  • Hi List, This should be really simple but I can't find the syntax. I add/alter columns/types/defaults etc all the time but I just went to add a comment to a column and couldn't find any syntax for ...
    Richard terryRichard terry
    Nov 16, 2009 at 10:25 pm
    Nov 16, 2009 at 10:34 pm
  • Hi, Is there any built-in support in Postgresql to calculate and verify a checksum of the data read to and from the disc? I found some posts regarding this that said there was some code developed. ...
    Henrik JönssonHenrik Jönsson
    Nov 12, 2009 at 1:43 pm
    Nov 12, 2009 at 2:44 pm
  • On Windows (Windows Server 2008), I create a file using a tool (Data Generator for PostgreSQL), and then try to execute the script using: psql --file="C:\PDS\TestData\populate_companies.sql" ...
    John LynnJohn Lynn
    Nov 9, 2009 at 3:24 pm
    Nov 9, 2009 at 3:29 pm
  • I have two machines bonny and clide which share a NFS disk (which contains the postgres binarys) bonny is running a postgres database 'testdb' on a local disk using the binarys on the NFS disk ...
    Michael LushMichael Lush
    Nov 6, 2009 at 3:36 pm
    Nov 6, 2009 at 4:44 pm
  • Hello list I just noticed a strange quirk of plpgsql. It gave me an error when trying to access a member of a complex field in NEW. Error reported was: "ERROR: NEW used in query that is not in a ...
    Alex du PlessisAlex du Plessis
    Nov 4, 2009 at 3:06 pm
    Nov 6, 2009 at 3:35 pm
  • Hello, FULL JOIN requiring merge-joinable conditions has been covered previously in http://archives.postgresql.org/pgsql-sql/2006-01/msg00080.php for a different application; here is a new context in ...
    John KoerberJohn Koerber
    Nov 5, 2009 at 9:55 pm
    Nov 5, 2009 at 10:14 pm
  • I am trying to write a plugin (for REALbasic) in C using Xcode on Mac OS X. I have succeeded except that my plugin depends on dylibs that must be installed on each client machine. I'd like to create ...
    Peter K. StysPeter K. Stys
    Nov 3, 2009 at 2:07 am
    Nov 3, 2009 at 3:43 am
  • Debian PG 8.4.1-1 ================== Hi, As pg_dump now takes care of tables order, can I be sure by disabling foreign keys constraint @restore that restores won't need any manual intervention? JY -- ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Nov 30, 2009 at 2:51 pm
    Nov 30, 2009 at 2:51 pm
  • sorry, just have faulty memory from doing it months ago with both derbydb and postgresql as alternative drivers. Derbydb was the one that preferred intermediate files for bulk loading of binary stuff ...
    Syan TanSyan Tan
    Nov 29, 2009 at 11:29 am
    Nov 29, 2009 at 11:29 am
  • I'm running a hockey player database and I'm building up statistics about player penalties. I extract the penalties like this: SELECT P.playerid, T.number, count(P.playerid) AS num_penalties, ...
    Rikard BosnjakovicRikard Bosnjakovic
    Nov 27, 2009 at 7:05 pm
    Nov 27, 2009 at 7:05 pm
  • Hi, Knowing all fields can be selected, is there a difference making a view that references all fields one by one and a view with a "select *"? -- "I don't mind going nowhere as long as it's an ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Nov 27, 2009 at 3:19 pm
    Nov 27, 2009 at 3:19 pm
  • Hi, Many times after I start the db (/etc/init.d/postgresql start), the second I access it I get *"FATAL: the database system is starting up"* Is there a natural way (any cli command or other) to ...
    Victor JasonVictor Jason
    Nov 4, 2009 at 6:20 am
    Nov 4, 2009 at 6:20 am
  • Is there a proper way to determine if a postgres database (8.2) is in recovery mode? (I'm looking at making a backup database that updates nightly (as a protection vs brainstorm) and want to shut it ...
    Michael LushMichael Lush
    Nov 3, 2009 at 6:41 pm
    Nov 3, 2009 at 6:41 pm
  • I recently installed PostgreSQL 8.2.11-1 on my Windows machine for use with my java application. I need to get a list of the databases available so that the user can choose one, but issuing a query ...
    Christopher FrankChristopher Frank
    Nov 2, 2009 at 3:49 pm
    Nov 2, 2009 at 3:49 pm
Group Navigation
period‹ prev | Nov 2009 | next ›
Group Overview
grouppgsql-novice @

58 users for November 2009

Tom Lane: 20 posts Jean-Yves F. Barbier: 17 posts Rikard Bosnjakovic: 11 posts Jasen Betts: 9 posts Richard Broersma: 9 posts Michael Wood: 8 posts Don Fox: 7 posts Thom Brown: 7 posts Richard terry: 6 posts Syan Tan: 6 posts Josh Kupershmidt: 5 posts Nathaniel Trellice: 5 posts Christopher Frank: 4 posts Michael Lush: 4 posts Brian Modra: 3 posts Brian Modra: 3 posts Didier Gasser-Morlay: 3 posts Greg Stark: 3 posts Kris Kewley: 3 posts Mark H. Nichols: 3 posts
show more