I am new to postgresql. I know it doesn't do auto increment on index. I am not sure how to say this: how do I create a sequence on command line so that I can get the next index # in my table F...
Hi
Where can I find a Postgresql ODBC driver for Windows Vista, if exists. I've installed their latest version but could not pick it up under the ODBC settings in Windows.
Thanks
Hello,
I need to copy one table (properties and data both) from one database to another. I am using pgAdmin III.
I tried doing it with pg_dump and psql, but I guess I don't have the correc...
Hi ,
I am trying to write a query in Postgres, for inserting values into a table , however if that INSERT were to insert a row with a duplicate key, it should update the original record in...
Hello,
when I'm trying to connect to the postgresql database (located on the server) I receive following error : "No connection could be made because the target machine actively refused i...
Is there a query that I can run to list all tables that depend on a certain table
e.g. all tables that depend on tblData
They currently have a foreign key defined and I would like a way...
I'm a bit nervous about running an update-inner join type query with postgres since it's different from MySQL and SQL Server that I"m used to (which is much easier). Last time I attempted thi...
Hi Experts,
I installed postgres - under a non-admin account through the installer for Postgres 8.3. The installer itself tries to start the service and cannot after the cluster is initializ...
Hi guys,
I have the following code to create a trigger which updates column making_price on table style
based on column packaging_price of same table style and column price_4_garment of tabl...
I have two tables, A and B.
A has two fields, KEY_A and VAL_A.
B has two fields, KEY_B and VAL_B.
Values in KEY_A and KEY_B may overlap.
I want to select all records from A and B into a ...
Hi Experts,
Is there a way to check if a table exists in a given database before I try to create it in ODBC for Postgres?
Thanks,
Mike
I received some SQL commands to execute in order to create tables for a report that my Director is wanting. I executed the commands in Webmin on the server and I cannot see the tables it crea...
Groupshield is using a PostgreSQL database this process: "postgress.exe" is taking huge number I/O reads and it is causing the server to perform slow.
Background scanning and proactive scanin...
In PostgreSQL, when writing a CREATE FUNCTION statement, you can add the statement OR REPLACE into the CREATE line, so it looks like this CREATE OR REPLACE FUNCTION. This checks if the functi...
Hi Experts,
Looks like a bug in Postgres - I just installed 8.3.1-1, hoping it was fixed... I added a column in PGAdmin III - I do a query (select * from mytable limit 1) and I get a row wh...
I am outputting a table that has a user's response with the period of time that has elapsed next to it
John Smith | Yes (15 mins ago)
Bob Jones | No ( 12 days ago)
Sally Thom...
A third party program generates a .sql script in a file which I would like to run.
In my Java app, I already have a connection in a connection pool to the database, and I'd like to use that...
Hi Experts,
I thought I fixed this - funny thing is - it was sort of fixed...
When doing INSERT statements, I use the following form with 'serial' columns (my customer_id column is a seria...
What software would anyone recommend for creating entity-relationship diagrams?
a) What are the strengths?
b) What are the weakness?
Hi Experts, I'm using the psql query editor - connected to MyDatabase. What is wrong with this? I've got a column defined as 'serial' as describe below - when I try to insert I get the error...
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 have installed the latest PostgreSQL native Windows beta (8.0.0-beta4 using the Windows MSI installer) on a Windows XP Pro SP2 system. I accepted all of the installation defaults, as far as...
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've run into a problem which I'm having a hard time fixing... a few couple of months ago I've switched from a jsp reporting scheme to one using datavision. I've field tested it for a few wee...
