On Sun, Feb 20, 2011 at 05:39, Craig Ringer cr...@postnewspapers.com.au wrote:
On 02/20/2011 09:38 AM, deepak wrote:
build.pl http://build.pl parses the Makefile to determine the list
of sources, etc. Essentially, your extension is built using the unix
Makefile. Since you've
Hey general@,
I want the server automatically disconnects idle connections
on timeout. I've tried to find setting parameter for such setting,
but failed. Am I missing something or it is not implemented in
Postgres?
--
// Dmitriy.
Hi, everyone. I've got a client who is planning to upgrade from
PostgreSQL 8.3 to 9.0 in the coming weeks. They use a lot of tables
with bytea columns. They're worried about the switch from octal to hex
formats for bytea data.
Based on everything I know and have read, the change is only
OK, so you're building it within the main Pg build system. Pg was
successfully compiled, including files that use elog.h . Yet your extension
doesn't compile, complaining about a macro/typedef conflict.
This makes me wonder: what's different?
Can you post the full sources of your extension,
Reuven M. Lerner reu...@lerner.co.il wrote:
So I've told them that I don't think that anything is necessary for
either input or output, except (perhaps) to set bytea_output in its
backward-compatibility mode. But I wanted to check with people here,
just to double-check my understanding.
Been using bytea heavily through JDBC. In transitioning to 9.0 I've found the
need to set the bytea_output parameter but otherwise everything else works the
same as it did before.
As for storage space concerns I do not know for sure but the numbers cannot be
that substantial to warrant
Reuven M. Lerner reu...@lerner.co.il Sunday 20 February 2011 12:31:09
Hi, everyone. I've got a client who is planning to upgrade from
PostgreSQL 8.3 to 9.0 in the coming weeks. They use a lot of tables
with bytea columns. They're worried about the switch from octal to hex
formats for bytea
Reuven M. Lerner reu...@lerner.co.il writes:
My client is concerned that the internal representation has changed, and
is asking me for a script that will change the representation, in order
to save space (since hex occupies less space than octal).
This is complete nonsense. The internal
deepak deepak...@gmail.com writes:
Here's the trimmed down version of the source and the Makefile (copied and
modified from the 'cube' contrib project)
(with which I see the error related to redefinition)
/* myext.c */
#include string.h
#include math.h
#include postgres.h
#include fmgr.h
For the record:
On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote:
Attached find some table and view definitions from the
GNUmed (www.gnumed.de) database.
Unfortunately I do not understand why PostgreSQL says
psql:xx.sql:14: ERROR: could not implement UNION
Thanks, everyone, for the swift and clear responses. It's good to know
that I did understand things correctly!
Reuven
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Karsten Hilbert karsten.hilb...@gmx.net writes:
On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote:
Unfortunately I do not understand why PostgreSQL says
psql:xx.sql:14: ERROR: could not implement UNION
DETAIL: Some of the datatypes only support hashing, while others only
I gave Postgre a password during install. However, it always rejects
it. I tried uninstalling, deleting all files, and reinstalling. Same
thing. It complains about user roedy (my windows id). It seems to
me the default user is supposed to be postgres not Roedy. Perhaps
that is the source of the
I am not sure if this is possible but is there a way that I can have
multiple columns from different tables be a foreign key to a single column
in another table, or do I need to write a check function and if so how could
I set up a relation?
CREATE TABLE seriestitle (
seriestitle text
);
CREATE
Thanks for your replying. But actually there are some difference database now,
and I really want to define the user-defined function or type one time so that
they can be accessed as system-defined function or type, how can I do?
Thanks!
--
祝好!
Hello,
Installation of postgresql requires you to enter a password for the user
'postgres'.
i) If the user 'postgres' is not there, it will create it and set the password
to whatever you have provided,
ii) If the user 'postgres' is already existing, then you have to give its
password to
On 02/20/11 2:40 PM, matty jones wrote:
If I were to create three separate attributes for each of
the separate titles in the seriestitle table then reference those
attributes from their respective tables that would produce errors I
believe, because a foreign key can't be null and not every
On 02/20/11 9:15 PM, Sachin Srivastava wrote:
In case you dont remember the password you set for user 'postgres'
then you can change the same via Right Click My
Computer--Manage- Users..
note that if you change it here, you also need to change it in the
postgres service descriptor, in
On Sun, Feb 20, 2011 at 02:31:46PM -0500, Tom Lane wrote:
Karsten Hilbert karsten.hilb...@gmx.net writes:
On Wed, Feb 09, 2011 at 11:12:01PM +0100, Karsten Hilbert wrote:
Unfortunately I do not understand why PostgreSQL says
psql:xx.sql:14: ERROR: could not implement UNION
DETAIL:
Hi,
I noticed in the the latest news section on http://pgfoundry.org, no
news has been uploaded since September 10, last year. I know at least
pgpool-II project has made news after September 10 but It did not
appear. I am not in the position speaking for other projects, I
suspect news made by
We are trying to determine the possible side effects of a rouge user account.
A web application requires a dedicated PostgreSQL database in which to
create tables and other database objects and manipulate data within
this single database. So I have created a database and made the
application's
21 matches
Mail list logo