ional things (if so, please describe how they'd also be dumped)?
Thanks,
csn
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates
(http://voice.yahoo.com)
--
PostgreSQL doesn't have any booth babes? ;P
csn
> On 09/20/06 16:38, Philip Hallstrom wrote:
> [snip]
> > I think that description is false. At a certain point in the
> > management hierarchy, the only way anyone has the ability to
> > evaluate something is on t
I have two tables:
items: id, title, added, ...
news: id, headline, datetime, ...
I'd like to select the latest 25 combined records from both tables. Is there a
way to do this
using just select?
Thanks,
csn
__
Do You Yahoo!?
Tired of
--- Douglas McNaught <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
>
> > I'm stymied. ;)
>
> So you've tried running both pg_ctl binaries against the data
> directory and both don't work?
Yes.
> I wonder how you ever had a
--- Douglas McNaught <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
>
> > I don't know which to run now! I tried both
> > '/opt/local/lib/pgsql8/bin/pg_ctl start -D pgdata'
> and
>
> You might want an absolute path for '
--- Douglas McNaught <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
>
> > I don't think so -- I followed the instructions
> here:
> >
> >
>
http://www.robbyonrails.com/articles/2006/05/29/install-ruby-rails-and-postgresql-on-osx
> &
using Fink or some other way. Any further
ideas?
Thanks,
csn
--- Douglas McNaught <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
>
> > DETAIL: The database cluster was initialized
> without
> > HAVE_INT64_TIMESTAMP but the server was compiled
>
n't agree with
PostgreSQL. But I've had crashes before and never had
a problem getting PostgreSQL going again. Anybody know
how to fix this? I also tried 'pg_resetxlog -f pgdata'
but still get the same error trying to start up.
Thanks,
csn
Mac OS 10.4.7
PostgreSQL 8.1.3
#x27;)) AS clusterowner FROM pg_shadow
I haven't messed around with template0. This is a
recent installation of postgres (8.0.x), done via yum.
Any idea what the problem is and how to fix it?
thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail ha
onnections limit, even though
the setup isn't getting much traffic currently. Is
there a way in postgres to close idle connection after
some time (or other remedy)?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protecti
when emdashes are stored in the
database as HTML entities, but they're displayed as
emdashes in a web form, but then get stored back in
the database wrong when edited (an accented A IIRC). I
dunno - maybe it's a browser or Rails thing.
CSN
psql? Hopefully it's not
necessary to insert with values like '\xC3\xA1'
instead (which I tried, but the values got inserted as
is and weren't converted).
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best
If you're going to be putting emdashes, letters with
lines and circles above them, and similar stuff that's
mostly European and American in a database, what's a
good default encoding to use - UTF-8?
CSN
__
Do You Yahoo!?
Tired of spa
I'm updating a field via a web form, and an em-dash is
getting stored in the database as 'âÃ-', and is
getting displayed back on the web page as 'âÂÂÃÂ'. The
encoding of the database is SQL_ASCII - should I
change it? And if so, to w
I have a bunch of timestamps like:
2005-11-20 20:45:48.281653-07
How can I change it so they never get saved with
seconds fractions?
Thanks
csn
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http
Is there some way/utility that allows dumping
according to specified criteria? Say, for example, you
have these tables:
members
comments
items
Where comments and items both have f/k's to members,
and you'd like to dump all data for a specific member
id. Possible?
In psql, is it possible to "tail" \s (say, the last
fifty lines), rather than do "\set HISTSIZE 50" and
have the entire history be only 50 lines?
Like 'history | tail -n 50' in the shell?
thanks
csn
__
Do You Yahoo
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 30, 2005 at 12:09:12PM -0800, CSN wrote:
> > ERROR: insert or update on table "types" violates
> > foreign key constraint "$1"
> > DETAIL: Key (page_template_id)=(8) is not present
> in
--- Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 30, 2005 at 13:30:40 -0800,
> CSN <[EMAIL PROTECTED]> wrote:
> > I have three columns, and one of them can be null.
> I'd
> > like to create a unique constraint across all
> three
>
'not allowed' lines are allowed.
thanks
csn
__
Yahoo! for Good - Make a difference this year.
http://brand.yahoo.com/cybergivingweek2005/
---(end of broadcast)---
TIP 3: Have
tement "UPDATE ONLY "public"."types"
SET "item_template_id" = NULL WHERE "item_template_id"
= $1"
SQL statement "DELETE FROM ONLY "public"."templates"
WHERE "site_id"
negative offsets -
such as maybe someday they'll offset backwards?
thanks
csn
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broa
Is it possible to copy data from a table into a file and specify a query for
what data should be
included? e.g.
\copy table1 to 'data.txt' where col1=true
thanks
csn
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
es). If it is,
what's the best option - use tsearch? How does tsearch (or whatever else)
compare performance-wise
to not using it, or to typical index-based queries for that matter?
thanks
csn
__
Start your day with Yahoo! - Make it your ho
I have a trigger function that simply updates item counts when the items table
changes (member_id
or active changes). I'm curious if this bit of the code can be simplified? :)
thanks
csn
ELSIF TG_OP = 'UPDATE' THEN
IF (OLD.member_id is NULL and NEW.member_id is not null) or
h, and now
they both appear to
function properly. I don't remember seeing anything in the docs stating that
this is necessary, so
I guess perhaps it's a bug?
csn
--- CSN <[EMAIL PROTECTED]> wrote:
> I have a members table and an items table. Every time items.member_id or
s
after changing a
table's schema? I don't know how something is trying to set members.admin to
null (table members
has no triggers).
thanks
csn
Postgresql 8.0.x
__
Yahoo! FareChase: Search multiple travel sites in one click.
http://fa
t; Having defended the undefendable, however, I'd
like to know if
> > postgresql really still doesn't support Unicode on
windows, as
> > I plan to develop on WindowsXP and deploy on
Linux.
> >
> > Warren Seltzer
Thread here:
http://www.ruby-forum.com/topic/3690#new
err'). Any way to further diagnose this?
thanks
csn
__
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
pg_get_serial_sequence(
> 'table','col' ) );
I like that better than the current 'table_col_seq'.
Perhaps just currval('table', 'col'). Or perhaps
tables could be made to have a default sequence (one
that's associated with the primary key).
CSN
omatically access the sequence. I don't like this
as it may break other things. Is there a way to create
an alias or something (e.g. quotes_seq_id points to
quotes_table_seq_id), or is there a better way?
Thanks,
CSN
__
Yahoo! Mai
,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choo
Here are some apparent problems with MySQL 5.0:
- Concurrent ALTER TABLE
- Replicated Session Variables and Concurrent ALTER
TABLE
- BIT indexing that [doesn't] actually uses a BIT!
- SELECT * FROM FOO WHERE ID IN ( SELECT FOO_ID FROM
BAR ) [doesn't use index]
http://www.feedblog.org/2005/10/what
nice comes to mind:
nice pg_dump ...
On Sat, 2005-10-22 at 07:39, Bryan Field-Elliot wrote:
> We have a huge database which must be backed up
every day with
> pg_dump. The problem is, it takes around half an
hour to produce the
> dump file, and all other processes on the same box
are starved f
ith potentially different sizes)?
Thanks,
CSN
__
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---(end of broadcast)---
TIP 4: Have you searched ou
BTW, it (the SQL spec I presume) has always seemed
contradictory to me that you can't do:
select * from table where field=null;
but can do:
update table set field=null;
(as opposed to 'update table set field to null' or
s NOT NULL) or
(OLD.value != NEW.value)) THEN
--
END IF;
So, does NULL != 'abc' always evaluate to false? The
manual
(http://www.postgresql.org/docs/8.0/interactive/functions-comparison.html)
states don't compare NULL values using =, but nothing
perhaps NULL's in OLD.stuff is
causing the IF to behave other than what I expect.
Thanks for any help!
CSN
CREATE or REPLACE function update_ts() returns trigger
as $end$
BEGIN
IF (TG_OP='UPDATE') THEN
IF (OLD.stuff != NEW.stuff) THEN
UPDATE tabl
I don't know if I'm going to get a copy of
pg_filedump. What's the best way to fix this - dump
then restore?
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > oid | ctid| x
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
Thanks,
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unli
There are some articles on eweek about this:
Oracle Finds the Flaw in MySQL's Business Plan
http://www.eweek.com/article2/0,1895,1869989,00.asp
"This is what Oracle says in its release: "InnoDB's
contractual relationship with MySQL comes up for
renewal next year. Oracle fully expects to negotiate
tries table are return (I expected an error). Is
this the "implicit FROM" gotcha?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
---
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > If integer's range is -2147483648 to +2147483647,
> why
> > is serial's range only 1 to 2147483647 instead of
> 1 to
> > about 4294967294?
>
> How are you goin
If integer's range is -2147483648 to +2147483647, why
is serial's range only 1 to 2147483647 instead of 1 to
about 4294967294?
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com
o determine how badly it lies. ;)
Thanks,
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > oid | ctid| xmin | cmin | xmax |
> cmax | id
> >
>
+---+-+--+-+--+-
> >
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sun, Oct 09, 2005 at 12:46:51PM -0700, CSN wrote:
> > select * from table1 where id=586;
> > 586|a|b|c|d
>
> Do you get different results from the following
> queries?
>
> SET enable_seqscan TO on;
> SET e
Yep, those were two of my very first questions too. ;)
CSN
--- "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
>
> Stupid question, but what does MySQL bring to the
> equation? Why not just
> use PostgreSQL in the first place?
>
> On Sun, 9 Oct 2005, CS
Look what somebody suggested!
---
If the worst happens and Oracle tries to squash
InnoDB, there may already be such an alternative out
there.
I wonder what it would take to add (and optimize)
Postgres storage engine support to MySQL? I don't know
exact
dows XP. This computer has been crashing repeatedly
lately, if that could be blamed (bad memory? hard
disk? I haven't quite figured out why.) Using
phppgadmin, I was able to delete one of the duplicate
rows (there are several) - don't know how i
AP
# InnoDB
# BDB or BerkeleyDB Tables
# Example
# Archive
# Federated
# CSV
# Blackhole
# NDB Cluster
http://dev.mysql.com/doc/mysql/en/storage-engines.html
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it
I had a similar experience speaking to the MySQL folks
at (the last) COMDEX. After trying to get them to
explain how their licenses work, I was even more
confused (and two reps even gave conflicting info).
CSN
> Hi everyone,
>
> I've just got back from LinuxWorld in London a
Yep, I think the SQL spec says fold to uppercase. I'm
not sure why PostgreSQL folds to lowercase instead,
but if folding has to occur, I prefer lowercase.
CSN
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> On Thu, Oct 06, 2005 at 12:54:43PM -0700, CSN wrote:
>
--- CSN <[EMAIL PROTECTED]> wrote:
> - 8 of the 13 are for versions of PostgreSQL <= 8.1
Doh!
- 8 of the 13 are for versions of PostgreSQL < 8.1!
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
h
--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-10-05 at 23:41, Tom Lane wrote:
> > "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > > On Wed, 2005-10-05 at 18:37 -0700, CSN wrote:
> > >> Just so I know (and am armed ;) ), are the
ble partitions? Or
Slony?
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
I consider "select as" to be
really trivial (and it appears a work-around can be
hacked).
- lowercase folding. I DO sometimes wish I could use
fieldID, etc. without quoting it.
- I've never found count(*) to be slow.
- I don't know enough about the "UNICODE me
I'm not sure what XA (distributed transactions) is -
is that something that can be achieved with Slony?
CSN
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-10-05 at 18:37 -0700, CSN wrote:
> > Just so I know (and am armed ;) ), are there any
&g
Just so I know (and am armed ;) ), are there any new
comparable features in MySQL 5.0 that aren't in
PostgreSQL up to the forthcoming 8.1? AFAIK, PG just
lacks updatable views (which are on the TODO).
MySQL 5.0 new features
http://dev.mysql.com/doc/mysql/en/mysql-5-0-nutshell.html
Thanks
here are also options for
"VT400", "VT100+", and "SCO" - haven't tried those).
Thanks,
CSN
--- Klint Gore <[EMAIL PROTECTED]> wrote:
> On Sun, 25 Sep 2005 20:00:03 -0700 (PDT), CSN
> <[EMAIL PROTECTED]> wrote:
> >
> > I did 'strace psq
It looks like I had readline 4.3 installed. I just
installed readline 5.0 - the F1-4 keys still cause
psql to segfault. (AFAIK I don't need to recompile
postgres for psql to use the newly installed
readline).
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTE
Hmm, all I could think of was perl and php - hitting
F1-4 just caused these chars to be displayed (the
interpreters didn't exit):
^[OP^[OQ^[OR^[OS
CSN
--- Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian writes:
> > > CSN wrote:
> > >> If I&
I did 'strace psql dbname' and this was the output
after hitting F1:
read(0, "\33", 1) = 1
read(0, "O", 1) = 1
read(0, "P", 1) = 1
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ k
Here's what 'od -c' shows for F1-4:
^[OP^[OQ^[OR^[OS
CSN
--- Bruce Momjian wrote:
> CSN wrote:
> > If I'm in psql (via putty, from WinXP to Redhat)
> and
> > hit F1-4 (F5+ just display a ~), psql will
> > segmentation fault and exit. Not that I&#x
d it using WinXP's command prompt and none
of the function keys cause psql to segfault.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(e
Nevermind, figured it out:
select distinct on (table1id, table2id) * into temp
from table3;
delete from table3;
insert into table3 select * from temp;
--- CSN <[EMAIL PROTECTED]> wrote:
> I have a table that relates id's of two other
> tables:
>
> table1id, table2i
I have a table that relates id's of two other tables:
table1id, table2id
Dupes have found their way into it (create unique
index across both fields fails). Is there a quick and
easy way to find and delete the dupes (there are tens
of thousands of records)?
Thanks
--- Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-09-21 at 15:02, CSN wrote:
> > This appears related to my previous post:
> >
>
http://archives.postgresql.org/pgsql-general/2005-09/msg00809.php
> >
> > I setup a unique index using the title, yi
, 2713
CONTEXT: SQL statement "insert into stuff (title,
yield, directions) values ( $1 , $2 , $3 )"
What do I do?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(e
e the
database automatically handle this (trigger to compute
hash field at insert time - unique index will raise an
exception).
Thanks for any help, insights, suggestions, etc.
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.
Just something I was curious about - is there any
difference at all between "character varying" (in the
SQL spec) without a length specified and "text" (not
in the SQL spec)?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editor
rmine what data types
each field should be?
Thanks,
CSN
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the pl
> CSN wrote:
> > Perhaps another possible feature request! I've
looked
> > through the docs and it doesn't appear that it's
> > possible to create deferred triggers - i.e. they
don't
> > get called unless the current transaction commits.
er or not there is a transaction in
progress.)
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
y row (and subsequently
be able to delete that row's files), or will only one
notify event be received (or some number less than the
actual number of rows deleted)?
Thanks,
CSN
Start your day with Yahoo!
For lack of a better term, but I was curious if there
is/was any thought about making PG's views
automatically "see" changes in underlying tables, as
opposed to currently having to drop/create all
corresponding views if a table's structure (add/delete
fields, et
t that was in cygwin/path - what's the
remedy to get \s to work?
BTW, is there a way to set the number of commands
returned by "\s"?
Thanks,
CSN
Start your day with Yahoo! - make it y
a way to rewrite
this query so the index is used?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
x27;2001-09-28' + ((7+7)||' seconds')::interval);
etc.
Or am I missing an easier way to do date arithmetic
using a table's fields as part of the equation? (I
think mysql has date_add(...), date_subtract(...),
etc.
CSN
__
Do Yo
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Aug 15, 2005 at 01:48:00PM -0700, CSN wrote:
> > db=>select ascii('');
> > ascii
> > ---
> >226
> >
> > db=>select id from news where body ilike '%%';
> &
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Aug 15, 2005 at 12:14:16PM -0700, CSN wrote:
> > Is there a way to replace all curly apostrophes
> with
> > standard apostrophes (presumably with
> replace(x,y,z))?
> > My database is SQL_ASCII and I can't
Ah, it's Western ISO-8859-1. Putty has the same
setting. I tried changing putty's charset to UTF-8 and
now curly apostrophes are displayed as a grey box in
psql's output (e.g. "in today[box]s news...").
Thanks,
CSN
--- Richard Huxton wrote:
> CSN wrote:
> >
n the database.
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of broadcast)---
TIP 3: Have you checked our extensiv
--- Richard Huxton wrote:
> CSN wrote:
> > In a field I have text like "in today's news..."
> When
> > I select that field in psql using putty (Latin-1),
> > then apostrophe doesn't show up (shows up as
> > "todays"), but it does sh
ls ..
In a field I have text like "in today's news..." When
I select that field in psql using putty (Latin-1),
then apostrophe doesn't show up (shows up as
"todays"), but it does show up in phppgadmin (and
other php programs). Is this an issue with psql, or
putty (or
Greetings-
How can I remove tsearch2 (all its tables, types,
functions, etc.) from a database?
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
---(end of
og. I'd guess maybe it's something
plphp is doing on its own with references, but I
should probably play around with some more plphp
functions and see if they generate the same warnings.
Anyhow, thanks for the help.
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
$message=<<";
mail($to,
"Link Activated - $group[name]!",
$message,
"From: {$group[name]} <$group[email]>\r\n");
}
}
}
$$ LANGUAGE 'plphpu';
-- CREATE TRIGGER email_activated_member AFTER INSERT
or UPDATE ON links
I'm using PHP5, and I'm not passing by reference. My
first stop WAS plphp.commandprompt.com, but none of
their mailing list links for plphp work.
CSN
> # jd ( at ) commandprompt ( dot ) com / 2005-08-11
15:45:18 -0700:
> > Roman Neuhauser wrote:
> > ># cool_screen_
Jeez, nevermind again! Turns out this was the problem
in the plphp script:
$sql="select * from table where id=123";
$result=spi_exec_query($sqll);
I'm still curious about the "Call-time
pass-by-reference has been deprecated" warning if
anybody knows.
Thanks,
CSN
reset: Failed.
And this is what shows up in the log:
LOG: server process (PID 31665) was terminated by
signal 11
LOG: terminating any other active server processes
Wow. I still don't see anything wrong with the plphp
function - how could it cause the entire server to
crash?
Thanks
Nevermind, I found some stray single quotes (in an
array var) in a double-quoted string that appears to
have been the problem.
--- CSN <[EMAIL PROTECTED]> wrote:
> I'm using plphp to create a trigger. I don't see any
> syntax errors in it (I've checked it with php -l
-reference, you
can set allow_call_time_pass_reference to true in your
INI file. However, future versions may not support
this any longer. in plphp trigger call on line 1
Is there anything I can do about it? I'd email plphp's
list, but their mailing list links a
ied that plphp (and plphpu) is installed
with 'createlang -l'.
Any idea what the problem is?
Thanks,
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
PG's docs on notify say that if events
happen in rapid succession, notify's might get
dropped. For example: could many item rows get
deleted, but some of their corresponding files not get
deleted due to dropped notify's?
Thanks,
CSN
Is it possible to have PG report the actual number of
rows that actually CHANGED in an update command? e.g.
UPDATE items set name=replace(name,'abc','def');
UPDATE 9000 -- Actually only 3 were changed
rather than update reporting all rows have been
&qu
with a small script
> which
> basically LISTENs to notify from database, spools
> the
> mails and go sleep again.
Could you elaborate how you do this? IIRC, there's an
example in the docs using C, but I'd prefer using a
scripting language.
Thanks,
CSN
nience! I want the email sent whether the member
is added via the web interface, directly in the
database, from the command line, etc. I don't see any
downside. It's only one user that'll be using this
function.
CSN
__
Do You Yahoo!?
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > I'm using plphpu and I'd like to allow the regular
> > database user to use it, but since it's
> "untrusted" it
> > requires users to be superusers. If I h
a user for a specific database? All I'm familiar with
is "alter user joe createuser." Or is there a better
way of handling this language and permission issue?
(The function uses mail(), so IIRC that necessitates
using plphpu).
Thanks,
CSN
1 - 100 of 170 matches
Mail list logo
