Sponsored Links

comp.databases.postgresql comp.databases.postgresql

Page 6 of 12

Threads in Forum : comp.databases.postgresql

Rating Thread / Thread Starter	Last Post	Replies	Views
Re-installing PostreSQL Hello everyone, I'm running two postgresql servers on linux redhat. (pgsql versions : 7.2 and 8.2). I compiled postgresql from source and installed... news	01-16-2009 05:17 AM Tanguy	2	203
query based on result of another query Hi, I'm accessing postgres from php and trying to avoid to much queries to db. Corently I do one select, then check with php if result is not empty,... Michael	01-15-2009 09:33 AM Laurenz Albe	4	191
eliminate duplicates Hi, result of my query has duplicates on one column like that: id attr name fname 3 def Gerry gerry 3 en gerry gerry 1 ... Michael	01-15-2009 04:11 AM Michael	4	193
Advanced query question Hello Group, I am trying to design a query for the following situation. I have 3 tables as follows: 1. criteria(CID int, CName varchar(20), DefWt... aquadoll	01-13-2009 11:25 AM Laurenz Albe	1	159
Trouble on building PostGIS support Hi, on executing this command, I got from a German PostGIS installing tutorial... Frank Glück	01-13-2009 10:03 AM Laurenz Albe	3	179
Help with Update Query using Sub-query I get an error when I run this one, Im new to postgresql and think that this syntax used to work on ms sql...could be wrong, been a while. any... mehoss	01-07-2009 03:47 PM mehoss	1	201
Problem with changins user ( 1 2 3 4 ) Hello! I'm new in this group and I would like to solve one problem. I've just installed on my Debian machine PostgreSQL from source... Obserwator	12-29-2008 02:56 AM Laurenz Albe	32	580
select into not supported within stored procedures? ( 1 2 3 4 5 ... Last Page) Hi, I am trying to execute a select into statement inside a sp, if I test it as plain sql command it works well, when I try to create the sp with... Coniglio Sgabbiato	12-23-2008 04:53 AM Coniglio Sgabbiato	56	643
Sending UDP packets Hi, I wonder if there is a way to send UDP/TCP packets to other hosts from within plpgsql functions? As far as I know there's no such built-in... mrupio	12-20-2008 02:05 PM Andreas Kretschmer	8	171
Help needed with subquery CREATE TABLE "o"."tb_main" ( "cust_id" VARCHAR, "order_no" VARCHAR ) WITH OIDS; CREATE TABLE "o"."tb_detail" ( "order_no" VARCHAR, "item_name"... Dave	12-16-2008 01:38 PM Dave	0	140
.net & posgreSql ole db I created a new vb.net (2.0) app. and I wanted to create a connection to it, but when instancin connection object, I receive an error: There is no... bu	12-04-2008 11:32 AM Coniglio Sgabbiato	8	140
editing pl/pgsql procedures ( 1 2 3 4 5 ) Hi all, I am new to Postgres and now I am doing some programming in pl/pgsql. At this moment I am wirting procedures with a text editor and pasting... Coniglio Sgabbiato	12-04-2008 11:30 AM Coniglio Sgabbiato	48	547
LibPq.dll change a database connection. ( 1 2 3 ) Hello to all. You can change the database of an active connection similar to the function of MySql mysql_select_db (oConn, cNewDB), without creating... Enzo Campanella	11-18-2008 10:32 AM Laurenz Albe	24	210
help on aggregate functions Hello, I am importing an old database into a new one with a new data structure, in order to map the old relations to new ones I need to perform some... Coniglio Sgabbiato	11-18-2008 06:39 AM Coniglio Sgabbiato	8	111
There is any graphical statistic tool/database modeling tool on Postgresql? Hello, I am looking for a web application for monitoring Postgresql, Like MONyog for mysql or Mysql, there is any one ? Why mysql have a lot of this... Mathieu POUSSIN	11-17-2008 02:51 AM Thomas Kellerer	8	107
Login/Connect denied if started as Administrator (Windows) Hello, how can I start postgreSQL as/wihtin the Administrator-Account (Windows XP SP3) The problem is that I have a PHP Application and would like... Thomas Steinbach	11-12-2008 04:46 PM Thomas Steinbach	0	90
Re: FATAL: incorrect checksum in control file ( 1 2 ) Józef Brodzi?ski <szopen (AT) nocnik (DOT) org> wrote: Then you are lost. Sorry. Yours, Laurenz Albe Laurenz Albe	11-10-2008 07:36 AM Laurenz Albe	10	217
MSVCR71.DLL and MSVCR80.DLL Call Nonexistent Functions in KERNEL32.DLL I am using Dependency Walker from http://www.dependencywalker.com/ to find out why I cannot start PostgreSQL in PHP Fast CGI running under Windows... Artist	11-09-2008 03:23 PM Artist	0	166
Novice email notification in update/insert/delete trigger ( 1 2 3 ) Hi all, Some of my users have requested that I implement and email notification system in an application. I can do it programatically, however what... johan.nel@xsinet.co.za	11-01-2008 10:51 AM Johan Nel	24	172
xml2 on win32 ( 1 2 3 4 5 ) Hi all, I have installed postgres 8.3 on windows vista. Unfortunately I did not enabled xml2 support during the installation. How can I add this... Zeljko Peric	10-31-2008 07:23 AM Laurenz Albe	40	482
annotated postgresql.conf ( 1 2 3 4 5 ... Last Page) Hi, I am trying to increase performances of Postgres by changing some memory parameters according to this... Coniglio Sgabbiato	10-30-2008 07:18 PM Coniglio Sgabbiato	120	849
Re: Subquery problems ( 1 2 3 ) Nico, select fld3 from table t where t.fld2 in (select max(fld2) from table); HTH, Johan Nel Pretoria, South Africa. Nico wrote: Johan Nel	10-28-2008 03:52 AM Andreas Kretschmer	22	221
Re: Newbie problems with date functions Björn Keil schrieb: The function is named "date_trunc". postgres=# select date_trunc('month', TIMESTAMP '2008-10-11') as... Armin Saul	10-25-2008 12:45 PM Armin Saul	3	131
\d mytable should display if trigger is enabled ( 1 2 ) Hi, I have a feature request: \d mytable should display if a trigger is enabled or disabled. Do others think this would be useful, too? Thomas Thomas Guettler	10-22-2008 06:35 AM Thomas Guettler	16	143
Using postgres for large database ( 1 2 ) Hello! I'm newbie in databases but I have a project where it's necessary. I need a DB software to store about a few Gb of text (xml) documents... Daniil Baturin	10-20-2008 03:48 AM Laurenz Albe	16	220
Sequence in Session ( 1 2 3 ) Hi, I would like to insert some data series (aroung 60.000 values / series). My table have this columns: master_id, series_id, position, value (all... Philipp Kraus	10-13-2008 07:53 AM Laurenz Albe	24	213
Names of Constraint Triggers Hi, I had a problem, that I was unable to drop a constraint trigger. 1. Why do constraint trigger loose their name and get... Thomas Guettler	10-09-2008 01:37 PM Nico Latzer	8	67
constraint trigger bound to session Hi, is it possible to create a constraint trigger which works only on the current session? I just used a constraint trigger to debug triggers which... Thomas Guettler	10-09-2008 09:39 AM Andreas Kretschmer	8	77
Distance and database ( 1 2 3 4 ) Hello, I have a small problem between maths and databases. I have a table in a database with 55 columns of reals and at least 200.000 lines (but up... Alain Reymond	10-08-2008 08:17 AM Alain Reymond	32	264
Nested Transactions ( 1 2 3 4 5 ... Last Page) Hi, postgres supports nested transactions by using savepoints. Unfortunately savepoints get lost after a commit. Is there any plan to support... Thomas Guettler	10-02-2008 07:58 AM Laurenz Albe	96	584
pgAdminIII restore database issue ( 1 2 3 4 5 ) Hi, I would like to modify by hand plain text dump of database (in SQL). I've done all changes and now my intention is to use pgAdminIII to... Marek	09-10-2008 07:20 AM Marek	48	292
check constraint on other column ( 1 2 ) Hello, is it possible to define a check with the following rules, without using a trigger? When inserting a value in field1: - if field2=true then... Generale Cluster	09-09-2008 02:21 AM Laurenz Albe	16	122
Multiple SELECTs cached by Postgres? ( 1 2 3 4 ) Hello group, I've a performance question about Postgres. Say I have two queries which are complex and require lots of time (many joins, etc). For my... Johannes Bauer	09-08-2008 03:14 AM Laurenz Albe	32	194
Trigger problem ( 1 2 ) Hello group, I'm playing around with triggers. What I want to achieve is a table of subnets. All subnets should be disjoint, network is of type... Johannes Bauer	08-31-2008 03:41 PM Andreas Kretschmer	16	119
Postgres CIDR/INET management - any useful functions? ( 1 2 ) Hello group, again I am stuck with a different problem. Let's say I have given a subnet '10.4.0.0/16'::cidr and a list of... Johannes Bauer	08-31-2008 03:08 PM Johannes Bauer	16	249
Backup and restore, manual rearrange ( 1 2 ) Hello group, I just found something extremely annoying: I backup my DB with pg_dump to extract the data. Then I drop the schema public in the... Johannes Bauer	08-25-2008 10:37 AM Johannes Bauer	16	112
Create VIEW readability ( 1 2 ) Hello group, for purposes of better readability I tried to avoid subqueries (which tend to become quite obfuscating at the 4th or 5th level of... Johannes Bauer	08-25-2008 10:36 AM Johannes Bauer	16	128
implementing the rules of business within the database Guys! is it better to implement the business logic within the database? i.e. through functions, triggers, constraints .. etc or implement the logic... Mahdi	08-14-2008 11:46 PM Guido Neitzer	8	49
can I restore window's Postgresql BKUP to a SUN SPARC server? ( 1 2 3 ) I know backup and restoratio between Linux/Windows is fine, but what about Sun SPARC platform, SUN sparc is using BLOCK, which is different... steeles	08-13-2008 04:17 AM Laurenz Albe	24	143
Remote connections ( 1 2 ) I have to allow remote access to my server from any PC. Can I enable the connection from any ip address, without writing it... Danilo Giuliani	08-05-2008 05:17 AM Danilo Giuliani	16	130
optimzing query with substr ( 1 2 3 4 5 ... Last Page) Hi Ng, maybe this question is not closely relatd to postgres but maybe someone can proide a better way than my approach. I'm trying to implement a... reppisch	08-05-2008 04:15 AM reppisch	64	368
ORDER BY in UNION in postgres 7.3.9 "SELECT a.*, m.mailbox_name FROM addresses a, mailboxes m, link_mailbox_addresses lma " + "WHERE NOT temp_address AND NOT delete AND a.address_ref >... Robert Welz	08-05-2008 03:44 AM Robert Welz	0	54
Libpq.dll ( 1 2 3 4 5 ) Hello everyone. I'm trying to interface my program in Visual Object so native postgreSQL through Libpq.dll. I have a problem with the dll in... Enzo Campanella	08-05-2008 03:21 AM Laurenz Albe	40	242
Complex unknown dept of select, maybe not so complex if you knowhow to do it Hi all, I have two pg tables that I try to define sub-forms and controls in: Table:formdef form_no serial, form_id... Johan Nel	08-01-2008 03:07 AM Laurenz Albe	8	65
Help: choose platform for postgresql HA load balancing I am having a project that will be using postgresql for HA (high availablity) and load balancing. Being search for a while, here is what I... steeles	07-31-2008 11:10 AM Laurenz Albe	8	73
pg_restore -a -c Hi, man pg_restore: -a Restore only the data, not the schema (data definitions). -c Clean (drop) database objects before recreating them. If -a is... Thomas Guettler	07-30-2008 11:47 AM Laurenz Albe	8	56
Install problem: I have no C: drive but installation only wants thatdrive Greetings from a newbie. I just downloaded PosgreSql for the first time, pending a possible job interview. Because I wanted the most trouble-free... Beau Nanaz	07-24-2008 04:56 AM Laurenz Albe	8	75
RULE: UPDATE on INSERT, but INSERT on UPDATE Hello list, I've a table where I want a UPDATE performed if the primary key that should be inserted already exists, but which performs a INSERT if... Johannes Bauer	07-24-2008 03:32 AM Åukasz Filut	8	66
Q: Update with Case when Hello Everybody! I'm trying to update a table with the following update statement, but always getting a syntax error: UPDATE object4 CASE WHEN... Ralf Bender	07-14-2008 08:32 AM Ralf Bender	0	86
psql interactive doesn't show error messages ( 1 2 3 4 5 ... Last Page) On Jul 5, 5:42 am, Mark Cudworth <use... (AT) markc (DOT) users.panix.com> wrote: I've tried that, but had no success. luislupe@gmail.com	07-05-2008 09:32 AM Luis P. Mendes	64	273

Page 6 of 12

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