Search Result

whsdu · Dec 13 '11, 11:34 PM

This is a really simple question and I'v been working on it for 2 hours........

The table is:

Code:

CREATE TABLE download
(
  id integer NOT NULL DEFAULT nextval('seq'::regclass),
  songid integer NOT NULL,
  counter integer NOT NULL,
  weeknumber integer NOT NULL,
  CONSTRAINT download_pkey PRIMARY KEY (id ),
  CONSTRAINT download_songid_fkey FOREIGN KEY (songid)

...

Finely · Aug 5 '11, 06:12 PM

What are the high level reasons for this assuming
we just have one database call it "test", in addition to the postgres one.

If I reload "test" from a fresh pg_dump will the
sizes be closer. Is this purely due table bloat?

What exactly is included in pg_database_siz e?

I could not find any documentation on discrepancies
between the actual size of the data directory...

kallem · Feb 28 '11, 01:46 PM

Hi kindly correct me the following code
[CREATE OR REPLACE FUNCTION dataimport()
RETURNS void AS
$BODY$
DECLARE

t_name RECORD;

BEGIN
FOR t_name IN
SELECT
c.relname
FROM
pg_catalog.pg_c lass c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
c.relkind = 'r'...

kallem · Feb 12 '11, 05:53 AM

Hi

I have one text file generated using SQLServer 2005. While I am importing the text file into one of my PostgreSQL table using "copy" it is giving me the following error:

ERROR: invalid byte sequence for encoding "UTF8": 0xff

Can any one tell me what i need to do get the data from SQLServer 2005 to PostgreSQL?

kallem · Feb 4 '11, 10:57 AM

hi,

[COPY worktrainees_hi story FROM E'C:\\bcp\\work trainees_histor y.txt' USING DELIMITERS ',' CSV]

the above command is working fine but i have more than 100 tables and related text files i wanted to run in a loop but
when i use a parameter for table name it is giving error so can any one give me example for this

kallem · Feb 2 '11, 02:09 PM

Hi,

I just want to create a stored procedure/Function which should address the following features

1. Able to connect to the SQL Server 2005
2. fetch the data from tables
3. inserting into the postgresql database

Kindly suggest me the way forward or sample procedure

ekekakos · Jul 8 '10, 11:48 AM

Hello,
I am trying to understand inheritance and how to use it with PostgreSQL. For this reason i design a database in the excel file. In the 1st columns you can see the table w/o inheritance while in the 2nd part of the sheet you can see the tables with INHERITANCE.
Can you give me your opinion and help on the following?
1. Which is the best design ( w or w/o inheritance )?
2. Is my design with inheritance good or sth...

vardhangiri · Jun 10 '10, 06:24 AM

Hi ,

I have an array that need to be split into table columns.

Ex:

test_array('{"( 1,2,3,4,5)","(1 0,20,30,40,50)" }')

test_table
col1 col2 col3 col4 col5
1 2 3 4 5
10 20 30 40 50

vardhangiri · Jun 10 '10, 05:30 AM

HI,

Im new to postgresql i have written two procedures.proc edure1 takes input from the user array of table objects and loops over them and for each row it calls the second procedure2 where the acutal filling of tables happen.

My problem here is if the user passes 10 record and if record 5 fails then all the other records should be posted to the table.

weijinxian · Mar 29 '10, 01:52 PM

I've installed postgresql from source code successfully on opensuse11.2.
and I launch gdb to debug postgresql.
when I try to "run", I get the following result:
"Starting program: /usr/local/pgsql/bin/postgres
Missing separate debuginfo for /lib64/ld-linux-x86-64.so.2
Try: zypper install -C "debuginfo(buil d-id)=591af1afa33 f255704fb6a6085 9b93d00e205302"
Missing separate debuginfo for...

wmstudio · Oct 11 '09, 09:44 PM

I have a PostgreSQL database encode in UTF-8. I try to do a mail merge from OOwriter. This seems to work except for non western characters. E.g. when I access the database from pgAdmin, a GUI client I can see all UTF-8 encoded characters. When I cut a text from the GUI and paste this text in OOwriter everything works well. The same text through a mail merge only shows question marks. An example:
---------------
เมืองไทย...

gocraig · May 20 '09, 10:45 AM

PG Admin Version 1.6.0 (Nov 15 2006, rev 5641) Running on Windows 2000
PostgreSQL 8.2.6, running remotely on Linux

pg_hba.conf contains the record ...
host all all 12.345.678.90 255.255.255.255 trust
where 12.345.678.90 is the IP address that I am trying to connect from

Database started with
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o -i start
...

Slapo · Apr 11 '09, 12:53 PM

Hello everyone,

I could use some help with this function I've created (see below) that runs flawlessly on PostgreSQL 8.3.6 on my development machine but ends with an error on the production server that has PostgreSQL 7.4.8 installed (see below).

My function:

Code:

CREATE OR REPLACE FUNCTION generate_menu(varchar(255), char(2), varchar(255), int, varchar(255), int, int, varchar(255), varchar(255)) RETURNS text AS '

...

jacinthe0020 · Feb 20 '09, 12:37 PM

Hello..

I need help on logs.. im still working on my system and finally i already have a functional system.. however i have an issue on systems logs, where i record every action the user takes...

Actually, i created a new table for logs and inserted data into it after every user's action.. but when i checked on the table's rows.. there are about 22000 results. is that a bad or good thing? is there any way i can reduce...

DarkGiank · Dec 28 '08, 07:57 AM

Hi, im new to csharp and im trying to create a class that can change the application database without no rewriting all connection code... but cause some reason it is not working... it tells me that im not creating the object but im doing it,,, please help im a newbie to c#

Code:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SQLite;
using MySql.Data;

...

Search Result

trigger function to replace insert with update

PGDATA directory 50% smaller then size give by select pg_database_size()

copy command in postgresql

sql server generated “Text File” data importing in to postgressql using copy command

How to use Copy Command in a loop?

How to write stored procedure in plpgsql to connect to the sql server 2005?

Design a database with or without inheritance

Split array data and fill the coulmns in the table

Exception handling in postgresql

missing separate debuginfo for... (postgresql installed on opensuse)

OpenOffice.org, PostgreSQL and Unicode

PGAdmin connection to PostgreSQL

Pseudo-type record seen as column by an older PostgreSQL version

Logs for PostgreSQL

PLEASE HELP ON THIS... Creating a class...