Is there any way I can override system-defined casts?
Tried
create cast (varchar as timestamptz) with function
user_timestamptz(varchar) ;
and got
ERROR: cast from type pg_catalog.varchar to type timestamptz already exists
DROP CAST does not work:
ERROR: cannot drop cast from
I am new to postgres and I have 4 doubts. 1) I have a performance problem as I am trying to insert around 60 million rows to a table which is partitioned. So first I copied the .csv file which contains data, with COPY command to a temp table which was quick. It took only 15 to 20 minutes. Now I
On Wed, 11 Oct 2006, Bill Eaton wrote:
I just notice that multiple inputs to aggregates are allowed in the
upcoming 8.2 release. This gives me a great incentive to play with
the beta and upgrade from 8.0.
One question remains: how about multiple outputs? Can I have a ROW as
a return value
am Thu, dem 12.10.2006, um 19:39:37 -0400 mailte Tom Lane folgendes:
> I think what you're really wishing for is an error cursor position.
> 8.2 has the infrastructure for this, eg
>
> regression=# create table foo (a int, b int, c int);
> CREATE TABLE
> regression=# select a, b, q from foo;
> ER
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> Postgresql uses three digit version number. i.e. 8.1.4
> What is warrant/constitute a change to the first digit?
There is no policy for that. Check back in the archives for the debates
that led up to renumbering 6.6 as 7.0, and later 7.5 as 8.0
Postgresql uses three digit version number. i.e. 8.1.4
>From my understanding from what I've read on the lists the third digits is
>incremented for bug
fixes. The second digit for incremental features additions.
What is warrant/constitute a change to the first digit?
Regards,
Richard Broer
On Oct 12, 2006, at 7:39 PM, Tom Lane wrote:
That's not necessarily all that much help, if you've got so many FK
constraints in your command that you don't know exactly where to look.
I think what you're really wishing for is an error cursor position.
8.2 has the infrastructure for this, eg
re
After a long battle with technology, [EMAIL PROTECTED] ("Jim C. Nasby"), an
earthling, wrote:
> But you can actually write good code that will run on multiple
> databases if you're willing to write the tools to allow you to do it.
There's an argument out there that we don't actually have relation
On Oct 13, 2006, at 01:36 , Robert L Mathews wrote:
Michelle Konzack <[EMAIL PROTECTED]> wrote:
I do this already but have problems since I have
stored arround 130 million files on a server...
> ...
>
MD5 hashes are 32 Bytes long, maybe they change
it to 64 Bytes?
I have already over 2000 co
Michelle Konzack <[EMAIL PROTECTED]> wrote:
I do this already but have problems since I have
stored arround 130 million files on a server...
> ...
>
MD5 hashes are 32 Bytes long, maybe they change
it to 64 Bytes?
I have already over 2000 collisions and checked
it, that the files are NOT the
Jonathan Vanasco <[EMAIL PROTECTED]> writes:
> Yes, I know that part. The error message is bad though, because it
> doesn't tell me exactly where the error is.
> I got as an error
> ERROR: column "id" referenced in foreign key constraint does not exist
> I should have gotten something l
Hello,I am trying to loop through a table to update one columncreate or replace function foo() returns integer as $$declare rec RECORD; row integer := 0;begin for rec in select * from table loop update rec set recordid = row; row++; end loop; return 0;end;$$ language pl
On Oct 12, 2006, at 3:44 PM, A. Kretschmer wrote:
Can you show us your SQL? The message is clear: you create a new table
with a foreign key to an other table that doesn't exist. An example:
Yes, I know that part. The error message is bad though, because it
doesn't tell me exactly where the
On Thu, 2006-10-12 at 16:12 -0400, Germán Hüttemann Arza wrote:
> I am writing triggers procedures in PL/pgSQL and I need to handle some
> errors inside the procedures.
> Specifically, I am doing a CAST(char AS integer) and I want to know
> when the char isn't a digit. How can I get do that?
>
>
On Thu, 2006-10-12 at 15:22 -0500, Tony Caduto wrote:
> Germán Hüttemann Arza wrote:
> > I am writing triggers procedures in PL/pgSQL and I need to handle some
> > errors inside the procedures.
> > Specifically, I am doing a CAST(char AS integer) and I want to know
> > when the char isn't a digit
On Thu, 2006-10-12 at 17:14, Jim C. Nasby wrote:
> On Thu, Oct 12, 2006 at 03:31:50PM -0500, Scott Marlowe wrote:
> > While all the talk of a hinting system over in hackers and perform is
> > good, and I have a few queries that could live with a simple hint system
> > pop up now and again, I keep t
brian wrote:
> I changed my postgresql.conf to have:
>
> log_statement = mod
>
> It appears to be working, though not logging *all* INSERTs. For
> instance, I have a PHP class that inserts into two tables in a
> transaction. The log shows the first, but not the second. Has anyone
> seen this b
On Thu, Oct 12, 2006 at 03:31:50PM -0500, Scott Marlowe wrote:
> While all the talk of a hinting system over in hackers and perform is
> good, and I have a few queries that could live with a simple hint system
> pop up now and again, I keep thinking that a query planner that learns
> from its mista
Merlin Moncure wrote:
On 10/12/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai.
wrote:
> When I start PostgreSQL service, the below error message is
displayed and
> finally service didn't started.
>
> The PostgreSQL Database Serv
Wei Weng <[EMAIL PROTECTED]> writes:
> (As you can see, all 3 strings are different)
> Why the difference? Is there something missing ??
Well, the password is actually supposed to be 'md5'||md5(passwd||user),
thus:
regression=# select md5('test_passwd' || 'test_user');
md5
---
2006/10/12, Martijn van Oosterhout :
On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
> (there are one of locale: lv_LV.utf8, for Latvian language). But if I
> want do "lower", then with standard latin
On 10/12/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:
> When I start PostgreSQL service, the below error message is displayed and
> finally service didn't started.
>
> The PostgreSQL Database Server 8.0 service of a local
I think I have found out something suspicious.
I used tcpdump to monitor the traffic to and from port 5432, and it
seems that the password the client on A sends out to the postmaster on B
is
"md54570471eccef21ae3c6e43033d8d2f66"
While the MD5-ed password stored in system catalog (pg_shadow) is
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:
> When I start PostgreSQL service, the below error message is displayed and
> finally service didn't started.
>
> The PostgreSQL Database Server 8.0 service of a local computer cannot begin.
>
>
> Error 1069: Service w
On Wed, Oct 11, 2006 at 11:13:21AM +0700, Luki Rustianto wrote:
> ... so what if the database size is above 20 GB, do we have to do
> pg_dump each at periodics time to get reliable backup?
No, you can also use Point In Time Recovery (PITR).
--
Jim Nasby
While all the talk of a hinting system over in hackers and perform is
good, and I have a few queries that could live with a simple hint system
pop up now and again, I keep thinking that a query planner that learns
from its mistakes over time is far more desirable.
Is it reasonable or possible for
On Thu, Oct 12, 2006 at 07:40:42PM +0200, Tim Tassonis wrote:
> > I have yet to see a good application that supports "database
> independence".
>
> If you are talking about high- end applications (big databases with lot
> of transactions), you're of course right. However, there are a lot of
> a
Germán Hüttemann Arza wrote:
I am writing triggers procedures in PL/pgSQL and I need to handle some
errors inside the procedures.
Specifically, I am doing a CAST(char AS integer) and I want to know
when the char isn't a digit. How can I get do that?
Just off the top of my head I would say you
On Thu, 2006-10-12 at 15:50 -0400, Tom Lane wrote:
> Wei Weng <[EMAIL PROTECTED]> writes:
> > I have the following lines in my pg_hba.conf file.
> > hostall all 192.168.1.180 255.255.255.1md5
>
> Not relevant to your immediate problem, but: you almost certainly
> want 255
> > All of them ... ? At least, I'm not aware of any that PostgreSQL
> > *doesn't* support ...
>
> Win32 is not supported on 64bit IIRC.
Actually, win32 works just fine on 64bit. Meaning that 32-bit PostgreSQL
runs on x64 versions of Windows.
Win64, however, is not supported. That would be a 64
On 12/10/06 21:14, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Marc G. Fournier wrote:
>>
>> All of them ... ? At least, I'm not aware of any that PostgreSQL *doesn't*
>> support ...
>
> Win32 is not supported on 64bit IIRC.
Should be no problem with the win32 build on 64 bit Windows. Wh
Marc G. Fournier wrote:
>
> All of them ... ? At least, I'm not aware of any that PostgreSQL *doesn't*
> support ...
Win32 is not supported on 64bit IIRC.
Joshua D. Drake
>
> --On Tuesday, October 10, 2006 15:56:01 +0300 Stanislaw Tristan
> <[EMAIL PROTECTED]> wrote:
>
>>> Please, provide
I am writing triggers procedures in PL/pgSQL and I need to handle some errors inside the procedures. Specifically, I am doing a CAST(char AS integer) and I want to know when the char isn't a digit. How can I get do that?
Regards,-- Germán Hüttemann
am Thu, dem 12.10.2006, um 15:27:08 -0400 mailte Jonathan Vanasco folgendes:
>
> I got a really bad error message in postgres on a CREATE TABLE in 8.1.0:
>
> ERROR: column "id" referenced in foreign key constraint does not
> exist
>
> That seems odd-- I mean, I know I obviously ma
Wei Weng <[EMAIL PROTECTED]> writes:
> I have the following lines in my pg_hba.conf file.
> hostall all 192.168.1.180 255.255.255.1md5
Not relevant to your immediate problem, but: you almost certainly
want 255.255.255.255 as the netmask here.
> psql -h 192.168.1.155 -U t
On Thu, 2006-10-12 at 15:38 -0400, Wei Weng wrote:
> I am trying to connect to machine A (192.168.1.155) from a different
> machine B (192.168.1.180), with password transmitted as a MD5 string.
>
>
> I have the following lines in my pg_hba.conf file.
>
> hostall all 192.168.1.180
I am trying to connect to machine A (192.168.1.155) from a different
machine B (192.168.1.180), with password transmitted as a MD5 string.
I have the following lines in my pg_hba.conf file.
hostall all 192.168.1.180 255.255.255.1md5
I created a database user "test_user
I got a really bad error message in postgres on a CREATE TABLE in 8.1.0:
ERROR: column "id" referenced in foreign key constraint does not exist
That seems odd-- I mean, I know I obviously made an error. I'm just
used to more detailed errors.
I didn't see anything in the changelogs
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
All of them ... ? At least, I'm not aware of any that PostgreSQL *doesn't*
support ...
- --On Tuesday, October 10, 2006 15:56:01 +0300 Stanislaw Tristan
<[EMAIL PROTECTED]> wrote:
> Please, provide a list of OS in which PostgreSQL have a native 6
I changed my postgresql.conf to have:
log_statement = mod
It appears to be working, though not logging *all* INSERTs. For
instance, I have a PHP class that inserts into two tables in a
transaction. The log shows the first, but not the second. Has anyone
seen this behaviour?
test=# show log
"Karen Hill" <[EMAIL PROTECTED]> writes:
>> Cool. Quick question, how does one go about noting the rowcount?
>> Using the rowcount in get diagnostics or something else?
> A "MOVE FORWARD ALL FROM cur;" statement returns "MOVE x". Where x is
> the number moved. The result seems to be of a NOTICE
Karen Hill wrote:
> Tom Lane wrote:
> > "Karen Hill" <[EMAIL PROTECTED]> writes:
> > > -- Is there a way to know the total number of rows the cursor is
> > > capable of traversing without using --count?
> >
> > If you want an accurate count, the only way is to traverse the cursor.
> > Consider usin
Joshua D. Drake wrote:
Well, that is hardly surprising. What exactly is your point?
If you want to write portable software, you usually stay with generally
available, standardized features or API's, be it "database independent",
"platform independent", you name it. You certainly don't go for
use
In response to Michelle Konzack <[EMAIL PROTECTED]>:
> Am 2006-10-05 21:22:04, schrieb Gregory S. Williamson:
>
> > a sufficiently large hash (MD5 for instance). Of course, there's
>
> I do this already but have problems since I have
> stored arround 130 million files on a server...
>
> > time
On Thu, Oct 12, 2006 at 12:18:48PM +0300, Peter wrote:
> Is there any way I can override system-defined casts?
>
> Tried
>
> create cast (varchar as timestamptz) with function
> user_timestamptz(varchar) ;
>
> and got
>
> ERROR: cast from type pg_catalog.varchar to type timestamptz already ex
Am 2006-10-05 21:22:04, schrieb Gregory S. Williamson:
> a sufficiently large hash (MD5 for instance). Of course, there's
I do this already but have problems since I have
stored arround 130 million files on a server...
> time to create the hash which might be an issue in a high volume
> system.
1) Make sure that your browser is set to display full errors, and not
"Friendly HTTP Error Messages" - that should allow you to see where and what
is breaking.
2) Your ASP code is referencing rcursor, but that construct is strictly
within the SQL and not visible to scripting language. Try usi
On Thu, Oct 12, 2006 at 10:34:30AM -0400, Tom Lane wrote:
> catalogs. I can only recall people ever asking for this feature in
> connection with the user/group catalogs, so covering those might be
> enough in practice; that'd certainly be lots less invasive than trying
> to make it work everywhere
Resending since it definitively seems it has been lost in outer spaces.
Sorry for duplicates if any.
On Sun, 8 Oct 2006 14:09:53 +0200
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 06, 2006 at 11:09:29PM +0200, Ivan Sergio Borgonovo
> wrote:
>
> > Is there any good documentation, exam
Martijn van Oosterhout writes:
> On Wed, Oct 11, 2006 at 08:56:23PM +0200, Rafal Pietrak wrote:
>> Are there any plans for anything like that (referencing keys in system
>> tables from public schemas)?
> Not really. The primary objection is that every lookup in the backend
> on the system catalog
Rob Richardson wrote:
Greetings!
I recently joined a company that uses a fairly small PostGres database.
I have never used PostGres before, but I am familiar with (but not
expert in) SQL Server. The PostGres database has 90 tables (including
Welcome.
the one I just added). When the data
> The PostGres
> database has 90 tables (including the one I just added).
[...]
> I would like to write a function that would add a
> column to a table, populate it with the number 1 to n (where
> n is the number of rows in the table), make that c
Greetings!
I recently joined a company that uses a fairly small
PostGres database. I have never used PostGres before, but I am familiar
with (but not expert in) SQL Server. The PostGres database has 90 tables
(including the one I just added). When the database was originally
develope
I have a postgresql function defined as follows ...
DECLARE int_userid ALIAS FOR $1;
BEGIN OPEN $2 FOR
SELECT DISTINCT
"users"."userloginid",
"roles"."rolelike"
FROM
"roles"
INNER JOIN "userpreferences" ON "roles"."roleid" =
"userpreferences"."roleid"
INNER JOIN "users" ON "use
> Used to run a time reporting system on a 3b2
> 400, 4MB Ram, WE32100 10MHz processor, 1.1 MIPS.
You had zeroes? We had to use the letter "O"!
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
---(end of broadcast)--
On 10/12/06, Marco Serantoni <[EMAIL PROTECTED]> wrote:
>> I'm evaluating of use postgresql but for local law requirements is
>> needed for the access of some kind of data (sensitive) a log of the
>> accesses (Auditing) is a feature available in many databases but i've
>> seen that lacks in Postg
installation:
make && make install
upgrade issue is tricky. their is a lower burden of backwards
compatibility than on in-core features. for example, some of contrib
was gpl and is getting moved out/changed. however, the more popular
modules, like tsearch are very well supported. I haven't us
On Thu, Oct 12, 2006 at 12:38:08PM +0200, Rafal Pietrak wrote:
> My particular need was to have the ability to block the account until
> its password is changed. Which I believe might (at certain point) come
> into the main sources. But other applicatoins may have unforseen
> requirements - It woul
Heikki Linnakangas a ecrit le 12/10/2006 12:43:
Guillaume Lelarge wrote:
I've tried to work on the first one, the ISO day field. My patch is
attached and is against CVS HEAD. It only takes care of the code,
nothing is done for documentation matter. It works with me :
I haven't been following
Guillaume Lelarge wrote:
I've tried to work on the first one, the ISO day field. My patch is
attached and is against CVS HEAD. It only takes care of the code,
nothing is done for documentation matter. It works with me :
I haven't been following this thread, but I just wanted to point out
that
On Thu, 2006-10-12 at 11:47 +0200, Martijn van Oosterhout wrote:
> What may have a better chance is assigning triggers to commands (like ON
> CREATE USER) which trigger on specific situations. No-one serious
> considered implementing this though, at it's unclear what the use-case
> would be anyway.
Peter Eisentraut a ecrit le 07/10/2006 09:01:
Brendan Jurd wrote:
* add an ISO day format pattern to to_char() called 'ID', which
starts at Monday = 1, and
* add an ISO year field to extract() called 'isoyear'?
That seems reasonable. Do you volunteer?
I've tried to work on the first one,
On Tue, Oct 10, 2006 at 03:56:01PM +0300, Stanislaw Tristan wrote:
> Please, provide a list of OS in which PostgreSQL have a native 64bit
> support.
Every 64-bit OS I've heard of is listed in the buildfarm.
http://www.pgbuildfarm.org/cgi-bin/show_members.pl
I think the listed of 64-bit platform
On Wed, 11 Oct 2006, Bill Eaton wrote:
I just notice that multiple inputs to aggregates are allowed in the upcoming
8.2 release. This gives me a great incentive to play with the beta and
upgrade from 8.0.
One question remains: how about multiple outputs? Can I have a ROW as a
return value
On Wed, Oct 11, 2006 at 08:56:23PM +0200, Rafal Pietrak wrote:
> Apparently there is also no way to "foreign key reference" those, even
> without installing any on-delete actions/triggers.
>
> Pity.
>
> Are there any plans for anything like that (referencing keys in system
> tables from public sc
Is there any way I can override system-defined casts?
Tried
create cast (varchar as timestamptz) with function
user_timestamptz(varchar) ;
and got
ERROR: cast from type pg_catalog.varchar to type timestamptz already exists
DROP CAST does not work:
ERROR: cannot drop cast from character v
Not necessarily. Last I heard, MySQL ships with multiple config files,
ie: small, medium and large. So by choosing one of those you're
effectively tuning MySQL as well.
Hmm, wouldn't it be a good idea to provide something similar?
I think an initdb could have an additional flag, like "--tune-fo
On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote:
> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4,
> (there are one of locale: lv_LV.utf8, for Latvian language). But if I
> want do "lower", then with standard latin symbols all is ok, but with
> others
68 matches
Mail list logo