Re: [GENERAL] Visual Designer in linux?

2004-11-06 Thread Alvaro Herrera Munoz
On Sat, Nov 06, 2004 at 10:32:30PM -0500, Eric wrote: > Is there a visual designer (open source) in linux for database? I would > like to developp my data model on the computer... > > I see "dia" with uml library but... it won't export to SQL. You can have UML diagrams exported to SQL with some

Re: [GENERAL] Gborg down?

2004-11-06 Thread Alvaro Herrera Munoz
On Sat, Nov 06, 2004 at 11:09:07AM -0400, Marc G. Fournier wrote: > On Sat, 6 Nov 2004, Gaetano Mendola wrote: > > >I used to have a script on my remote server that I was running in BG before > >to touch the network, that script was bringing up the network if was down > >for more then 2 minutes. M

Re: [GENERAL] union query returning duplicates

2004-10-20 Thread Alvaro Herrera Munoz
On Wed, Oct 20, 2004 at 01:54:04PM +0200, Sim Zacks wrote: > It is very weird, I just tried both a group by and distinct and both > of them still return the duplicates. > > I also tried a very simple union which didn't return any duplicates, > both of these said, it is obviously not a problem with

Re: [HACKERS] [GENERAL] Rollback on Error

2004-10-08 Thread Alvaro Herrera Munoz
On Fri, Oct 08, 2004 at 08:40:56PM +0200, Michael Paesold wrote: > I hope you will be willing to comment on the issues when times come. I am > not really satisfied myself, but without further discussion I did not want > to continue to work on it. Anyway, I understand this is not the right time

Re: [GENERAL] Losing records when server hang

2004-08-08 Thread Alvaro Herrera Munoz
On Sun, Aug 08, 2004 at 08:36:36PM -0600, Scott Marlowe wrote: > On Sun, 2004-08-08 at 19:43, lec wrote: > > If I commit the following records 1,2,3,4,5,6,7,8,9,10 to the database > > and the server hangs, I could lose records 5,6,7,8,9 but record 10 is > > there. How is this possible and do an

Re: [GENERAL] pg_clog problems

2003-11-20 Thread Alvaro Herrera Munoz
On Thu, Nov 20, 2003 at 10:48:08AM -0300, Franco Bruno Borghesi wrote: > The file was there, but maybe some blocks where missed (it's a fat32 > fs). > Finally I reinstalled the database and the problem got solved, but now I > know what to do for the next time :P Doh ... Don't run your database in

Re: [GENERAL] Find overlapping time intervals, how?

2003-09-09 Thread Alvaro Herrera Munoz
On Tue, Sep 09, 2003 at 09:29:58PM +0200, Holger Marzen wrote: > Say, we have uptimes from several servers: > > Server up_from up_to > -- --- --- > s1 0:00 8:00 > s1 10:0020:00 > s1 22:0024:00 (would better be a timestamp with 0:00 and nex

Re: [GENERAL] to_timestamp and to_date fails in postgresql 7.1.3

2003-09-09 Thread Alvaro Herrera Munoz
On Tue, Sep 09, 2003 at 06:36:48PM +, kaab kaoutar wrote: > A client is using postgresql 7.1.3, and to_date() and to_timestamp() > functions fail sometimes,However they never do in postgresql 7.3.2. > Are these bugs? Maybe you are getting some interval with the seconds field set to 60? It was

Re: [GENERAL] [HACKERS] tablelevel and rowlevel locks

2003-09-04 Thread Alvaro Herrera Munoz
On Thu, Sep 04, 2003 at 11:21:05AM -0700, Jenny - wrote: > >I think the locks would actually by represented by PROCLOCK structures. > >The LOCK structures are for lockable objects, not for actual locks. > > Well,from what i understand, PROCLOCK stores the TransactionID and the LOCK > its holding

Re: [GENERAL] TCL trigger doesn't work after deleting a column

2003-09-04 Thread Alvaro Herrera Munoz
On Thu, Sep 04, 2003 at 09:01:08AM -0600, Josu? Maldonado wrote: > Tom, > > This is my table definition: [etc] It would help if you send the complete example, including the part where you actually drop a column from the table. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "La victoria es para quien s

Re: [GENERAL] Using oids

2003-09-03 Thread Alvaro Herrera Munoz
On Wed, Sep 03, 2003 at 01:05:30PM +0200, Malcolm Warren wrote: > I agree with you about database design and in fact fortunately I don't use > oids as foreign keys, which I thought unwise. However I have found oids very > useful as temporary unique references to a record in my programming. If I

Re: [GENERAL] Database recovery after fs crash

2003-08-26 Thread Alvaro Herrera Munoz
On Tue, Aug 26, 2003 at 10:17:48AM +1000, Martijn van Oosterhout wrote: > Wow. Take to pull out those backups... > > Hmm, presumably you don't have those. There are programs to read postgresql > data files however they need to know the exact structure of the table before > you can even start to de

Re: [GENERAL] Postgres Hanging on Inserts

2003-07-30 Thread Alvaro Herrera Munoz
On Wed, Jul 30, 2003 at 01:03:55PM -0500, Adam Kavan wrote: > I have found the problem (I think) below is the list of all the locks > pending on the relation. The relation is a hash index on the table that is > being INSERT'd rapidly. From what I can see pid 10024 and 10025 both have > an Exclus