Sponsored Links

comp.databases.postgresql.questions comp.databases.postgresql.questions

Page 2 of 6

Threads in Forum : comp.databases.postgresql.questions

Rating Thread / Thread Starter	Last Post	Replies	Views
Is GROUP_BY best for this? Given table all_prices: product_id \| company_id \| price -----------+------------+------ 1 0 1 1 6 ... John	05-06-2005 01:16 PM no-spam	2	482
A graphical tool for the visualization? Hi, does anyone know about a tool (free or commercial) for object and relation view for postgres? Thanks for any help. MK Magdalena Komorowska	05-06-2005 01:07 PM no-spam	2	325
JNDI DataSource with PostgreSQL and Tomcat Hello group, I have some questions concerning configuring and using a JNDI DataSource with PostgreSQL and Apache Tomcat. Currently, I belive I... no-spam	05-06-2005 01:01 PM no-spam	0	423
Logging trigger calls I am trying to log the results of a series of triggers that are fired when I insert into a table. It looks like the only option is to change the... Rob Sorenson	05-06-2005 09:41 AM Rob Sorenson	0	311
how to import data into table How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into... John Kolvereid	05-05-2005 11:09 PM Warren Killian	3	306
newbie I think I have postgress installed on my redhat 7.3 box ~ User=root $ps -ef \| grep postgr postgres 1295 1 0 02:26 ? 00:00:00... mickeyg	05-05-2005 09:50 PM Some Internet Dude	1	247
PostgreSQL ?? Hi I'm a developer currently wondering which DB choose for my next project. I looked on the net found ofcourse Oracle but also came up... Mateusz [PEYN] Adamus	05-05-2005 09:40 PM Some Internet Dude	1	308
MS SQL vs PostgreSQL Hello :) I'm working on an internet application with MS.Net client program, which is supposed to communicate with database through PHP or ASP-based... Dominik Flejter	05-05-2005 09:13 PM Some Internet Dude	3	438
Postgres ok, pgadmin not: why? Hi, Hope this is the right group to post this Q! Don't shoot please. Ive got my postmaster service running on my Mandrake 9.1. I'm able to... Skynet	05-05-2005 09:01 PM Some Internet Dude	3	220
[PGSQL+MSSQL] - connection between them Hi, Has anyone Pg linked to MSSQL or vice versa? I need to transfer some data MSSQL->PGSQL, but without writing a complex program. Maybe using... Maniek	04-29-2005 07:44 PM Wiseguy	2	233
DateAdd function? I am currently migrating from MSDE to PostgreSQL and have to rewrite the function that is calculating next date of sampling... In MSDE there is a... Zlatko Matiæ	04-19-2005 05:48 AM Zlatko Matiæ	0	184
pg_autovacuum Hello is anybody know how to install pg_autovacuum as a window service. i've tryed this : pg_autovacuum -I -U my_user -P my_password -H... LPO	03-23-2005 03:43 AM LPO	0	225
Best way to Insert related records Hello, I have 2 tables tab_1, tab_2 records in tab_1 are related to records in tab_2 i write records to both tables i one step. e.g. i write record... Robert Vailor	03-21-2005 05:13 AM Robert Vailor	0	184
External SQL functions exported by DLLs 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... Peter Sullvan	03-11-2005 07:51 AM Peter Sullvan	0	177
pgsql optimizer Hello, I've got a server postgresql 7.4.6 installed from RPM for linux RH 9. Lately, I've noticed, that some queries last too long... It appears to... gefek	03-09-2005 06:17 AM gefek	2	191
Continuous performance regression Hello. I use postgress to manage a small amount of data (ca. 25MB), but often changed. This is a mirror of several tables taken form four different... Przemyslaw Mazur	01-31-2005 04:37 PM Przemyslaw Mazur	2	187
Data Recovery Is there any way to recover data after a mistaken delete query, using the binary data files? For example, can I make a database return to the state... Vangelis Natsios	01-16-2005 01:01 PM Nikolay A Mirin	1	293
Where to get DBD::pg Perl module for Windows? Hello, I want to make use of a Perl script "ora2pg" (Oracle to PostgreSQL schema converter), which requires the following modules: DBI, DBD::Oracle... Piotr B.	01-12-2005 05:08 AM Piotr B.	0	238
PostgreSQL/PHP/UTF-8? 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... Mark	12-15-2004 06:17 PM Mark	0	182
postgis and related topics... Is anyone out there using PostGIS in a production environment? If so does anyone know how well if at all postgresql/postgis work with the likes... jason	12-14-2004 05:59 PM David Jacques	1	179
Bulk import date into table. ---------------------------------------- BACKGROUND: My company (www.glass.biz) keeps information about products in a network-shared (samba)... Leszek Dubiel	11-18-2004 10:07 AM Alban Hertroys	4	225
[ANN] FmPro Migrator 2.57 - Migrates FileMaker Repeating Fields to PostgreSQL FmPro Migrator 2.57 Enterprise Edition from .com Solutions Inc. has been updated to add repeating fields extraction from FileMaker databases... David Simpson	11-17-2004 11:19 AM David Simpson	0	197
Insert/Update Perl Function involving two tables needing to by 'in sync' 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... Ferindo Middleton Jr	11-02-2004 09:35 PM Ferindo Middleton Jr	0	183
Fedora Core 2 postgresql regress problems. 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... Flash	09-27-2004 11:27 PM Flash	0	192
default schema 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... Thomas Aichinger	09-06-2004 06:16 AM Thomas Aichinger	0	313
postgres replication only some datas 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... Matthias Blohm	08-23-2004 06:49 AM Matthias Blohm	0	166
Simple ERP problem ----------------------------------------- BACKGROUND In my company (www.glass.biz) we use ERP software to compute what has to be done to do products... Leszek Dubiel	08-22-2004 10:55 AM Leszek Dubiel	0	314
Capturing the result status of an ALTER command in plpgsql How does one capture the result status of an ALTER command inside plpgsql code block? For example: ----------------- CREATE OR REPLACE FUNCTION... jarednevans@yahoo.com	08-18-2004 03:38 PM jarednevans@yahoo.com	0	197
Return set different in pgsql and MS Access/ODBC I need to know why MS Access/ODBC is reporting different results than the one shown in psql. I created a very simple function... jarednevans@yahoo.com	08-18-2004 03:37 PM jarednevans@yahoo.com	0	189
PL/Perl Trigger Problem I'm new to Postgres, and getting nowhere with a PL/Perl trigger that I'm trying to write - hopefully, someone can give me some insight into what I'm... Dunc	08-18-2004 08:13 AM Jeff Boes	1	182
Memory problem 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... bart	08-13-2004 04:45 AM bart	0	205
Creating variables outside a 'create function' 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... Ogee	08-12-2004 11:47 PM Ogee	0	273
Create Table with Foreign Key Error Postgresql 7.4.3-1 under Cygwin. I created a table called ServerTypes: CREATE TABLE ServerTypes( ServerTypeID SERIAL UNIQUE NOT NULL, Type TEXT... John Haney	08-11-2004 02:21 PM Niels Muller Larsen	1	167
Create Table with Foreign Key Error Postgresql 7.4.3-1 under Cygwin. I created a table called ServerTypes: CREATE TABLE ServerTypes( ServerTypeID SERIAL UNIQUE NOT NULL, Type TEXT... John Haney	08-10-2004 03:37 PM John Haney	0	284
TOP ? Hello in some databases there is TOP for example: select * from tab1 top 3 will show only 3 rows. Is there any similar in postgresql ? Thanx vertigo	08-02-2004 09:51 AM Tony Reina	1	186
ODBC creating nulls? From: "Dan Perlman" <dan (AT) dpci (DOT) NOSPAM.us> Subject: ODBC creating nulls? Date: Friday, July 09, 2004 10:43 AM Hi, Below is my VB6 code... Dan Perlman	07-09-2004 05:22 PM Dan Perlman	0	177
using sql to update a table ** 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... Julie Paten	07-06-2004 06:36 PM Julie Paten	0	184
Recovery after delete Hello! I accidentally deleted over 1,000,000 records from one table. I found a xlog file containing those records but I don't know the structure... Szymon	07-06-2004 09:45 AM Szymon	0	206
7.4 serial not working ? Hello i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL exists but does not working. Example: My table: create table1( id SERIAL, name... vertigo	07-05-2004 02:53 PM Tony Reina	1	185
import from oracle dmp. Hi, is there a way to make direct import to PostgreSQL from oracle dmp file ? -- best regards stic stic	07-01-2004 03:02 AM stic	0	244
transform like excel possible? how do i translate this... Peter Paskoff	06-25-2004 01:31 AM Peter Paskoff	0	159
Can I interrupt queries already processing in the server? 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... Laura Arbilla	06-22-2004 04:05 PM Laura Arbilla	0	152
[v7.0.3] loop through a database and union all tables begiining with "j" and name is like j### (#=digit) how can i do that? thx peter Peter Paskoff	06-21-2004 08:43 AM Peter Paskoff	3	209
Stored procedures in PL/PGSQL Hello, I am in a bit of a conflict here. I would like to know if the stored procedures that I write in PL/PGSQL to run on PostgreSQL 7.4.2 are ANSI... FET	06-15-2004 10:11 PM Christopher Browne	2	179
How to write a single update sql statement to update different setof attributes of a table How to write a single update sql statement to update different set of attributes of a table. In other words what will be the value of indicator... ajay	06-15-2004 09:42 PM Matt Emmerton	2	294
bytea SQL ERROR with size Hi, ok, so I have pictures that I store in Postgres (7.2.4) via JDBC. if the size of my picture is small (less than 1ko) it's ok, there is no... lionel pacoud	06-15-2004 09:42 AM lionel pacoud	1	200
one to one and many to many => one to (one and many) I have these tables. There are many languages, and many countries. Every country has many (some subset of) languages. create table countries... carloschoenberg@yahoo.com	06-14-2004 10:44 PM carloschoenberg@yahoo.com	0	159
large dimension table 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... Andreuzza	06-05-2004 03:23 AM Andreuzza	0	183
how to transfer contents Sir, I am a development engineer in network application I have a problem regarding upgrading my database the problem is how do I transfer the... brijesh	06-05-2004 02:10 AM Bhavin Patel	1	203
Concurrency relate issue. 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... Bhavin Patel	06-05-2004 02:06 AM Bhavin Patel	0	172

Page 2 of 6

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off