Hi,
I try to rebuild my pg 7.4 to get generated jdbc driver.
If I run gmake it stops with error (without --with-java option I do not
have any problems to complite it).
I send the error message (one part from message):
gmake[5]: Nothing to be done for `all'.
gmake[5]: Leaving directory `/pginst/po
pgSql 7.4.0
Hi,
Suppose, there are two (2) schemas in the database: schemaA and schemaB.
schemaA is relatively small and updated all the time, schemaB is huge and
updated occasionally, maybe several times a day. The whole database, with
schemaA and schemaB, is dumped once a week, say Sunday, and
Hi all,
I've got a function in PG set up, the libpq C call goes like this:
PERFORM funcName(''t1'', ''t2'', ''t3'', ''t4'', NEW.someInteger,
NEW.someBoolean)
funcName looks like this:
create function funcName(text, text, text, text, int, boolean)
returns int as '/var/lib/postgres/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I want to change a column from text to bytea; since it seems that alter
table can't change the column type, i have to add a temporary column and
copy the data from the old one to the new, delete the old and rename the
new.
But it seems that Post
Title: RE: [ADMIN] Cast text to bytea
Have you seen this?
http://www.postgresql.org/docs/current/static/datatype-binary.html
Maybe you need some backslashes?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Alvar Freude
Sent: Tuesday, December 02, 2
Has anyone any experience with PGSQL 7.x and implenting the FTC
do-not-call list - which is about 50 million 10 digit N. American phone
numbers? If so what structures have you used and what have you done
interms of performance tweaks? Is there an equivalent to Oracle's IOT
(index organized tabl
Kris Kiger writes:
> I'm not sure if there is a good way to pass parameters through libpq,
> or will I have to use something like SPI to grab them? Use of libpq is
> preferable, but not absolute. I appreciate the input!
There is no choice: libpq connects to a remote database as a client; SPI
p
hi
there is any utility or command in postgresql for incremental backup or
incremental restore.
plz. help me.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere"
Hi Folks,
I've refreshed my Cygwin distribution and haven't noticed that postgres is
also being upgradeing. So it has been upgraded to version 7.4.1. Starting
"pg_ctl start -D /usr/local/psql/data -m fast 2>&1 &" sends an error
message like this:
$ FATAL: database files are incompatible with ser
xfs_freeze is a userspace program included in the xfsprogs rpm. It does run
on Redhat 7.3 (the SGI supplied kernels and userspace for RedHat 7.3 are
somewhat dated; I'd suggest patching the 2.4.21 kernel with XFS 1.3.1
patches and upgrading the userspace programs from the SRPMS). Post to the
linux-
10 matches
Mail list logo