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
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 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 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 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
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
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
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
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.
>
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
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
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
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
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
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
=
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
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
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 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, 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?
&
-
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
s-only", no_argument, NULL, 'g'},
{"host", required_argument, NULL, 'h'},
{"ignore-version", no_argument, NULL, 'i'},
{"oids", no_argument, NULL, 'o&#x
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
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
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 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
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
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
28 matches
Mail list logo
