PostgreSQL Database Forum

How can I find out with a SQL query whether a column in a view is indexed? That is whether a column in a view is just a 'copy' of a column in a table on which an index exists. Martin

Does anyone have any instructions on how to compile any relatively recent verson of Postgres on OpenVMS 7.2?

I have one table that have 1000 record(for example). there 2 user. If 1st user select 100 record and then 2nd user tryies to select records from that table records selected by 1st user is not shown to 2nd user. if 2nd tries to select all records then only 900 records should be selected in these case. 1st 100 selected records should be...

Hi the "insert into" syntax can degrade a performance in a table whit a big number of row? Or insert 1 row in a table whit 0 row make the same time to insert 1 row in a table whith 900000 row? tanks! D

I have these tables. There are many languages, and many countries. Every country has many (some subset of) languages. create table countries ( country_id serial primary key, country_name varchar(128) unique not null ); create table languages ( language_id serial primary key,

We are running Postgres 7.3 on a Debian Linux system. Our python web application uses psycopg to talk to the Postgres server. Our problem is that our queries can be on millions of records of data and take a long time. At times, the user (of the web app) loses interest in waiting for the results. I can have the web app move on, but the...

how do i translate this table: tag stunden projekt_nr 3 7,75 7192500 4 7,75 7192500 5 7,75 2118310 6 7,75 2118310 7 3 2118310 7 3 7192500 10 6 2118310

Hi, is there a way to make direct import to PostgreSQL from oracle dmp file ? -- best regards stic

**** Post for FREE via your newsreader at post.usenet.com **** Hello, I am using sql+ to try and update a table and am having some trouble. Below is a select statement with the result I want to acheive. I want to get this result by using update to update my table. I have attempted to create the update sql statement, see below.

From: "Dan Perlman" <dan@dpci.NOSPAM.us> Subject: ODBC creating nulls? Date: Friday, July 09, 2004 10:43 AM Hi, Below is my VB6 code that writes data from an Access 2000 table to a PG table. The " & "" " on the right of each line should prevent nulls from being

Postgresql 7.4.3-1 under Cygwin. I created a table called ServerTypes: CREATE TABLE ServerTypes( ServerTypeID SERIAL UNIQUE NOT NULL, Type TEXT PRIMARY KEY); Works fine.

Is it possible to create variables outside a create statement? I'd like to do something along the lines of SELECT INTO temp primary_key_id from a_table where a_table.value='something'; However this seems to only work within creating functions. Probably because it's being interpreted as standard sql instead of plpgsql. This would...

Hi, I'am running postgresql 7.4.1 on cygwin under win XP with 1GB ram. I've got into problems while running big inserts 'as select'. When running such sql postgresql start's to use about 800MB of memory which makes PC unusable. How it is possible to set an upper limit for postgresql memory consumption? Regards, Bart

Hello! I'm writing my degree about open Source databases and I'd be greatful for some examples of PostgreSQL usage. Could you please tell me something about yours systems? Destination, database size, avg. noumber of connections per second etc. Thanks,

I need to know why MS Access/ODBC is reporting different results than the one shown in psql. I created a very simple function below: ------------------ CREATE OR REPLACE FUNCTION public."Return_Some_Text"() RETURNS SETOF varchar AS 'DECLARE

How does one capture the result status of an ALTER command inside plpgsql code block? For example: ----------------- CREATE OR REPLACE FUNCTION public."Setup_Primary_Keys"() RETURNS SETOF varchar AS 'DECLARE

----------------------------------------- BACKGROUND In my company (www.glass.biz) we use ERP software to compute what has to be done to do products for our customers. Main algorithm takes data in form of two tables -- let's call them "Structure" and "Orders". "Structure" keeps information on construction

Hello, a question about a tool or a possibility how could something work. following situation: we have a database which is full of very sensitive information and needed that db to use our online website. but now we move the website to a server outside our office and needed to replicate only some datas to the online db. with the tool slony i...

Hi! How can I change the default search_path of a user? For example, I created a schema test and a user xy. Whenever the user xy logs on (with psql or via pearl pg:) he should have the search_path set to test. Thanks Thomas

I have been playing with postgresql at home. This is on a fedora core 2 linux box. Here are the packages yum installed: $ rpm -qa | grep postgres postgresql-libs-7.4.2-1 postgresql-server-7.4.2-1 postgresql-test-7.4.2-1 postgresql-7.4.2-1

I am trying to write a Perl Function for one of the databases I'm building a web application for. This function is triggered to occur BEFORE INSERT OR UPDATE. This function is complex in that it involves fields in two different tables which need to be updated, where the updates one receives depend on and must actually also reflect the same...

I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week they are sending me 2 Universal Studios tickets. Here's the link http://66.219.102.40/ and by the way I am a real person, this is my real email address. I'm not a spammer and didn't appreciate the nasty email I got last time I tried to post this link....

hello! does anybody know how well the pg extension in PHP for PostgreSQL supports UTF-8 character sets? functions such as pg_escape_string would be of particular concern as they go whipping through strings replacing things. are these functions tuned to the input string type, the database string type, or just hardcoded as 8859-1? ...

Hello, I want to make use of a Perl script "ora2pg" (Oracle to PostgreSQL schema converter), which requires the following modules: DBI, DBD::Oracle and DBD::Pg. As I don't use Perl on a regular basis, I've downloaded and installed ActivePerl 5.6.1.638 (Windows). Then, I installed DBI and DBD::Oracle using the PPM utility. But,...

We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++. Sybase supports this quite nicely. The client app can call such routines by: ...