July 2008

Discussions Analytics Info

Search Discussions

26 discussions - 83 posts

Newest Active Popular

9
How to copy a schema under another name in same database

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 Gour
Jul 29, 2008 at 1:51 pm
Jul 31, 2008 at 12:59 am
5
Two novice questions

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 ...

Wm.A.Stafford
Jul 14, 2008 at 3:28 pm
Jul 24, 2008 at 12:51 pm
5
function source

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, George
Jul 10, 2008 at 3:48 pm
Jul 11, 2008 at 5:53 pm
5
encoding problem when creating a database

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 B
Jul 2, 2008 at 1:52 pm
Jul 2, 2008 at 5:01 pm
4
Concurrent COPY commands

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 Sitbon
Jul 2, 2008 at 4:44 pm
Jul 9, 2008 at 5:07 pm
4
Calculating repeating events - functionality lost with the demise of tinterval ?

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 ...

Netzach
Jul 2, 2008 at 11:01 am
Jul 3, 2008 at 11:08 am
3
tracking down idle transactions in pg_locks

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 Gardner
Jul 18, 2008 at 2:48 am
Jul 18, 2008 at 5:14 am
2
For Perl users - hope it helps somebody

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 ...

Leo
Jul 10, 2008 at 2:38 pm
Aug 11, 2008 at 5:47 am
2
Character set conversion

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 Olij
Jul 21, 2008 at 6:48 am
Jul 24, 2008 at 2:03 am
2
Stopping a transaction as soon as an error occurs

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. Baluyos
Jul 17, 2008 at 5:16 am
Jul 21, 2008 at 1:37 am
2
updating table where one date field is null

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 terry
Jul 17, 2008 at 10:20 pm
Jul 18, 2008 at 12:59 am
2
Dataimport from remote db

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-ZTPS
Jul 11, 2008 at 12:05 pm
Jul 11, 2008 at 2:10 pm
2
how to get dependancies of a table?

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 Obermayr
Jul 7, 2008 at 8:47 am
Jul 9, 2008 at 7:13 am
1
CANNOT CREATE A TABLESPACE

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 ...

JORGE MALDONADO
Jul 24, 2008 at 5:07 pm
Jul 24, 2008 at 5:14 pm
1
Number of postgres connections

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. Baluyos
Jul 11, 2008 at 7:34 am
Jul 11, 2008 at 4:22 pm
1
SQL "pseudo-variables" for a view

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 Hurt
Jul 10, 2008 at 3:12 pm
Jul 10, 2008 at 3:32 pm
1
[Problem] - Error: cannot open pg_class_oid_index: Permission denied

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,Chennai
Jul 9, 2008 at 6:14 am
Jul 9, 2008 at 6:54 am
1
Object Privileges

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 Abbott
Jul 8, 2008 at 4:29 am
Jul 8, 2008 at 11:27 am
1
date formatting question

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 terry
Jul 3, 2008 at 5:38 am
Jul 3, 2008 at 10:27 am
1
Table exists but can't drop.

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. Baluyos
Jul 2, 2008 at 8:54 am
Jul 2, 2008 at 3:26 pm
1
Slow Query and Big File Size even after emptying

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. Baluyos
Jul 1, 2008 at 3:19 am
Jul 1, 2008 at 4:01 am
0
Re: How to copy a schema under another name in same database

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 Gour
Jul 30, 2008 at 1:10 pm
Jul 30, 2008 at 1:10 pm
0
[PostgreSQL with OpenSolaris]Configuration

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 Silva
Jul 14, 2008 at 2:30 pm
Jul 14, 2008 at 2:30 pm
0
parameters in pg_conf

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 Ravichandran
Jul 8, 2008 at 7:45 pm
Jul 8, 2008 at 7:45 pm
0
how to create a function in plpgsql which picks the name of a variable which is NULL out of a list of variables?

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; ...

Miernik
Jul 4, 2008 at 12:45 pm
Jul 4, 2008 at 12:45 pm
0
please explain vacuum with WAL

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 Melekhov
Jul 3, 2008 at 8:28 am
Jul 3, 2008 at 8:28 am