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...
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...
Hi,
I have installed Postgresql 8.3 successfully on my windows machine. And able to connect to the databases from my machine. But when I try to make connection to it from other machine (Cli...
I have a postgres database setup on a remote server. The currently working DSN on my windows laptop was set up by someone else. When I run PERL programs on my laptop which query the database...
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 am having using inserting new values into what shoudl be a rather simple hibernate/postgresql map. I have created all my mappings in myeclipse using the hibernate tool. When I try to save ...
Hi,
I am running a database on my machine. but i forgot the database password i still know the username.
and if i go to pgAdmin i see that the database is running and that the password is...
INSERT INTO sales_order_lines (order_line_id, order_id, part_no, quantity_ordered) VALUES SELECT(("MAX(order_line_id) + 1" AS order_line_id, '1234' AS order_id, 'P78979879' AS part_no, '5' AS...
say i have below:
CREATE TABLE test.testing
(
studentid character varying(5),
amount_paid numeric
)
and i try to insert
INSERT INTO test.testing(
studentid, amount...
I found the following message within syslog.
< message >
postgres ERROR: value too long for type character varying(256)
I am not developer but manage server.
Would you please tell m...
I have a table gnr with a column country. I want a result like
USA 33
Canada 36
I try select country, sum(1) as count from gnr group by country; and get a syntax error. I am unknow...
I've just installed PostgreSQL 8.3.5 on Windows XP SP2. I'm trying to use the LibPQ C library. I've succesfully compiled and linked the program. I've added libpq.dll and libpq.lib into the wor...
Experts,
I have a script that creates users and assigns them to tablespaces etc. My code below:
I cannot get this script to run in PostgreSQL. It stops on line
DEFAULT TABLES...
Hi experts!
I am currently rebuilding a reporting application using BIRT. Before developping to much, I want to be sure of the database software choice I will have to live with.
I starte...
The following is a PL/pgSQL boolean function that checks if a product can be found with a given department id, so that the department_id can be deleted altogether - it is used to avoid orphani...
I'm trying to connect to Postgres with my PHP program. The program is running on the same host as Postgres.
This program worked on my other apache/PHP/Postgres server, but after copying it ...
Hi,
Can anyone tell me how to convert hex to decimal conversion only through sql (don't want to create function). I tried 2 things first one worked when I pass value physically but second one...
Here is a sample postgresql statement:
CREATE TABLE users (
id SERIAL,
login VARCHAR(80),
password VARCHAR,
PRIMARY KEY(id)
) WITH OIDS;
What does the with oids do?
Hello,
I am attempting to import some csv files into existing tables in my Postgresql database.
Instead of easily copying the data into my tables I seem to be doing something wrong.
Each of...
Any possibility to get the root password or reset the new password? Because I forgot it the password in my linux server...
Do I need reinstall postgress If I don't have any option in it.?
...
Hi Experts,
How to return dataset from a postgre sql function? I wish to know how it works.. I'm not looking for a complex solution using pl/pgSQL, just a simple sql funtion returning ...
To do pagination, I need to run two queries:
select count(*) from table where x=1;
select * from table where x=1 limit 30 offset 91;
To then display "< Items 91 to 120 > of 1932" for ex...
Need assistance tuning up PostgreSQL 8.3.7 for 1000 max connections, tried to set it to 500 but it returned an error about SHMMAX.
Debian Lenny
PostgreSQL 8.3.7
7.5Gb RAM
Thank you in ...
I need to know what the differences are between the following for a PostgreSQL database:
Encoding = UTF-8
Encoding = SQL-ASCII
hello there,
i installed postgre db on my win xp. when when i go into the phadmin window and try to connect i get this error
FATAL: role "postgres" does not exist
please help
cheer...
