"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
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
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
comp
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 exha
Is the EXECUTE command supported in v 7.0.3 or is that new in 7.1?
Wade Oberpriller
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 ar
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
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
$
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,
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]]
S
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
b
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 n
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...
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
Indianapol
--- [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:
http://people
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=#
[ 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
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.
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... I
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
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
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" <[
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 i
hi all,
i have some questions about new postgres version:
- how many weeks or month will be 7.1 release in beta testing?
- have 7.1 implemented database replication? and can we use it in stable
version, or we may wait until 7.2 will be launched?
thanks for answers..
p.gubis
--
Peter Gubis
Eric
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 fol
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
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
INTERSECT
SELECT col1 as my_col
FROM table
WHERE
INTERSECT
SELECT col1 as my_col
FROM table
WHERE
Any help would be appreciated.
Regards
mi
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.
Hello Tom,
Tom Lane wrote:
> Jose Manuel Lorenzo Lopez <[EMAIL PROTECTED]> writes:
> > I created a table bdf_users as admin user 'postgres' and granted insert
> > access for this table to public.
> > Now I want to insert a line as user 'jose' (That's me!) and got the
> > following message:
> >
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 impro
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,
Pat
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
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
Good morning all,
I would like to know how I can get the number of elements of an array.
regards,
Renaud THONNART
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. S
Lincoln Yeoh wrote:
>
> At 01:52 PM 27-02-2001 -0500, Mitch Vincent wrote:
> >
> >I agree 100% that a shell script is probably the best way to go.. All you're
> >doing is running a few utilities, there is hardly any processing on the part
> >of the script that calls the utilities so there isn't m
36 matches
Mail list logo