Jeff Brown wrote:
Hi guys
Is there some sort of C API available for PostgreSQL?
I'm quite happy with libpqxx.
ftp://gborg.postgresql.org/pub/libpqxx/stable/libpqxx-2.5.0.tar.gz
Cheers
Jeff
---(end of broadcast)---
TIP 8: explain analyze
I suspect the error below is bad. - Running 8.0.1 on linux FC3 on AMD 64.
septicide=# delete from sp_log where sp_log_time < (now() - interval '7
days')::abstime;
DELETE 215822
septicide=# vacuum full analyze;
ERROR: invalid page header in block 5991 of relation "sp_log_idx2"
septicide=# vacuum f
I had some interesting issues come up, I'm not sure they're related to
GCC 4, but that's the only thing that I can thing of.
Firstly, the gcc version is :
gcc (GCC) 4.0.0 20050130 (experimental)
1. While running ./configure, it failed on not being able to detect the
type of parameters to accept(
Toby Doig wrote:
...
So, what is going wrong? Why can't I import this very simple unicode file?
I've searched the archives and google, but to no avail.
try converting the file to utf-8.
iconv -t utf-8 -f utf-16 < unicode-file.txt > utf-8-file.txt
---(end of broadcast)
Keith C. Perry wrote:
I had this same issue as well but now I'm *slightly* concerned since most of my
code is perl. How soon would issue be reviewed? (not that I'm NOT going to use
your patch for right now).
I suspect that this is only an issue when you use
"--enable-thread-safety" which accordi
[EMAIL PROTECTED] wrote:
Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".
But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.
No losers here :-)
Great job guys !
.Sig - Sp
David Lutz wrote:
Hello, I want to convert an existing database with
SQL_ASCII encoding to UNICODE encoding.
(postgresql ver 7.3.2)
I thought that it might be as easy as:
pg_dump mydatabase > dump.sql
createdb --encoding=unicode newdatabase
psql newdatabase < dump.sql
but it wasn't going to be t
Dennis Gearon wrote:
Got a link to that section of the standard, or better yet, to a
'interpreted' version of the standard? :-)
Stephan Szabo wrote:
On Wed, 13 Aug 2003, Dennis Gearon wrote:
Dennis Bj?rklund wrote:
In the future we need indexes that depend on the locale (and a lot
of other
Dennis Gearon wrote:
I agree with all of that except for one caveat:
all my reading, and just general off the cuff thinking, says that
processing variable width characters SIGNIFICANTLY slows an
application. It seems better to PROCESS fixed width characters (1,2,4
byte), and TRANSMIT varia
I need to store some sensitive data and I want to use public keys so
anyone can encrypt the data but can only be decrupted by certain users.
Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.
It's probably not th
Dennis Gearon wrote:
How did you solve the problem .. :-)
inlining - most chars are just ascii and there are trivial optimizations
that can lead to just as fast as moving 4x the data around.
---(end of broadcast)---
TIP 6: Have you sear
Sean Chittenden wrote:
PostgreSQL will never be single proc, multi-threaded, and I don't
think it should be for reliability's sake. See my above post,
however, as I think I may have a better way to handle "lots of
connections" without using threads. -sc
never is a VERY long time ... Also
Sean Chittenden wrote:
PostgreSQL will never be single proc, multi-threaded, and I don't
think it should be for reliability's sake. See my above post,
however, as I think I may have a better way to handle "lots of
connections" without using threads. -sc
never is a VERY long time ... Also, the s
Sean Chittenden wrote:
I have received a question via the Advocacy site and I am not
knowledgeable enough to answer. Can you help?
The question is: can PostgreSQL handle between 10'000 and 40'000
simultaneous connections? The persone asking the question has to
choose between Oracle and PostgreSQL,
Reuben D. Budiardja wrote:
Hi all,
Suppose I have a table with more than one primary key. If I create another
table and I want one of the column of that second table REFERENCE to one of
the primary key of the first table, how do I do that?
eg
CREATE TABLE test
(
col1 VARCHAR(20),
col2 VARCHAR(2
15 matches
Mail list logo
