How do you change the column size in a populated table?
I've run into a problem which I'm having a hard time fixing... a few couple of months ago I've switched from a jsp reporting scheme to one using datavision. I've field tested it for a few wee...
Hi Folks,
I currently have an outrageously complex query consisting of many nested subqueries and convoluted joins in order to produce a recordset of about a half a dozen rows.
This quer...
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,
I have an existing database and I want to "copy" it to another place - both with PostgresSQL.
I have succeded to export the data with phpPgAdmin as an SQL script file.
Now I h...
We were doing regular vacuum of the site before and last week our admin deleted the cron for vacuum. We were running
full vacuum every night using this command:
vacuumdb -d db_final -f -z
...
What software would anyone recommend for creating entity-relationship diagrams?
a) What are the strengths?
b) What are the weakness?
If I have a table 'TABLE' like the following:
FOO BAR BAZ
----- ----- ----
A Y Z
B Y Z
B Y Q
C Y Q
C Y Q
I would like to write ...
Hey!
Just started using PostgreSQL, use to MS SQL Server. Noticed Postgre does not have a varchar table datatype.
Tried using a character[] thinking a varchar is simply a character arra...
OS: Linux (Debian)
I am new to Linux/postgresql.
I am trying install dspace as per the instruction given at the following site :
http://dspace.org/technology/system-docs/install.html
...
I am trying to INSERT a record in my postgres table and I get t his error:
ERROR: array value must start with "{" or dimension information
My table definnition
CREATE TABLE paymentmethod...
Hi!
We have a problem with Geoserver, PostGIS and MapBuilder.
Our map displays fine, but we noticed a lot of instances of postgres.exe in the task manager, simultaneously, mapbuilder f...
how can I limit the result of a query, so that e.g. only 100 rows are loaded maximum? needs to run on every database, so it needs to be standard sql.
I installed postgreSQL 8.2 on windows xp and am now unable to uninstall it. I think it has something to do with the user account it created. I don't have permission to uninstall it as a user, ...
Does anyone know the sql select statement to retrieve every nth row from a table? (Like, 2nd, 12th, etc....)
We will be soon taking on task on implementing encryption to various fields of our Postgre database. Our question is on where should we store the encryption key? We will be storing names an...
I am using postgresql 7.x and thought the following would work, but it does not. It seems to me that similar syntax works. What am I doing wrong?
DatabaseError: error 'ERROR: cross-databa...
Is there a query that I can run to list all tables that depend on a certain table
e.g. all tables that depend on tblData
They currently have a foreign key defined and I would like a way...
I need to know what the differences are between the following for a PostgreSQL database:
Encoding = UTF-8
Encoding = SQL-ASCII
When I try to run an application that does lots of updates and inserts in parallel, I get deadlock detected error messages on a regular basis (one every few seconds with 20 threads).
The er...
I have two records for each employee. One with a 2006-12-31 datestamp, the other with a 2007-12-31 datestamp in the YR field. In the ASP, I know the latest year by performing "SELECT max(yr) a...
I want to display some 3d objects in the graphics window from the database postgresql ...... The data about the objects are stored in the database postgresql.......
1,is it possible to conne...
I have the following 3 database tables:
CREATE TABLE public.courserecord
(
courserecordid numeric(38) NOT NULL,
studentid numeric(38) NOT NULL,
courseinstanceid numeric(38) NOT NU...
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...
Hi,
I've recently upgraded to postgres 8.3.0, and when I run my java app that connects via Jdbc to postgres I am now getting the error: SET AUTOCOMMIT TO OFF is no longer supported. I'm no...
