Tagged Questions
0
votes
1answer
31 views
PgSqlExcetion: date/time field value out of range: “4/20/2012 12:00:00 AM”
I want Insert Data Table in DataBase
public void InsertNote(DataTable dataTable)
{
var query = new StringBuilder();
query.Append("INSERT INTO ...
0
votes
2answers
31 views
NHibernate configuration, foreign keys
I must admit I'm still pretty new to NHibernate, so please go easy on me.
I have 2 POCOs, a Log and a UserProfile. If it is not inherently clear, the log entry can reference a user profile, and a ...
0
votes
1answer
69 views
ASP.NET Notification
I'm developing an application in ASP.NET and Postgresql(9.0). There will be two users of the system. Whenever the 1st user enters record into database, other user must get notified about the change in ...
0
votes
6answers
78 views
C# Timer to populate the database
I am trying to retrieve the data from MSSQL and PostrgeSQL databases to populate it into a MySQL database on a regular basis (every hour).
Based on a research I've done, I would like to use a C# ...
0
votes
1answer
57 views
HttpWebRequest doesnt work in Mono + Npgsql
I'm having the same problem as this guy: Mono Apache2 HttpWebRequest crashes with "The request timed out"
Only that the way he solved it doesn't work for me.
My case is different in that ...
0
votes
2answers
44 views
PostgreSQL Function TEMP TABLE Alternative Solution
CREATE OR REPLACE FUNCTION "getArticulos"(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
CREATE TEMP TABLE "Temporal" AS
SELECT a."idArticulo", SUM("Stock") AS "Stock"
FROM "ArticuloMarca" ...
0
votes
1answer
82 views
PostgreSQL, ODBC: Connection string doesnt work for PostgreSQL
I am using the following connection string structure in my web.config in order to connect to a PostgreSQL database using ODBC however I get an error:
Connection string
<add ...
2
votes
3answers
154 views
How to silent install Postgresql on Windows 7
I want to install "postgresql-9.1.3-1-windows-x64.exe" on windows 7 silently.
Where can i find msi install of postgresql-9.1.3.1
Thank you
Zak
2
votes
4answers
105 views
PostgreSQL: Programatically inserting rows where field value is SQL statement
I am currently working on a solution in C# to copy database tables across from Oracle to PostgreSQL. Everything is working great apart from one thing. When I get to copying one of my table which ...
0
votes
0answers
36 views
how to capture stderr of pg_dump invoked from asp .net mvc2 controller
Code below is used for backup. pg_dump never finishes, cpu usage is 0%. If line
process.StartInfo.RedirectStandardError = true;
is removed, code works ok but error result cannot captured. ...
0
votes
1answer
72 views
How detect send completed in MVC controller
Code below is used to create backup is ASP .NET MVC2 application in Linux and windows. On complete, entry should written to log file. This code writes it in process Exit event.
Exit event write is ...
0
votes
1answer
44 views
Npgsql: Can it recognize ODBC espace sequences?
I have this SQL query (in T-SQL):
--DECLARE @strTerm varchar(300)
--SET @strTerm = 'c'
SELECT TOP 10
USR_ID
,USR_UserName
FROM T_Benutzer
WHERE (1=1)
--AND {fn LCASE(USR_UserName)} ...
0
votes
2answers
54 views
how to pipe stdout to browser in Mono Apache MVC2 application
Code below is used to save PostgreSql database backup from browser in Apache Mono MVC2 web application in Linux.
It takes long time for backup to finish before file transfer begins. pg_dump can write ...
1
vote
0answers
40 views
How to backup PostgreSql database from browser in MVC2 application on Mono
Mono MVC2 application is used to backup PostgreSql database from browser.
After some time of work exception Thread was being aborted occurs (whole error message is below).
pg_dump runs but looks like ...
0
votes
1answer
57 views
Parsing PostgreSQL CSV Log
I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server.
The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log
The Server version in 9.0.4
The ...
