[GENERAL] back-end dies on select

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

[GENERAL] Relation 'pg_user' does not exist

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

Re: [GENERAL] Sharing Postgres Files

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

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

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] Relation 'pg_user' does not exist

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: Re[2]: [[GENERAL] Please vote for postgresql!!!]

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] RI and restoring dumps

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.

[GENERAL] data change violation inside transaction

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] running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2

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] julian day number input/output

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

[GENERAL] Help with database locking

#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