Advertisement

Experts have come up with some helpful tips for getting a solution to your problem fast.

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested PostgreSQL Solutions: 101 - 125 of 290
 
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"...