Topic profile page for PostGres.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: PostGres.
Topic "Postgres" was discussed 3,080 times on 373 sites in last 3 months
EnterpriseDB is now on YouTube! Subscribe today and... EnterpriseDB is now on YouTube! Subscribe today and enjoy a number of video tutorials. http://bit.ly/XObeJ #postgresql #postgres #opensource 1:45 PM Sep 10th from web
Started 5 days, 23 hours ago (2009-11-04 15:01:00)
by acimi acimi is offline Member
The schema and views work fine in BI server 3.0. However, in 3.5 I notice 1. A dimension with 1 level that uses KeyExpression with SQL dialect="postgres" does not show in the list of dimensions, when I click on 'Open OLAP navigator' in JPivot. - For another such dimension, I can see the dimension name but get a "An error occurred while rendering Pivot.jsp. Please see the log for ...
Started 5 days, 23 hours ago (2009-11-04 15:01:00)
by acimi
The schema and views work fine in BI server 3.0. However, in 3.5 I notice 1. A dimension with 1 level that uses KeyExpression with SQL dialect="postgres" does not show in the list of dimensions, when I click on 'Open OLAP navigator' in JPivot. - For another such dimension, I can see the dimension name but get a "An error occurred while rendering Pivot.jsp. Please see the log for ...
Started 1 week ago (2009-11-02 17:18:00)
by sangfroid
Hi, I have been successful in exporting database 'accounts' to a text file with pg_dump command... What I need to do is to import this database to a different postgres server. This server doesn't have any database called 'accounts' defined... How do i create this database, its tables and import the data from the dumped text file ? Any help will be highly ...
Started 6 days, 3 hours ago (2009-11-04 11:14:00)
by pmlemos
Hi people, I'm involved in several projects nowadays, and that makes me the need to install several postgresql versions. My actual problem is, how can I install postgresql-8.3.1 and postgresql-8.3.4 on ubuntu (linux). Anyone knows how can I do it? Thanks!
Started 4 days, 15 hours ago (2009-11-05 23:42:00)
by tcliam
Hi guys I am having to convert a MS SQL Stored Procedure to a Postgresql Function. I have a MS SQL Stored Procedure that has an Output Paramter aswell as Returning Columns in a table. I have looked in the Postgresql documentation and it talks about both of these but not using them together. I have tried a few things but have had no luck I'm thinking that it will involve the "RETURN NEXT" ...
Started 4 days, 2 hours ago (2009-11-06 11:58:00)
by nilaynilay
my pt works fine. today i tried to update to 8.4.1 and dl the full installer. it comes to a stage where it needs a password. i know my pass is dbpass coz tablescan turbo can connect with that pass but i am getting a error messg. what do i need to do to update to 8.4.1
Started 3 days, 20 hours ago (2009-11-06 18:01:00)
by Kraada
It's not possible to do otherwise; it's the way PostgreSQL is built. They will continue to maintain the 8.3 line with security updates for quite a while. 7.4 is still maintained and is many years old at this point.
There's another concern that may not be as obvious... That is availability of human resources that are familiar with the technologies you've built your company on. Imagine yourself trying to hire and keep a team of people (software developers, database administrators, technical power users, etc) who know postgres inside and out? Postgres knocks the socks off of MSSQL any day, ...
Started 1 week, 1 day ago (2009-11-02 01:33:00)
by Roy Schestowitz
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 CAOS Theory Podcast 2009.10.30 ,----[ Quote ] | Topics for this podcast: | | *-DoD memo and official use and | consideration of open source | *EnterpriseDB updates its Postgres Plus | Server, gets Red Hat investment | *Latest in Linux from Canonicalâs Ubuntu | and Red Hat Enterprise Linux, Deltacloud | *Roundup of Oracle-...
Started 1 week ago (2009-11-02 18:37:00)
by sangfroid
Hi, I have been successful in exporting database 'accounts' to a text file with pg_dump command... What I need to do is to import this database to a different postgres server. This server doesn't have any database called 'accounts' defined... How do i create this database, its tables and import the data from the dumped text file ? Any help will be highly appreciated. Thanks...
Started 1 week ago (2009-11-03 14:35:00)
by Ciccio83
I've try to add a postgreSQL database to my project. It seems to be ok, when i double-click on the added database a window with all the tables appears, but the tables are completely empty! There are no columns! I'm using the postgres plugin downloaded from realsoftware site. Is it no upgraded? Is it a bug or what else?
Started 4 days, 1 hour ago (2009-11-06 13:10:00)
by Ciccio83
Example. I've a postgres database. Two tables. First table, named "CarConstructor", had two columns: ID(primary key),ConstructorName. Second table, named "CarModel", had three columns: ID(primari key),CarModel,IdCarConst(foreign key). First table rows: 1----Opel 2----Fiat 3----Mercedes Second table rows: 1----Zafira----1 2----Astra----1 3----Punto----2 4----S500----3 5----S300----3 So, i know...
Hello all When configuring mediawiki (1.11.2 ) using postgresql 8.3 I get the following failure message: # Database type: PostgreSQL # Loading class: DatabasePostgres # Attempting to connect to database "postgres" as superuser "postgres"... # Checking the version of Postgres...version 8.3 is OK. # User "wikiuser" already exists, skipping account creation. # Database "wikidb" ...
![Mondrian [Pentaho Analysis Services]](http://icons.boardreader.com/5e/81/5e81c0b836cd5680ca424a12bd2453d2.png "Mondrian [Pentaho Analysis Services]"){kind=icon}
