RE: [GENERAL] Selecting field names?
Enclosed please find a sample: cfmg_am= select attname, typname from pg_attribute, pg_type, pg_class cfmg_am- where relname = 'pgt_processing' cfmg_am- and attrelid = pg_class.oid cfmg_am- and atttypid = pg_type.oid; attname | typname +--- pga_classname | name pga_processedbytransaction | int4 pga_transactionnumber | int4 pga_pid| int4 backendpid | int4 oid| oid ctid | tid xmin | xid xmax | xid cmin | cid cmax | cid pga_nodeip | inet pga_minorstatus| bpchar pga_majorstatus| bpchar pga_modifiedon | timestamp pga_createdon | timestamp (16 rows) Regards, Andrzej Mazurkiewicz [EMAIL PROTECTED] www.mazurkiewicz.org -Original Message- From: Michael Hall [SMTP:[EMAIL PROTECTED]] Sent: 9 kwietnia 2000 17:58 To: [EMAIL PROTECTED] Subject: [GENERAL] Selecting field names? Is there a way to 'select' the names of the fields and the field types of a table? -- Michael J. Hall, CCAIntelligence Technologies Int'l [EMAIL PROTECTED]http://www.inteltec.com secure: [EMAIL PROTECTED]
[GENERAL] PostgreSQL versus Oracle
Hello, Does anybody have ever heard about PostgreSQL vs Oracle performance tests and bibliography? Thanks Guillaume Perral Stagiaire MIAG Cemagref - URH Tl: 04.72.20.87.64
[GENERAL] BLOB datatype
i have created a table having blob object but now i am not able to insert a picture into the table. Can you send me sql command to insert picture into the table i need syntax. i tried through DB2IMAGE but failed to insert. if there is any other method of putting image in the table, kindly send me the same
Re: [GENERAL] OID rollover?
On Sun, 9 Apr 2000, Charles Martin wrote: What happens to my database when the OID rolls over? A simple-minded calculation yields that you would have to create about 1 million new (not updated) records every day for more than 10 years to exhaust the oid space. By the time that becomes a problem we'll all have 64 bit machines in anticipation of Y2038 anyway. If the answer is "doom", is there anything I can do about it? Dump and reload your database. Unless you are actually *using* all of them (in which case you'd need more than 100 GB to simply store the tuple control structures), then "doom" is a feature. :) -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden
[GENERAL] pg_group table's grolist field
Hello I have just typed : "\d pg_group;" It said grolist field type: int4[], length var How can I create fields like grolist? What's to correct name of that field type wich used by the grolist field too? Thanks for any infos Regards Balazs
[GENERAL] need a help
Hi, I'm using PostgreSQL for an year and I'm very impressed with it. I have read all documentation included in RPM archieve but I found nothing about functions subst, ltrim, pg_get_userbyid etc.. Please, would you tell me where can I find any documentation about this subject. Thanks
Re: [GENERAL] Permission denied while importing data from a file?
I've gotten that message before when users couldn't read the directory the file is in. -- Adam Ruth InterCation, Inc. www.intercation.com "Felix Slager" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... LS, i'm trying to copy data into a table using a copy command using: COPY tabelName FROM '/somewhere/somebody/datafile.txt'; I've given everybody the right to use the datafile.txt (execute, read, write) with an incredible chmod . Still i get the message: ERROR: COPY command, running in backend with effective uid nr 666, could not open file '/somewhere/somebody/datafile.txt' for reading. Errno = Permission denied (13). Why? I mean how does this happen? Please help... Felix
Re: [GENERAL] Minor hack to support LO string searches
Hi, all, at http://www.idyll.org/~t/www-tools/ you'll find an add-on function to PostgreSQL 6.5.3 that allows one to do string searches through large objects. It's not a terribly good hack, but it works ;). I do plan on extending this add-on to support regular expressions Real Soon. I already have such functions + operator definitions. I could post them if there is enough interest. -- Tatsuo Ishii
Re: [GENERAL] need a help
Anton Kalauzky wrote: ... I have read all documentation included in RPM archieve but I found nothing about functions subst, ltrim, pg_get_userbyid etc.. Please, would you tell me where can I find any documentation about this subject. http://www.postgresql.org/docs/faq-english.html#1.8
Re: [GENERAL] recursive queries?
Personally, I'm really only interested in something elegant. Meaning I don't want to mess around with a solution where this broker communicates with that broker via an n-way blah blah blah. I can maintain literacy in several tools at once, but not several dozen. Is my best bet simply to accept SQL's limitations and program around them in C++ (or C, or Python, or Perl, etc.)? Good question! I have certainly given this one some thought before. One of my projects involved a directory structure of sorts which allowed non-cyclic symlinking. My solution in this case was to create a seperate table that was a 'map' -- the map was a pre-calculated, flattened version of the entire graph. Thus, a single query of the map table for "/blah/blah2/etc/" returned immediately correct subdirectory. Each time the linking tables are updated, the map table must be re-calculated. This solution will not work for the general cyclic graph, of course... and it may be inappropriate for the situation where the link tables are update frequently since each update forces a large recursive caluculation of the map -- the primary advantage is the speed and easy of querying. I am not aware of any SQL constructs of 'for' loops or 'while' loops, so I am not sure how one could solve the problem in pure SQL -- actually, you probably could using a recursive stored procedure. Andy
RE: [GENERAL] BLOB datatype
look at the examples in the postgresql book available on the website. krishna -Original Message- From: iqbal [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 7:11 AM To: [EMAIL PROTECTED] Subject: [GENERAL] BLOB datatype i have created a table having blob object but now i am not able to insert a picture into the table. Can you send me sql command to insert picture into the table i need syntax. i tried through DB2IMAGE but failed to insert. if there is any other method of putting image in the table, kindly send me the same
RE: [GENERAL] Permission denied while importing data from a file?
maybe the directory '.../somebody' does not have read permission (700?) krishna -Original Message- From: Adam Ruth [mailto:[EMAIL PROTECTED]] Sent: Monday, April 10, 2000 9:54 AM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Permission denied while importing data from a file? I've gotten that message before when users couldn't read the directory the file is in. -- Adam Ruth InterCation, Inc. www.intercation.com "Felix Slager" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... LS, i'm trying to copy data into a table using a copy command using: COPY tabelName FROM '/somewhere/somebody/datafile.txt'; I've given everybody the right to use the datafile.txt (execute, read, write) with an incredible chmod . Still i get the message: ERROR: COPY command, running in backend with effective uid nr 666, could not open file '/somewhere/somebody/datafile.txt' for reading. Errno = Permission denied (13). Why? I mean how does this happen? Please help... Felix
RE: [GENERAL] Re: newline character handling
maybe we need a keyword DOS|UNIX or perhaps TEXT|BINARY to tell postgresql to pick DOS style or UNIX style line endings... krishna -Original Message- From: Michael Blakeley [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 08, 2000 12:57 PM To: [EMAIL PROTECTED] Subject: [GENERAL] Re: newline character handling From: "Sampath, Krishna" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: newline character handling Date: Fri, 7 Apr 2000 15:49:58 -0400 As I tried, using COPY, to import a few flat files created under Windows into postgresql running on a Linux machine, I discovered that: * If the last field in your record is a string, postgresql imports it, but keeps the ^M as part of the text string. * If the last field is numeric, postgresql refuses to import that line (because of the ^M, the field is not recognized as a number) Once I stripped the ^M, the data bulkloaded without a problem. Perhaps COPY should be smarter and recognize the DOS-style line endings? I'm ok with this for numerics, but against it for text. Why? Because I work with some binary data, and I wouldn't want the mysterious problem of not being able to COPY a line containing a record that's _supposed_ to end in ^M. -- Mike
Re: [GENERAL] Re: newline character handling
maybe we need a keyword DOS|UNIX or perhaps TEXT|BINARY to tell postgresql to pick DOS style or UNIX style line endings... Maybe we just need to make sure that the files we are using are in the correct format for the platform they're being processed on. ; ) steve
[GENERAL] Features
Hi Folks, I know this one has been asked alot, but since i can't search, i'm gonna re-ask. 1: Reliablility - is there any documents out there regarding stability and reliablilty of postgresql 2: replication - still in exotic list ? there is huge market demand, and lots of people willing to throw cash into it. 3: don't think it's been asked, but does postgresql have any XML support, or has anyone looked into it ? Jeff MacDonald [EMAIL PROTECTED]
[GENERAL] Re: [NOVICE] installation question
On Sun, Apr 09, 2000 at 11:43:35PM -0400, Vipin Samtani wrote: - hi, - i am a novice user running Red Hat Linux Server 6. - what files do i need to download to install PostGreSQL? - vipin - Have you checked to see if there is an RPM package on your RH CD? -- -- C^2 No windows were crashed in the making of this email. Looking for fine software and/or web pages? http://w3.trib.com/~ccurley
Re: [GENERAL] [NOVICE] installation question
Vipin Samtani wrote: hi, i am a novice user running Red Hat Linux Server 6. what files do i need to download to install PostGreSQL? vipin ftp://ftp.postgreSQL.org/pub/postgresql-7.0beta5.tar.gz (it's beta, but it's best) Also, no need to blast all the lists with the question. pgsql-general will usually work fine.
[t-ishii@sra.co.jp: Re: [GENERAL] Minor hack to support LO string searches]
This points out a need that I haven't really seen addressed -- a PG software contrib archive. Is there such a thing? Are there any objections to starting such a thing? cheers, --titus - Forwarded message from Tatsuo Ishii [EMAIL PROTECTED] - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Minor hack to support LO string searches In-Reply-To: [EMAIL PROTECTED] X-Mailer: Mew version 1.94 on Emacs 19.34 / Mule 2.3 (SUETSUMUHANA) Date: Mon, 10 Apr 2000 22:56:15 +0900 From: Tatsuo Ishii [EMAIL PROTECTED] X-Dispatcher: imput version 990905(IM130) X-Mailing-List: [EMAIL PROTECTED] Precedence: bulk Hi, all, at http://www.idyll.org/~t/www-tools/ you'll find an add-on function to PostgreSQL 6.5.3 that allows one to do string searches through large objects. It's not a terribly good hack, but it works ;). I do plan on extending this add-on to support regular expressions Real Soon. I already have such functions + operator definitions. I could post them if there is enough interest. -- Tatsuo Ishii - End forwarded message -
