Hello all,
I am interested in setting up an index with a date_part as
part of it… From what I have been able to find I need to write a function
that will return the date_part that I want I have tried
CREATE FUNCTION month_idxable(date) returns date AS 'SELECT date_part('month', date)
f
Hello,
I am trying build and install 8.0 on RedHat 9.0 the
configure runs with out a problem and when I type make I get:
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wendif-labels -fno-strict-aliasing zic.o ialloc.o scheck.o localtime.o
-L../../src/port -Wl,-rpath,/usr/local/pg
Is is
possible to use replace along with regular _expression_ to remove any and all
punctuation from a field?
If so how?
I have tried:
SELECT replace ('Brian\'s Co, INC.', 'Y*([.]',''),SUBSTRING('XY1234Z',
'Y*([0-9]{1,3})');
The second
field substring works with out a problem
] replace() and Regular Expressions
Importance: High
am 31.10.2005, um 13:11:20 -0500 mailte DEV folgendes:
> Is is possible to use replace along with regular expression to remove any
> and all punctuation from a field?
Which version?
PG 8.1 have a function 'regex_replace'
I have seen several posts pertaining to the "overhead" difference in storing
in a db table versus the file system. What is this difference?
I also think the decision as store in a db table or file system is looking
at how the files will be accessed. If all the clients are on the same
network as
Hello all,
I have
user information in a table that I want to use to add users to the user roles
tables that are part of postgresql. My question is this: the passwords in my
user table are in there as a text file with the data being encrypted using the
crypt function, is there a way
Okay but the issue I have is that I have the passwords already generated and
in crypt() format and would love to just use them if at all possible?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Davis
Sent: Tuesday, October 17, 2006 12:36 PM
To: DEV
Hello friends,
we have some strange problem, postmaster (pg 8.1 /win32)
suddenly shutdown because of "no reason".
The interesting thing is that this occurs always at
almost same time (between 0.00 and 0.30h), in that time period is
running system backup (Veristas backupexec agent) - starts at
Hello all,
I have a database system in which i truncate a main table to update the
information. I would like to setup some foriegn keys referencing
back to that table but am concerned as to how the truncating of the
Parent table will effect the keys? Would all I have to do is insure
that I vacuu
Hello all.
I am
trying to build postgres from the source on a WINXP system. I am using MSVC++.Net
and I use the link with it to get to the command prompt. After I do that I run
vcvars32.bat and the nmake /f win32.mak and I get:
C:\Dev\postgresql-8.1.4\src>nmake
/f win32.
Shoaib,
That looks like it worked thank you!
Bruce,
I am using the following compliler:
C:\Dev\postgresql-8.1.4\src\interfaces\libpq\Release>nmake --help
Microsoft (R) Program Maintenance Utility Version 7.10.3077
Copyright (C) Microsoft Corporation. All rights reserved.
Wh
ow to make 'DEBUG'
Stop.
So what am I
missing. I see in the mak file for debug but I can not see how to enable that?
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shoaib Mir
Sent: Wednesday, August 09, 2006
3:30 PM
To: DEV
Cc: pgsql-general@postgresql.
Hello all,
Okay I
have gotten the Win32 to “build” with out any errors but I am
working with libpqxx and it says I need th comerr32.dll and krb5_32.dll from
the src\bin of postgresql and they are not there?
What do I
need to do?
Hello all,
I have been working with joins and having alot of success up until now.
What I have is this:
SELECT a.merno
,g.mcmid
FROM (
total AS a LEFT JOIN mcmid AS g ON (g.merno=a.merno))
WHERE a.repno='11'
AND a.month='2003-11-01'
AND g.month='2003-11-01'
ORDER BY merno
Currently it
Hello all,
I am trying to get a total number of rows returned form a
query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the
group by.
I need the count of the rows returned!
Any way to do this?
Brian C. Doyle
Director, In
10/14/2004, Dev wrote:
Hello all,
I am trying to get a total number of rows returned form a
query.
SELECT count(this) from table group by this
Currently it is returning x rows with a count of each of the group
by.
I need the count of the rows returned!
Any way to do this?
Brian C. Doyle
Bruce Momjian said:
> My guess is that Nusphere wants to create a MySQL community like ours.
Not sure you can "create" something like the PG community. I have to say that this is
one of the most informed and overall polite (you can tell I'm British can't you :-)
online communities I'm involve
On 3/6/01, 12:44:07 AM, Boulat Khakimov <[EMAIL PROTECTED]> wrote
regarding [GENERAL] List of all system tables.:
> Hi,
> How do I get the list of all system tables starting with "pg_"
> Regards,
> Boulat Khakimov
Try \dS from the psql prompt. If you want to see how it does it try
starting p
On 3/6/01, 8:55:05 AM, Frank Nijenhuis <[EMAIL PROTECTED]> wrote regarding
[GENERAL] remote dumping of databases:
[snip]
> Now I want them to be able to dump their own database. And when I use the
> command without piping the result to a file everything works.
> (pg_dump -h .
> You get the user
On 3/6/01, 12:59:40 AM, Fernando "P." Schapachnik
<[EMAIL PROTECTED]> wrote regarding [GENERAL] interval question:
> Hello:
> Maybe somebody on the list can give me a hand with this. I
> have:
> id serial,
> start time,
> duration time
Surely "duration" should be of type interval.
Also -
Am I doing something stupid trying to escape an underscore in LIKE?
Version 7.1b3
richardh=> select * from foo;
a
-
a_c
a_d
abc
(3 rows)
richardh=> select * from foo where a like 'a_c';
a
-
a_c
abc
(2 rows)
richardh=> select * from foo where a like 'a\_c';
a
-
a_c
abc
Apologies if this appears twice - testing a new email client.
There was some discussion the other day about a desire for int8
sequences. This simulates that by providing a large base value combined
with an int4 sequence. You will need to reset the big sequence to a new
base value every once in
Hello Experts,
I want to have my postgreSQL database to only execute SQLs and avoid
execution of perl and python script executions.
Can you please suggest ways to achieve this?
Regards...
On Tue, Jul 26, 2016 at 6:35 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> The way to go about prohibiting their usage altogether is specific to your
> installation method. But by default those languages are not installed into
> newly created databases and only a superuser can "CRE
On Tue, Jul 26, 2016 at 6:29 PM, Sameer Kumar
wrote:
You mean you don't want any routines/functions written in Pl/perl or
> PL/pythin to get executed?
>
> If that is what you are looking for them simply drop the extension for
> these languages or deny privilege to users/public on these extensions
On Tue, Jul 26, 2016 at 6:54 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> Superuser: yes (specifically I'm thinking the COPY FROM PROGRAM command,
> but also C language functions)
> Ordinary user: not that I can think of.
>
OK, is there a way to restrict usage of COPY FROM PROGRA
On Tue, Jul 26, 2016 at 6:59 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> Typically this means that given user only having psql, or some other
> backend protocol only, connect to the database are they able to execute
> arbitrary commands as the user running the PostgreSQL process
On Tue, Jul 26, 2016 at 7:49 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> For superusers, no. You'd have to protect the system using external
> tools to limit what areas and commands the postgres (or whatever PostgreSQL
> runs as) user can access.
>
Thanks David for the informa
On Tue, Jul 26, 2016 at 7:53 PM, John McKown
wrote:
> I agree. From my reading at:
> https://www.postgresql.org/docs/9.5/static/sql-copy.html the COPY FROM
> PROGRAM is only available to a PostgreSQL user who is database superuser.
> That, sort of, implies to me that said user is trusted not to d
Hello,
I want to upgrade my database from version 9.3.4 to 9.3.10.
For this task, do I need to upgrade database using pg_upgrade utility?
http://www.postgresql.org/docs/9.3/static/pgupgrade.html
>From the details it looks like for minor version upgrade pg_upgrade utility
is not required.
"pg_u
On Tue, Jan 12, 2016 at 3:25 PM, John R Pierce wrote:
> On 1/12/2016 1:28 AM, Dev Kumkar wrote:
>
>
> I want to upgrade my database from version 9.3.4 to 9.3.10.
>
> For this task, do I need to upgrade database using pg_upgrade utility?
> <http://www.postgresql.org/docs/9
I have some php code that will be pulling in a file via ftp. This file will
contain 20,000+ records that I then need to pump into the postgres db.
These records will represent a subset of the records in a certain table. I
basically need an efficient way to pump these rows into the table, replacin
h two
rows, one with is_new of 1 and some with 0. Just don't know if this would
be best.
On Dec 26, 2007 3:13 PM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> On Wed, 26 Dec 2007 20:48:27 +0100
> Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
>
> > blackwat
Hello all,
I'm pulling in a csv file nightly and need to pump in into my db. My plan
is to pump it into a temp table and then to an update or insert from the
temp table to the real table. I'm having an issue, however, with the copy.
Here is a my syntax.
COPY cars FROM 'cars04.txt'
On Wed, Apr 16, 2014 at 9:08 PM, Dev Kumkar wrote:
> On Wed, Apr 16, 2014 at 7:50 PM, Stephen Frost wrote:
>
>> * Dev Kumkar (devdas.kum...@gmail.com) wrote:
>> > I just downloaded the latest binaries from EnterpriseDB and when checked
>> > with libssl.so.1.0.0 can
On Thu, Jun 5, 2014 at 11:03 PM, Magnus Hagander
wrote:
> Hi!
>
> The guys at EnterpriseDB are busy building new installers as we speak, I
> would expect them to be out tomorrow or so.
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
>
Thanks for
Hello,
I want to change the timezone to Europe/Moscow. Moscow timezone is changing
from +4 to +3
On the box, I have changed the timezone to MSK+3.
>From the db side I have modified the following files:
1)postgresql.conf
timezone = 'Europe/Moscow'
2)pgsql/share/postgresql/time
On Wed, Sep 10, 2014 at 8:43 PM, Tom Lane wrote:
> You'd want to get a new version of the IANA timezone database files for
> that. Depending on what packaging you're using, this might be an
> operating-system update not a Postgres update. If you are relying
> on the Postgres copies, you'd have
On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver
wrote:
>
> What OS and what packaging?
>
> For both windows-64-bit and Linux-64-bit.
PostgreSQL version - 9.3.4
I believe the file "pgsql/share/postgresql/timezone/Europe/Moscow" will
require changes.
As the above changes will then be reflected in t
On Tue, Sep 16, 2014 at 6:16 PM, Dev Kumkar wrote:
> On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver
> wrote:
>
>>
>> What OS and what packaging?
>>
>> For both windows-64-bit and Linux-64-bit.
> PostgreSQL version - 9.3.4
>
> I believe the file &quo
Hello,
On one my machine the pg_multixact directory size has grown up to 5 GB and
am not sure how to clean up this directory.
>From the storage-file-layout this directory contains multitransaction
status data.
pg_multixactSubdirectory containing multitransaction status data (used for
shared row l
On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver
wrote:
>
> http://www.postgresql.org/docs/9.3/static/routine-
> vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND
>
> Might also want to take a look at pg_stat_activity to see what queries
> maybe hanging up:
>
>
> http://www.postgresql.org/docs/9.3/sta
On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund
wrote:
> On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote:
> > On one my machine the pg_multixact directory size has grown up to 5 GB
> and
> > am not sure how to clean up this directory.
>
> Which version of postgres are
On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver
wrote:
> So you will need to determine what method you binaries use. If they are
> using the system timezone data, you will need to update that.
Thanks!
Just a hack here, how about copying
"pgsql/share/postgresql/timezone/Etc/GMT-3" as
"pgsql/shar
On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar wrote:
> Thanks, yes have been looking into pg_stat_activity table and somehow the
> standard queries are hanging.
> Not sure if this is because the database response has become very slow.
>
Would having a huge pg_multixact directory have
On Wed, Sep 17, 2014 at 8:52 PM, Adrian Klaver
wrote:
>
> I am not that versed in the timezone handling to make a definitive
> statement. I would say it should work until you upgrade. At that point the
> new Moscow timezone should be correct and the change will not matter. I
> would verify on the
On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane wrote:
> The next set of minor releases, whenever those are (and no, there's
> no schedule).
>
I hope the binaries archive containing ""pgsql/share/postgresql/
timezone/Europe/Moscow" uploaded at
http://www.enterprisedb.com/products-services-training/pg
On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver
wrote:
> On 09/17/2014 12:26 PM, Dev Kumkar wrote:
>
>> I hope the binaries archive containing ""pgsql/share/postgresql/
>> timezone/Europe/Moscow" uploaded at
>> http://www.enterprisedb.com/products-services-
On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar wrote:
> On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver
> wrote:
>
>>
>> http://www.postgresql.org/docs/9.3/static/routine-
>> vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND
>>
>
Looked into these details. Can the
On Thu, Sep 18, 2014 at 2:41 AM, Adrian Klaver
wrote:
>
> Aaah, hit enter too soon. Also see the other changes under Changes that
> apply to multixact in 9.3.5
Thanks for sharing same. Found this one interesting "Truncate pg_multixact
during checkpoints, not during VACUUM (Álvaro Herrera)" and
On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund
wrote:
> I don't think that's relevant for you.
>
> Did you upgrade the database using pg_upgrade?
>
That's correct! No, there is no upgrade here.
> Can you show pg_controldata output and the output of 'SELECT oid,
> datname, relfrozenxid, age(rel
On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar wrote:
> On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund
> wrote:
>
>> I don't think that's relevant for you.
>>
>> Did you upgrade the database using pg_upgrade?
>>
>
> That's correct! No, there
On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera
wrote:
> Can you paste the pg_controldata output please?
>
pg_controldata output as follows:
pg_control version number:937
Catalog version number: 201306121
Database system identifier: 6023658189132429183
Databa
On Fri, Sep 19, 2014 at 1:03 PM, Andres Freund
wrote:
> Yes: Learning some patience. You'd given the previous answer two hours
> before this one. Nobody is paid to work on this list...
Apologies for the delay, was working/troubleshooting same issue and was
away from my emails. :(
Regards...
On Fri, Sep 19, 2014 at 7:14 PM, Emanuel Calvo <
emanuel.ca...@2ndquadrant.com> wrote:
>
> Could it be related to some fixes on 9.3.5?:
>
> - Fix wraparound handling for pg_multixact/members (Álvaro Herrera)
> - Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro
> Herrera)
>
Curr
On Fri, Sep 19, 2014 at 1:23 PM, Dev Kumkar wrote:
> Apologies for the delay, was working/troubleshooting same issue and was
> away from my emails. :(
> Regards...
>
Received the database with huge pg_multixact directory of size 21G and
there are ~82,000 files in "pg_multixact
On Fri, Sep 26, 2014 at 1:36 PM, Dev Kumkar wrote:
> Received the database with huge pg_multixact directory of size 21G and
> there are ~82,000 files in "pg_multixact/members" and 202 files in
> "pg_multixact/offsets" directory.
>
> Did run "vacuum full
On Tue, Sep 30, 2014 at 8:50 PM, Alvaro Herrera
wrote:
> Did you try decreasing the autovacuum_multixact_freeze_min_age and
> autovacuum_multixact_freeze_table_age parameters?
>
As per the docs this set anywhere from zero to 1 billion for
vacuum_multixact_freeze_min_age
And zero to 2 billion for
Hellos,
How to manually increase pg_multixact members and offsets?
Does a transaction waiting for exclusive lock or shared lock result into
entry being created in pg_multixact?
Excerpt of multixact.c:
/*-
2 *
3 * multixact
On Thu, Nov 20, 2014 at 11:15 PM, Alvaro Herrera
wrote:
> Search for "burnmulti" in the archives, which is a contrib module to
> test pg_multixact.
>
Thanks, got some links. Will give a try and get back.
Merely waiting does not, but more than one lock being acquired on a
> tuple does cause a mu
On Fri, Nov 21, 2014 at 1:14 AM, Alvaro Herrera
wrote:
>
> If there are foreign keys on the tables, the system internally runs some
> SELECT FOR KEY SHARE queries on the referenced tables (the ones
> containing the primary or unique keys). You can get some multixacts
> that way too.
>
> --
> Álv
Am debugging a race condition scenario where multiple transaction are
running in parallel and there are insert/update these transactions are
performing.
I was able to identify the blocking query and blocked query using following
SQL.
However observed the blocking query is holding the locks on the
Thanks Bill !
On Wed, Nov 26, 2014 at 9:07 AM, Bill Moran
wrote:
> In addition to what you're getting from that query, include the xact_start
> and
> state_change columns from pg_stat_activity. My guess is that your code is
> starting a transaction, then running a query, then processing the quer
an you please let me know any mapping document which maps ODBC
constructs between sybase and postgres.
Also list of ODBC constructs to be used with postgres.
Thanks in advance!
Regards...
p.s. Am not sure if the earlier email was sent..sorry for spam in case it
was.
On Mon, May 20, 2013 at 5:37 P
Also adding the pgsql-admin alias.
Regards...
On Mon, May 20, 2013 at 9:12 PM, Atri Sharma wrote:
>
> If you wish to work in C,then,I would suggest libpq.I would wait for more
> replies on this,as I have little knowledge
> about psqlODBC.
>
Thanks for the comments. Yes objective is to work in C and found libpq
useful but am not sure about p
On Mon, May 20, 2013 at 11:32 PM, Heikki Linnakangas <
hlinnakan...@vmware.com> wrote:
> libpq is generally-speaking better than psqlodbc. The advantage of ODBC is
> that if you have a suitable driver, you can connect to other DBMS' as well,
> while libpq will only work with PostgreSQL. Unless you
On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote:
for pooling, check out pgbouncer. IMHO its a better basic pooler than
> pg_pool.
>
Sure, looks like its more light weight. And I hope, its not related to the
decision between libpq and psqlODBC. And will work with both?
thats the perfect
On Tue, May 21, 2013 at 12:32 PM, Dev Kumkar wrote:
> On Tue, May 21, 2013 at 12:16 PM, John R Pierce wrote:
>
> for pooling, check out pgbouncer. IMHO its a better basic pooler than
>> pg_pool.
>>
>
> Sure, looks like its more light weight. And I hope, its no
On Tue, May 21, 2013 at 12:35 PM, Guy Rouillier wrote:
> On 5/21/2013 3:32 PM, Dev Kumkar wrote:
>
>> Well to work with psqlODBC, will I need to recompile the psqlODBC binary
>> and any additional stuff to get ODBC working?
>>
>
> No, you don't need to recompil
On Tue, May 21, 2013 at 12:45 PM, Dann Corbit wrote:
> >>
>
> Just install the driver and use it. You don’t have to build the driver.
> It is already built for you. Look here if you need Solaris or BSD:
>
> http://www.postgresql.org/download/
>
> Or go directly here for Mac, Windows
On Tue, May 21, 2013 at 3:17 PM, John R Pierce wrote:
> what specific non-Windows operating system distribution are you using?
> ODBC stuff is packaged for most of them. for instance, the
> yum.postgresql.org repository has it packaged as postgresql92-odbc,
> available for a variety of redhat/f
On Tue, May 21, 2013 at 5:21 PM, Dann Corbit wrote:
> When you install an ODBC driver, it does not install a library. It
> installs a DLL or shared object.
>
> If you have already installed the driver, then set up your data source
> with a data source manager.
>
> ** **
>
> IODBC is a popul
On Tue, May 21, 2013 at 7:09 PM, Dann Corbit wrote:
> The ODBC library is contained in either the iodbc or unixodbc RPMs.
>
> The correct RPM to use will depend on your operating system.
>
Where are these located?
>
> Currently looking for RHEL 5. Thanks! yes looked into my machine and "yum
> list postgres*" listed "postgresql91-odbc.x86_64"
> But when trying to install, then found the base ODBC library itself are
> missing and those needs to be configured first on test machine.
>
> Error: Missing Dependenc
On Tue, May 21, 2013 at 7:35 PM, John R Pierce wrote:
> On 5/21/2013 7:02 PM, Dev Kumkar wrote:
>
> The link
> http://www.enterprisedb.com/products-services-training/pgdownload#windows
> which
> you had earlier provided was postgres installation. It installed libpq but
>
On Tue, May 21, 2013 at 7:40 PM, John R Pierce wrote:
> # yum install unixODBC-libs
>
> should install the latest version from the distribution base repositories.
Its not finding it. May be I need to get on another box then, not sure.
Since ODBC driver was missing, downloaded unixODBC-2.3.0.t
On Tue, May 21, 2013 at 8:40 PM, Dann Corbit wrote:
>>>
>
> I guess that if you did a successful make install of unixODBC-2.3.0 it
> will work as your ODBC driver manager.
>
> On the other hand, it is easier and more trouble free to use the
> standardized package installer for your distributi
On Tue, May 21, 2013 at 10:49 PM, John R Pierce wrote:
> its looking for the RPM installed packages it was linked against. its not
> looking to see if any same named files just happen to be on your system.
Oh, got it. So the only way is to do bless it thru 'yum install
unixODBC-libs' only. Hmm
On Wed, May 22, 2013 at 11:44 AM, John R Pierce wrote:
> why the heck are you not installing unixODBC-libs from RPMs ?!?
>
> yum install unixODBC64 unixODBC64-libs unixODBC64-devel
>
> should do it, unless you're on Red Hat Enterprise without a subscription,
> then you can do it the hard way.
On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ wrote:
>
> Yes, or, as mentioned before, you can simply download the RPM directly
> from the repo.
>
Thanks Devrim!
Installed postgres-92 server from
postgresql92-server-9.2.4-1PGDG.rhel5.x86_64.rpm, actually links which John
(Thanks!) mentioned wer
On Tue, May 21, 2013 at 7:25 PM, Dann Corbit wrote:
> >>
>
> I do not know if you have 64 bit or 32 bit Linux and if it is Redhat or
> Mandrake or whatever.
>
> To be clear:
>
> The PostgreSQL distribution allows you to download the PostgreSQL ODBC
> driver. The PostgreSQL ODBC driver i
On Tue, May 21, 2013 at 11:28 PM, Dev Kumkar wrote:
> On Tue, May 21, 2013 at 10:49 PM, John R Pierce wrote:
>
>> its looking for the RPM installed packages it was linked against. its not
>> looking to see if any same named files just happen to be on your system.
>
>
>
On Wed, May 22, 2013 at 6:06 PM, Dev Kumkar wrote:
> On Wed, May 22, 2013 at 4:10 PM, Devrim GÜNDÜZ wrote:
>
>>
>> Yes, or, as mentioned before, you can simply download the RPM directly
>> from the repo.
>>
> Thanks Devrim!
>
> Installed postgres-92
I have a query that is driving me nuts. In one table we have data that is
split between two columns and I'm trying to pull in all values from another
table where that column is represented by one piece of data. Also, all the
info in column2 is unique but not in col 1.
table1
col1_pfx
col2_numbe
I have data that I'm running through pg_escape_sting in php and then adding
to stdin for a copy command. The problem is "O'reilly" is being changed to
"O''Reilly" in the string and then in the db. I saw with the copy command I
can specify the escape but it isn't working for me. Should this comma
I have a table with a mileage column that is a character varying (please
don't ask why :).
I need to do a query where mileage > 500
select * from cars where mileage>500
So I need to cast it but everything I try throws an error such as :
ERROR: invalid input syntax for integer: "+"
How can I c
Yeah, it was my being stupid, I got it going now.
Thanks!
On Tue, Apr 22, 2008 at 11:42 AM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> On Apr 22, 2008, at 10:34 AM, blackwater dev wrote:
>
> I have a table with a mileage column that is a character varying (please
> > don
I have to find the same firstname+ lastname combo in my db and see which
name appears the most so I basically need to do the following:
select name, count(name) from people group by name having count(name)>1
The problem is name is not one column but made up of firstname,
lastname...how do I do th
Great, thanks!
On Thu, Jun 19, 2008 at 5:14 PM, Sam Mason <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 19, 2008 at 03:38:28PM -0400, blackwater dev wrote:
> > The problem is name is not one column but made up of firstname,
> > lastname...how do I do this?
>
> I&#
I have a table with a lot of columns. One of the columns I want to alias so
have a query of:
select *, column as newname from mytable.
The problem is I now have column and newname in the results. I don't want
to select column by column. How can I do a select * but omit one?
Thanks!
unsubscribe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
How to create case insensitive database?
I know about CITEXT data type, but what am looking for is if there any
parameter at database level which just makes the database case insensitive.
I mean both values 'ABC' and 'abc' are treated same for inserts and also
all the comparisons by default are c
case
insensitive.
regards...
On Wed, Dec 11, 2013 at 12:10 PM, John R Pierce wrote:
> On 12/10/2013 10:31 PM, Dev Kumkar wrote:
>
>> I know about CITEXT data type, but what am looking for is if there any
>> parameter at database level which just makes the database case inse
How to create scheduled events in postgres simillar to whats event in
Sybase.
Is there any method of doing so?
Also am looking at PgAgent which can create jobs but is it similar like
events in sybase.
Please suggest.
Regards...
Resending...
On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar wrote:
> Yes actually that's one alternate solution to use cron or windows
> scheduled tasks.
>
> The intent is to call certain stored procedures at certain time intervals.
>
>
> On Wed, Dec 11, 2013 at 7
Can case-insensitive collation help here?
On Wed, Dec 11, 2013 at 4:55 PM, Dev Kumkar wrote:
> Thanks John.
>
> Yes CITEXT would work, the only thing its needs DDL changes across and
> hence was looking for any such global database parameter setting while
> creating databa
ec 11, 2013 at 8:58 PM, Andrew Sullivan wrote:
> On Wed, Dec 11, 2013 at 04:55:07PM +0530, Dev Kumkar wrote:
> You could build lower() indexes on any column you want to search CI
> and lower() all the input text during searches, in order to avoid any
> work on the schema. Bit of a kludge, though.
>
> Best,
>
> A
>
On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar wrote:
> Actually for searches lower will work.
> But the other important aspect is 'inserts' which would result 2 rows if
> the values are 'A' and 'a'. Intent here to have it case insensitive.
>
> If
+ hackers
On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar wrote:
> On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar wrote:
>
>> Actually for searches lower will work.
>> But the other important aspect is 'inserts' which would result 2 rows if
>> the values are '
1 - 100 of 165 matches
Mail list logo
