#make
make[3]: Entering directory
`/opt_noraid/src/postgresql-8.3.0/src/interfaces/libpq'
echo '{ global:' >exports.list
gawk '/^[^#]/ {printf "%s;\n",$1}' exports.txt >>exports.list
echo ' local: *; };' >>exports.list
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-fno-strict-al
ount=0 !!
How to achieve this?
thnx a lot,
peter
--
mag. peter pilsl - goldfisch.at
IT-Consulting
Tel: +43-650-3574035
Tel: +43-1-8900602
Fax: +43-1-8900602-15
skype: peter.pilsl
[EMAIL PROTECTED]
www.goldfisch.at
---(end of broadcast)---
TI
does not know about the
CSV-option yet (not does the postgres 8).
Is there any ready tool to create flexible csv-files or any trick I did not find
out yet?
thnx,
peter
--
mag. peter pilsl - goldfisch.at
IT-Consulting
Tel: +43-650-3574035
Tel: +43-1-8900602
Fax: +43-1-8900602-15
skype: peter.
Richard Huxton wrote:
peter pilsl wrote:
I just get my mind crossed here:
I do a simple select with order on a text-type. In my opinion entries
with leading spaces should be either first (or maybe last) in the list.
But in my select the whitespace just seems to be ignored:
That'll be
I just get my mind crossed here:
I do a simple select with order on a text-type. In my opinion entries with
leading spaces should be either first (or maybe last) in the list.
But in my select the whitespace just seems to be ignored:
Note that the second row has a leading space and should imho
other update on the same table which
makes postgres break with a nested.loop -error (happily postgres detects
the recursion :)
thnx for any help
peter
--
mag. peter pilsl
goldfisch.at
IT- & dataconsulting
tel: +43 650 3574035
tel: +43 1 8900602
fax: +43 1 8900602 15
[EMAIL PROTECTED]
s like
select x,count(id<5),count(id>15) from test2 group by x;
thnx a lot,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fae +43 699 4 3574035
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
the count-aggreate counts every expression that does not evaluate to null.
I would like to have a count that counts all values that are true.
Do I really need to make a count( case when expression then 't' else
null) to implement this?
thnx,
peter
--
mag. peter pilsl
goldf
Martijn van Oosterhout wrote:
thnx a lot. But it does not work as expected cause the update-statement
ist not commiting for the whole table during the execution. So the
resulting order can be different from the original order, which is what
I try to avoid.
Well, that's because you're typin
6:40AM +0200, peter pilsl wrote:
I've entries with id's like:
x | id
---+
b | 1
a | 4
e | 5
c | 12
d | 19
(5 rows)
now I'd like to have the id in continuing number to get:
x | id
---+
b | 1
a | 2
e | 3
c | 4
d | 5
(5 rows)
Simpliest way to do would be to
pdate the whole
table using nextval on the sequencec. Unfortunately UPDATE does not know
about an order-statement.
Any Idea,
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fae +43 699 4 3574035
[EMAIL PROTECTED]
---(e
n?
Or is my question faulty at all, cause CPU is only 20% of the whole system.
Any comments appretiated,
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fae +43 699 4 3574035
[EMAIL PROTECTED]
---(end of broadcast)--
etc. On one system CPU-speed might be the bottleneck, on
others the RAM and so on. And the cost for a query on your system is not
always the same. Depending on swap, cache and so on.
Maybe you should consider having a second SQL-server to lower load.
best,
peter
--
mag. peter pilsl
goldfisch.at
cter varying::text
And more: here is my retrieving program. I use perl and the DBI-module
and the following code-snip
--
my $sth=$dbh->prepare(
'select OID from artikelindex where id_artikel=?');
foreach (@id) {
my $ret=$sth->execute($_);
my
while the
server crashed.
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fax +43 699 4 3574035
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
e the name, which is important.
thnx.
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fax +43 699 4 3574035
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
ld be stored somewhere in
this index.
My current solution is to read all the data without the WHERE-clause
and then fetch the needed ones, which is quite time-demanding.
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fax +43 699 4 3574035
[EMAIL PROTE
eeded ones, which is quite time-demanding.
thnx,
peter
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fax +43 699 4 3574035
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http:
wer postgresql-version, but my topic
did not apperar in the list, so I didnt try new 7.4.5. I think its
merely a problem with setting than with postgreSQL. (at least I hope so ...)
--
mag. peter pilsl
goldfisch.at
IT-management
tel +43 699 1 3574035
fax +43 699 4 3574035
[EMAIL PROTECTED]
---
rse converting to latin before storing
would be a solution but we plan to offer support for many non-latin languages
later and the meaning of unicode is to get rid of all this converting-stuff
after all.
thnx,
peter
--
IT-Consulting
mag. peter pilsl
tel:+43-699-1-3574035
fax:+43-699-4-
is there a trick to drop a column in a table ? or do I need to
recreate the table and drop the old one ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
---(end of
s the same query two times (difference is only
the limit-section) and this takes 8 instead of 4 seconds.
Any way to do better ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key avai
w can I work around ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
---(end of broadcast)---
TIP 2: you can get off all lists at once with the u
, search, entries per page ...). When he adds a new entry to
that database the application should automatically show exact the page
where the new entry is displayed.
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED
On Sun, Apr 22, 2001 at 03:37:12PM -0400, Tom Lane wrote:
> Peter Pilsl <[EMAIL PROTECTED]> writes:
> > Is there are way to use postmaster with the -i option (accept
> > tcp-ip-connections) and bind only to certain addresses interfaces ?
>
> In 7.1 there's a postm
Is there are way to use postmaster with the -i option (accept
tcp-ip-connections) and bind only to certain addresses interfaces ?
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
be, sounds curious if everythig is right on mew DB.
>
It is curious and I dont want play around any more on my testmachine. Later
in the weekend I will jump into the production-server and dump all
the stuff and try to restore the data in a new installed
7.1-environment.
I'll post my succe
other 7.1 : does a
brute filecopy do it ?
Thanx a lot for your help,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
oid's in the corresponding tables.
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
---(end of broadcast)---
TIP 5: Have you checked our ext
an use for copy/paste in access I guess ...
hope this helps,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
ns the tables for
oid's and save the corresponding blobs to files and restore the
blobs/update the tables later. But if (WAL) will do it for me I'm also
looking forward for it. When will it come and where can I find
information about it ?
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
write a script to restore the blobs ?
second question: how do you guys deal with blobs when
upgrading/backuping/restoring ?
thanx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: [EMAIL PROTECTED]
sms : [EMAIL PROTECTED]
pgp-key available
we just update from a 6.5 to a 7.0 version and we made a dumpall and we saved all
files too.
Restoring the data stored with dumpall didnt bring back the blobs again.
How can I restore the blobs out of the pure filedump again ?
thanks,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax
bh->{AutoCommit} = 0;
...
show_blob; # work fine !!
...
$lobj_fd = $dbh->func($blob-oid, 'lo_unlink');
bloberror('lo_unlink failed') if not(defined($lobj_fd));
...
$dbh->rollback;
...
show_blob; # get an error !!
...
thanx for any help,
peter
--
mag. peter pilsl
pgp-key available
34 matches
Mail list logo