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
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
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
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo