Jeff,
Jeff wrote:
I've tried fruitlessly to install cygwin1.1.8 work with postgresql7.03
Has any body out there done it?
What is actually wrong with the install? If you can't start the postmaster,
because its complains about the IPCs, I fall over the same problem, but
actually with 7.1.
Good morning all,
I would like to know how I can get the number of elements of an array.
regards,
Renaud THONNART
Is there a function in Postgres which will DES-encrypt a given string
with a given key? If not, has anyone out there written a linkable C
function to do that? I know it's easy to do, if you know C, but I
don't know C.
Thanks
On Thu, 01 Mar 2001 21:04, Jens Hartwig wrote:
Hello all, hello Bruce,
first of all I want to say, that Bruces Book was very well done in my
opinion!
I think we all concur with that opinion.
To answer the question, I already began writing a book about PostgreSQL
for Addison Wesley in
Hi!
A thought just hit me and I got a bit worried... If OIDs are "globaly"
unique and I have a very high data-throughput on my database, i.e. I do a
lot of inserts and deletes, is it then possible to "run out" of OIDs? If
this can occur, will it cause any problems?
Need I worry? =)
Regards,
I wrote :
Hello,
i have one postgresql server (7.0) where several users access.
Is there any way to improve performance for:
i) accesses of different users at different dbs
ii) accesses of different users at the same db
Thanks.
My question simple wanted know if it is possible, to improve
On Thu, Mar 01, 2001 at 08:59:38AM -, [EMAIL PROTECTED] wrote:
Is there a function in Postgres which will DES-encrypt a given string
with a given key? If not, has anyone out there written a linkable C
function to do that? I know it's easy to do, if you know C, but I
don't know C.
In
Hi,
Is it possible to count the number of rows returned by a command which use
the intersect operator,
such as :
SELECT col1 as my_col
FROM table
WHERE conditions 1
INTERSECT
SELECT col1 as my_col
FROM table
WHERE conditions 2
INTERSECT
SELECT col1 as my_col
FROM table
WHERE conditions 2
Any
Christopher Sawtell wrote:
On Thu, 01 Mar 2001 21:53, you wrote:
Good morning all,
I would like to know how I can get the number of elements of an array.
create function array_element_count(_int4) returns integer as '
declare
a alias for $1;
i integer;
begin
i := 1;
Dear Mirko,
Thanks for the reply. I have now PostgreSQL7.1 installed, but need to
re-install package "php-pgsql-4.0.1pl2-9.i386.rpm". The installation
procedure reports me the following:
error: failed dependencies:
libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9
And I have found the
yOn Thu, 1 Mar 2001, Peter Gubis wrote:
hi all,
i have some questions about new postgres version:
- how many weeks or month will be 7.1 release in beta testing?
7.1 release should be out by march 15th (+/- a couple of days)
- have 7.1 implemented database replication? and can we use it in
Sorry... Exact same data. Did a pg_dumpall from one to the other
first, then analyzed.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
- Original Message -
From: "Joseph Shraibman" [EMAIL PROTECTED]
To: "Tom Lane"
On Thu, Mar 01, 2001 at 11:27:15AM +0100, Karel Zak wrote:
On Thu, Mar 01, 2001 at 08:59:38AM -, [EMAIL PROTECTED] wrote:
Is there a function in Postgres which will DES-encrypt a given string
with a given key? If not, has anyone out there written a linkable C
function to do that?
hello
i want to find the differences between two database schemas...is there a
function for this or do i just pg_dump both of them and do a diff in unix?
thanks
chris
Denis Perchine [EMAIL PROTECTED] writes:
I declare a cursor on the table of approx. 1 million rows.
And start fetching data by 1000 rows at each fetch.
Data processing can take quite a long time (3-4 days)
Theoretically postgres process should remain the same in size.
But it grows... In the
Hi all.
I want to make a LEFT JOIN of table A with detail tables B and C. How can I
make that?:
SELECT A.*, B.*, C.* FROM A LEFT JOIN B ON A.foo = B.bar ???
I don't know where to put info of JOIN between A and C.
Any help, please? Thanks.
[ Charset ISO-8859-1 unsupported, converting... ]
On Wed, 28 Feb 2001 14:54, Joseph Shraibman wrote:
About what? Your book covered all the basics.
Bruce Momjian wrote:
As many of you know, I wrote a PostgreSQL book last year.
If you were to repeat the exercise would you use the LyX
Renaud Tthonnart [EMAIL PROTECTED] writes:
I would like to know how I can get the number of elements of an array.
There is a function that returns an array's dimensions as a text string:
regression=# select array_dims( '{1,2,3}'::int[] );
array_dims
[1:3]
(1 row)
regression=#
--- [EMAIL PROTECTED] wrote:
I tried at one point though I don't know the cygwin version.
I didn't work; said c compiler cannot produce
executeable
This happened to me as well. It occurs because you haven't
applied the source patch. You can read out and download it
here:
Sams Publishing, a computer book publisher based in Indianapolis, is looking for
authors to write high-level PostgreSQL books and for technical reviewers. Interested
parties should contact [EMAIL PROTECTED]
Patricia G. Barnes
Acquisitions Editor
Sams Publishing
201 W. 103rd Street
Mario Weilguni wrote:
Am Mittwoch, 28. Februar 2001 10:43 schrieb will trillich:
so i've got my data recovered (thanks to oliver) and now
i wanna back it up with a pg_dumpall...
instead, i get 'failed sanity check, type with oid 779927 was no
found' in the oddest places...
I'm
On Thu, Mar 01, 2001 at 10:21:53AM -0500, some SMTP stream spewed forth:
hello
i want to find the differences between two database schemas...is there a
function for this or do i just pg_dump both of them and do a diff in unix?
As far as I know, such a function (or program/script) does not
Anthony Metzidis writes:
Is there any way to keep postgres from saving the passwords in plain
text?
No.
This seems to be a huge security hole.
No, because the directory that contains these files shouldn't be world
readable. The issue has been noted though, but no one has implemented a
hey,
kind of a simple question. How can you show the rules/triggers on a database
using psql. Even better: how can you show all rules/triggers/constrains/etc
that pertain to a given table?
as always...thanks.
--tony
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
Hi.
I have a table which represents clients' sessions / orders.
CREATE TABLE sessions (
id INTEGER NOT NULL DEFAULT nextval('sessions_seq'),
...
finishedTIMESTAMP,
bl_confirmedBOOL NOT NULL DEFAULT false,
bl_sent BOOL NOT NULL DEFAULT false,
Hello -
When using DBD::Pg through DBI, can somebody tell me if it is necessary
to be calling the $sth-finish routine? The DBI.pm documentation states
that there is no need to call it if you call $sth-fetchrow_xxxref until
the rows are exhausted - finish should get called automatically, and
One possible part of a cron script:
su --command="psql -d $PGUSER -c 'vacuum analyze;' /dev/null" $PGUSER
where 'PGUSER' has been defined as the appropriate user name. Of course,
you'll need a bit more if your database has a different name.
HTH...
-frank
On Thu, Mar 01, 2001 at 05:33:21PM +0100, Paolo Sinigaglia wrote:
Can anybody show any reason why the code using a prepared
statement with a where clause using a date won't find any records
on PostgreSQL but WILL work using Access and the jdbc-odbc
bridge?
Assuming you are running
Is the EXECUTE command supported in v 7.0.3 or is that new in 7.1?
Wade Oberpriller
On Thu, 1 Mar 2001, David Lynn wrote:
Hello -
When using DBD::Pg through DBI, can somebody tell me if it is necessary
to be calling the $sth-finish routine? The DBI.pm documentation states
that there is no need to call it if you call $sth-fetchrow_xxxref until
the rows are exhausted -
Hello Christopher,
[...]
Please could you encourage them to do this, or perhaps do it yourself?
You seem to have a good knowledge of English.
[...]
I will see, if I can encourage Addison Wesley to translate the book.
Regarding the translation on my own - thank you very much for your
From: "Martin A. Marques" [EMAIL PROTECTED]
Hi, I would like to know which are the properties of the SERIAL type.
Is a column defined SERIAL a primary key?
Saludos... :-)
Basically serial is NOT NULL with DEFAULT of nextval(some-sequence) and a
primary key index defined on it. In fact if
"Wade D. Oberpriller" wrote:
Is the EXECUTE command supported in v 7.0.3 or is that new in 7.1?
Wade Oberpriller
7.1 according to CHANGES
- Richard Huxton
33 matches
Mail list logo