alues();
I've a feeling that's what was meant in the original posting and that having
done that the nextval on the default sequence fails because the sequence is
not in the search_path.
I seem to remember something like turning up sometime last year for me. I
don't have a 7.4 or HEAD install to check against at the moment.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, 21 Jan 2004, Andrew Sullivan wrote:
> On Wed, Jan 21, 2004 at 11:23:40AM -0700, Rick Gigger wrote:
> >
> > Yes but sometimes an enterprise level application may need to be put on a
> > laptop and taken off-line. Having an embedded database that is compatible
> > with the one on the serve
On Fri, 16 Jan 2004, Jeff Bowden wrote:
> Tom Lane wrote:
>
> >Jeff Bowden <[EMAIL PROTECTED]> writes:
> >
> >
> >>Still, the main problem I, and I suspect others, would like to solve is
> >>installation/configuration. For my app I don't want the user to have to
> >>understand anything about
On Sat, 10 Jan 2004, Nigel J. Andrews wrote:
> And a common culprit is whatever is being used for usenet caching/serving...or
> ordinary mail which is just accumulating in /var/mail (or whereever).
Sheesh. Did I really put ordinary mailbox mail in the uses up inodes category?
I should tak
e usage.
>
> On linux, you can change the % reserved for root to 1% with tune2fs:
>
> tune2fs -m 1
--
Nigel J. Andrews
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mon, 5 Jan 2004, Gregory Stone wrote:
> I have a need to run postgres only when my Java application is running.
> Basically I want to do a Runtime.exec() from java in order to start up the
> DB server. Is there any reason why this should present a problem? My
> init.d script is su-ing to the pg
Just to poke fun at MySQl:
On Tue, 30 Dec 2003, Bret Busby wrote:
> ...
> It is alright for people in this thread, to say "But they are MySQL, and
> MySQL is not as powerful as PostgreSQL, so who cares what advantages
> there are in MySQL", but MySQL appears to be more mature, as it has
> thin
On Mon, 8 Dec 2003, Josué Maldonado wrote:
> Hello list,
>
> Is there a way to manual/explicit lock a record from within a plpgsql
> function?
SELECT ... FOR UPDATE
--
Nigel Andrews
---(end of broadcast)---
TIP 5: Have you checked our extens
On Tue, 18 Nov 2003, Rick Gigger wrote:
> I will search the archives but does anyone know off the top of their head
> which performs better?
lo_* but then I forgot to turn off compression on the bytea column.
--
Nigel Andrews
>
> - Original Message -
> From: "Keith C. Perry" <[EMAIL
[EMAIL PROTECTED] writes:
> I think the original driving thought technically has something to do with
> system backup, and restore or system re-install in the case of
> catastrophic failure, as well as what I've alluded to in regards to
> original server setup planning and how intended usage imp
On Mon, 10 Nov 2003, Pavel Stehule wrote:
> Hello,
>
> it isn't problem. You can write
>
> SELECT INTO
> IF FOUND THEN
> ...
> END IF
>
> or
>
> SELECT INTO ..
> GET DIAGNOSTICS variable = ROW_COUNT;
> IF variable > 0 THEN
> ...
> END IF
>
> You can see on
> http://developer.postgr
would require the sort step having retrieved all the
tuples and the others would just use the index pages.
It is Friday though.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Tue, 30 Sep 2003, Tom Lane wrote:
> "Nigel J. Andrews" <[EMAIL PROTECTED]> writes:
> > In 7.3 and less ssl connections fail if a host line matches before the hostssl
> > line. At least I think that's the situation, there is definitely something
> >
n, there is definitely something
there that will make a ssl connection get rejected even if there is an
appropiate entry in pg_hba.conf
This works more sensibly in 7.4 I believe.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Fri, 26 Sep 2003, [gb2312] zhuangjifeng wrote:
>
> hello,
> i wonder how and where i can find the part of source codes about how to create
> catalogs. i mean
> how to create the structure of pg_class and so on,not just insert the tuple of
> system attributes of
> user-defined table into i
On Thu, 25 Sep 2003, Claudio Lapidus wrote:
> Hello
>
> We need to deny access to the database for regular users, while allowing
> access to admins and a variety of application scripts.
>
> If we use passwords, everything is fine while interactive, but could not
> devise a way for scripts to han
y random() then id. *falls on floor giggling
like a little school girl*
> Anybody know what's going on here ? I've tried this from Zope/psycopg,
> pgAdminII, and psql ... removing the limit doesn't do any good, and neither
> does using ASC or DESC !
Sheesh, now all I've g
delete from aaa where id = 44
You wouldn't believe the number of times I've explained that error message to a
PHP developer.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregiste
kup without setting password. Or is their any
> > > other
> > > way to take backup.
> >
> >Look for the .pgpass entry in the document index. You can create a private
> >file containing usernames/passwords for databases.
> >
> >--
> > Richard Hu
[I'm not convinced this is a -hackers issue so have cross posted to -general in
the expectation followups will go there]
I also didn't feel there was much I could cut from the earlier posts without
losing relevent info, so I didn't. Sorry.
On Fri, 19 Sep 2003, chakkara rangarajan wrote:
> Chris
runs with 7.3.4? If
so please email it to me. The tar file is tsearch-v2-stable.tar.gz, just for
clarity and I can supply it if someone volunteers but doesn't have it.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 6: Have you searched ou
On Wed, 17 Sep 2003, Daniel Schuchardt wrote:
> Hm, but lo_import/lo_export imports/exports from the local filesystem.
> I want to upload/download a clientfile to/from the Server Database with
> psql. I think this is a feature in psql. But i can't remember...
Yes it is. You want to look up \lo_
k.
The odd thing is I never thought it a bug, just something to work around, until
someone else has been persuing it on the list as one (it's the create schema
thing).
--
Nigel J. Andrews
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ECTED] lib]#
Well not quite. The complaint is that the PHP interface to PostgreSQL isn't
found. As for why it can't be found I can't really help. Could be PHP
configure/build, could be it wasn't installed. A little surprising perhaps but
then I know next to nothing about
On Fri, 12 Sep 2003, Oliver Elphick wrote:
> On Fri, 2003-09-12 at 07:21, Nigel J. Andrews wrote:
> > On Thu, 11 Sep 2003, Richard Welty wrote:
> ...
> > > [Thu Sep 11 16:17:25 2003] [notice] caught SIGTERM, shutting down
> > > PHP Warning: Unable to load dynamic l
case
--
11:29:20
(1 row)
test=# select version();
version
---
PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC 2.95.4
(1 row)
There must be something differ
On Sun, 7 Sep 2003, Tom Lane wrote:
> "Nigel J. Andrews" <[EMAIL PROTECTED]> writes:
> > One thing that started worrying me having found what looks like a bug in
> > to_tsquery_name from the 7.3-stable version of tsearch v2 is the question of
> > bug f
On Thu, 4 Sep 2003, Teodor Sigaev wrote:
>
>
> Nigel J. Andrews wrote:
> >
> > I don't seem to be able to find the mailing list thread that covered pretty
> > much this exact unexpect exit fault. So, can anyone help with a fix,
> > explanation or link to
More importantly
I don't seem to be able to find the mailing list thread that covered pretty
much this exact unexpect exit fault. So, can anyone help with a fix,
explanation or link to the relevent thread please?
Thanks,
--
Nigel J. Andrews
---(end of broadcast)---
Replying to myself...
On Wed, 3 Sep 2003, Nigel J. Andrews wrote:
>
> The subject says it really. Is there a way to query the value of $libdir, and I
> don't mean the dynamic_library_path GUC?
>
> I ask because, I have scripts to create databases and I've come to m
t the right list but seeing as I'm emailing. tsearch2 doesn't
even compile outside of contrib/ I presume that is necessary? Is there any
particular reason why the stop word files are installed with no permissions for
'world'? It kinda screws up installing as one user and ru
would help, regarding
> this problem ? But a bugzilla tool, may also be nice :-)
>
> /BL
There is cvsweb available for the repository. I think it's linked from
somewhere on http://developers.postgresql.org/
--
Nigel J. Andrews
---(end of broadcast)
can administer users. So create a new user, say
postgres2. Initialise a data directory:
$ initdb -D ~postgres2/data
as that new user. Then when you need to you can at least start the db manually
by logging in as postgres2, which you are able to do since you have control
over that user.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
; >
> > Here's a normal day:
> >
> > neptune# cat /var/log/amavisd.o | grep "Aug 17" | awk '{print $7}' | sort
> > | uniq -c
> > 332 BAD
> > 13 BANNED
> > 938 INFECTED
> > 3792 Passed,
> >
> >
> >
> &
Marc, I'd be interested in seeing the updated stats for this bought of virus
transmission we're going through.
Yesterday you had almost 1 for 1 valid email. By then I think I was getting
about 3-4 per valid email but since then it's sky rocketed and it looks more
like 30+ per 1 valid message.
I
le;
ERROR (possibly)
and then there is the search path:
set search_path to second, first;
select * from atable;
Gives: value == 'this is second schema'
Hope that helps.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 2: you ca
significant wrong than slow/blocked queries.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 8: explain analyze is your friend
a search of the archive. Of course, someone like
Tom, Bruce etc. while no doubt pop up with the specifics.
--
Nigel J. Andrews
On Fri, 4 Jul 2003, Maksim Likharev wrote:
> Ok, what I see here tells me that text is slower then fixed len varchar,
> due to stored in separate table
extened to other kind of
> exceptions?
I was just looking at that fkey violation message yesterday and thinking how
much better it would be to be able to see the offending value in the
message. Is that what 7.4 shows?
--
Nigel J. Andrews
---(end of broadcast)--
e installed a v7.3.2 and PostgreSQL seems to be running very well but we
> want to get rid of this message.
>
> Thanks in advance for your response
>
>
You should ask your system admin to take a look. That init script should be
pretty straight forward unless your admin has rolled his/h
's JDBC-driver.
>
If you're looking to actually have a suitable method in your jdbc objects why
not simply code up your requirements in derived class and use that instead? I'd
have thought that was a near perfect example of object orientation.
--
Nigel J. Andrews
[rest of mes
would give you six rows the same
from that query?
BTW, the above query while the same as my version (I haven't inspected it so I
take your word for it) is not so good. That is forcing postgresql to join in
the tables in the specified order. Using the join constraints in the where
clause as mi
On Thu, 19 Jun 2003, Matthew Nuzum wrote:
> Regarding backup history:
>
> I have an application designed for novices. Apparently it's easy to hit the
> "Delete" button, and then say yes to the "Are you sure you want to delete
> this?" question even when they don't want to. Therefore I simply mar
re t_stockchanges.productid = t_prod_in_pgr.productid
and t_productgroups.id = t_prod_in_pgr.productgroupid
;
Without the foreign keys and other constraints though that could get very
wrong as you pointed out Dennis.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Thu, 19 Jun 2003, Nigel J. Andrews wrote:
> On Thu, 19 Jun 2003, Peter Eisentraut wrote:
>
> > Travis Hume writes:
> >
> > > So at this point all selects are screwed unless I issue a ROLLBACK;
> > > Why? Is there a way for SELECTs (or all SQL) statem
On Thu, 19 Jun 2003, Tom Lane wrote:
> "Nigel J. Andrews" <[EMAIL PROTECTED]> writes:
> > If in a trigger one does a select * from the table the trigger is on
> > is it safe to assume that tg_trigtuple (and so tg_newtuple) will use
> > the same TupleDesc as
first example
is in a script I will be running again and it turned up pretty consistently
before, I'm sure that that will be reproducable. That is unless the '\q'
sequences I've added to the end don't make it work.
--
Nigel J. Andrews
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
47 matches
Mail list logo
