# [EMAIL PROTECTED] / 2006-02-26 20:15:20 +0100:
> # [EMAIL PROTECTED] / 2006-02-26 14:36:47 -0400:
> > On Sun, 26 Feb 2006, Roman Neuhauser wrote:
> >
> > >Hello,
> > >
> > >I've been waiting five months for the majordomo moderators to a
gsql--owner@ and postmaster@
aliases? Does anyone pay attention to the approval queue?
Anyway, here's a few snippets from my last year's email
conversations with [EMAIL PROTECTED]
My subscription requests:
: Date: Sat, 24 Sep 2005 12:17:37 +0200
: From: Roman
# [EMAIL PROTECTED] / 2006-02-27 16:32:55 -0400:
> On Mon, 27 Feb 2006, Roman Neuhauser wrote:
>
> ># [EMAIL PROTECTED] / 2006-02-26 19:01:58 -0400:
> >>'k, I just checked all the lists you listed, and you are subscribed to
> >>each of them ... are you not rec
# [EMAIL PROTECTED] / 2006-02-28 15:14:39 -:
> It looks like the listserv cannot handle that address - it says:
>
> "Individual words are not allowed in an e-mail address without an
> intervening period or at symbol ('.' or '@')."
Which address? I see no whitespace in any of the addresse
Let me start this email by saying thank you to whoever fixed the
problem. I found a bunch of "Welcome to..." / "Results from delayed
command" message pairs in my mail this morning, and a batch of
messages from each of sql, performance, and hackers mailing lists.
# [EMAIL PROTECTED]
and in 1.0 beta 2.
I've also tried commercial driver from Core Lab.. with the same
result.
PostgresSQL version 8.1.2.
The field idvideodate is Timestamp and mediabinary is bytea.
Probably it's a problem not with ado.net driver, but with
PostgressSQL but how to cope with that?
Roman.
I've compared Debug log between correct and wrong activity:
Good activity:
2006-03-24 16:30:36 2632Debug String written: select * from
getvideodata(2::int4, 1::int4, '2006-03-24 16:30:31.40'::timestamp,
1::int4) AS (idvideodate timestamp, mediabinary bytea).
2006-03-24 16:30:36 26
# [EMAIL PROTECTED] / 2006-04-06 12:03:18 -0400:
> On Apr 3, 2006, at 11:23 PM, Chris Browne wrote:
> >Yeah, someone at the office was asking me on the elevator about
> >whether some Post-something was somehow up and coming.
> >
> >In retrospect, I think he was trying to pronounce Postgre, and arri
# [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
> I would like to know if somebody already has a Mac OSX Intel 10.4.5
> pg-Library (for C, C++, Objective C) or knows how to compile it?
What problems did you have building libpq?
Note: I'm not an OSX user.
--
How many Vietnam vets does
# [EMAIL PROTECTED] / 2006-03-29 17:17:48 -0800:
> Hello,
>
> I would like to create a function that lets me to search in a table
> rows according differents parameters.
> I looked in the documentation of postgresql 8.1 about Pl/Perl
> procedures but I didn't found how to cross each row of a table
# [EMAIL PROTECTED] / 2006-04-07 14:31:04 -0700:
> A further question: we are using Debian system. So when we leave the
> 'Address' box
> blank (on the Add Server page of pgAdmin), according to the help file, it
> will go to
> use the default Postgresql socket on the local machine.
> We actual
# [EMAIL PROTECTED] / 2006-04-08 14:04:28 +0200:
> Am 07.04.2006 um 13:50 schrieb User Roman:
> ># [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
> >>I would like to know if somebody already has a Mac OSX Intel 10.4.5
> >>pg-Library (for C, C++, Objective C)
# [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> Basically we've got several different "states" that an item can be in.
> From what I've seen the way many places seem to deal with them is
> something along the lines of making bool values that act as
> switches...
>
> Ex:
> table items:
> item_id
# [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400:
> >
> >>Basically we've got several different "states" that an item can be in.
> >>From what I've seen the way many pla
# [EMAIL PROTECTED] / 2006-06-02 05:18:08 -0700:
> I think I need to explain a bit further.
>
> I tried simply using
>
> update people
> replace(address, 'mailto:','');
>
> but unfortunately that produced a duplicate key error as some of the
> addresses prefixed with 'mailto:' are already presen
# [EMAIL PROTECTED] / 2006-06-05 16:19:19 +1000:
> On 6/5/06, Joe Conway wrote:
> >Chris Velevitch wrote:
> >> But what about my original question?
> >>
> >> "What is the point of the create or replace view command if you
> >> can't change the
> >> column and data types?"
> >
> >-- create t
# [EMAIL PROTECTED] / 2006-06-06 11:58:26 +0300:
> How to force postgres to use index for the following query (I can change the
> query to equivalent if required)
>
> select nimi from klient where lower(nimi) like 'test%'
do you have an index on klient (lower(nimi))?
--
How many Vietnam ve
# [EMAIL PROTECTED] / 2006-06-09 10:12:21 +0200:
> Agent M wrote:
> > If you don't use NULL, then you don't
> > come across 3-valued logic--problem solved.
>
> So was does "SELECT sum(1) FROM dual WHERE false" return?
You stripped this:
> > Some Tutorial D notions really make sense; I would
# kleptog@svana.org / 2006-06-22 09:19:44 +0200:
> On Tue, Jun 20, 2006 at 02:06:19AM -0700, [EMAIL PROTECTED] wrote:
> > Such construction is very slow but when I modify SQL to:
> > OPEN cursor1 FOR SELECT * FROM alias WHERE mask>=alias_out
> > ORDER BY mask LIMIT 100;
> >
> > it works ve
# [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
> OK I know this is an odd question but I'm working on an app that will rely
> more and more on database driven functions, and while the app's source is
> in SVN, and I intend for the source of the SQL scripts to also be there, I
> was wondering..
# [EMAIL PROTECTED] / 2006-07-07 14:08:08 -0600:
> --On July 7, 2006 12:35:53 PM +0000 Roman Neuhauser <[EMAIL PROTECTED]>
> wrote:
>
> ># [EMAIL PROTECTED] / 2006-07-06 22:41:27 -0600:
> >>OK I know this is an odd question but I'm working on an app that will
# [EMAIL PROTECTED] / 2006-07-11 12:04:07 -0400:
> On 6/30/2006 1:07 PM, Merlin Moncure wrote:
>
> >* mysql has a few features here and there which are nice...just to
> >name a few, flush tables with lock, multiple insert, etc
(...)
> The multiple insert stuff is not only non-standard, it al
# [EMAIL PROTECTED] / 2006-07-19 09:50:05 -0400:
> Yesterday I sent two messages to pgsql-general@postgresql.org, and
> neither one posted, as far as I can tell.
>
> "Please explain the gin index" - 7/18/06 10:44 AM EDT
>
> "number of distinct values in tsearch2 gist index" - 7/18/06 1:24 PM EDT
# [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
> Actually Postgres manual of triggers says that in postgres, you can't write
> a trigger in conventional sql. You have to write it in a procedural language
> like C. So wanted some more insight on it.
> ~Jas
Where does it say so? Do you have a
# [EMAIL PROTECTED] / 2006-08-01 02:35:48 -0400:
> On 8/1/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> >
> ># [EMAIL PROTECTED] / 2006-07-31 11:58:49 -0400:
> >> Actually Postgres manual of triggers says that in postgres, you can't
> >write
> >>
# [EMAIL PROTECTED] / 2006-08-01 10:18:45 -0700:
> I read in the documentation that the money type is depreciated. It
> says to use the to_char function and NUMERIC/decimal instead. Why was
> the money type depreciated when it was so useful? How would be the
> best way to use to_char and numeri
# [EMAIL PROTECTED] / 2006-08-02 07:57:55 +0200:
> I'm bothered by listen listening from the end of the transaction in
> stead of the start of the transaction.
Sorry if this isn't what you're after, instead just a question:
Why don't you issue the LISTEN in a separate transaction before
# [EMAIL PROTECTED] / 2006-08-02 10:49:01 -0700:
> On 8/1/06, Reece Hart <[EMAIL PROTECTED]> wrote:
> >
> > Eric Andrews wrote:
> >> I am not much of a schema designer and have a general questoin about
> >> the proper use of the array datatype. In my example, I have
> >> destinations, and destinati
# [EMAIL PROTECTED] / 2006-08-05 19:32:27 +0200:
> I stop the postmaster service and then i copy the directory in an other place.
> Restart the postmaster and then test someting modifications.
> Then i stop the service and restore the saved data directory
> Now the postmaster dont start any more
>
# [EMAIL PROTECTED] / 2006-08-06 11:47:43 +0200:
> the following function is created properly:
> CREATE OR REPLACE FUNCTION insert_into_table_overview(text, chr integer)
> RETURNS void AS '
> DECLARE
> in_tableALIAS FOR $1;
> p RECORD;
> BEGIN
> RAISE NOTICE '
# [EMAIL PROTECTED] / 2006-08-07 22:17:26 -0700:
>
> I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
> I do not have any DUMP or other backups. I want to use this folder instead
> of the newly created DATA folder after new installtion.
>
> I tried replacing the new f
# [EMAIL PROTECTED] / 2006-08-11 10:12:40 -0400:
> I think my Dell Precision 650 has SATA on the motherboard. The boss says
> I can order one drive, so what should I get? How much faster is RAID 0+1
> than a single drive?
You need 4 disks for 0+1 (or 1+0, also called 10).
--
How many Viet
# [EMAIL PROTECTED] / 2006-08-16 11:55:39 -0400:
> Hi,
> Conventionally a trigger would fire a few sql queries on a particular event
> and we have standard code for that.
>
> My requirement is to start a stored procedure or a C function as a trigger
> action.
>
> Is this possible?
Besides th
# [EMAIL PROTECTED] / 2006-08-18 10:00:20 +0200:
> On 8/18/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
> >When the subselect returns
> >NULL for at least one row, you fall into this sort of case.
> >
> >x NOT IN (...) is equivalent to NOT(x IN (...)) which is
> >NOT(x = ANY (...))
> >
> >x = ANY (
# [EMAIL PROTECTED] / 2006-08-19 20:18:53 -0700:
> Installing with yum, Fedora core 5. Get error: "could
> not open file "global/pg_database": No such file or
> directory." The file exists however, in
> /var/lib/pgsql/data/global and contains 3 lines:
> postgres 10793 1663 499 499
> template
# [EMAIL PROTECTED] / 2006-08-21 21:16:14 -0700:
> I'm considering using a UUID as a primary / foreign key for my schema,
> to help ensure portability of data in a multi-master context. Does
> anyone have experience with this?
>
> There's a project on Gborg (pguuid) to create a "native" UUID ty
# [EMAIL PROTECTED] / 2006-08-30 12:22:47 -0400:
> -- Forwarded message --
> From: Chris Hoover <[EMAIL PROTECTED]>
> Date: Aug 30, 2006 12:22 PM
> Subject: How to convert a string to bytea?
> To: "pgsql-admin@postgresql.org"
>
> I am in need of some help. I need to use the encod
# [EMAIL PROTECTED] / 2006-08-30 14:11:11 -0400:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > So I don't think we should do anything about it. It's not really a
> > serious problem.
>
> Actually, what I'd like to see done is to get majordomo to bounce list
> messages containing "unsubscribe"
# [EMAIL PROTECTED] / 2006-08-30 12:32:21 -0500:
> There are good reasons why that is not a feature found in many popular
> email clients. The biggest of which is that if it was people would use
> it all the time and spammers would abuse it as a way to cull current
> email addresses.
IOW g
# [EMAIL PROTECTED] / 2006-08-31 07:35:30 -0700:
> > Ralf Engelschall's OSSP uuid looks very good. Written in C with
> > interfaces into PostgreSQL, PHP and C++ (classes wrapping the C
> > structures and functions).
> >
> > http://www.ossp.org/pkg/lib/uuid/
>
> Can you give a link
# [EMAIL PROTECTED] / 2006-09-01 03:19:03 -0400:
> If that is the case then why does it throw error in one on the insert
> queries in the shared object written in SPI without inserting the row on the
> table on which record is inserted.
>
> Follwing query in the shared object throws an error.
>
>
# [EMAIL PROTECTED] / 2006-09-01 20:13:14 +1000:
> Hey,
>
> I am running PostgreSQL 8.1.4 and I want to create a user from inside a
> function. Is this possible in 8.1?
>
> Ive found quite a few references on google using EXECUTE, but this seems
> relevant to earlier versions, not 8.1.
>
> I hav
Suppose we have table A and table B. When action is performed on table A
(for example INSERT), some action (for example UPDATE) through the trigger
is done on table B.
If user had GRANT permission on both tables - everything is good. But in
that way user can get access to table B directly.
If I
Suppose we have table with indexes, attached triggers, and finnaly alot of
records (more then 100,000). Records are adding continuously.
Once a month you have to do archiving of records. Simple INSERT INTO ARCHIV
followed by DELETE and then VACUUM take alot of time, offen even hang up
sessions. D
Suppose we have table A and table B. When action is performed on table A
(for example INSERT), some action (for example UPDATE) through the trigger
is done on table B.
If user had permission on both tables (GRANT INSERT on table A and GRANT
UPDATE on table B)- everything is good. But in that way
onfirms that I first need to connect as this predefined user, but
doesn't say what that user's password is.
How can I find out the password for user postgres so that I can finally
begin working with this database?
TIA,
--
Mel Roman
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
n internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# CREATE USER mel CREATEDB
test-# \q
bash-2.05b$ exit
exit
[EMAIL PROTECTED] mel]$ psql test
p
out my problem. As you can see from my CREATE USER
command above, I simply forgot to put the semicolon at the end. Doah!
I guess it's been a little while since I've done much SQL. I've since
successfully made myself a user and life is good.
Thanks for eve
lp me?
-
[EMAIL PROTECTED] Roman Volkoff
101 - 149 of 149 matches
Mail list logo
