pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
35+ messages / 31 participants
[nested] [flat]
* (no subject)
@ 1998-05-13 16:26 sebastien Flacher <flash@cur-archamps.fr>
0 siblings, 0 replies; 35+ messages in thread
From: sebastien Flacher @ 1998-05-13 16:26 UTC (permalink / raw)
To: pgsql-sql
subscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-06-04 23:24 Chris Olivier <mjaunes1@tampabay.rr.com>
0 siblings, 0 replies; 35+ messages in thread
From: Chris Olivier @ 1998-06-04 23:24 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-06-08 14:42 Mike Payne <mpayne@i1.net>
0 siblings, 0 replies; 35+ messages in thread
From: Mike Payne @ 1998-06-08 14:42 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-06-13 21:22 Edwin S. Ramirez <edwin.ramirez@erols.com>
0 siblings, 0 replies; 35+ messages in thread
From: Edwin S. Ramirez @ 1998-06-13 21:22 UTC (permalink / raw)
To: pgsql-announce@postgresql.org; pgsql-sql
subscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-06-19 20:13 Steve Doliov <doliov@statsol.com>
0 siblings, 0 replies; 35+ messages in thread
From: Steve Doliov @ 1998-06-19 20:13 UTC (permalink / raw)
To: pgsql-novice-request@postgresql.org; pgsql-interfaces@postgresql.org; pgsql-general@postgresql.org; pgsql-sql
subscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-07-19 11:38 Barry Voeten <barry@ekonism.org>
0 siblings, 0 replies; 35+ messages in thread
From: Barry Voeten @ 1998-07-19 11:38 UTC (permalink / raw)
To: pgsql-sql
subscribe barry@office.netland.nl
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-08-15 17:32 Dariusz Owczarek <do@pap.waw.pl>
0 siblings, 0 replies; 35+ messages in thread
From: Dariusz Owczarek @ 1998-08-15 17:32 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1998-09-08 01:45 jmjang <jmjang@netlab.korea.ac.kr>
0 siblings, 0 replies; 35+ messages in thread
From: jmjang @ 1998-09-08 01:45 UTC (permalink / raw)
To: pgsql-sql
subscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-05-03 08:55 Thomas Malkus <tmalkus@csi.com>
0 siblings, 0 replies; 35+ messages in thread
From: Thomas Malkus @ 1999-05-03 08:55 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql tmalkus@csi.com
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-05-18 05:26 Ivanko Alexandr <shura@nikts.nk.ukrtel.net>
0 siblings, 0 replies; 35+ messages in thread
From: Ivanko Alexandr @ 1999-05-18 05:26 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe pgsql-digest-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-05-19 04:29 Robert Chalmers <robert@chalmers.com.au>
0 siblings, 0 replies; 35+ messages in thread
From: Robert Chalmers @ 1999-05-19 04:29 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-05-28 06:04 Ivanko Alexandr <shura@nikts.nk.ukrtel.net>
0 siblings, 0 replies; 35+ messages in thread
From: Ivanko Alexandr @ 1999-05-28 06:04 UTC (permalink / raw)
To: pgsql-sql@hub.org
unsubscribe pgsql-sql-digest
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-07-22 18:49 root <raptor@unacs.bg>
0 siblings, 0 replies; 35+ messages in thread
From: root @ 1999-07-22 18:49 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-07-26 04:04 Martin Jackson <mhjacks@nwa.quik.com>
0 siblings, 0 replies; 35+ messages in thread
From: Martin Jackson @ 1999-07-26 04:04 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-08-17 02:58 Stanley Morgan <stan@cyberfort.com>
0 siblings, 0 replies; 35+ messages in thread
From: Stanley Morgan @ 1999-08-17 02:58 UTC (permalink / raw)
To: pgsql-sql
unsubscribe pgsql-sql
Attachments:
stan.vcf (text/x-vcard, 183B) download
begin:vcard
n:Morgan;Stanley
tel;home:USA (409) 7667888
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:stan@cyberfort.com
x-mozilla-cpt:;-28368
fn:Stanley Morgan
end:vcard
* (no subject)
@ 1999-08-25 05:54 Stanley Morgan <stan@cyberfort.com>
0 siblings, 0 replies; 35+ messages in thread
From: Stanley Morgan @ 1999-08-25 05:54 UTC (permalink / raw)
To: pgsql-sql
unsubscribe pgsql-sql
Attachments:
stan.vcf (text/x-vcard, 314B) download
begin:vcard
n:Morgan;Stanley
tel;pager:ICQ 13840917
tel;fax:USA 281-282-9904
tel;home:USA 409-766-7888
tel;work:USA 281-282-9902
x-mozilla-html:TRUE
org:CyberFort, Inc.
adr:;;;;;;
version:2.1
email;internet:stan@cyberfort.com
title:Director of Product Development
x-mozilla-cpt:;-28256
fn:Stanley Morgan
end:vcard
* (no subject)
@ 1999-09-07 20:26 leonardo albrizio <albrizio@freemail.it>
0 siblings, 0 replies; 35+ messages in thread
From: leonardo albrizio @ 1999-09-07 20:26 UTC (permalink / raw)
To: pgsql-sql
subscribe albrizio@libero.it
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-10-13 17:11 Ottawa Online Digital Development <sumi@ottawaonline.com>
0 siblings, 0 replies; 35+ messages in thread
From: Ottawa Online Digital Development @ 1999-10-13 17:11 UTC (permalink / raw)
To: pgsql-sql
hi
I like to find out any examples or books using perl and postgresql
database.
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-12-06 03:38 cristiv <cristiv@mangalia.ro>
0 siblings, 0 replies; 35+ messages in thread
From: cristiv @ 1999-12-06 03:38 UTC (permalink / raw)
To: pgsql-sql
unsubscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-12-09 16:20 cristi voinicaru <cristiv@mangalia.ro>
0 siblings, 0 replies; 35+ messages in thread
From: cristi voinicaru @ 1999-12-09 16:20 UTC (permalink / raw)
To: pgsql-sql
unsubscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 1999-12-09 16:21 cristi voinicaru <cristiv@univ-ovidius.ro>
0 siblings, 0 replies; 35+ messages in thread
From: cristi voinicaru @ 1999-12-09 16:21 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2000-01-15 11:19 Michal Frajt <frajt@aki.cz>
0 siblings, 0 replies; 35+ messages in thread
From: Michal Frajt @ 2000-01-15 11:19 UTC (permalink / raw)
To: pgsql-sql
Attachments:
frajt.vcf (text/x-vcard, 299B) download
begin:vcard
n:Frajt;Michal
tel;cell:+420603521051
tel;fax:+420541249909
tel;work:+420541249909
x-mozilla-html:TRUE
org:<a href=http://www.aki.cz>AKI Brno, s.r.o.</a>
adr:;;Minská 30;Brno;;616 00;Czech Republic
version:2.1
email;internet:frajt@post.cz
x-mozilla-cpt:;0
fn:Ing. Michal Frajt
end:vcard
* (no subject)
@ 2000-01-19 16:32 Sevo Stille <sevo@ip23.net>
0 siblings, 0 replies; 35+ messages in thread
From: Sevo Stille @ 2000-01-19 16:32 UTC (permalink / raw)
To: pgsql-sql
subscribe
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2000-01-21 12:25 david tzuriel <tzuried@mail.biu.ac.il>
0 siblings, 0 replies; 35+ messages in thread
From: david tzuriel @ 2000-01-21 12:25 UTC (permalink / raw)
To: pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2000-01-23 08:53 Dmitry A. Alyekhin <dmitry@moris.ru>
0 siblings, 0 replies; 35+ messages in thread
From: Dmitry A. Alyekhin @ 2000-01-23 08:53 UTC (permalink / raw)
To: pgsql-sql
subscribe pgsql-sql
^ permalink raw reply [nested|flat] 35+ messages in thread
* (No Subject)
@ 2001-01-19 13:09 Tony Mantana <tony_mantana@lycos.com>
0 siblings, 0 replies; 35+ messages in thread
From: Tony Mantana @ 2001-01-19 13:09 UTC (permalink / raw)
To: pgsql-sql
Hello,
I have visited your web site and found very interesting and informative.
I would like to know:
What is a BLOB Field and can you give a example of one?
I hope to hear from you soon
Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2003-06-12 11:28 A. Van Hook <hook@kcp.com>
0 siblings, 1 reply; 35+ messages in thread
From: A. Van Hook @ 2003-06-12 11:28 UTC (permalink / raw)
To: pgsql-sql
When updating from 7.2.3 to 7.3.3 we have lost the ability to see the
passwords in pg_shadow. Is there a way to decrypt the passwords?
thanks
--
A. R. Van Hook
Honeywell Federal Manufacturing & Technologies
IT System Engineer
City of Lake Lotawana MO
Mayor
^ permalink raw reply [nested|flat] 35+ messages in thread
* Re: (no subject)
@ 2003-06-12 13:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Achilleus Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 35+ messages in thread
From: Tom Lane @ 2003-06-12 13:42 UTC (permalink / raw)
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>; +Cc: A. Van Hook <hook@kcp.com>; pgsql-sql
Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> On Thu, 12 Jun 2003, A. Van Hook wrote:
>> When updating from 7.2.3 to 7.3.3 we have lost the ability to see the
>> passwords in pg_shadow. Is there a way to decrypt the passwords?
> But you still can do
> ALTER USER foo UNENCRYPTED password 'bar';
Also, there is a postgresql.conf setting that will make UNENCRYPTED
the default, same as before (although I fail to understand why anyone
would think that's a good idea ;-))
regards, tom lane
^ permalink raw reply [nested|flat] 35+ messages in thread
* Re: (no subject)
@ 2003-06-12 16:55 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: A. Van Hook <hook@kcp.com>
0 siblings, 1 reply; 35+ messages in thread
From: Achilleus Mantzios @ 2003-06-12 16:55 UTC (permalink / raw)
To: A. Van Hook <hook@kcp.com>; +Cc: pgsql-sql
On Thu, 12 Jun 2003, A. Van Hook wrote:
> When updating from 7.2.3 to 7.3.3 we have lost the ability to see the
> passwords in pg_shadow. Is there a way to decrypt the passwords?
The default case (with md5 method in pg_hba.conf) is encrypted passwds.
But you still can do
ALTER USER foo UNENCRYPTED password 'bar';
dynacom=# SELECT * from pg_shadow where usename='foo';
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
---------+----------+-------------+----------+-----------+--------+----------+-----------
foo | 100 | f | f | f | bar |
|
(1 row)
dynacom=#
>
> thanks
>
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill at matrix dot gatewaynet dot com
mantzios at softlab dot ece dot ntua dot gr
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2003-08-07 10:14 A. Van Hook <hook@kcp.com>
0 siblings, 1 reply; 35+ messages in thread
From: A. Van Hook @ 2003-08-07 10:14 UTC (permalink / raw)
To: pgsql-sql
We have been using 7.3.3 on several different applications and have
discovered an anomaly.
Backups are done nightly using "pg_dump --attribute-inserts -f
att.dump.`dcode` spdb";
Dump files are used to restore and test. This test method has been used
successfully on
all previous versions. However, in 7.3.3, when the dump utility hits a
carriage return imbeded with in a text field, the
dump utility immeadiately jumps to the next record rendering the dump of
successive records useless.
i.e.
INSERT INTO registry (rid, sid, aflag, fname, lname, mi, addr, city,
state, zip, phone, email, weddate, regdate, items, \
notes, ref) VALUES (1148, 503, NULL, 'Jillian', 'Kooker', ' ', '', '',
'', '', '610-649-3327', '', '2002-10-24', '2002-0\
8-15', 'HP: 9120 Malis Henderson Veil: S2378 sparkle tulle and rat-tail
edge', 'Used an 888 slip^M <<<<<<
What am I doing wrong??
thanks
--
A. R. Van Hook
Honeywell Federal Manufacturing & Technologies
IT System Engineer
City of Lake Lotawana MO
Mayor
pager (816)458-2585
cell (816)564-0769
hook@kcp.com (816)997-3531
hook@lota.us (816)578-4704
hook@lake-lotawana.mo.us (816)578-4215
^ permalink raw reply [nested|flat] 35+ messages in thread
* Re: (no subject)
@ 2003-08-07 15:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: A. Van Hook <hook@kcp.com>
0 siblings, 0 replies; 35+ messages in thread
From: Tom Lane @ 2003-08-07 15:10 UTC (permalink / raw)
To: A. Van Hook <hook@kcp.com>; +Cc: pgsql-sql
"A. Van Hook" <hook@kcp.com> writes:
> Dump files are used to restore and test. This test method has been used
> successfully on
> all previous versions. However, in 7.3.3, when the dump utility hits a
> carriage return imbeded with in a text field, the
> dump utility immeadiately jumps to the next record rendering the dump of
> successive records useless.
AFAICT, pg_dump with -D in 7.3 and current dumps embedded carriage
returns and newlines literally, same as it always has. I suspect your
problems are not actually with Postgres, but with some other tool that
is misreading or altering the dump file.
Personally, I would use pg_dump without -D. Recent versions give a
fairly nice behavior for embedded control characters:
COPY foo (f1) FROM stdin;
aaa\rbbb\r\nccc
aaa\rbbb\r\nccc
\.
regards, tom lane
^ permalink raw reply [nested|flat] 35+ messages in thread
* (No Subject)
@ 2004-06-11 04:36 William Anthony Lim <wei.liang@eudoramail.com>
0 siblings, 1 reply; 35+ messages in thread
From: William Anthony Lim @ 2004-06-11 04:36 UTC (permalink / raw)
To: pgsql-sql
is it possible to dump within procedural language/SQL syntax? Using pg_dump from console is very confusing for some end user who don't have Linux skills. so I decide to create a function to do that, and they may call it from my application.
Thanks
William
Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com
^ permalink raw reply [nested|flat] 35+ messages in thread
* Re: (No Subject)
@ 2004-06-11 14:02 Franco Bruno Borghesi <franco@akyasociados.com.ar>
parent: William Anthony Lim <wei.liang@eudoramail.com>
0 siblings, 0 replies; 35+ messages in thread
From: Franco Bruno Borghesi @ 2004-06-11 14:02 UTC (permalink / raw)
To: wei.liang@eudoramail.com; +Cc: pgsql-sql
I remember reading somewhere that it was possible to execute system
commands from plperl... don't know if it's the best way, but you could
do an exec of pg_dump from inside a plperl procedure.
On Fri, 2004-06-11 at 01:36, William Anthony Lim wrote:
> is it possible to dump within procedural language/SQL syntax? Using pg_dump from console is very confusing for some end user who don't have Linux skills. so I decide to create a function to do that, and they may call it from my application.
>
> Thanks
>
> William
>
>
> Need a new email address that people can remember
> Check out the new EudoraMail at
> http://www.eudoramail.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2006-07-08 08:57 onin <jnana@mobius.ph>
0 siblings, 0 replies; 35+ messages in thread
From: onin @ 2006-07-08 08:57 UTC (permalink / raw)
To: pgsql-sql
--
"A whim, a thought, and more is sought... awake, my mind... thy will be wrought!"
^ permalink raw reply [nested|flat] 35+ messages in thread
* (no subject)
@ 2008-04-09 12:07 Colin Martin <cmlist@electriciq.net>
0 siblings, 0 replies; 35+ messages in thread
From: Colin Martin @ 2008-04-09 12:07 UTC (permalink / raw)
To: pgsql-sql
--
Colin Martin
^ permalink raw reply [nested|flat] 35+ messages in thread
end of thread, other threads:[~2008-04-09 12:07 UTC | newest]
Thread overview: 35+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-05-13 16:26 (no subject) sebastien Flacher <flash@cur-archamps.fr>
1998-06-04 23:24 (no subject) Chris Olivier <mjaunes1@tampabay.rr.com>
1998-06-08 14:42 (no subject) Mike Payne <mpayne@i1.net>
1998-06-13 21:22 (no subject) Edwin S. Ramirez <edwin.ramirez@erols.com>
1998-06-19 20:13 (no subject) Steve Doliov <doliov@statsol.com>
1998-07-19 11:38 (no subject) Barry Voeten <barry@ekonism.org>
1998-08-15 17:32 (no subject) Dariusz Owczarek <do@pap.waw.pl>
1998-09-08 01:45 (no subject) jmjang <jmjang@netlab.korea.ac.kr>
1999-05-03 08:55 (no subject) Thomas Malkus <tmalkus@csi.com>
1999-05-18 05:26 (no subject) Ivanko Alexandr <shura@nikts.nk.ukrtel.net>
1999-05-19 04:29 (no subject) Robert Chalmers <robert@chalmers.com.au>
1999-05-28 06:04 (no subject) Ivanko Alexandr <shura@nikts.nk.ukrtel.net>
1999-07-22 18:49 (no subject) root <raptor@unacs.bg>
1999-07-26 04:04 (no subject) Martin Jackson <mhjacks@nwa.quik.com>
1999-08-17 02:58 (no subject) Stanley Morgan <stan@cyberfort.com>
1999-08-25 05:54 (no subject) Stanley Morgan <stan@cyberfort.com>
1999-09-07 20:26 (no subject) leonardo albrizio <albrizio@freemail.it>
1999-10-13 17:11 (no subject) Ottawa Online Digital Development <sumi@ottawaonline.com>
1999-12-06 03:38 (no subject) cristiv <cristiv@mangalia.ro>
1999-12-09 16:20 (no subject) cristi voinicaru <cristiv@mangalia.ro>
1999-12-09 16:21 (no subject) cristi voinicaru <cristiv@univ-ovidius.ro>
2000-01-15 11:19 (no subject) Michal Frajt <frajt@aki.cz>
2000-01-19 16:32 (no subject) Sevo Stille <sevo@ip23.net>
2000-01-21 12:25 (no subject) david tzuriel <tzuried@mail.biu.ac.il>
2000-01-23 08:53 (no subject) Dmitry A. Alyekhin <dmitry@moris.ru>
2001-01-19 13:09 (No Subject) Tony Mantana <tony_mantana@lycos.com>
2003-06-12 11:28 (no subject) A. Van Hook <hook@kcp.com>
2003-06-12 16:55 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2003-06-12 13:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-08-07 10:14 (no subject) A. Van Hook <hook@kcp.com>
2003-08-07 15:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-11 04:36 (No Subject) William Anthony Lim <wei.liang@eudoramail.com>
2004-06-11 14:02 ` Re: (No Subject) Franco Bruno Borghesi <franco@akyasociados.com.ar>
2006-07-08 08:57 (no subject) onin <jnana@mobius.ph>
2008-04-09 12:07 (no subject) Colin Martin <cmlist@electriciq.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox