Jonel,
I have initialized a new cluster in the installation (you did not),
but that should not have mattered, should it?
Best Regards,
Otto
2006/1/15, Jonel Rienton <[EMAIL PROTECTED]>:
> Hi,
>
> I was just doing the same thing this morning, well somewhat the same;
> anyways, what I did was
>
>
On Fri, Jan 13, 2006 at 09:53:29AM -0800, Cyphos wrote:
> I get an error that the column myLocationID doesn't exist. I'm sure
> it's something simple, but I can't figure it out.
Not all procedural languages support named arguments. Apparently
SQL functions don't, so use $1, $2, etc.
http://www.p
On Jan 14, 2006, at 2:46 PM, [EMAIL PROTECTED] wrote:
I'm probably going to connect Drupal to mysql and play some more.
If we
end up using it I'm leaning toward converting the ecommerce module
table
definition file from mysql to postgreSQL, I'll cross that bridge
when we
come to it.
In
On Saturday 14 January 2006 14:06, Andrew - Supernews wrote:
> On 2006-01-14, Robert Paulsen <[EMAIL PROTECTED]> wrote:
> > Here is my query so far:
> >
> > SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]'
> > ORDER BY state ASC LIMIT 1.
> >
> > This works as expected. My problem
Hi,
I have tried two db designs and both can work but I wonder which one
the db gurus would go with. This is a general db design question
that has cropped up in a few situation. Here is the example I've been
working on...
In an online store, categories and images have a many-to-many relationship
On Saturday 14 January 2006 14:10, Michael Fuhr wrote:
> On Sat, Jan 14, 2006 at 01:38:52PM -0600, Robert Paulsen wrote:
> > SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]'
> > ORDER BY state ASC LIMIT 1.
> >
> > This works as expected. My problem is that I am relying on the colla
Hi,
I was just doing the same thing this morning, well somewhat the same;
anyways, what I did was
1. uninstall Postgres, and run the installation again(don't use the
upgrade.bat), same major version.
2. on the initial installation window, choose a new data directory by
clicking on browse, point
On Jan 13, 2006, at 23:27 , Shawn Garbett wrote:
In oracle there is the idea of group by functions,
i.e. cube and rollup that are very useful for
reporting. I've not found an equivalent in PostgreSQL.
What's the status of this? Can I write my own?
As far as I know, CUBE and ROLLUP haven't bee
Martijn van Oosterhout wrote:
> On Thu, Jan 12, 2006 at 08:51:44PM -0800, rlee0001 wrote:
> > 1.
> > Two new special variables in triggers functions (TG_STATEMENT and
> > TG_EFFECTIVE_STATEMENT) which returns the statement that triggered the
> > trigger.
>
> Which would that be? The statement that
Hi guys,
I'm very new to PostgresSQL, coming from MS SQL. I'm trying to write a
function that will select a row from a location:
CREATE FUNCTION SelectLocation(IN "myLocationID" int4) RETURNS
"Location"
LANGUAGE 'sql' AS
$BODY$
SELECT
"LocationID",
"Name",
"PhoneNumber",
I think I've hit a bug here when upgrading my Windows installation from
version 8.1.1 to 8.1.2 using the upgrade.bat file included in the
installation kit. When it comes to the part of registering the service, it
keeps on saying can't register because I don't have enough permission, I'm
an admistra
Hi guys,
I have some questions about postgres and would be glad if you could
help me...
Here ist what I am planning to do:
Build a database with 1 Billion (10^9) rows describing geometric
properties:
create table steric_descriptor(
distance0 bit(4),
distance1 bit(4,
distance2 bit(4,
distance3 bit(
Me and a friend are testing some operations for a search application in
PostgreSQL. In version 8.1 my friend tried to copy the result of a join
into another table, about 45.000.000 (small) records. This is the
result:
testsearch=> insert into t_documentword2 (SELECT document_id,
t_word2.id,
freque
Buen día.- Espero me puedan ayudar a resolver mi problema, es el siguiente: En una base de datos de PostgreSQL tengo miles de registros y necesito pasar estos datos a otra (tambien en postgre) pero con algunos cambios en algunas de sus tablas. Mil Gracias Espero su pronta respuesta Yurimar
In oracle there is the idea of group by functions,
i.e. cube and rollup that are very useful for
reporting. I've not found an equivalent in PostgreSQL.
What's the status of this? Can I write my own?
Connect by Prior is a recursive query function for
navigating tree data structures in oracle, i.e A
On Sat, Jan 14, 2006 at 01:38:52PM -0600, Robert Paulsen wrote:
>
> SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]'
> ORDER BY state ASC LIMIT 1.
>
> This works as expected. My problem is that I am relying on the collating
> sequence of the letters a-z and the desirability
On 2006-01-14, Robert Paulsen <[EMAIL PROTECTED]> wrote:
> Here is my query so far:
>
> SELECT foo, bar, baz, FROM my_table WHERE state ~ '[abc]'
> ORDER BY state ASC LIMIT 1.
>
> This works as expected. My problem is that I am relying on the collating
> sequence of the letters a-z and
All.
After reading about the Drupal CMS using mysql *OR* postgreSQL I've been
experimenting with it, setting it up with postgreSQL and playing.
Another fellow and I are considering using it more, but when we loaded the
ecommerce module we could only find a table definition file for
mysql.
Hi,
I need to query a database for a record with the "best" value in a
one-character field. The field is named "state" and I need a record with a
state of 'a', 'b', or 'c'. There may be more than one matching record but I
want the "best" one where "best" is defined as state 'a', or if there are
I think I've hit a bug here when upgrading my Windows installation from
version 8.1.1 to 8.1.2 using the upgrade.bat file included in the
installation kit. When it comes to the part of registering the service, it
keeps on saying can't register because I don't have enough permission, I'm
an admist
Thank you :)
> -Original Message-
> From: Magnus Hagander [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 14, 2006 6:16 PM
> To: Gevik
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Unregister Windows Service pg_ctl error
>
> > > You need administrative privileges to unre
> > You need administrative privileges to unregister a service.
> Can't run
> > it as user postgres.
>
> I did the same under "Administrator" but then I get an access
> violation error like:
>
> Unhandled exception at 0x77c478c0 in pg_ctl.exe: 0xC005:
> Access violation reading location 0
So is it still advisable not to store it in a string format like
'jarraa, mooreg3, flowerpower' [read my comments below please]
awaiting some feedback.
-assad
On 1/12/06, Assad Jarrahian <[EMAIL PROTECTED]> wrote:
> Alban and Tino,
> More explanations lie below.
> A document contains to field,
On 2006-01-13, Rudolph <[EMAIL PROTECTED]> wrote:
> Me and a friend are testing some operations for a search application in
> PostgreSQL. In version 8.1 my friend tried to copy the result of a join
> into another table, about 45.000.000 (small) records. This is the
> result:
Do you have any constr
Hello,
Ok. I did not set any security on the machine. Only I have access to
it. Now I have done this:
0. Registry is modified (yesterday)
1. Restart today
2. Modify registry to the old value
3. Start PostgreSQL -> pg_ctl and postmaster are running (they are in
the task list), but no postgres
4. "
Ok, two things:
First, when using this method, yo uhave to reboot after editing the registry.
If you didn't do that, then that's your problem. Sorry, forgot to mention that.
If not, then looking at permissions as Rodrigo suggested is the next step.
Second, there is of course a nicer way of doin
> I just did a test to see what comes up when I typed
> "replication" in the search box at postgresql.org. Got a 503
> error. We really need to work on that. Bad enough we don't
> use Postgres to do the searching.
Yes we do. We certainly don't back aspseek with mysql... (No, we don't
use the st
27 matches
Mail list logo
