ols and the likes?
|
| Many thanks to you all.
A version control system like Subversion comes to my mind. From there
you might be able to collect all relevant information. But I might be
wrong...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
ust handle the error - if
| any - and resume from there properly.
I didn't try myself, but wrapping the whole into a PL/pgSQL function and
using exceptions might do the work;
http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
Ciao,
Thomas
lt underlines the abbreviation with a dotted line and
displays the title when leaving the cursor on it. In a way this means
probably defining the abbreviation.
Reference: http://www.w3.org/TR/html401/struct/text.html#edef-ABBR
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
lled from within a Perl script.
|
| I've tried the same command directlly on the shell and it works fine.
| But from the perl script it complaints about pg_dump !!!???
What does "type -a pg_dump" output? Maybe it's a leftover from an
incomplete uninstall of a PostgreSQL install
perator in a string doesn't
leave much room for interpretation IMO, regardless if the "a" column
is of type "bigint" or not.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
output order is not guaranteed without order clause.
| 2. Qustion, sorting as main keys when query, how to do?
You mean: select * from test order by code ?
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
7;t easily seem to find a reference either. It is a FAQ though.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
s mismatch; did you already mention on what
architecture you are on?
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
vladimir konrad wrote:
I think that I understand basic relational theory but then I had an
idea. What I would like to know if this is sometimes done or that I am
possibly mad... Also, I do not know the terminology for this kind of
thing so I do not know where and what to look for.
Basically
nt for PostgreSQL, run it under your account (ie without
the "sudo").
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi,
Conor McTernan schrieb:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
[...]
Does anyone know of any commercial or open source software that will do this?
Datastudio (www.aquafold.com) also has a tool to build ER diagrams.
It is a commercial
om/doc/refman/5.0/en/faqs-sql-modes.html
You can set the @@sql_mode variable to a value, that MySQL almost behaves
like standard SQL (I've not tested this by myself, though).
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
Sent via pgsql
Troy Rasiah schrieb:
Apologies if this has been posted somewhere else but what is the
equivalent of perl's \b in postgres regular expressions ?
I think you are looking for \m and \M.
See
http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Ciao,
Thom
ter.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
? This is crucial and yet I
| am stumbling over something. Since I am not updating foo_old I am baffled
| as to what this messsage really means. I've tried "where foo_old.foo_id =
| foo.foo_id ... same message.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de
Raymond O'Donnell wrote:
> On 29/05/2009 00:14, Guy Rouillier wrote:
>> You may remove yourself. At the bottom of *every* message sent from the
>> mail list server are these instructions:
>
> Actually, for some reason, the instructions don't seem to have come
> through on the OP's emailI was
Henry schrieb:
I must be missing something here:
SELECT '1.1.1.1' ~ E'^\d+';
returns FALSE, when I would expect TRUE, as for:
SELECT '1.1.1.1' ~ E'^[[:digit:]]+';
ie, '[[:digit:]]' != '\d'
In config, "regex_flavor = advanced".
Any ideas?
Yes; you have to escape the backslash character:
Reg Me Please wrote:
Here it comes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
-> Nested Loop (cost=0.00..227.34 rows=49 width=8)
-> Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1 = 'VEND'::text)
-> Index Scan using i_T1_partial on T1
devi schrieb:
Hi Friends,
I wrote a sample php program that connects to PostgreSQL DB.
==> I was able to run the PHP program from the command prompt as
postgres user & not as anyother user
$ php pgsql.php
==> I was not able execute the same file from the web browser. FATAL
ERRO
Hi,
Ow Mun Heng schrieb:
I don't think I understand how PG implements fulltext searching or if my
search actually needs to use fulltext search.
No, that's something different. See the fine manual.
basically, I have a btree index on a SERIAL_NUMBER which is of sort like
ABC12345 or AAA123434
Keaton Adams schrieb:
Any ideas on how to debug these types of error messages?
Apr 30 01:36:02 mxlqa401 postgres[23600]: [3-1] FATAL: invalid frontend
message type 77
Apr 30 01:36:02 mxlqa401 postgres[23601]: [3-1] LOG: unexpected EOF on client
connection
Apr 30 01:36:02 mxlqa401 postgres[23
e and connection delays caused by improperly
configured IPV6 support on some Linux machines. Removing the responsible
modules from the kernel fixed it. Just another guess though :-)
Ciao,
Thomas
--
Dr. Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---
that fails, you probably have to edit
your /etc/modprobe.conf or /etc/modprobe.d/aliases file, comment
out the ipv6 module entry and reboot the machine.
Then repeat your test.
But again, I'm just guessing in the wild.
Ciao,
Thomas
--
Thomas Pundt --- http://www.pund
t; utility can help then? Something like
pg_dump -t artik munttest | recode latin1..utf | psql muntfinal
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 4: Have you searched o
On Wednesday 31 August 2005 14:09, Thomas Pundt wrote:
| maybe the "recode" utility can help then? Something like
|
| pg_dump -t artik munttest | recode latin1..utf | psql muntfinal
sorry to follow up on myself, but that command should read
pg_dump -t artik munttest | recode la
re script and
| hand-compiling the test program works if I say "/lib/libpam.so.0", but
| fails if I say "-lpam". Very bizarre - anyone encountered this?
Nothing bizarre here - you most probably have to install the pam-devel
package.
Ciao,
Thomas
--
Thomas Pundt <
y into postgres ? are
| there any special flags that i am missing ?
The "smallint", "integer" and "bigint" types are available regardless of that
output from configure.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
c0 t isinf
000140f0 t isinff
0001bc50 t isinfl
So the obvious question seems to be: is your postgres binary linked against
libm? Just a guess though - I'm not on any kind of Embedded Linux ...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
-
if we are using binaries on a rpm based system and without
| looking at the src.rpm is there a way to query the postgresql server to
| find out whether it was built against the zlib compression library ?
ldd /path/to/your/bin/postgres | grep libz
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTE
On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
| Can we have Auto Backup facility to schedule backup of
| PostgreSQL Database
| I am using version 8.2.0
why don't you use cron to set up a backup script?
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://r
ht want to look
at your init scripts (/etc/init.d/postgresql I assume) for how they do it.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
en = tsearch2_yyleng;
return SPACE;
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Monday 23 April 2007 14:56, chrisj wrote:
| Wow, how did you discover that?
man readline?
search for "quoted-insert"
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
DUN: (.*?) ' for
extracting the DUN part.
Ciao,
Thomas
--------
Thomas Pundt <[EMAIL PROTECTED]> -- http://www.pundt.de
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
h: it escapes some more characters in the generated SQL dump.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
--- Ora2Pg.pm 2004-12-30 01:30:40.0 +0100
+++ Ora2Pg.pm 2006-03-14 14:40:16.0 +0100
@@ -1091,8 +1091,11 @@
}
}
of the performance of INSERT and
| UPDATE.
how about using COPY for the import? Or at least putting the INSERTs into
a transaction using BEGIN and COMMIT? I would do the same with the UPDATEs:
put it into a transaction frame.
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> htt
s you from using a transaction here...
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
37 matches
Mail list logo
