hello i've got a problem on CREATE USER and ALTER USER when i have many
users connected.
i have prosgresql 7.1 running on Redhat 7.0
is this a bug in postgres?
pls let me know. thanks
richard.
---(end of broadcast)---
TIP 4: Don't 'kill -9'
chard <[EMAIL PROTECTED]> writes:
> hello i've got a problem on CREATE USER and ALTER USER when i have many
> users connected.
> i have prosgresql 7.1 running on Redhat 7.0
> is this a bug in postgres?
How can we tell? You'll need to provide a much more specific report
than that. See
http://www
>From pg_group, it's possible to return the users that are in that group.
How can in put the values in that array of integer to an array ??
Using plpg/SQL, how can i access to the array of integers ???
Best Regards
Luis Sousa
---(end of broadcast)---
read the doc section datatype!!!
serial just create a sequence on a standard way, if you dont like it you'll
have to create your sequence.
bye
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end
"Roy Souther" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
0105301102010Q.28903@OlympusMons">news:0105301102010Q.28903@OlympusMons...
> I am testing my SQL commands in pgaccess before I put them into my C++
code.
> Trying to copy a table using...
> SELECT * INTO TABLE copy_stuff FROM
Hi,
I'm trying to retreive DISTINCT Values from a two colomn table called
"Books". The colomns are named "Author" and "URL".
DISTINCT values should be retieved from the "Author" Colomn , and then I
should be able to retrieve the corresponding URL.
How do I build the SQL Query ?
I tried to use: "S
stone schrieb:
> Hello:
> I'm new user of postgresql. My problem is that:
> 1. How to create template table? Is it right of ' Create temptable
> test(..)'?
> 2.My application is Client/Server, can I has some workstations create the
> same template table name on the same time? If I could, How
> exemple:
> CRETAE TABLE Address (Number integer, Street varchar, city varchar, contry
> varchar);
> CREATE TABLE Person (Name varchar, addr Address);
> INSERT INTO addrerss VALUES ( 5, 'rue du pont', 'Lyon', 'France');
> The question is :
> How we can insert a new person whose address is that i
read this:
http://www.postgresql.org/idocs/index.php?sql-createtrigger.html
bye
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end of broadcast)---
TIP 4: Don't 'kill -9
If you use index on this table it's better to:
1) drop all index on the table
2) do the insert
3) (re)create the indexes
--
--
"L'idea di base è estremamente semplice..."
©opyright Frank "Pazzooo" Contrepois (schiavista francese del '900)
---(end of broadcast)---
Hello:
I'm new user of postgresql. My problem is that:
1. How to create template table? Is it right of ' Create temptable
test(..)'?
2.My application is Client/Server, can I has some workstations create the
same template table name on the same time? If I could, How can I do with it?
Thank
On Thu, 31 May 2001 17:24:54 + (UTC), [EMAIL PROTECTED] (Mark)
wrote:
>
>How does one perform date manipulation within SQL? For example, SQL
>Server has a dateadd() function that takes a date part, scalar, and the
>date to manipulate.
>
>I have a query that determines the number of days that
Greetings,
I am investigating whether our application will run on 7.1.1 (from
7.0.3), and our client software only accesses the database through views
for security and convenience.
In our client app, we lock our table before doing something to it.
Fortunately, in 7.0.3, a view looked like a
i am trying to build a query in sql that compares between 2 tables one
hold to field and the other hold the 2 fields in one
example:
table1:EN,12
table2:EN.12
how can i compare between the tables throw that field
i try with this query but it doesnt work:
SELECT * FROM dbo.CNT_DOC_LANGS x INNER JO
hi,
I wanted to know that does postgresql database support php-nuke
--
Donot rely on the Operating System which don't have any sources for.
-Seen somewhere on the Net
___ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
hi,
i'am really new to postgresql and i try it with php ..
Now i have following question :
is it possible to make one query on two databases. I have a database calles
db1 and one db2 and i want to get :
select * from ":db1:table1" where ":db1:table1:col1" in (select "col1" from
":db2:table1"
Try:
- The ILIKE operator, for example,
SELECT * FROM account WHERE username ILIKE "test";
- upper() or lower(), for example,
SELECT * FROM accont WHERE lower(username) = "test";
-
Andrew J. Perrin - Assistant Professor of Sociology
Muhammed Yazici wrote:
>
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> db1 and one db2 and i want to get :
>
> select * from ":db1:table1" where ":db1:table
find libpq.so.2.1 in the tree from the compile (find . -name
libpq.so.2.1 -print)
then copy it to /usr/libexec manually.
you might also want to check the permissions on the library, it should be
755 (rwxr-xr-x).
Best regards,
Chris
- Original Message -
From: "Dorin Grunberg" <[EMAIL PROT
...sh*
But thanx ..
i'll try another solution ..
"Nils Zonneveld" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> Muhammed Yazici wrote:
> >
> > hi,
> > i'am really new to postgresql and i try it with php ..
> >
> > Now i have following question :
>
There is currently no ability to span databases in a single
query.
On Wed, 30 May 2001, Muhammed Yazici wrote:
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> d
hello:
how does one execute an sql statement from inside a plperl function?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Wed, 30 May 2001, Nicolas wrote:
> Hi,
>
> I'm trying to retreive DISTINCT Values from a two colomn table called
> "Books". The colomns are named "Author" and "URL".
> DISTINCT values should be retieved from the "Author" Colomn , and then I
> should be able to retrieve the corresponding URL.
clayton cottingham <[EMAIL PROTECTED]> writes:
> how does one execute an sql statement from inside a plperl function?
At the moment, one doesn't.
This is one of a number of features that have to be finished before
plperl can be classed as more than a proof-of-concept exercise.
However, Mark Holl
As I know, plperl doesn't support that yet.
plpgsql does, so does pltcl.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Tue, 5 Jun 2001, clayton cottingham wrote:
> hello:
>
>
Limlim,
Please post table definitions and some sample data. Your problem does
not look that challenging and there is probably a simple reason that
you're having trouble with it.
> i am trying to build a query in sql that compares between 2 tables
> one
> hold to field and the other hold the 2 f
Hi folks,
I have a special application that considers a playday to be from 8am to
3pm the next morning. The system then does maintenance from 3am till 8am
(if necessary).
I'd like to ease application development by creating a new kind of
"playDay" to query from. For example:
SELECT * FROM tab
Hi the list !
How can I make a test on a int2vector ? If I have a vector that contains
(1, 2, 5, 9), how can I check these values incivicually ? Thanks by
advance for your help.
--
David BOURIAUD
--
In a world without walls or fences, what
28 matches
Mail list logo
