The postgresql-8.4 tag has no wiki summary.
0
votes
0answers
52 views
Writing with multiple psql processes to database seems to damage data
I have a couple terabytes of CSV data that I am trying to import into a PostgreSQL 8.4 database (on a RedHat 6.2 server), whose data directory is initialized on a multipath hardware RAID. There are ...
2
votes
2answers
54 views
Creating sequence for longer numeric values
I need to create a database model that includes a field to store 20 digit unique values. Which will be used by many clients over an API.
The value must be 20 digit long, numeric and unique. Best ...
4
votes
2answers
99 views
Custom unique column constraint, only enforced if one column has a specific value
Is it possible to have a custom unique column constraint as follows? Suppose I have two cols, subset and type, both strings (though the data types probably doesn't matter).
If type is "true", then ...
1
vote
1answer
58 views
Remote connection to PostgresSQL in Windows 2008 Server is prompting the error below
The error:
"Unable to read data from the transport connection. an existing connection was forcibly
closed by the remote host."
The conditions:
1) I have the following connection string:
...
2
votes
2answers
62 views
String handling in postgres 8.4
This started as a question about indexes, but then when I got my answer I realized I would have to try and convert the answer into 8.4 syntax (I can't believe that format does not exist).
I thought I ...
3
votes
1answer
86 views
PostgreSQL 8.4: How to tell if a procedural language is installed or not?
I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I need to make sure the language is installed or the app will fail. I don't want to drop the ...
1
vote
0answers
105 views
Connecting a GUI to the user-created function in PostgreSQL [closed]
I have been given a task to create profiles for the applications. The Database that we use is Postgresql. I've defined some function that will give me those profile and I've added them to the ...
4
votes
1answer
56 views
Safe way to stop/abort REINDEX
I am running a REINDEX but it takes long time and still working. The application using the DB is not responding right now. Is there a safe way to stop it and do it another time?
PostgreSQL version is ...
0
votes
1answer
77 views
PostgreSQL 8.4 no levenshtein fuzzymatching?
I'm using debian squeeze package, it says function does not exist?
