I have the following:
- windows xp running
- postgres SQL database using UTF-8
- ODBC connection to postgres database, assume data soucrce name is BOB
- a program which retrieves...
Hi.. I am setting up a VPS, and am having some issues with PostGres and php..
I get this:
Fatal error: Call to undefined function: pg_connect() in
I have installed PostGres.
I have u...
I downloaded and installed postgresql-8.0.3.zip from http://www.postgresql.org/ftp/binary/v8.0.3/win32/ . I have created a database with sql statement as below
CREATE TABLE my_table
(
"...
I am creating a SQL Script in PostgreSQL. I need it to check if a function exists in the database and if so, I need to execute the drop first and then a CREATE...the pseudo code would be some...
I installed postgreSQL 8.2 on windows xp and am now unable to uninstall it. I think it has something to do with the user account it created. I don't have permission to uninstall it as a user, ...
I am trying to INSERT a record in my postgres table and I get t his error:
ERROR: array value must start with "{" or dimension information
My table definnition
CREATE TABLE paymentmethod...
Hello,
I am trying to invoke a stored procedure in postgres from C# asp.net web app. here is the code. it's not working.
odComm = new OdbcCommand("editCountry", odbcConn);
odComm.Command...
Hello All,
I'm running a postgresql 8 server on a centos 5 system. I've created a table with a couple of fields using the DATE data type. When I try to insert data I get an error "...incorr...
I am using postgresql 7.x and thought the following would work, but it does not. It seems to me that similar syntax works. What am I doing wrong?
DatabaseError: error 'ERROR: cross-databa...
Hey!
Just started using PostgreSQL, use to MS SQL Server. Noticed Postgre does not have a varchar table datatype.
Tried using a character[] thinking a varchar is simply a character arra...
Hi.
Im trying to create a java class that deletes all data in a db. When its done Id like only empty tables. The problem is that I dont know anything about the tables and the structure.
...
I am having using inserting new values into what shoudl be a rather simple hibernate/postgresql map. I have created all my mappings in myeclipse using the hibernate tool. When I try to save ...
Hi Experts,
I'm trying to get a silent install of postgres 8.3 working properly on XP (SP2). I run the following command:
MSIEXEC /i "postgresql-8.3-int.msi" /qb /log "c:\mydir\logfile.tx...
I have a Ubuntu Server setup at a friends house and I want to be able to manage PostgreSQL from my house via pgAdmin III for Windows. I'm connected to the box though SSH and have port forwardi...
We will be soon taking on task on implementing encryption to various fields of our Postgre database. Our question is on where should we store the encryption key? We will be storing names an...
Hi,
I want to create a trigger that will update a column when an INSERT tries to insert a row with a duplicate key.
Take this query for example:
INSERT INTO sessions SET
data = 'so...
Hi,
I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most imp...
How do you change the column size in a populated table?
I need to know what the differences are between the following for a PostgreSQL database:
Encoding = UTF-8
Encoding = SQL-ASCII
I want to install pgadmin (the postgres admin tool) on a CentOS 4 system.
I initially just downloaded the rpm, but I ended up in rpm hell where it required wxGTK and then when I tried to in...
Hi Experts,
Just wondering if there is a free ADO.NET driver for C# and one for C++ to interface with Postgres? I'm using Visual Studio 2008.
Thank you!
Mike
Hi Experts,
I have an existing database and I want to "copy" it to another place - both with PostgresSQL.
I have succeded to export the data with phpPgAdmin as an SQL script file.
Now I h...
How to change postgresql auto-increment database field, similar to
"ALTER TABLE tbl AUTO_INCREMENT = 500" in MsSQL database?
Any possibility to get the root password or reset the new password? Because I forgot it the password in my linux server...
Do I need reinstall postgress If I don't have any option in it.?
...
I am getting this error on one of my CSV file imports. I have tried deleting everything from the end of the rows and columns, but to no avail. What causes this problem?
ERROR: extra data ...
