[GENERAL] Help with database locking

2001-02-26 Thread Matt Beauregard
#x27;re running 7.0.3. Any suggestions would be greatly appreciated. -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

[GENERAL] julian day number input/output

2001-01-11 Thread Matt Beauregard
How do I turn a timestamp into a Julian day number with decimal part? How do I turn one of these back into a timestamp? tia, -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

Re: [GENERAL] running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2

2001-01-04 Thread Matt Beauregard
haps you could mail [EMAIL PROTECTED] and find out if there are any issues with shared memory inside a jail. My first guess as to what the error message means is that it's not supported. -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

[GENERAL] data change violation inside transaction

2001-01-01 Thread Matt Beauregard
y when we remove all the references from the table definition, and isn't a problem outside a transaction, but we'd really like it to work inside the transaction. What's the reason for the error and how can we fix it? -- Matt Beauregard Information Technology Operations, DesignSca

Re: [GENERAL] RI and restoring dumps

2000-12-13 Thread Matt Beauregard
K constraints are implemented are the very last things in the dumpfile, so the data would be loaded into the database without any constraint checking. I shouldn't think it possible to have RI problems with this method of restoration assuming the table data was consistent when it was dumped.

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread Matt Beauregard
reset to 450ish twice just while I've been watching. They mustn't be too keen on installing it... -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

Re: [GENERAL] Relation 'pg_user' does not exist

2000-11-08 Thread Matt Beauregard
On Wed, Nov 08, 2000 at 10:03:05PM -0500, Tom Lane wrote: > Matt Beauregard <[EMAIL PROTECTED]> writes: > >>>> NOTICE: mdopen: couldn't open pg_user: No such file or directory > >> > >> This is strange in itself. There should be an (empty) file na

Re: [GENERAL] Relation 'pg_user' does not exist

2000-11-08 Thread Matt Beauregard
On Wed, Nov 08, 2000 at 08:40:08PM -0500, Tom Lane wrote: > Matt Beauregard <[EMAIL PROTECTED]> writes: > >> The plot thickens ... what did you say the error message was > > exactly? > > > !759 marauder@bofh:~$ pg_dump -h tweedledee ds > > getTypes(): S

Re: [GENERAL] Sharing Postgres Files

2000-11-07 Thread Matt Beauregard
to run one database server on the machine of your choice, with local datafiles, and have both web servers connect to the database server using internet sockets. -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

[GENERAL] Relation 'pg_user' does not exist

2000-11-07 Thread Matt Beauregard
least get my dumps working again? -- Matt Beauregard Information Technology Operations, DesignScape Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

[GENERAL] back-end dies on select

2000-09-06 Thread Matt Beauregard
the server was lost. Attempting reset: Failed. !# That's the first time anything like this has happened... no doubt I have the join syntax wrong (I don't normally use natural joins) but it shouldn't bring down my connection, should it? -- Matt Beauregard Information Techno