I have some libraries that serve as libpq wrappers. One function has
the PGresult structure pointer passed to it. I'd like to be able to
determine the host name from within the function, but I don't have the
PGconn pointer to use PQhost().
Is there any workaround to this? Can I somehow pass PGresu
> You might try porting your code to libpqxx, which is C++-native and should
> make large swathes of this sort of code unnecessary.
>
I've seriously considered it (along with the npgsql library), but am
not really sure as to what the advantage(s) would be considering that
(with the corrections su
> I'm a bit rusty on C++ string mashing, but surely sizeof() is not the
> correct way to determine the number of bytes presently stored in a
> variable-length string?
>
> > * PQputCopyEnd(conn, msg);
Yes, I've had several people mention this and that did the trick.
Thanks to all that replie
I read in the manual that the libpq functions PQputline(conn, cmd) and
PQendcopy(conn) have been deprecated and that PQputCopyData(conn, cmd,
sizeof(cmd)) and PQputCopyEnd(conn, msg) are the replacements.
I'm trying to convert a program that works just fine with the old
functions. I assume I'm mis
Last link was wrong.
Here's the correct one.
http://www.dertech.com/pgmex/pgmex.html
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
DerTech LLC has developed a MATLAB interface for PostgreSQL. It's
essentially mex wrappers for the functions in libpq. We're releasing
it for free with source code included.
Here's the website link: http://www.dertech.com/neurodb/pgmex.html
Could this be added to the related projects page?
Thank
I've got a database running PostgreSQL 7.4.2 on Fedora Linux. In the
past, pg_dump would dump database backups using COPY to restore the
data. This time it appears that it has individual INSERTs for each
tuple. Perhaps I'm missing this in the latest documentation, but I
thought COPY was the default
In postgresql.conf the first entry should be something like 'tcpip'.
Set it to 'true'. That's the equivalent of the postmaster -D.
HTH,
-Tony
[EMAIL PROTECTED] (Nailah Ogeer) wrote in message news:<[EMAIL PROTECTED]>...
> How do you connect to postgres if it is running on a different machine. I
At 02:17 PM 7/20/02 +0900, Curt Sampson wrote:
>Have you tried it using the standard relational method of doing this?
>(I.e., you put the common fields in one table, and the extra fields in
>other tables, along with a foreign key relating the extra fields back
>to the main table.) That would more
d target = 3::smallint;
NOTICE: QUERY PLAN:
Unique (cost=100105115.88..100105115.93 rows=2 width=5)
-> Sort (cost=100105115.88..100105115.88 rows=19 width=5)
-> Seq Scan on center_out_cell (cost=1.00..100105115.47
rows=19 width=5)
EXPLAIN
db02=#
-Tony
At 09:47 P
I'm using Postgres 7.2.1 on a dual-Athlon running RedHat 7.3bigmem
with 2 Gig of RAM and a 240 Gig RAID 5 (3ware IDE RAID). I just did a
'vacuum analyze' on the database, however the same query to two
similar tables is coming up quite different. The two tables only
differ in that one ("center_out_
[EMAIL PROTECTED] ("Luis Alberto Amigo Navarro") wrote in message
news:<005901c1d17a$4d7b0e10$[EMAIL PROTECTED]>...
> >
> > cc-1070 cc: ERROR File = xact.c, Line = 587
> > The indicated type is incomplete.
> >
> > struct timeval delay;
>
> struct timeval must be defined
I've been able to compile previous versions of PostgreSQL on my SGI
machines, but am having trouble this time. I have an SGI O2 with IRIX
6.5.15f, gmake 3.79.1, and MIPSPro C 7.3.1.3 compiler. I can get
through the 'configure' step fine. I've copied the Makefile.irix5 up
to the src directory. I've
I know it's probably a long shot, but has anyone coded statistical
distributions as functions in PostgreSQL? Specifically, I'm looking
for a function to calculate the cumulative F distribution.
By the way, I know that I can do /df at the psql command line to list
the available functions. Is there
[EMAIL PROTECTED] (Bruno Mattarollo) wrote in message
news:<[EMAIL PROTECTED]>...
> Hello
>
> Thanks Peter! That solved the problem and I could get postgresql 7.1.3 to
> compile. Actually it works :) It seems that for my needs now, this GCC is
> enough... At least I could compile postgresql, pyt
Peter Moscatt <[EMAIL PROTECTED]> wrote in message
news:<4x9f7.126086$[EMAIL PROTECTED]>...
> I am pretty new to PostgreSQL so please bare with me :-)
>
> When issuing the CREATEDB MyDb then creating some tables with CREATE
> TABLE, I then go back and do a search for the file I have just crea
I recall seeing a message by Tom Lane stating that dropping and
re-creating a primary index may speed up db performance. Is there a
SQL command that will do this?
My current method is to use pg_dump -s to dump out the schema. Then I
go through and cut out everything but the CREATE INDEX lines. Th
I'd like to have statistics on when my database was last backed up or
vacuumed. Currently, I'm implementing this by using simple shell
scripts that write a date stamp to ascii files. I was wondering
whether this is or could be a feature added to Postgres?
For example, could one of the pg_* tables
In the past, I had to change the RedHat Linux kernel so that the
shared memory was set to something much higher than the default (which
I think was about 32 MBytes). It seems that this is no longer
necessary in RH 7.1 (kernel 2.4). Can someone confirm this?
-Tony
---(end
[EMAIL PROTECTED] (Peter Eisentraut) wrote in message
news:<[EMAIL PROTECTED]>...
> Every once in a while some user complains that "the cursor keys don't work
> anymore in psql". There has even been one case where a major vendor has
> shipped binaries without readline support. While we keep tel
20 matches
Mail list logo
