had a lot of work
with reconstructing the contents of one of our databases (we lost it
due to a disk crash).
Right, we should have tested our backups but they worked with the tested
data set...
Oliver, can you please forward this upstream?
Thanks
Torsten
- --
Torsten Landschoff Bluehor
to be deleted in spite of the REFERENCES
clause pointing to that table. These may bring the db to an inconsistent
state.
...
--- End of Forwarded Message
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/o
on Linux) it automatically
nices (lowers the priority of) the process. You may not want the
priority lowered...
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 C
l
ii libpgsql2 7.2.1-2Shared library libpq.so.2 for Post
ii libreadline4 4.2a-5 GNU readline and history libraries
ii libssl0.9.6 0.9.6c-2 SSL shared libraries
ii zlib1g1:1.1.4-1 com
on to other calendars is through a
set of suitable functions, which haven't been written yet.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09
On Tue, 2003-02-25 at 22:08, Tim Ellis wrote:
> On Mon, 2003-02-24 at 23:03, Oliver Elphick wrote:
> > different for different countries. There was a discussion of this on
> > the patches list recently
> > (http://archives.postgresql.org/pgsql-patches/2003-02/msg00038.php an
s-only", no_argument, NULL, 'g'},
{"host", required_argument, NULL, 'h'},
{"ignore-version", no_argument, NULL, 'i'},
{"oids", no_argument, NULL, 'o&#x
-
00:00:00+00 <-- ...permanently, it seems.
(1 row)
The same seems to happen with date_trunc()
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 0
On Thu, 2003-03-13 at 23:06, Tom Lane wrote:
> Oliver Elphick <[EMAIL PROTECTED]> writes:
> > This is with -configure -enable-integer-datetime in 7.3.2, i386 Linux
> > platform. Is anyone else seeing this? If so, does it happen without
> > --enable-integer-datetime?
&
on to see how.
You also need to look at access controls in $PGDATA/pg_hba.conf - see
the Administrator's manual.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E
On Thu, 2004-01-01 at 17:58, Tom Lane wrote:
> Oliver Elphick <[EMAIL PROTECTED]> writes:
> > On Thu, 2004-01-01 at 03:22, Oliver Elphick wrote:
> >> What is needed to provide spinlock support for linux on hppa?
>
> Possibly nothing --- can you try CVS tip? Bru
On Thu, 2004-01-01 at 03:22, Oliver Elphick wrote:
> What is needed to provide spinlock support for linux on hppa?
I should add that 7.3.4 built OK.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
ead. The
logjam only cleared in time for me to put 7.4.1 in unstable.
Unfortunately, this meant that packages didn't get built for other
architectures unless someone using those architectures did a build from
source, which apparently didn't happen with hppa.
--
Oliver Elphick
p;arch=hppa&stamp=1072828455&file=log&as=raw
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
=
me way.
Bastian
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
&quo
er whose identity the webserver itself is running. If you want
to have different users connecting through the webserver, you will have
to use some kind of password authentication instead.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight
On Fri, 2004-07-02 at 11:24, vertigo wrote:
> Hello
> i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL
> exists but does not working. Example:
> My table:
> create table1(
> id SERIAL,
> name VARCHAR(100)
> );
>
> insert into table1 (name) values('name1');
> ERROR: duplicate key viol
seq"'::text). Therefore nextval is
being executed multiple times.
> - How can I bypass this problem and ensure that I use the correct value,
>and that it's not incremented once more ?
Presumably, the rule should use currval('"album_id_seq"'::text
ferences
product_xref(id);
(and id in products should not be a serial field, or the default should
be explicitly set to nextval(product_xref_id_seq))
and the same for each child table
Then create a trigger function to create a record in product_xref on
insertion and delete it on deletion.
--
Oliv
your
plaintive appeal correctly. :-)
> disappear from the target set while waiting for a lock may result in less
> than LIMIT # of rows being returned. This can result in unintuitive
> behavior, so FOR UPDATE and LIMIT should only be combined after significant
> testing.
>
se. This is a
_feature_. It lets you ensure that every new database contains certain
objects.
If you don't want them in new databases, delete them from template1.
Oliver Elphick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
o obvious ones will be fixed).
Thanks,
Julien Cristau
- End of Forwarded Message -
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F
Pg 8.0.3 (Debian package) on AMD64, linux 2.6.12
I am importing a table using COPY. The data is tab-delimited. COPY
seems to be putting the data for one field into the preceding field,
which should contain the empty string.
Here is the data, with tabs indicated by ^I and end of line by $:
67829
On Wed, 2005-10-12 at 09:09 +0100, Oliver Elphick wrote:
> Pg 8.0.3 (Debian package) on AMD64, linux 2.6.12
>
> I am importing a table using COPY. The data is tab-delimited. COPY
> seems to be putting the data for one field into the preceding field,
> which should contain the em
On Wed, 2005-10-12 at 13:52 -0400, Tom Lane wrote:
> Oliver Elphick <[EMAIL PROTECTED]> writes:
> > Pg 8.0.3 (Debian package) on AMD64, linux 2.6.12
> > I am importing a table using COPY. The data is tab-delimited. COPY
> > seems to be putting the data for one fie
On Wed, 2005-10-12 at 12:37 -0600, Michael Fuhr wrote:
> On Wed, Oct 12, 2005 at 12:19:41PM -0600, Michael Fuhr wrote:
> > On Wed, Oct 12, 2005 at 07:08:20PM +0100, Oliver Elphick wrote:
> > > I should add that the table inherits from another one, but the
> > > swapped
On Wed, 2005-10-12 at 17:45 -0400, Tom Lane wrote:
> Oliver Elphick writes:
> > ... in this particular case, the column
> > order was wrong. I should add that the table inherits from another one,
> > but the swapped columns are a long way into the extra columns speci
On Wed, 2005-10-12 at 19:28 -0400, Tom Lane wrote:
> Oliver Elphick writes:
> > On Wed, 2005-10-12 at 17:45 -0400, Tom Lane wrote:
> >> Hm. Could we see the actual pg_attribute data for both this table and
> >> its parent?
>
> > Here you are:
>
> Tha
28 matches
Mail list logo
