Re: [GENERAL] has anybody gotten cygwin1.1.8 to work with postgresql?
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. Some other guys investigated it already, and there is a problem with the IPCs with cygwin1.1.8 So their suggestion is to downgrade to 1.1.7, but there is trap when doing it, because of locked dlls. Have a look into the threads of the -ports mailing lists of Feb2001, especially this below, when downgrading: http://www.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00084.html Where can I get the latest postgresql7.1? http://www.postgresql.org/sites.html Peter
[GENERAL] Counting elements of an array
Good morning all, I would like to know how I can get the number of elements of an array. regards, Renaud THONNART
[GENERAL] DES in Postgres?
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
Re: AW: [GENERAL] Addison-Wesley looking for authors
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 Germany. It will be released in autumn this year in german language. Perhaps it could be translated by Addison Wesley Corp.? Please could you encourage them to do this, or perhaps do it yourself? You seem to have a good knowledge of English. My book does not try to compete with Bruces book (I wouldnt dare to do ;-), it rather does complete the theme while it will contain many, many examples from real life (besides many small examples, the whole book is accompanied by one constantly growing example) That is the way to do it. For me anyway, disjointed snippets of code are horrible. and it will contain a rather complex section about PL/pgSQL-programming and application development, also accompanied by many examples. At least I would like to thank Bruce for the offered help - I surely will remember ;-) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -- Please refrain from using HTML or WORD attachments in e-mails to me --
[GENERAL] Thought on OIDs
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, Patrik Kudo (I'm sorry if this becomes a repeated post. I tried to mail last night, but my subscription to the list wasn't registered at that time, so the mail didn't seem to get through)
[GENERAL] something more about my question about performance
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 performance, to make users access to different postgres servers, making access, for example, the user1 to the db1 on the server1, the user2 to db2 on the server2 and so on. If it possible, how can I do that? Thank you. Best. Enrico Mangano Netsoftware Division __ NETHOUSE S.R.L. Cso Re Umberto I, 57 - 10128 Torino - Italy Tel. +39-011-581.581 - Fax +39-011-581.591 http://www.nethouse.it - mailto:[EMAIL PROTECTED]
[GENERAL] Re: DES in Postgres?
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 the 7.1 contrib tree is nice crypto module, perhaps (I hope) contains DES too. Only 2 weeks to this release... Karel -- Karel Zak [EMAIL PROTECTED] http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
[GENERAL] Count and Intersect
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 help would be appreciated. Regards michael
Re: [GENERAL] Counting elements of an array
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; while a[i] loop i := i+1; end loop; return i-1; end;' language 'plpgsql' with(isstrict,iscachable); Thanks a lot Regards, Renaud THONNART
Re: [GENERAL] PostgreSQL 7.1 Linux Installation
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 following files to exist on our system: [root@atlas PostgreSQL]# find /usr -name "libpq.so.*" /usr/lib/libpq.so.2 /usr/lib/libpq.so.2.0 /usr/lib/libpq.so.2.1 Should I make some sort of symlink or perhaps force installation of php-pgsql package? Can anybody give me some clue of how to procceed? TIA, Paulo Parola [EMAIL PROTECTED] - Original Message - From: Mirko Zeibig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 7:20 PM Subject: Re: [GENERAL] PostgreSQL 7.1 Linux Installation On Thu, Feb 22, 2001 at 04:07:06PM -0300, Paulo Parola wrote: [root@atlas PostgreSQL]# rpm -Uvh postgresql-7.1beta4-1.i386.rpm error: failed dependencies: postgresql = 7.0.2 is needed by postgresql-server-7.0.2-17 libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9 libpq.so.2.1 is needed by postgresql-server-7.0.2-17 [root@atlas PostgreSQL]# rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm error: failed dependencies: postgresql = 7.1beta4 is needed by postgresql-server-7.1beta4-1 libpq.so.2 is needed by postgresql-server-7.1beta4-1 You have to specify both RPMs at once during the update: rpm -Uvh postgresql-server-7.1beta4-1.i386.rpm postgresql-7.1beta4-1.i386.rpm should do the trick, unless the beta-rpm does not provide a libpq.so.2.1 (at least with a build from CVS libpq.so.2.1 is installed, so I guess rpm is clever enough to provide this one as well). libpq.so.2 is just a symlink to libpq.so.2.1 Regards Mirko -- [EMAIL PROTECTED] http://sites.inka.de/picard/
Re: [GENERAL] 7.1 stable
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 stable version, or we may wait until 7.2 will be launched? there is a base replication available in contrib, and there is also a version available that will work for 7.0.x at http://www.pgsql.com ...
Re: [GENERAL] 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) 0;
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" [EMAIL PROTECTED] Cc: "Rod Taylor" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 6:12 PM Subject: Re: [GENERAL] 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) 0; Tom Lane wrote: "Rod Taylor" [EMAIL PROTECTED] writes: Query on 7.0 on Ultra II took over 5 hours. Query on 7.1 on x86 took under 10 seconds. Same data. Good ... I guess, because I'm not sure why the difference. We haven't done very much in the optimizer since 7.0. What are the full declarations of these tables and their indexes? regards, tom lane Sometimes your production and development machines have different data so behave differently. With postgres this is more of a problem than in general because of the planner. RT: have you tried the same query with the same data on your development machine with 7.0? -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.targabot.com
Re: [GENERAL] Re: DES in Postgres?
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? I know it's easy to do, if you know C, but I don't know C. In the 7.1 contrib tree is nice crypto module, perhaps (I hope) contains DES too. Only 2 weeks to this release... Nope. Only digest() is there :( I have encrypt/decrypt stuff coded, but there is problem with "what I tell"/"what I want" differences - so I mostly dig in various crypto libraries around at the moment. It would be nice if encrypted data can be decrypted with later versions of pgcrypto too :) I have hoped to get the binary format stable, then release, but if there is interest I can make a for-playing-only release. Btw, I have hmac() and crypt() too... -- marko
[GENERAL] database diff
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
Re: [GENERAL] Postgres eats up memory when using cursors
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 end of 3rd day it becames 256Mb large Query details please? You can't expect any results from such a vague report. regards, tom lane
[GENERAL] JOIN of a table with many detail tables
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. David
Re: [GENERAL] Addison-Wesley looking for authors
[ 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 / LaTeX combination again? Yes, absolutely. I doubt I would have written the book if I had to use native LaTeX or a normal word processor. LyX had the right mix of control and ease of use that I needed. I had to crack open a book to do some special things with LaTeX, but it was pretty easy. De you feel able to share the special modifications to LyX you made? [mentions margin line numbers] That is a standard LaTeX macro package called vruler. I had to download it from CTAN, but that was easy. Attached are all the macros I put in the LaTeX preamble using LyX. The only other modifications where extending the page size by one line to force proper paragraph breaks in a few cases. I also did a few things to help latex2html render the cover page properly. It is the clear separation of content from appearance that made me like LyX. You tag the content, and LaTeX generates the appearance. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 % I use LY1 encoding from http://www.yandy.com/usely1.htm % It does a better job matching my fonts to TeX and PDF \renewcommand{\rmdefault}{palladio} \renewcommand{\sfdefault}{nimbsans} \renewcommand{\ttdefault}{0414} % no prompting \batchmode % prevent footnote paragraphs from splitting across pages \interfootnotelinepenalty=300 % hyphenate tt font \usepackage[htt]{hyphenat} \usepackage{color} \usepackage{html} \raggedbottom % vruler %\usepackage{vruler} %\setvruler[10pt][1][1][4][1][0pt][570][] % % for dvips %begin{latexonly} \special{papersize=7.375in,9.25in} %end{latexonly} \renewcommand{\rmdefault}{0285} %begin{latexonly} \let\realnormalsize=\normalsize \renewcommand\normalsize{% \realnormalsize \@setfontsize\normalsize{10.5}{13.5} } %end{latexonly} % index \usepackage{makeidx} \makeindex % caption skip %begin{latexonly} %\setlength\abovecaptionskip{5pt} \let\mycaptionskip=\baselineskip \multiply\mycaptionskip by 2 \setlength\belowcaptionskip{\mycaptionskip} %end{latexonly} % % force blank pages before chapters \let\realcleardoublepage=\cleardoublepage \renewcommand{\cleardoublepage}{% \newpage{\pagestyle{empty}\realcleardoublepage} } % shrink gutter margin %begin{latexonly} \addtolength\evensidemargin{0.1in} \addtolength\oddsidemargin{-0.1in} %end{latexonly} % fix large section numbers in table of contents %begin{latexonly} \renewcommand*\l@section{\@dottedtocline{1}{1.5em}{3em}} \renewcommand*\l@figure{\@dottedtocline{1}{1.5em}{3em}} %end{latexonly} % % pdfmark the text \usepackage[ colorlinks, pdfmark, pdfauthor={Bruce Momjian}, pdftitle={PostgreSQL: Introduction and Concepts}, pdfsubject={PostgreSQL}, pdfkeywords={Copyright Addison-Wesley} ]{hyperref}
Re: [GENERAL] Counting elements of an array
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=# select array_dims( '{{1,2,3},{4,5,6}}'::int[] ); array_dims [1:2][1:3] (1 row) regards, tom lane
Re: [GENERAL] has anybody gotten cygwin1.1.8 to work with postgresql?
--- [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.freebsd.org/~kevlo/postgres/portNT.html Note: Peter Schindler's remark above is correct. PostgreSQL will not run under Cygwin 1.1.8. There was a problem with fork I believe that caused the problem. It has been fixed, although you will need to download the most recent snapshot of cygwin to get it. Brent __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
[GENERAL] Publisher seeks authors/technical reviewers
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 Indianapolis, Indiana 46290-1097 (317) 581-3627 [EMAIL PROTECTED]
Re: [GENERAL] pg_dumpall - fails SOLVED
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 just guessing, but it is possible that you're using different versions of pg_dump and postmaster? I had a similar problem when I had an old 7.0 binary lying around in /usr/bin/ when trying to dump a 7.1 database. no, it was that i'd been iterating through a series of drop table xyz; create table xyz ( ... ); drop function pdq ( xyz ); create function pdq ( xyz ) returns ; when it reached the "drop function" it was referenceing an old instance (oid) of the xyz table. then a new function was created that referred to the new table (oid). i found six such functions referring to nonexistent tables. apparently postgresql does cascading correctly on rules, indexes, and triggers when deleting tables that they depend on. but a function argument that's defined in terms of a table -- apparently that slipped through the cracks! i.e. create table eg( id int4 ); create index ed_id_idx on eg ( id ); create function go( eg ) ; drop table eg; -- this also drops the index, but not the function so, instead, now i drop function pdq ( xyz ); drop table xyz; create table xyz ( ... ); create function pdq ( xyz ) returns ; dropping the function first, works like a charm. -- mailto:[EMAIL PROTECTED] http://www.dontUthink.com/
Re: [GENERAL] database diff
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 exist. It occured to me a few days ago that such a beast would be useful, but I have to finish the projects that are two months behind, first. ;-/ dan thanks chris
Re: [GENERAL] PG_PWD and PG_PASSWORD Security
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 better solution yet. I thought that passwords were to be saved in PG_SHADOW. What is PG_SHADOW for anyway? Pg_shadow is the system catalog table that stores the user information, such as user name and password. The pg_pwd file is a plain text dump of pg_shadow, which is necessary because at the time the password is needed (during the connection attempt), the system can't read the pg_shadow table yet (because it's not connected yet, sort of). -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
[GENERAL] showing rules/triggers with psql
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]] Sent: Thursday, March 01, 2001 11:06 AM To: Anthony Metzidis Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] PG_PWD and PG_PASSWORD Security 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 better solution yet. I thought that passwords were to be saved in PG_SHADOW. What is PG_SHADOW for anyway? Pg_shadow is the system catalog table that stores the user information, such as user name and password. The pg_pwd file is a plain text dump of pg_shadow, which is necessary because at the time the password is needed (during the connection attempt), the system can't read the pg_shadow table yet (because it's not connected yet, sort of). -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
[GENERAL] functional indices with functions taking row as argument
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, bl_paid BOOL NOT NULL DEFAULT false, bl_ok BOOL NOT NULL DEFAULT false, PRIMARY KEY (id) ); bl_* fields define state of the session. I define some conditions based on those booleans and other fields. Example: CREATE FUNCTION is_session_to_be_sent (SESSIONS) RETURNS BOOL AS ' SELECT ($1.bl_ok) AND ($1.bl_confirmed) AND (NOT $1.bl_sent) ' LANGUAGE 'sql'; I don't want to explicitly pass those three arguments to the function, because there may be more of them in the future. So I pass SESSIONS type arg. It would be nice, if I could create functional index on this table. Then the following query might be faster. SELECT * FROM sessions s WHERE is_session_to_be_sent(s) = true; Unfortunately, it seems that there is no appropriate syntax for creating such an index. Hope I'm wrong ;) (I see a workaround - additional boolean field updated in triggers) greetings, Tom -- .signature: Too many levels of symbolic links
[GENERAL] Perl DBI/DBD::Pg confusion with finish
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 $sth-{'Active'} should change to false. However, if I don't call $sth-finish after reading all rows, then $sth-{'Active'} is still true - which makes it useless to test. Also, it seems that if I call $sth-fetchrow_hashref (or $sth-fetchrow_arrayref) until I exhaust the rows and get an undef, I can actually then call it again and it will start over from the first row in the result set (is this supposed to happen?). Which, if for some reason you do this, can send you into an endless loop of rereading the result set. By all appearances in my code, it does not seem necessary to call finish, and I get no errors even if I intentionally try to force one by starting a new query before I have read all the rows from the first (similar to the example in DBI.pm). However, the interaction with the Active attribute, and who knows what else, does not seem to work as implied in the docs. Anybody have any experience with this, with postgres or otherwise? I am hoping that my resulting code will be portable, but I have not yet used DBI with another database system, so it is rather important that whatever works with DBD::Pg will also work with others! --d
Re: [GENERAL] Users in pg_shadow
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
Re: R: [GENERAL] Date types in where clause of PreparedStatement
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 PostgreSQL on a *nix machine and the odbc client on a Win* different machine, couldn't be a problem of different locale settings? Using Delphi BDE I had **a lot** of troubles on an all-windows-98 network because of different locale settings among the clients. First in all, day-month swapping in dates (dd-mm- and mm-dd- formats mixed through the network). Make all dates ISO format and life should be good. I think MS Access does something like that for ODBC. So, -mm-dd ('2001-03-01') or dd-MMM- ('01-Mar-2001'), are good candidates. For time as well: -mm-dd hh:mm[:ss[-hh[mm]]] '2001-03-01 23:42:58-0800' Always having year first makes a good heuristic that date/time is in ISO format, and there's no question that each successive part represents a decreasing date/time part. -- Eric G. Miller [EMAIL PROTECTED]
[GENERAL] EXECUTE in PLPGSQL
Is the EXECUTE command supported in v 7.0.3 or is that new in 7.1? Wade Oberpriller
Re: [GENERAL] Perl DBI/DBD::Pg confusion with finish
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 - finish should get called automatically, and $sth-{'Active'} should change to false. We've found that DBD::Pg doesn't do this. So we either have to call $sth-finish every time, or prepare the statement with $dbh-prepare_cached() and passing the active flag as true. It shouldn't be this way, but it is. HTH, David
AW: AW: [GENERAL] Addison-Wesley looking for authors
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 compliment ;-) Unfortunately my knowledge of the english language does not go as far as it seems to do ... much of it costs me valuable time to look up the right words. Therefore I do not really think about a translation by myself ... you would surely repent it :-) Best regards, Jens - T-Systems Projektleiter debis Systemhaus GEI GmbH Hausanschrift: Eichhornstrae 3, 10785 Berlin Postanschrift: 10785 Berlin Telefon: (004930) 25 54-32 82 Telefax: (004930) 25 54-31 87 Mobiltelefon: (0170) 167 26 48 E-Mail: [EMAIL PROTECTED] Internet: http://www.t-systems.de
Re: [GENERAL] serial properties
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 you do a \d on the table concerned, that's what it'll say. It's really just shorthand to save typing - Richard Huxton
Re: [GENERAL] EXECUTE in PLPGSQL
"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