Forum: PostgreSQL / PGSQL

Hi all, I have a field that I'll be ordering and I noticed that ordering is done logically and would confuse my users here (1,12,16,4,8, etc). ...

Hi list: Recently I installed postgresql 8.0, marvellous; and I've been studying the tutorial. I got stuck in chapter 2 "The SQL languaje". There,...

Ive noticed what seems to be an odd effect in psql 7.3. It works like this: 1> Create a table: CREATE TABLE foo ( sval serial, uval int...

Are there any differences between text and varchar? I found the following in the docs, which leads me to believe that there are no differences at...

Have a winXP machine with the above program installed, however, the service will not start, even when logged in as administrator. Need a step by...

This one must be obvious for most here. I have a 170 million rows table from which I want to eliminate duplicate "would be" keys and leave only...

Hello everyone, I'm building a postgresql db which will have to get lots of data from "the outside" (customers, that is). The db has lots of...

I have need to set up a 2nd database server for a client in their new offices in another state this month. We will be shutting down the old...

On Fri, 4 Feb 2005 09:44:15 +0100, Victor Spång Arthursson <victor@tosti.dk> wrote: Can you send the table structure and the query that does...

The underground ballot-stuffing team is going to *FUCK* *UP* the vote, and sway the outcome in whatever direction we choose............. once...

Pgpool 2.5b2 supports "master slave mode" which can cope with master/slave replication softwares such as Slony-I. In this mode pgpool sends non...

Hi all, Does anyone know if PostgreSQL got a function which work like load_file() of mySQL? I need it for uploading of big files... i encounter...

you are perfectly right, fixing the source of the problem is the best way to fix this. i always make it a habit to close my connections as soon as...

Dear list, I have a problem starting PG 8.0 on a OSX machine, getting this FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission...

Hi, Is there a replication solution for PostgreSQL? I learnt Slony 1 is for Linux OS. Also, has anyone used the tablellog contrib in Windows...

This is know issue with OIDS. You,probably, needed to apply regprocedure_7.4.patch.gz patch from...

"Mike Cox" <mikecoxlinux@yahoo.com> wrote in message news:m33bwdazgz.fsf@linux.local... wrote: Usenet Then take in to PGSQL* where it is...

Got it fixed. As it happens, there's an "untsearch2.sql" script in the contrib directory. Removing the transaction block around it allowed it to...

Joseph Kiniry <kiniry@acm.org> writes: Sure, just run the CREATE VIEW command executed by initdb; it's in the initdb shell script. Note that all...

"Andrew Hall" <temp02@bluereef.com.au> writes: Could we see the exact log trace, rather than handwaving? Also the schemas of the...