The installer should have an option for 'client only' so you end up with
psql, pg_dump and friends but not the database.
From http://www.postgresql.org/download/windows :
pgInstaller packages are only being maintained for PostgreSQL 8.2 and 8.3.
8.3 pg_dump returns error for 8.4 database.
Hello all,
I'm trying to write a postgres client application in C.
I'm having to make use of some existing in-house code that soley uses ECPG to
interact with a number of databases. However, I need to exploit some
lower-level libpq functionality directly.
Does anyone know how I can get hold
Does anyone know if the Postgres DBD for the Perl DBI supports the array
datatype?
Thanks in Advance !
On Tue, Sep 08, 2009 at 05:11:02PM +0100, Sam Mason wrote:
On Tue, Sep 08, 2009 at 05:58:01PM +0200, Kristian Larsson wrote:
On Tue, Sep 08, 2009 at 11:37:02AM -0400, Tom Lane wrote:
I think the whole thing is a bit of a crock; adding integers to inet
addresses doesn't make a lot of sense
Kristian Larsson krist...@spritelink.net writes:
Do we
a) ignore it and let users use the workarounds?
b) add a next_address() as per Toms suggestion ?
c) add a conversation between NUMERIC and INET so one can add a
NUMERIC to an INET just as is possible today with INTEGERs?
I vote for (a).
Hi folks
First time poster here so please extend grace if I don't initially
provide what is needed to help.
I am running postgresql 8.3.7 on debian lenny
(postgresql-8.3_8.3.7-0lenny1_i386.deb).
I have three of these servers and generally they run well.
On this one server if I use the
Alvaro Herrera wrote:
decibel wrote:
On Aug 6, 2009, at 2:00 PM, Bill Moran wrote:
Well ... life better really depends on which failure scenario you're
more comfortable with ... personally, I'd rather lose log messages
than
have the DB system go down. Of course, if auditing is
Grant Maxwell wrote:
Hi folks
First time poster here so please extend grace if I don't initially
provide what is needed to help.
I am running postgresql 8.3.7 on debian lenny
(postgresql-8.3_8.3.7-0lenny1_i386.deb)
Well that's useful.
I have three of these servers and generally they
On Thu, Sep 10, 2009 at 10:30:49AM -0400, Tom Lane wrote:
Kristian Larsson krist...@spritelink.net writes:
Do we
c) add a conversation between NUMERIC and INET so one can add a
NUMERIC to an INET just as is possible today with INTEGERs?
Proposal (c) is disingenuous because it ignores the
On Thu, Sep 10, 2009 at 9:41 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
Does anyone know if the Postgres DBD for the Perl DBI supports the array
datatype?
I use numeric array columns with DBD::Pg. What do you define as support?
--
Sent via pgsql-general mailing list
I plan to use text arrays.
I have an old O'Reilly Programming the Perl DBI and it doesn't mention
supoprt of these things. I suppose that this might be because some DBs don't
support them. But PG does, and I was wondering how it would pass column data
which is an array when using something
On Thu, Sep 10, 2009 at 8:37 AM, Grant
Maxwellgrant.maxw...@maxan.com.au wrote:
Hi folks
First time poster here so please extend grace if I don't initially provide
what is needed to help.
I am running postgresql 8.3.7 on debian lenny
(postgresql-8.3_8.3.7-0lenny1_i386.deb).
I have three of
Berge Schwebs =?utf-8?Q?Bj=C3=B8rlo?= be...@trivini.no writes:
Recently, WAL archiving begain failing on the test which checks wether the
file exists. This first occured two hours after an incident where someone
edited pg_hba.conf and left it with permissions denying Postgres read access
to
Hi Alban-
I have two tables that are georeferenced (although in this case I'm
not using PostGIS) that I need to join.
A ( lat | lon | depth | value)
|A| = 1,100,000
B ( lat | lon | attributes)
|B| = 14,000,000
A is a special case because the lat / lon values are all at half
On Thursday 10 September 2009 18:28:28 Gauthier, Dave wrote:
I have an old O'Reilly Programming the Perl DBI and it doesn't mention
supoprt of these things. I suppose that this might be because some DBs
don't support them. But PG does, and I was wondering how it would pass
column data which
set client_encoding = 'utf8';
copy from stdin/to stdout;
What if I want to do this on the server side (because it's much, much
faster)? Does COPY use the default encoding of the database? If not,
what?
If this is a restrictive as it appears, and there are no outstanding
enhancements planned in
Peter Headland pheadl...@actuate.com writes:
set client_encoding = 'utf8';
copy from stdin/to stdout;
What if I want to do this on the server side (because it's much, much
faster)? Does COPY use the default encoding of the database? If not,
what?
If this is a restrictive as it appears, and
On 10 Sep 2009, at 19:09, Christopher Condit wrote:
Here are both queries (with explain analyze):
EXPLAIN ANALYZE SELECT B.* FROM B,
(SELECT lat, lon FROM A WHERE value 0 AND value 2 AND depth = 0)
AS foo WHERE getwoalatitude(B.latitude::numeric) = foo.lat AND
The COPY command reference page saith
Input data is interpreted according to the current client encoding,
and output data is encoded in the the current client encoding, even
if the data does not pass through the client but is read from or
written to a file.
Rats - I read the
- Peter Headland pheadl...@actuate.com wrote:
The COPY command reference page saith
Input data is interpreted according to the current client
encoding,
and output data is encoded in the the current client encoding,
even
if the data does not pass through the client but is
Hi,
I have a situation where trying to drop a table results in:
#drop table cdrimporterror_old;
NOTICE: default for table cdrimporterror column cdrimporterrorid
depends on sequence cdrimporterror_cdrimporterrorid_seq
ERROR: cannot drop table cdrimporterror_old because other objects depend on
Peter Headland pheadl...@actuate.com writes:
How about my suggestion to add a means (extend COPY syntax) to specify
encoding explicitly and handle UTF lead bytes - would that be of
interest?
There are no lead bytes in UTF-8, and we make no pretense of handling
UTF-16, so I don't think we'd be
If I've got a function (sql or plpgsql) that takes anyelement as a
param, how do I determine the type name or oid that was actually passed
in? I figure there is probably a function for this but darn if I can
find it.
Specifically, I'm trying to make a function like Oracle's dump that will
There are no lead bytes in UTF-8
Sorry, sloppy use of terminology. I should have said UTF signatures
aka the byte order mark. IOW, the magic number bytes commonly found
at the front of UTF encoded files:
UTF-16 little-endian FF FE
UTF-16 big-endian FE FF
UTF-8 EF BB BF
These tend to be
Maybe the link might help?
http://www.postgresql.org/docs/8.4/interactive/multibyte.html
That page is too generic; what would be helpful is a section in the doc for
each command that is affected by I18N/L10N considerations, that identifies how
that specific command behaves.
Now that I have
Hello
please, try to look on function pg_typeof
postgres=# CREATE OR REPLACE FUNCTION x(anyelement)
RETURNS oid AS $$
SELECT pg_typeof($1)::oid; $$ LANGUAGE sql;
CREATE FUNCTION
postgres=# select x(10);
x
23
(1 row)
postgres=# select x(current_date);
x
--
1082
(1 row)
postgres=#
David Brain wrote:
Hi,
I have a situation where trying to drop a table results in:
#drop table cdrimporterror_old;
NOTICE: default for table cdrimporterror column cdrimporterrorid
depends on sequence cdrimporterror_cdrimporterrorid_seq
ERROR: cannot drop table cdrimporterror_old
David Brain dbr...@bandwidth.com writes:
I have a situation where trying to drop a table results in:
#drop table cdrimporterror_old;
NOTICE: default for table cdrimporterror column cdrimporterrorid
depends on sequence cdrimporterror_cdrimporterrorid_seq
ERROR: cannot drop table
Scott Bailey arta...@comcast.net writes:
Specifically, I'm trying to make a function like Oracle's dump that will
take anything as input and return the internal representation of it. So
I want to determine what type was passed in and call the appropriate
send function.
You would need to
2009/9/10 Tom Lane t...@sss.pgh.pa.us:
Scott Bailey arta...@comcast.net writes:
Specifically, I'm trying to make a function like Oracle's dump that will
take anything as input and return the internal representation of it. So
I want to determine what type was passed in and call the appropriate
please, try to look on function pg_typeof
Thanks Pavel. Just what I needed. But you're too late on the orafce
recommendation. I had already written it by the time you posted. I would
have written it any way though because Tom said I couldn't :)
You would need to write that in C.
Two
2009/9/10 Scott Bailey arta...@comcast.net:
please, try to look on function pg_typeof
Thanks Pavel. Just what I needed. But you're too late on the orafce
recommendation. I had already written it by the time you posted. I would
have written it any way though because Tom said I couldn't :)
Hi,
On Thu, Sep 10, 2009 at 2:55 PM, Tom Lane t...@sss.pgh.pa.us wrote:
The ownership link is still there, evidently, and should be switched
to the new table. Read up on ALTER SEQUENCE OWNED BY.
regards, tom lane
Thank you - that was the issue, once the ownership
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
On this one server if I use the command show all in psql,
phpPgAdmin
or pgAdmin3 the postgresql server spits the dummy as follows:
postgres=# show all;
server closed the connection unexpectedly
Hmm - some modules can provide their own
Grant Maxwell grant.maxw...@maxan.com.au writes:
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
Hmm - some modules can provide their own config variables. Do you have
the same modules installed in all three servers?
How can I determine what modules are installed ?
The
Peter Headland wrote:
As a general comment, I18N/L10N is a hairy enough topic that it merits
its own heading in any commands where it is an issue.
I agree, this seems a good idea because people is often confused by
this.
--
Alvaro Herrera
On 11/09/2009, at 8:17 AM, Tom Lane wrote:
Grant Maxwell grant.maxw...@maxan.com.au writes:
On 11/09/2009, at 1:09 AM, Richard Huxton wrote:
Hmm - some modules can provide their own config variables. Do you
have
the same modules installed in all three servers?
How can I
Grant Maxwell grant.maxw...@maxan.com.au writes:
On the problem server:
shared_preload_libraries = 'pgmemcache'
#local_preload_libraries = ''
on the others both are emply.
Sounds like a smoking gun to me.
For good measure I removed pgmemcache but the problem persists.
Did you
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Grant Maxwell grant.maxw...@maxan.com.au writes:
On the problem server:
shared_preload_libraries = 'pgmemcache'
#local_preload_libraries = ''
on the others both are emply.
Sounds like a smoking gun to me.
For good measure I
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
shared_preload_libraries = 'pgmemcache'
...
Sounds like a smoking gun to me.
Yep, known problem with pgmemcache. Bruce and I poked around
with this about a year ago. Bruce, I think you were going
to throw the problem at some EDB people - did
Hi all. is there available some freeware and/or opensource visual
database design tool for postgresql ? Something like commercial microOLAP ?
thanx for help
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Check out Power Architect. Pre-major release, it has some bugs, but
generally works well. It can also forward and reverse engineer.
2009/9/10 NTPT n...@centrum.cz:
Hi all. is there available some freeware and/or opensource visual database
design tool for postgresql ? Something like commercial
I am an MIT student doing a project on schema-less database usage and would
greatly appreciate if you guys can fill out a quick survey on this (should
take 5 mins)
http://bit.ly/nosqldb
--
View this message in context:
Hi,
I am looking for a way to get the OUT parameters of a FUNCTION/PROCEDURE in
my application (C++) using C libpq library. I can get the result set of an OUT
parameter having REFCURSOR data type through an explicit FETCH ALL from
but for OUT parameter of type integer/varchar I dont
Grant Maxwell grant.maxw...@maxan.com.au writes:
On 11/09/2009, at 8:36 AM, Tom Lane wrote:
Did you restart the postmaster afterwards?
yep - full restart.
okay, next step is to collect a stack trace ...
regards, tom lane
--
Sent via pgsql-general mailing list
45 matches
Mail list logo