Search Result

Collapse
16 results in 0.0015 seconds.
Keywords
Members
Tags
postgresql
  •  

  • whsdu
    started a topic trigger function to replace insert with update

    trigger function to replace insert with update

    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)
    ...
    See more | Go to post

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

    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...
    See more | Go to post

  • kallem
    started a topic copy command in postgresql

    copy command in postgresql

    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'...
    See more | Go to post

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

    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?
    See more | Go to post

  • kallem
    started a topic How to use Copy Command in a loop?

    How to use Copy Command in a loop?

    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
    See more | Go to post

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

    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
    See more | Go to post

  • Design a database with or without inheritance

    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...
    See more | Go to post

  • Split array data and fill the coulmns in the table

    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
    See more | Go to post

  • vardhangiri
    started a topic Exception handling in postgresql

    Exception handling in postgresql

    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.
    See more | Go to post

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

    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...
    See more | Go to post

  • wmstudio
    started a topic OpenOffice.org, PostgreSQL and Unicode

    OpenOffice.org, PostgreSQL and Unicode

    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:
    ---------------
    เมืองไทย...
    See more | Go to post

  • gocraig
    started a topic PGAdmin connection to PostgreSQL

    PGAdmin connection to PostgreSQL

    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
    ...
    See more | Go to post

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

    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 '
    ...
    See more | Go to post

  • jacinthe0020
    started a topic Logs for PostgreSQL

    Logs for PostgreSQL

    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...
    See more | Go to post

  • DarkGiank
    started a topic PLEASE HELP ON THIS... Creating a class...

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

    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;
    ...
    See more | Go to post
Working...