Hi People,
We're looking to move our DBMS to PostgreSQL, and I'm looking for a good reliable replication system to use.
The idea is this; a master and slave onsite and then another slave...
Would this translation be correct
Mysql syntax
CREATE TABLE `voicemessages` (
`id` int(11) NOT NULL auto_increment,
`msgnum` int(11) NOT NULL default '0',
`dir` varchar(80) default ...
Hi!
I´m looking for any document or page that can show me statistics on this matter. I need to know what benefits can PostGre offer, and how do these compare to the ones Oracle offer. ...
Could really use a hand here. We have a vb.net application that checks a back end database table for new data to process. The original back end database was in MS Access. We have upgraded the...
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,
I'm a linux newbie ---
I have fresh installs of fedora 5 and have a php web site that we are load testing from windows clients. We expect a few hundred simultaneous users. I've pu...
My form data does not seem to be getting to my fom handler. There is no information in any
$_POST value.
hello. im trying to create some funtions to simplify a complex sql query. can someone show me an example of how to create a function that takes in some arguments and use it in a sql query and ...
Is it possible to make a timer-driven trigger in postgresql?
For example, if you have items in a store that have an expiration date and would want a trigger to keep track of when the current_...
I have a linux server (Suse10.2) which will only be running Postgres. It will be feeding a web server and only responding to web applications. The specs of the HW are:
HP ML370 G3
Dual Xeo...
If I'm importing a text file into mysql, I can do this:
LOAD DATA INFILE 'test.txt'
INTO TABLE myTable
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n';
What's the equivalent of this...
I have a postgre database installed on a Solaris platform. Unfortunately i am facing a lot of slowness in the processing of queries. I need to monitor the database queries in order to know the...
To back up and restore a postgres database I export the db to a sql file and then import it using "psql -f".
That works, but it takes hours to run. Is there a faster way?
Hello Experts,
I ran this once, but I lost the instruction, and I googled it but with no luck. Does any of you know what is the instruction on PostgreSQL for knowing how many current open c...
I need to select some rows from a table based on a certain field, something like
select * from table where ts=100
On these rows, I need to edit the value in ts to current value (100 in t...
hello. i have the following code that is able to retrieve column names of a table. instead of getting one table "testtable", is there a wat to retrieve table column names of more than 1 table ...
hello. how can i get records between year? e.g 2008 to 2009? im using timestampz as the date field.
select * from records where date BETWEEN 01/01/2007 AND ????
i cant actually put 30/1...
I am trying to write a function in postgresql and I keep getting the error: language "plpgsql" does not exist. I have type in createlang cs442 and added 'Language plpgsql to my function but I...
i am trying to get the output from a SELECT command to be comma separated and each field has to have quotes around it. I need to do that in psql. I have tried this but it doesn't work:
>psq...
while doing an insert in postgresql, I get permission denied on a serial field. Here is the error:
/home/familynetwork/cgi-bin/addideas.py
180 for category in fields["category"]:
18...
I'm looking for a tool for database comparison and synchronization for PostgreSQL.
Basically what I wanted to do is automate the task of checking the latest alterations/modifications in the S...
I am installing sql-ledger which uses postgreSQL. The installation instructions for sql-ledger say:
*********
You also have to add some users to your postgres DB
The easiest way to tes...
Hi,
I am brand new to Postgres DB's.. I have a SQL file that I'm trying to import, and it contains a few statements like:
CREATE FUNCTION lexize(oid, text) RETURNS text[]
AS '$libdi...
How do you identify the end of a cursor in plpgsql?
Oracle:
WHILE mycursor%FOUND LOOP
END LOOP;
How to do that in plpgsql ?
-g
I've been trying to create a database from c# using Npgsql, with the following technique:
creating a string and pass to database as a command.
question 1 : is it normal that i have to conne...
