dbTalk Databases Forums  

Sponsored Links


comp.databases.postgresql.general comp.databases.postgresql.general


Discuss in the comp.databases.postgresql.general forum.



Post New Thread
Threads in Forum : comp.databases.postgresql.general Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
On Sun, 10 Oct 2004 19:12:51 +0400, Eugeny Balakhonov <c0ff75 (AT) mail (DOT) ru> wrote: I think you could create a daemon/cron job which would get...
Eugeny Balakhonov
10-16-2004 06:44 PM
Gaetano Mendola Go to last post
9 159
In Microsoft SQL Server, I can write an UPDATE query as follows: update orders set RequiredDate = (case when c.City IN ('Seattle','Portland') then...
Mark Dexter
10-16-2004 11:11 AM
Mark Dexter Go to last post
2 278
Hello, I am trying to create audit tables for all of the tables in my database. The function, table and trigger create statements are...
Scott Cain
10-16-2004 01:57 AM
William Yu Go to last post
15 379
I'm in the process of adding more historic information to one of my databases. I've liked the theoretical treatment of the concept in "Temporal Data...
Eric D. Nielsen
10-16-2004 12:13 AM
Michael Glaesemann Go to last post
5 165
Hi All, Earlier this year there was a discussion between Tom and Ezra regarding extending 'set session authorization' to facilitate changing the...
Greg Wickham
10-15-2004 06:14 PM
Greg Wickham Go to last post
2 141
I read "Chapter 23. Monitoring Database Activity" to monitor postgresql, but on Solaris it doesn't work. I tried "/usr/ucb/ps", but it doesn't work...
Leonardo Francalanci
10-15-2004 02:50 PM
Andrew Sullivan Go to last post
5 152
I have a situtation where a particular table includes a timestamp column and a id column. The query I am working with right now filters based...
Thomas Yagel
10-15-2004 01:57 PM
Tom Lane Go to last post
1 144
Hi, given a table with some data, e.g. some monthly measures. Some of the measures are missing though. id m1 m2 m3 m4 m5 .... ...
Alexander Pucher
10-15-2004 12:21 PM
Marco Colombo Go to last post
3 143
Hi, I am getting ready to release a new version of my postgresql browser and regrettably no longer have access to any version 7 of postgresql. I...
Jerry LeVan
10-15-2004 12:10 PM
Jerry LeVan Go to last post
0 219
I am in the process of converting an existing database to PostGreSQL and wrote a generic script to update all of the sequences as they default at...
Sim Zacks
10-15-2004 11:40 AM
Michael Fuhr Go to last post
4 170
ljb <ljb220 (AT) mindspring (DOT) com> writes: Yeah, looks like Neil applied that about two weeks ago. regards, tom...
David Rysdam
10-15-2004 11:09 AM
Tom Lane Go to last post
2 126
I have a database in sql_ascii that I need to convert to Unicode. I tried using pg_dump -Fc .. but it fails on certain characters. like this one...
Jason Tesser
10-15-2004 10:48 AM
Alvaro Herrera Go to last post
3 137
One's marked VOLATILE, the other is marked IMMUTABLE. This affects whether it's considered a constant, the planner estimates and hence whether it...
Martijn van Oosterhout
10-15-2004 10:46 AM
Tom Lane Go to last post
2 148
Hi, When I execute a function, I would like psql to show me only RAISE NOTICE messages but not all function calls.... Indeed, I currently get some...
Patrick Fiche
10-15-2004 10:43 AM
David Rysdam Go to last post
4 133
Hello all, I am trying to get a total number of rows returned form a query. SELECT count(this) from table group by this Currently it is returning...
Dev
10-15-2004 08:47 AM
Dev Go to last post
5 166
Dear postgres community, I would like to know what are the significant changes and new features introduced in Postgres 8.0 which warranted the major...
Artem Litvinovich
10-15-2004 07:26 AM
David Garamond Go to last post
8 167
Hello, If I have a rule like this: CREATE OR REPLACE RULE sometable_update AS ON UPDATE TO table2 DO UPDATE cache SET updated_dt=NULL WHERE...
Net Virtual Mailing Lists
10-15-2004 05:57 AM
Oleg Bartunov Go to last post
2 121
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I'm trying to determine the best way of saying 'The current time in UTC with no time zone...
Stuart Bishop
10-15-2004 05:43 AM
Martijn van Oosterhout Go to last post
13 250
Hello. I'm writing SQL functions that take an action code and determine the rows visible by accessing application-maintained privilege...
Mike Mascari
10-15-2004 01:02 AM
Tom Lane Go to last post
1 114
Hi, I'd like to store who changed records on some tables. I'd prefer not to store the username but rather his/her ID. Will I allways have to...
Andreas
10-14-2004 10:24 PM
Andreas Go to last post
2 75
Hi, folks.... There is a file located at /usr/local/pgsql/data/base/26920/ named 35987 that is roughly 750mb. Is there any way to find out...
Michael Holden
10-14-2004 05:20 PM
Alvaro Herrera Go to last post
1 99
First, apologies in advance for this somewhat OT post ... I'm looking for a source of information on using the psycopg interface to postgresql. A...
Scott Frankel
10-14-2004 04:52 PM
Lee Harr Go to last post
2 126
Postgres returns me 't' or 'f' from boolean field How to change that it returns me 'true' or 'false' replace(its, 'f', 'false') AS its doesn't...
Bambero
10-14-2004 04:43 PM
Bambero Go to last post
0 222
Is there a way to do "dirty" reads on postgres? If there is an insert of a million records or so, is there a way to select from those records before...
Josh Close
10-14-2004 04:38 PM
Bruce Momjian Go to last post
1 119
Hmm, very good points. Thank you. I was hoping for a get/easy solution, but those never pan out :) Your suggestion is also much more flexible --...
Eric D Nielsen
10-14-2004 01:20 PM
Michael Fuhr Go to last post
1 98
I'm connected to a database and I want to verify that a username and password for some user is correct. I know I can verify a users existence by...
Thomas Hallgren
10-14-2004 01:19 PM
Steven Klassen Go to last post
3 232
I have a large amount of data that I copy in and out of Sybase very often. Now I also want to copy this data in and out of postgres. I have an...
David Rysdam
10-14-2004 11:47 AM
Michael Fuhr Go to last post
9 105
I wrote a function to sum arrays. It works, but I had to cast the data pointer to int64 (because my arrays are 'int8'): int64* ptr1 =...
Leonardo Francalanci
10-14-2004 09:33 AM
Leonardo Francalanci Go to last post
0 116
Hi Guys! Anyone already made a importation from CTREE files ( files .dtc) to PostgreSQL ? I know that there is a "contrib" tool to import files...
Rodrigo Carvalhaes
10-14-2004 09:21 AM
Rodrigo Carvalhaes Go to last post
0 116
Is there any way to remove a password, specifically from the postgres user? I installed the 8.0 Windows version via the installer, and it forces you...
Neil Berkman
10-14-2004 06:48 AM
Tom Lane Go to last post
1 115
Hi Gaetano: This procedure to recover data from a corrupted table should be documented somewhere... If it is, I could not find it! Now I wonder if...
ruben20@superguai.com
10-14-2004 05:09 AM
Gaetano Mendola Go to last post
5 109
Hi all, We, Software Research Associates, Inc., have started "PostgreSQL CE" (PostgreSQL Certificated Engineer), on Oct 1st. PostgreSQL CE is...
Tatsuo Ishii
10-13-2004 11:51 PM
Bruce Momjian Go to last post
3 133
Hello I am going to do a comparison betweem PgSQL and MySQL replication system. I hear there are some replication projects available for PgSQL. ...
nd02tsk@student.hig.se
10-13-2004 10:11 PM
Christopher Browne Go to last post
6 106
Dear All, Within a transaction, now() and current_timestamp are constant and give the time that the transaction started. This is normally what you...
Phil Endecott
10-13-2004 06:56 PM
Phil Endecott Go to last post
3 142
On Saturday, our database machine locked up hard on us due to some faulty hardware. Since then, we have been getting messages like this: ERROR: ...
Steve Wolfe
10-13-2004 05:46 PM
Tom Lane Go to last post
1 127
Hi I'm trying to create a select statement that will return all rows that are older than 30 milleseconds. Is either of these correct? select...
phil campaigne
10-13-2004 04:33 PM
phil campaigne Go to last post
0 84
Hi, Im looking for instructions on installing the postgresql ODBC driver on mac osx and windows. Is there any reference for that. Any help...
Alexander Cohen
10-13-2004 01:06 PM
Robby Russell Go to last post
1 118
In reference to the pg_clog errors I'm having, I am still looking for tips or help. Here's the info again: "ERROR: could not access status of...
Steve Wolfe
10-13-2004 01:01 PM
Steve Wolfe Go to last post
0 199
I found on http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql-porting.html that it is not poosible to use start or end a...
Michael Kleiser
10-13-2004 12:04 PM
Tino Wildenhain Go to last post
1 157
Hi, I'm trying to come up with a relatively simple multi-master replication solution. This is for multiple databases that need to be discreet,...
Ted Shab
10-13-2004 11:56 AM
Ted Shab Go to last post
5 103
Hi: I've migrated a couple of weeks ago from 7.4.2 to 7.4.5 and I am getting this error after executing a query: Warning: pg_exec() query failed:...
ruben20@superguai.com
10-13-2004 11:34 AM
Tom Lane Go to last post
2 125
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat Enterprise server, version 3.0). We find ourselves in an awkward position: we...
Michael Hannon
10-13-2004 09:56 AM
John Go to last post
4 211
The following query updated all the rows in the AssembliesBatch table, not just where batchID=5. There are 2 rows in the AssembliesBatch table with...
Sim Zacks
10-13-2004 09:41 AM
Ian Harding Go to last post
3 118
I try to detect potential memory management bugs of my program with valgrind. (PostgreSQL is at version 8.0 beta2. Operating System is Red Hat...
xiaoling he
10-13-2004 09:37 AM
Gaetano Mendola Go to last post
2 149
Hello everyone, I would like to know if anyone has found or developed any monitoring software for Postgres. I would like to be able to gather...
Bob Powell
10-13-2004 09:28 AM
Frank Kurzawa Go to last post
2 103
Hi I want to test PostgreSQL v8 native windows taht allows to create a table or column with 128 characters !! Where can i get it ? Thanks U for help...
DEHAINSALA Hondjack
10-13-2004 07:48 AM
DEHAINSALA Hondjack Go to last post
0 85
hello everybody, i ve got two big tables with the same structure. i would like to add the second one to the first one directly without generating a...
fx gamoy
10-13-2004 07:45 AM
DEHAINSALA Hondjack Go to last post
3 108
Hi, how come, if you create a user with no permissions at all, having been granted nothing, he can still log into any database, list available...
Henriksen, Jonas F
10-13-2004 05:37 AM
Richard Huxton Go to last post
1 127
Hello. For a project we are planning cost management. Each "user" should pay for the cost he/she generates on the postgresql server. The idea is that...
stig erikson
10-13-2004 03:59 AM
stig erikson Go to last post
0 111
hi, could anyone tell me how to open stat log in postgres? and how to monitor its concurrent connection number as well as the current sql(s)...
postgres2008
10-13-2004 03:55 AM
Neil Conway Go to last post
1 138
Post New Thread

Display Options
Showing threads 501 to 550 of 4769
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.