+list
First off you are going to get considerably better response from the JDBC
list or our github project.
Looking at the code; in order to ensure the backend has received the
acknowledgement you need to call forceUpdateStatus
Otherwise it may not receive the ack
Dave Cramer
da
I see.
Thanks Jeff,
On Mon, Sep 11, 2017 at 2:38 PM, Jeff Janes <jeff.ja...@gmail.com> wrote:
> On Mon, Sep 11, 2017 at 7:02 AM, Dave Florek <dave.a.flo...@gmail.com>
> wrote:
>
>> Hi,
>>
>> I'm trying to setup streaming replication on a cluster of
Hi,
I'm trying to setup streaming replication on a cluster of postgresql
databases and I followed the instructions outlined here (
https://wiki.postgresql.org/wiki/Streaming_Replication) but I'm stuck on
the archive and restore commands. In reading the comments from the archive
command, WAL
oops=1)
Filter: (aspect_id IS
NOT NULL)
Total runtime: 5013.070 ms
(53 rows)
On Sat, Sep 9, 2017 at 8:26 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Dave Peticolas <d...@krondo.com> writes:
> > Hi, I am trying to analyz
Hi, I am trying to analyze a performance regression from 9.2.21 to 9.6.3.
The query and execution plans are below with 9.6.3 first. If the query
looks a bit odd, it was generated by an ORM and the names have been
modified. The slight difference in row counts is because they are from
snapshots
Well we won't be fixing any bugs in anything but the latest version if that
makes a difference to you.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 21:34, Rob Sargent <robjsarg...@gmail.com> wrote:
>
>
> On Aug 25, 2017, at 5:55 PM,
There are newer versions out there!
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 25 August 2017 at 19:53, Rob Sargent <robjsarg...@gmail.com> wrote:
>
>
> On 08/25/2017 05:34 PM, Dave Cramer wrote:
>
> The JDBC driver release is divorced from the serve
The JDBC driver release is divorced from the server release.
Thanks
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 August 2017 at 19:33, Rob Sargent <robjsarg...@gmail.com> wrote:
> I see no mention of a new jdbc driver on the release notes for Beta 1.
> Do
is not so easy (plus, with
different user input, it might need B or C in the ORDER BY).
- Dave
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
() and the last reset date can be retrieved from
pg_stat_database, but I’d prefer not to reset ALL stats when the focus is
on a particular table/index.
Are individual table/index reset timestamps stored? If so, can they be
retrieved?
Thanks,
Dave
the mailing lists for comments or suggested
changes. If you have comments, please email them to
coc-comme...@postgresql.org no later than 2017-03-05, 11:59PM GMT for
the committee to review.
Regards, Dave.
--
Dave Page
PostgreSQL Core Team
http://www.postgresql.org/
--
Sent via pgsql-general mailing
Unfortunately JSONB is output in text. So this is the way it is done.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 27 August 2016 at 06:39, Alexander Farber <alexander.far...@gmail.com>
wrote:
> Hello,
>
> what do you use to retrieve a jsonb column using JDBC?
&
have no idea if this will work
5) pg_dump everything and reload it into a new db.
Let me know how it goes.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 6 June 2016 at 16:57, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 06/04/2016 01:20 PM, lifetron
In cases like this I normally restart the progresql under strace/truss
etc and then wade through the output, it will normally tell me which
process was invoked.
On 23/08/15 18:49, Tom Lane wrote:
Igor Sosa Mayor joseleopoldo1...@gmail.com writes:
Adrian Klaver adrian.kla...@aklaver.com writes:
On Sat, Jun 27, 2015 at 11:00 AM, Francisco Olarte fola...@peoplecall.com
wrote:
Hi Dave:
On Fri, Jun 26, 2015 at 2:59 AM, Dave Johansen davejohan...@gmail.com
wrote:
It appears that calling SELECT insert_test_no_dup('2015-01-01', 1, 1)
cause the XID to increment? I'm not sure if it's
On Tue, Jun 9, 2015 at 8:38 AM, Dave Johansen davejohan...@gmail.com
wrote:
On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen davejohan...@gmail.com
For the sake of documentation, here's the function that I used to
accomplish this:
CREATE FUNCTION insert_test_no_dup(tutc_ TIMESTAMP WITHOUT TIME
Hi: I'm trying to get a 10,000 ft understanding of the difference in DB access
speeds for two different scenarios...
Scenario 1: Apps are on linux. PG DB is on linux (different server than
apps)
Scenario 2: Apps are on linux. MSSql DB is on Windows (obviously a
different server)
, 2015 10:10 AM
To: Gauthier, Dave; Postgres General
Subject: Re: [GENERAL] DB access speeds, App(linux)-PG(linux) vs App(linux)
-MSSql(Windows)
On 6/24/2015 8:44 AM, Gauthier, Dave wrote:
Hi: I'm trying to get a 10,000 ft understanding of the difference in
DB access speeds for two different
24, 2015 12:50 PM
To: Gauthier, Dave
Cc: Postgres General
Subject: Re: [GENERAL] DB access speeds, App(linux)-PG(linux) vs App(linux)
-MSSql(Windows)
Hi Dave:
On Wed, Jun 24, 2015 at 3:44 PM, Gauthier, Dave dave.gauth...@intel.com wrote:
Hi: I'm trying to get a 10,000 ft understanding
On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen davejohan...@gmail.com
wrote:
I'm using Postgres 8.4 on RHEL 6 and I need to support inserting data into
a table from multiple processes with there occasionally being duplicates
from the different processes. Here's a simple example table:
CREATE
is there some way to catch
the unique_violation exception without creating a function? Or some other
solution to this?
Thanks,
Dave
of a complete set of test data... using psql to
load a dump, or possibly CREATE DATABASE testdbcopy WITH TEMPLATE testdb.
Integration tests can be costly to maintain with little ROI, tread
carefully...
-Dave
So we can consider this matter closed ? CallableStatements are necessary
because postgres has to use select to call a function.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 18:06, Nanker Phelge n.phelg...@gmail.com wrote:
The database function does
The logs from the server would be useful
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 4 May 2015 at 07:05, Thomas Kellerer spam_ea...@gmx.net wrote:
Hannes Erven schrieb am 04.05.2015 um 12:31:
Hi,
String sql = select test_user_result_insert_func
anyway, the data I am after is only tiny fraction of the original
db...)
- restore the filtered constraints/triggers
Dave Owens
541-359-2602
TU Corporate Website
http://t.signauxun.com/link?url=http%3A%2F%2Fwww.teamunify.com%2F__corp__%2Fukey=agxzfnNpZ25hbHNjcnhyGAsSC1VzZXJQcm9maWxlGICAgOCP
.
Of course, I would love to hear about options D) - Z) as well! Thanks in
advance for your input.
Dave Owens
541-359-2602
TU Corporate Website
http://t.signauxun.com/link?url=http%3A%2F%2Fwww.teamunify.com%2F__corp__%2Fukey=agxzfnNpZ25hbHNjcnhyGAsSC1VzZXJQcm9maWxlGICAgOCP-IMLDAk=b64a8344-b9e5
unfortunately not.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 6 March 2015 at 11:27, Philippe EMERIAUD p.emeri...@ordirope.fr wrote:
Hi all,
We have an application based on DB2 database, We are testing this same
application on PostgreSQL database. By default we
George,
One solution for you might be to write a C function which gets the OS
timezone and then you can execute set timezone=server_timezone();
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 24 February 2015 at 09:25, George Woodring george.woodr...@iglass.net
wrote
Well you could always just put it back to whatever you want when you open
the connection ie set timezone
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 08:40, George Woodring george.woodr...@iglass.net
wrote:
Anyone have a suggestion
to control
which timezone both the server and the client are operating in.
I'm open to suggestions ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:42, George Woodring george.woodr...@iglass.net
wrote:
Yes, that is where we think we are heading
For posterity please be aware this will very likely break any timestamps
transfer using JDBC and binary transfer.
This is not recommended for general consumption
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 10:49, Tom Lane t...@sss.pgh.pa.us wrote
On 23 February 2015 at 16:31, Tom Lane t...@sss.pgh.pa.us wrote:
Dave Cramer p...@fastcrypt.com writes:
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Hmm ... depending on exactly how you issue
George,
Everytime you get a connection the driver will issue set timezone ...
It does not change the default time zone for the server (AFAICS)
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 23 February 2015 at 15:29, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 02
I have written a test program using postgres that creates a string with a
surrogate pair. I then insert that string into a varchar property in a
table.
I then execute a select statement to pull the string out. But when I
evaluate the string the lead char of the pair is correct, but the
I am new to Postgresql. I have a postgres server running on a windows
platform. The DBs will not have any remote access, only users logged onto
the localhost will have access. SSPI seems like a great authentication
protocol to use in this case.
I believe I have followed all the instructions on
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 25/11/14 21:36, Adrian Klaver wrote:
On 11/25/2014 01:27 PM, Dave Potts wrote:
I have a psql function that make a general sql query, returns a set of
results
Q. Is there anyway that I can limit the size of the result sets ?
Put a LIMIT on the query.
If that is not what you want then we
On 25/11/14 22:24, David G Johnston wrote:
Thanks List, I think this is the right way to go.
Adrian Klaver-4 wrote
If I am only interested in get 2 entries per result set, I would expect
to see
Actually =2.
How do you determine which rows to keep, by id or something else?
1 xx,yy
2 xx,yy
, Training Services
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
to add all the OpenSSL header files? That must be around
75..
On Thu, Jul 3, 2014 at 1:24 PM, Dave Page dp...@pgadmin.org wrote:
Sandeep, how much effort is it to do this?
On Thu, Jul 3, 2014 at 6:26 AM, Craig Ringer cr...@2ndquadrant.com
wrote:
Hi
I've just noticed that the EDB
support platforms other than Windows).
On Thu, Jul 3, 2014 at 10:35 AM, Sandeep Thakkar
sandeep.thak...@enterprisedb.com wrote:
Okay. For psqlODBC, the dependencies only include gettext and OpenSSL.
On Thu, Jul 3, 2014 at 2:08 PM, Dave Page dp...@pgadmin.org wrote:
I think the point
Can you elaborate as to your problems. That driver should work fine
depending on what you are doing. Also it would be better to use the jdbc
list.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3 July 2014 06:25, Orestis Tsakiridis otsa...@gmail.com wrote:
Hello,
I'm
Well the JDBC4 bits that are not implemented may or may not be relevant.
You can try the 9.1 driver or even the 9.3 driver. I still don't see enough
information in the stacktrace to tell what the issue really is?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 3 July
!
--
--Dave Peticolas
Ya, they probably don't like that we use server side prepared statements
Might be possible to just mess with classpath's to get it done.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On 11 April 2014 17:39, Rob Sargent robjsarg...@gmail.com wrote:
On 04/11/2014 03:31 PM
In theory, you could write a script that opens both DBs, then systematically
inserts or updates records in the destination DB table based on what's in the
source DB table. Brute force, but automatable.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On
What about a regexp match ?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Thursday, February 06, 2014 10:32 AM
To: alexandros_e
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgresql GROUP
You said they upgraded the driver but the versions you stated are the same
???
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Wed, Feb 5, 2014 at 12:23 PM, CS DBA cs_...@consistentstate.com wrote:
Hi All;
We have a client running Pentaho to migrate data
Yes, please check the server logs. There should be no reason whatsoever
that JDBC would effect the results if the query is the same
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Jan 3, 2014 at 3:42 PM, Igor Neyman iney...@perceptron.com wrote:
-Original
Hi:
Longshot, but here goes
Someone is asking me for a way to architect a model which will store basic
table data (columns with names and rows), but the number and name of the
columns are both variables. I'll call these data-tables here.
Example, Store this data-table
'col1'
Ok, I found the offending line. It was not the pgadmin line. There was a
line with a large binary insert.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 6:31 PM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 09/23/2013 12:46 PM, Dave Cramer wrote
OK,
I have a little more information.
Yes, in isolation I can import these lines, however something happens after
69000 lines. These lines cause an error.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Fri, Sep 20, 2013 at 9:59 AM, Adrian Klaver adrian.kla
I tried copying 500 lines above it and it still works :(
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Sep 23, 2013 at 4:15 PM, Alvaro Herrera alvhe...@2ndquadrant.comwrote:
Dave Cramer escribió:
OK,
I have a little more information.
Yes, in isolation I
.
If I used different schemas, it resolves data protection issues, but
doing a backup might become a nightmare
In general which is the fast access method?
regards
Dave.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
pgadmin uses multi line queries and copy from 'cvslogs' cannot read them.
Does anyone have a work around or other solution ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
AND
r.package_id IS NOT NULL
INNER JOIN printdata_page p ON r.id = p.report_id
INNER JOIN printdata_item i ON p.id = i.page_id
WHERE
r.timestamp = '2012-09-01' AND r.timestamp = '2013-08-31'
GROUP BY
Month Name,
Target,367,,pgAdmin III - Query Tool
Dave Cramer
text,
PRIMARY KEY (session_id, session_line_num)
);
2) The exact error message is ERROR: extra data after last expected column
considering ~39000 lines go in before this line I am fairly certain it
is the line.
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
I have a DB that relies heavily on recursive stored procedures that tap
reflexive tables that store hierarchical data. These procedures are called
from queries and return record streams. Temp tables are used to store
collected data as the procedure runs up/down the hierarchy. And many other
I find stored procedures to be a God-send. The alternative, external code, is
the risky, difficult and often poorer performing approach to the problems sp's
solve. What better way to interact programatically with your database than
WITH your database?
The only people that I see frown upon
Hi:
v9.0.1 on linux
Is there a way to query on synonyms of a value transparent to the user?
For example, a column called animal can have any text value, including
'horse' and 'cow' and 'pig'. But I want the user to find all the animal='pig'
records if they specify 'hog' instead.
So..
On 30 May 2013 14:48, Chris Angelico ros...@gmail.com wrote:
On Thu, May 30, 2013 at 6:02 AM, Corbett, James
james.corb...@cra-arc.gc.ca wrote:
For those twenty years as a developer I should say that I have been
completely blind, relying upon a screen review application known as JAWS and
a
v9.0.1 on linux
thedb=# select
||bicolumn||,
coalesce(permitted_values,'is_null'),
case permitted_values when NULL then 'null' else ||permitted_values||
end
from bi_constraints limit 2;
?column?| coalesce| case
Hi:
v9.0.1 on linux.
I have a table with a column that is a csv. Users will select records based
upon the existence of an element of the csv. There is an index on that column
but I'm thinking that it won't be of much use in this situation. Is there a
way to facilitate these queries?
As far as I remember this is an artifact of using rules to update a table.
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Feb 25, 2013 at 2:52 PM, Russell Keane russell.ke...@inps.co.ukwrote:
Hi,
** **
We have a table which is inserted to and update via
Many, many (many) years ago, while working at DIGITAL EQUIPMENT (before it
bellied up), I worked with a relational DB they created called RDB. Someone
at DEC wrote an sql development gui in Xwindows called InstantSQL. It was
really great. All the tables of the DB were icons, you could drag
Is there anything like this soln for v8.3.4 ?
I know, I know, just upgrade. But its out of my hands.
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, February 13, 2013 9:24 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re
Trying ( and failing) to get this to run...
select regexp_replace(pg_get_functiondef(proname::regproc),E'[ ]+\\+\n','\n')
from pg_proc where proname = 'maketime';
Goal is to remove the space padding and the + at the end of each line in the
dump of pg_get_functiondef, something that could
Hi:
Looking for a table or view which contains the list of arguments that are
passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc or other
pg_proc columns.
Thanks in Advance for any help.
Excellent !
Thank You very much !
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Wednesday, February 13, 2013 9:30 AM
To: Gauthier, Dave; pgsql-general@postgresql.org
Subject: RE: How to get stored procedure args list from metadata tables ?
Dave Gauthier
]
Sent: Wednesday, February 13, 2013 9:26 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get stored procedure args list from metadata
tables ?
On 02/13/2013 06:13 AM, Gauthier, Dave wrote:
Hi:
Looking for a table or view which contains the list of arguments
OK, with the help of this feedback, they caved and will keep it local storage.
Thanks !
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Can PG V9.1* support a DB that's on an NFS disk?
I googled around, but nothing popped out.
Also, would you happen to know the answer to this for MySQL v5.5*?
Thanks in Advance.
Bob,
Can you provide a snippet of code so I can understand what you mean by
declare ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 7:11 AM, Bob Futrelle bob.futre...@gmail.comwrote:
Do the declare statements and insert all have to be done in one
Bob,
Ok, have a look at PreparedStatement
Essentially the same
PreparedStatement pstmt= db.prepareStatement(insert into hello values ?)
pstmt.setInt(1,intVar)
pstmt.execute()
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Jan 28, 2013 at 1:50 PM, Bob Futrelle
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Shridhar Daithankar
Sent: Wednesday, January 23, 2013 10:32 PM
To: pgsql-general@postgresql.org
Cc: Gauthier, Dave; Rob Sargent
Subject: Re: [GENERAL] DB alias ?
On Wednesday, January 23, 2013 09
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark
Sent: Thursday, January 24, 2013 12:46 PM
To: Jeff Janes
Cc: Chris Angelico; pgsql-general@postgresql.org
Subject: Re: [GENERAL] noobie question
On
Problem: Some users (scripts actually) try to connect to a DB who's name is
derived from environmental variables. The DB doesn't exist (yet), and I want
them to connect to a different DB for the time being. Is there a way to define
an alias for the existing DB that = the db name that doesn't
. In the meantime, I want those
who try to connect to FEB to connect to JAN (for example).
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Wednesday, January 23, 2013 4:04 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
On 01/23
Sent: Wednesday, January 23, 2013 4:16 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1 of every month. So
there's a DB called JAN, another called FEB, etc... . The DB
] On Behalf Of Steve Crawford
Sent: Wednesday, January 23, 2013 4:38 PM
To: Rob Sargent
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] DB alias ?
On 01/23/2013 01:16 PM, Rob Sargent wrote:
On 01/23/2013 02:10 PM, Gauthier, Dave wrote:
Nope. Think of it this way, a new DB is created on day 1
One thing I've done in the past is to create a temporary table and insert
raise notice debug statements to it, incrementing a sequence as it went
along. Then just select the message with order by the seq. Useful in the
recursive calls I was testing at the time. But it did require that I
v9.1 on linux
Connect to postgres DB, then...
create user select password 'select';
create user insert password 'insert';
alter default privileges for user insert grant select on tables to select;
alter default privileges for user insert grant select on sequences to
select;
alter default
The fix had to do with connecting as the insert user, then setting the
default privs. My mistake was to run the alter default privileges... as the
superuser.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Thursday
If you're from the US and are planning to come to FOSDEM in February,
can you ping me please?
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql
What's wrong with this picture. Trying (failing) to create a user called
select with default select privs and nothing else. Demo below. Comments in
red...
fcadsql7 psql sde
psql (9.1.5)
Type help for help.
sde=# \du
List of roles
Role name |
select to one user for all tables in a DB?
On Wed, Dec 5, 2012 at 2:12 PM, Gauthier, Dave
dave.gauth...@intel.commailto:dave.gauth...@intel.com wrote:
V9.1.5 on linux
User select created (yup, that's right, they want the user name to
be select. Guess what ptivs it is to have! Don't kill
-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Wednesday, December 05, 2012 8:00 AM
To: Chris Angelico; pgsql-general@postgresql.org
Subject: Re: [GENERAL] how do I grant select to one user for all tables in a DB?
This worked. Thank You Chris!
One problem remains. The select user
V9.1.5 on linux
User select created (yup, that's right, they want the user name to be
select. Guess what ptivs it is to have! Don't kill the messanger :-) )
postgres=# grant select on all tables in schema sde to select;
ERROR: schema sde does not exist
postgres=# \l
?
No, there are no plans to do so.
Aparantly there are major issues with sideloading in windows 8.
We've seen no problems in our testing, and I haven't seen anything on
the -bugs list. If you see any specific issues, please report them
there.
Thanks.
--
Dave Page
Blog: http://pgsnake.blogspot.com
% to see if it really
points to cmd.exe .
Interesting - thanks for the info Craig. Sandeep; can you please look
into adding such a check to the installer. We already test the
VBscript interpreter, so this should go in the same place.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter
Here's the deal...
Instead of architecting and loading a table like...
create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text);
insert into foo (col1,col2,col3,col4,col5) values ('c1',null,'c3','c4',null);
They did this instead...
create table foo (property text, value text);
Thanks for the answers. But I also have a predicate...
select col1,col2 from foo where col4='c4' and col5 'xxx';
How is that done?
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Tuesday, October 23, 2012 3:24 PM
To: ch...@chriscurvey.com
Cc: Gauthier, Dave; pgsql-general
If its not too much work, swap them around and retest to see if its really the
DB/version or the machine.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Scott Marlowe
Sent: Friday, September 21, 2012 3:01 PM
To: salah
One thing I sometimes forget to do after loading up an empty DB with data is to
run analyze. I usually remember once I see poor query performance, run the
analyze, and its fixed.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On
Is there a way to determine when a DB was created (create database...)?
Thanks in advance.
I googled around and found that adding/dropping columns from views is not
available. (if not true, I'm all ears).
Given that, what's the best way to do this? I was thinking along the lines of
a stored procedure that reads the view's definition, modifies it, drops the
view, recreates the view.
Hi:
v9.0.1 on linux.
Trying (failing) a test to see if I can run ddl in a procedure where elements
of the ddl are vars. Consider...
create or replace function newcol (text) returns integer as $$
declare
newcol alias for $1;
begin
alter table target add column newcol text;
return(0);
Yup, works like a charm.
Thanks Salah and Tom for the advise !
-dave
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, August 29, 2012 11:18 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] using vars in ddl in procedure call
Thanks for all the replies !
The real problem has nothing to do with names. I just used that as a vehicle
for articulating the problem.
The view approach for queries is workable, at least for queries. Thanks for
the input on that and the idea to replicate the various aliases in the view!
: Thursday, August 23, 2012 9:52 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Can column name aliases be supported?
On 08/23/2012 09:32 PM, Gauthier, Dave wrote:
The view approach for queries is workable, at least for queries. Thanks for
the input
1 - 100 of 1224 matches
Mail list logo