I am using "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" on Windows 2003 server . While I am trying to update a prmary key It is failing with the ...
When I attempt to use the Configure Data Source wizard to set up advanced SQL Generation Options the options (i.e. add addtional INSERT, UPDATE... statements) are grayed out.
I found out w...
Hello,
I'm new to postgres and I've googled on this seemingly simple issue all morning...
FreeBSD 6.1
PostgreSQL 8.2.3
PHP 5.2.5
I want to query my table and return records (to scri...
I have this MYSQL code. This code creates a view in database asterisk and reads from another databse called openser.
CREATE VIEW vmusers AS
SELECT phplib_id as uniqueid,
username as ...
I have a table in a PostgreSQL database with a column "modified". How can I update the value to the current datetime (using now()). I suppose this is done using a trigger function?
Take th...
Hi Experts
Can PostgreSQL installed on windows? is there any tech resources/web ?
Thanks
Dishan
Hi,
when executing a postgresql function/stored proc (like an update) I would like to have as return value the number of affected rows. Could someone, please, help me?
Thanks,
...
Is there an equivalent of @@identity in PostgreSQL to automatically return the record just created?
Thanks heaps.
Hi Experts,
I am using the PG triggers. I have a library that sends the trigger events to a process. It works fine when I have small number of updates to generate triggers. If I increa...
I cannot get libpq,PostgreSQL's C API, to compile a debug version, though it will compile a release, so I've copied the release folder, renamed it debug and appended a "d" to each of the dlls/...
Hi all
How to migrate data from Postgre to MS SQL Server 2000 on Windows 2000 /Advanced Server?
Thnx
rahool
Hi experts,
I am working on VS2005 and Back end is PostgreSql8.2. Here i am using PostgreSQLDirect .NET Data Provider as the connectivity between VS and postgre. I am not able to get th...
I get this error when I try to start postgres on Solaris 10
could not connect to server: No such file or directory
Is the server running locally and accepting
connections ...
I just uninstalled Postgre Database from my Server and made a huge mistake. I there any way that I can recover the data files and log files? I did not format the drive just unistalled the data...
Hi,
I am assigned the task of presenting a document on the advantages and dis advantages of using PostgresSQL Vs SQL Server to my management. I would like to have valuable feedback or points ...
Hi there,
I'm experimenting with PostGres, and being primarily a MySQL user, I'm running into some syntactical issues.
In MySQL, I'm able to do something like this:
INSERT INTO myTabl...
Hi
Is it possible to backup the structure of a Postgres Database, I normally use the pgdump command for a backup but then the structure and the data is backup. I want to replicate the DB ...
Sometimes I get this error when working with PostgreSQL for several hours (reloading one page all the time). "FATAL: connection limit exceeded for non-superusers"
How can this be fixed?
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...
i have a table called road
It has
select count(*) from road;
count
---------
1098822
I want to fire this query in the database
select name, astext(the_geom) from road where ...
Creating my first project in Visual Studio 2005 and having problems setting up a Data Connection to our Postgres SQL database. Originaly I tried to use the ODBC DSN that I have bee using to da...
I am programing in VB6 and this is a postgreSQL db.
Below is the 2 tables that are setup in the db.
tblvrdata
vr_city - character varying(primary key) - 297 rows - Never Changes
vr_loc...
Hi.
I am trying to create a sql statement on a table that would calculate the standard deviation of the daily returns for each Ticker I send to the function.
table
Date Ti...
I can't seem to see any commands in the stats tables despite setting stats_command_string = true. I can't stop it from saying ' <command string not enabled>'. I am running as the superuser.
OK Postgres Guru's, this question is for you.
I have the following SQL statement that I am executing. Take note to the '\' being used in the SQL statement.
SELECT "bondId", "bondSeqNo"...
