Search Discussions

26 discussions - 83 posts

  • Hello! I have a PostgreSQL (8.3.3, WinXP + linux) database with multiple schemas. I would like, on a regular basis, to be able to copy the structure and data of one schema under a new schema, using ...
    Daniel GourDaniel Gour
    Jul 29, 2008 at 1:51 pm
    Jul 31, 2008 at 12:59 am
  • I have received a collection of scripts to be used to build a PostgreSQL db and I can't figure out the following. 1. Usage of quotes in the scripts. The following comes from a script to build and ...
    Jul 14, 2008 at 3:28 pm
    Jul 24, 2008 at 12:51 pm
  • Is there a way to hide/encrypt the source for functions I might write in any of the procedural languages? Doing \df+ <func shows all of it.
    Wright, GeorgeWright, George
    Jul 10, 2008 at 3:48 pm
    Jul 11, 2008 at 5:53 pm
  • I get this message when it fails to create a new database encoding UTF8 does not match server's locale sv_SE.iso88591 when trying to create a database with the createdb command and the parameter " -E ...
    A BA B
    Jul 2, 2008 at 1:52 pm
    Jul 2, 2008 at 5:01 pm
  • Hello, I am running some queries that use multiple connections to issue COPY commands which bring data into the same table via different files (FIFOs to be precise). This is being done on a SMP ...
    Phillip SitbonPhillip Sitbon
    Jul 2, 2008 at 4:44 pm
    Jul 9, 2008 at 5:07 pm
  • Hi list, I need to know whether a repeating event occurs or not on a particular day. I currently have the following information: date of first occurrence (date) repeat frequency (interval) date to ...
    Jul 2, 2008 at 11:01 am
    Jul 3, 2008 at 11:08 am
  • I've been tracking down a problem with idle transactions being left open and not being able to vacuum one of my tables. I think I have tracked it down to proprietary app, the problem seems to be that ...
    David GardnerDavid Gardner
    Jul 18, 2008 at 2:48 am
    Jul 18, 2008 at 5:14 am
  • Hello If you use Perl (like me) I have made a very nice set of small programs to access any database, any table and add, change or delete data. I like it better than using Webmin or PgAdmin because I ...
    Jul 10, 2008 at 2:38 pm
    Aug 11, 2008 at 5:47 am
  • Hi All, I have a client application that uses an 8 bit character set that is not supported by Postgresql. I'm using UTF-8 to store data within my database and would like to create a character set ...
    Bastiaan OlijBastiaan Olij
    Jul 21, 2008 at 6:48 am
    Jul 24, 2008 at 2:03 am
  • Hi list, I am dumping a series of data. Basically I'm migrating the tables from one database to another. However, I wanted the transaction to stop immediately as soon as the error below occurs: ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jul 17, 2008 at 5:16 am
    Jul 21, 2008 at 1:37 am
  • I'm passing some information to postges (from gambas basic), which gets the data from date type eg date1 as date date2 as date (IN the postgres database the default on the date field is null) my ...
    Richard terryRichard terry
    Jul 17, 2008 at 10:20 pm
    Jul 18, 2008 at 12:59 am
  • Hello, i have several machines having the same database layout. Now i want import data from a remote machine. I tried something like this: CREATE OR REPLACE FUNCTION import_sc(text) RETURNS int4 AS ...
    Schoenit, Tobias AT/BHL-ZTPSSchoenit, Tobias AT/BHL-ZTPS
    Jul 11, 2008 at 12:05 pm
    Jul 11, 2008 at 2:10 pm
  • I want to delete a table and get the message ERROR: cannot drop table dummyblabla because other objects depend on it HINT: Use DROP ... CASCADE to drop the dependent objects too. Cascading is a ...
    Emil ObermayrEmil Obermayr
    Jul 7, 2008 at 8:47 am
    Jul 9, 2008 at 7:13 am
  • I am trying to create a new Tablespace without success. I am using PostgreSQL 8.3 and pgAdmin III v1.8.2 in a Windows XP Professional environment with the following steps: 1. I create an empty ...
    Jul 24, 2008 at 5:07 pm
    Jul 24, 2008 at 5:14 pm
  • Hi list, I've having a dilemma here. My problem here is that I'm getting maxed out of my connection. My max connection is set to 100. I don't know if setting the max connection higher is the right ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jul 11, 2008 at 7:34 am
    Jul 11, 2008 at 4:22 pm
  • A more generic-SQL question if I could. Say I have a table foo with a column insert_date of type DATE. What I'd like to do is define a view that works like this: CREATE OR REPLACE VIEW vw_foo AS ...
    Brian HurtBrian Hurt
    Jul 10, 2008 at 3:12 pm
    Jul 10, 2008 at 3:32 pm
  • Hi, This is Selva from India. Actually my application is using the postgres 7.2.4 as backend. Around 8 client consoles will be connecting and making the transactions to one of the tables in the ...
    Selvakaruppiah s-TLS,ChennaiSelvakaruppiah s-TLS,Chennai
    Jul 9, 2008 at 6:14 am
    Jul 9, 2008 at 6:54 am
  • This email is subject to a disclaimer which may be found by connecting to www.medscheme.co.za and clicking on the "Terms of Use" link. Alternatively, the disclaimer can be emailed to you by sending a ...
    Marc AbbottMarc Abbott
    Jul 8, 2008 at 4:29 am
    Jul 8, 2008 at 11:27 am
  • Hi, I'm using gambas to save some data to the database, and use the date from a textbox to write to the database in format 'dd/mm/yyyy', however when I look at the database using pgadmin3 , the date ...
    Richard terryRichard terry
    Jul 3, 2008 at 5:38 am
    Jul 3, 2008 at 10:27 am
  • Hi all, I have a weird problem. When I'm describing a table, I can see its table structure. However, when I try to drop/select the table. It says that the table doesn't exist. I checked the rights of ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jul 2, 2008 at 8:54 am
    Jul 2, 2008 at 3:26 pm
  • Hi All, I checked the file size of my database and it's 115GB. I already figured out which tables suck up all the space and I decided to delete all the entries in them. But still after emptying ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jul 1, 2008 at 3:19 am
    Jul 1, 2008 at 4:01 am
  • Thank you for your input, but I was looking for was a solution to copy all of the database objects (table, indexes, functions, etc) (and their data) that are under one schema and copy them into ...
    Daniel GourDaniel Gour
    Jul 30, 2008 at 1:10 pm
    Jul 30, 2008 at 1:10 pm
  • Hi guys, I am a new user from PostgreSQL. I am trying to configure the PostgreSQL on my OpenSolaris 2008.05 so i want to know if you know some links, articles or tutorials about the first steps on ...
    Leví Teodoro da SilvaLeví Teodoro da Silva
    Jul 14, 2008 at 2:30 pm
    Jul 14, 2008 at 2:30 pm
  • Hi, I was going through the various performance tweaking documents pointed out by various people on this mailing list last month. I was hoping I could do a quick spot-check, and get your expert ...
    Ram RavichandranRam Ravichandran
    Jul 8, 2008 at 7:45 pm
    Jul 8, 2008 at 7:45 pm
  • Hello. I am trying to create a function in plpgsql, but I got stuck on one issue, looking for some clues. Inside the function I have 4 variables of type boolean: a1 boolean; a2 boolean; a3 boolean; ...
    Jul 4, 2008 at 12:45 pm
    Jul 4, 2008 at 12:45 pm
  • Hello! I just installed 8.3 with WAL enabled. But I can't understand why postgres generated many archive logs during vacuum, if WAL is enabled. Could you explain? Thank you!
    Dmitry MelekhovDmitry Melekhov
    Jul 3, 2008 at 8:28 am
    Jul 3, 2008 at 8:28 am
Group Navigation
period‹ prev | Jul 2008 | next ›
Group Overview
grouppgsql-novice @

39 users for July 2008

Tom Lane: 12 posts Ridvan Lakas ng Bayan S. Baluyos: 5 posts Wright, George: 5 posts Daniel Gour: 4 posts A B: 3 posts Mark Roberts: 3 posts Netzach: 3 posts Obe, Regina: 3 posts Phillip Sitbon: 3 posts Richard terry: 3 posts Alan Hodgson: 2 posts Andrej Ricnik-Bay: 2 posts Bastiaan Olij: 2 posts David Gardner: 2 posts Emil Obermayr: 2 posts Frank Bax: 2 posts John DeSoi: 2 posts Schoenit, Tobias AT/BHL-ZTPS: 2 posts Sean Davis: 2 posts Stephan Szabo: 2 posts
show more