Hi,
Newbie needs help. I have a small web-based phonebook app using php and
postgresql 7.02. It seems the nobody (apache) user can delete, update,
add anything except increment the 'id' sequence. I don't think it's the
code (cut and pasted from a tutorial) because the pgsql user can
increment
On Sat, 14 Apr 2001, Ian Pulsford wrote:
> Newbie needs help. I have a small web-based phonebook app using php and
> postgresql 7.02. It seems the nobody (apache) user can delete, update,
> add anything except increment the 'id' sequence. I don't think it's the
> code (cut and pasted from a tu
> Try this
>
> CREATE SEQUENCE just_a_seq;
> Select nextval('just_a_seq') as row_no, * from pg_tables ;
> drop SEQUENCE just_a_seq;
Wow! Great idea! :-)
In fact I need row numbering in browsing and printing invoices. They
should be read on various platforms (Windows clients, generated HTML a
=?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= wrote:
>I have accidentally created a user with no name. How can I delete this
>user?
>I have compiled my attempts below:
>
>Hans
>
>
>persons=# SELECT * FROM pg_user;
> usename | usesysid | usecreatedb | usetrace | usesuper | use
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> Can someone explain this to me?
Are you taking into account that SQL booleans are actually three-valued?
They can be TRUE, FALSE, or NULL (NULL taken as meaning "don't know").
regards, tom lane
---(end o
While we're on this subject, where is the documentation on
pg_shadow? Specifically, what it 'usetrace' for?
-Cedar
On Fri, 13 Apr 2001, Tom Lane wrote:
> =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <[EMAIL PROTECTED]> writes:
> > I have created a user called epi who is not allowed to create
Hello All,
This may be the wrong mailing list for this question but I hope someone can
answer it for me as it is holding up my development progress.
I have now been able to compile the tutorial/complex.c functions and test them
out with no problems.
I made a copy of the Makefile, Makefile.globa
Peter,
> No way. You're doing something wrong. How about showing the data
> that
> makes you believe this?
Hey, take it easy. It was only a technical question / potential issue.
Not a personal criticism.
Based on your implied assertion that the queries *should* be working in
a Boolean fashi
Tom,
> Are you taking into account that SQL booleans are actually
> three-valued?
> They can be TRUE, FALSE, or NULL (NULL taken as meaning "don't
> know").
That turned out not to be the issue, but that's good information to
have. I'll need to remember to make all of my BOOLEAN columns NOT NULL
Hi All again,
One more thing that I have tried.
If I now do a similar thing as in my previous message with the "funcs.c" file,
but this time with the "funcs.cc" file then I can get:
-
[root@Treazurac /test]# g++ -I./include
Tim Perdue <[EMAIL PROTECTED]> writes:
> SELECT *
> FROM (stats_http_downloads sh
> FULL OUTER JOIN stats_ftp_downloads sf USING (day,filerelease_id)) ;
> ERROR: FULL JOIN is only supported with mergejoinable join conditions
I've committed a fix for this problem. It'll appear in 7.1.1, or you
Hi group,
We have a DSS system based on Informix IDS and number of OLTP systems based
on Interbase.
After we was running this system, we had have a unceasing serious problems
with Interbase.
1) Massive inserts, updates, deletes is crashed database internal structure
!!!.
we have to make backup
>How stable is PostgreSql ?
>I know, PostgreSql doesn't support 'prepare ' operation, is it successful to
>use one for OLTP databases ?
Speaking from experience, I have personally stress tested Postgres under
loads of over 512 persistent connections with our LXP application server
with zero probl
13 matches
Mail list logo
