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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
What software would anyone recommend for creating entity-relationship diagrams?
a) What are the strengths?
b) What are the weakness?
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...
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
(
"...
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 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...
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...
